Application Express :: Dynamic Action To Show Skill-builders Pop Up Only Works When Page Refresh?

May 28, 2013

I have a report with a link column:

'<a href="f?....................................class=show_popup"........

I have a dynamic action defined like this:

Event: click.
type: jquery selector
selector: a.show_popup
no condition.

action: skillbuildersmodalpage 2.0.0
URL: attribute of triggering element.

This works fine, but after the popup is shown and closed, the link is not working until the page is entirely refreshed again.

after the popup is closed, i only refresh the report with $a_report , ( in another dynamic action on the "auto close skillbuolders" event) i don't want to submit all the page....the partial refresh is working fine too, but not the link, it only works again by refreshing or submiting all page

View 2 Replies


ADVERTISEMENT

Application Express :: Skill Builders Calendar Plugin When Using Session State Protection?

Jun 13, 2013

I have a calendar region using SkillBuilders plug-in. When click on an event, a modal page opens showing the event details and allowing the user to modify it. Recently, I enabled Session State Protection in my pages, so I changed my query in the calendar region to use the APEX_UTIL.PREPARE_URL function when generating the URL to edit the event. Now, when I click on an event, the URL looks like: [URL]....

p=34925:3:102130990572822::::P3_ID:41&cs=3DE8BFFE2FCA925B7716361D6ECFC546B If you notice the URL has & before the check-sum (cs), instead of just & and it is causing an error on my page. The reason is that the plug-in is escaping special characters. If I change the source of the plug-in to use this: 
l_url := l_column_value_list(6)(x); Instead of: 

[code]....

View 0 Replies View Related

Application Express :: Show Region After Running Dynamic Action Plsql?

May 1, 2013

i have a hidden region at the page top i want to show only after clicking my button which is running DA plsql code. This region is like a prompt message container/div at the top of the page so after few seconds like 10 secs i want to hide it again. I tried to use JQUERY but never hide it back, also i tried another TRUE CONDITION within my dynamic action but it doesnt reset it back the region is always shown...

View 2 Replies View Related

Application Express :: Use Page Item In LOV That Was Set By Dynamic Action?

Aug 15, 2012

I have a situation where I need to reference a hidden item in a List of Values (for a pull-down list) SQL statement. It doesn't seem to be working properly. Here is what I have:

1) Using a dynamic action, set the value of a hidden item based on the change of Select List 1.

2) Select List 2 has a parent LOV item of Select List 1, and the Select statement for Select List 2 uses the hidden item that was set from the dynamic action above.

I can see that the dynamic action is working correctly. But when I change Select List 1, the Select List 2 does not show any values from its LOV.

I'm wondering if the LOV for Select List 2 is not working because the item used in the SQL statement was set by a dynamic action?

View 7 Replies View Related

Application Express :: 4.2.1 Dynamic Action Definition True Action Settings Not Visible

May 16, 2013

im working with apex 4.2.1 and when i try to define a Dynamic action on any item, if the action type is "Set Value" or execute SQL/Javascript code it should appear a text field that let me define the action taking place. However this wont do..

this is what happens:

And this is what should happen:

I know that patch 4.2.2 solves some issues regarding dynamic actions but in the bug report there's no reference to such a problem.

View 1 Replies View Related

Application Express :: Enter A Value Using Set Value Dynamic Action

Aug 1, 2012

I'm using Oracle 11g XE with apex 4.0.2.

I've been trying to use a dynamic action on a text field 'item_group'. Button doesn't have this facility. I created an advanced action using 'set value' with no condition the value being 'RAM.' The event is "change", selection type 'event source', set type is 'static assignment' and value is RAM. It is supposed to trigger when the create button is pressed but nothing happens and the field is still null. I've tried variations on this but nothing works.

View 1 Replies View Related

Application Express :: Suppress A Dynamic Action Loading GIF?

Mar 1, 2013

I've created a change event dynamic action which fetches a description from the database for a user-entered code. When this is run in Firefox, a swirling loading image is displayed next to the description.However, the loading image causes anything displayed its right to be moved out and then back again when it disappears. On a form with lots of dynamic actions this can be quite disconcerting so I'd like to stop it.

Can a dynamic action's loading image be suppressed?

APEX inserts the following HTML alongside the input field:
<span class="apex-loading-indicator"></span>One option is to apply "display: none;" to the "apex-loading-indicator" class but this could affect other loading images that use the same class.

Note: This affects Firefox (18) but not IE9

View 1 Replies View Related

Application Express :: Call Dynamic Action From Link

Nov 28, 2012

All I want to do is call a DA from an HTML link, is it possible? Do I call the DA function like I do with JS?

View 2 Replies View Related

Application Express :: Raise Application Error On Dynamic Action

Jul 18, 2013

I am using Apex 4.2. On a click of button a Dynamic Action is written, which calls a DB Package. The DB package has exception handlers and also the package has two output parametersError Code and Error MsgSo in my code(Dynamic Code) i make a call to the package and checks the value for Erroc Code.

Begin Package call......  If v_error_code <> '0' Then    Raise SC_Error;  End if;Exception   When SC_Error Then    RAise_Application_error(v_err_code, v_err_msg);End;

But when i run the page and I click I get an Internal exception errorOutput from Debug -- I am not sure what the Cell in Red colour means, because the package is returning a correct message (before the red line).AJAX call returned server error ORA-20003:

Customer has already been matched for Execute PL/SQL Code.4......is_internal_error: true4......apex_error_code: APEX.AJAX_ SERVER_ ERROR4.. ora_ sqlcode: -200034......ora_sqlerrm: ORA-20003: Customer has already been matched4......error_backtrace: ORA-06512: at line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 2304 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 442 4......component.type: APEX_APPLICATION_PAGE_DA_ACTS4......component.id: 231852037977562094......component.name: NATIVE_EXECUTE_PLSQL_CODE4.

Execute Error Handling Callout defined on Page or Application Level4...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := apx_error_utils.handleerror ( p_error => l_error ); end; end;4......Values changed by callout:4..

An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation. 4..display_location: ON_ERROR_PAGE4Stop APEX Engine detected4Final commit4-1 - 59

View 4 Replies View Related

Application Express :: Dynamic Action Call From An Interactive Report?

Jul 6, 2012

I’m on APEX 4.1, 11gR2, Windows 7 and the latest version of Firefox. I have an interactive report. I want the end user to have the ability to click on a row level link and launch a modal pop up view of another page. Ideally, I'd like to be able to use the Skillbuilders plug-in. I can get it to work if I just go the full page route but I cannot figure out a way to get it to work as a modal pop up. I’ve tried various methods, none of which work, but the one I believe I should be following is by using a page level Dynamic action that fires when a JQuery Selector found item is clicked. The problem I’m having is that I cannot find the correct JQuery Selector syntax for the column. My report has a static ID of IDN and my column a header of PARTS. The best I can manage is not to see anything happen other than a page refresh (when the link is set to the same page). I do not see and firebug console errors.

I’ve replaced the dynamic action modal page call with an alert, which is not showing, to make sure that it's not the plug-in configuration that is causing the problem.

what I should be filling in in the JQuery Selector field of the DA and what the link attributes should be? Given that I wish to redirect from page 1 to page 2, what do I put in the other link fields?

View 2 Replies View Related

Application Express :: How To Have A Dynamic Action Populate Text Fields

Sep 7, 2012

How to have a dynamic action populate text fields. When the create button is hit, it will insert the record in the DB like normal.

I had a search box doing a dynamic action when a record_number is entered and the selection changes It populates the remaining text boxes with the results of the record_number.

I used a "SET_VALUE" true action on each individual ITEM

For each individual item i have different SQL Statement populating that item.

Ex. To populate Last_Name/ P2_LAST_NAME item i do the following

Select LAST_NAME from patient_Demographics
where record_id = :P2_RECORD_ID

Affected Elements:
P2_LAST_NAME

So i have about 8 of these true statements, so i'm hitting the DB 8 times to get the individual items. Is there a way to hit the DB once and set the items using one PL/SQL statement? I tried using a PL/sql function body,

View 14 Replies View Related

Application Express :: Deleting From A Tabular Form With Dynamic Action

Jan 24, 2013

Using Apex 4.2

Is it possible to delete a row from a tabular form using dynamic actions.

At the moment my report sql contains html and javasript for a delete button

'<input type="button" name="Delete" value="Delete"  onclick="del(''delete'','''||a.applicationname||''')">' A2I then have javascript in my page header
function del(Request, Name){
var answer=confirm("Do you really want delete application "+Name+"?

* Provider assignments will be deleted
* Application objects will be deleted
* DB-roles will be dropped
* DB-views will be dropped
* User-synonyms will be dropped");

if (answer==true) {
  document.getElementById('P10_APPLICATIONNAME').value = Name;
  doSubmit(Request);
}
}

Finally I have a page process to do the delete which fires when the request = delete

View 18 Replies View Related

Application Express :: Dynamic Action For A Text Field In Tabular Form?

Sep 13, 2012

for a text field of a, wizzard generated, tabular form i created a dynamic action when lost focus. using a jquery selector to bind the da to the item in every row when the event fires some jscript and pl/sql code is executed. this all works like charm for existing rows.

but how can i bind the da to the field for newly added rows?a sc of the definition of the da can be found here [URL]...

View 2 Replies View Related

Application Express :: Display Only Value Not Save To Database Based On Dynamic Action?

May 22, 2013

I have a select box with products, and a dynamic action that updates a display only element with the price, based on the product selection.After the selection is made and the page is submitted, I have noticed that the price is not stored in the database. If I change the display only value to a text box, the data is saved. Is this expected behavior? If so, can I add something to the text box to make it not editable?

Version is Application Express 4.1.1.00.23

View 6 Replies View Related

Application Express :: How To Create A Dynamic Action From Link Column In Classic Report

Feb 23, 2013

I Have an apex page that display a modal window utilizing jquery. In the modal window I have a classic report with a link column that I want to capture its click event.

I was thinking I could create a dynamic action with selection type=jquery selector. Not for sure if I need to do anything on link column and do not know the syntax jquery selector.

View 5 Replies View Related

Application Express :: How To Fire Dynamic Action On Cascaded (child) Select List

Nov 8, 2012

When a user selects a Plan Type (Parent Select list) Plan codes (Child select list) to be filtered, working OK.
When a plan code is selected I need to do conditional display of regions.
Example: Plan code = A then display Region A
Plan code = B then display Region B etc.

I have a DA on Plan code select list but it's not working as it's being a cascaded (child) select list and the 'Change' event is already fired when I selected the Plan type, I also tried with other event options with no success.

Plan code shows no value in the session.

View 4 Replies View Related

Application Express :: Dynamic Action In Report Region In Master Detail Form

Nov 7, 2013

I have created a master detail form , in which many validation etc is done ,the MASTER is a FORM  and DETAIL is a REPORTNow I am stuck up with the detail region .i.e reportI have Line Detail where there are ITEMS such as SL NO:

,ITEM_ID , UOM ( Unit of measuremnt ) etcNow here is where

Using POP UP LOV i have managed to fetch in LOV for the item "ITEM_ID",---

i can select an item name using the pop up LOV ,Now all that I want is when I select an item name from the pop up lov , an Item Id is displayed or fetched in that particular place , now i want the corresponding UOM to be diaplayed  ( i.e the UOM for that particular Item Id which has been selected by me from the pop up lov ). 

In order to resolve this I created a Dynamic action where in I get the UOM . Bt the problem is that the ITEMS displayed for selecting in the WHEN section (DYNAMIC action-IDENTIFICATION section-WHEN section----- items (  here i am not listed with ITEMS of the REPORT region instead ITEMS of the MASTER is available )-TRUE ACTION section etc is only theITEMS of the MASTER region ..

View 1 Replies View Related

Application Express :: Page Item Only Refresh Into Session?

Mar 24, 2013

I have some troubles with a "Set Value" Dynamic Action. What I want to do is set a Page Item with a specific variable derived from javascript. So basically I have a javascript variable 'test' that is being changed in javascript code. I am using a dynamic Action "Set Value" to set this value into a page item. As source, Im using "Javascript Expression". It is working, however, the Set Value Dynamic Action with JAvascript expression does not reflect this change in the session, so the page item is not updated.

I tried:

$s -> does not work
apex.submit -> does work, however submits the page. I need to submit only the Page item.

View 3 Replies View Related

Application Express :: Partial Page Refresh PL/SQL Region

Aug 13, 2013

I have an APEX page with a master and a detail. The master is a classic report with a column link which sets an hidden item on my

page:javascript:$s('P280_DAK_ID','#DAK_ID#'); 

I have a dynamic action which reacts on change of the item P280_DAK_ID.It then refreshes the detail region which is a PL/SQL region with the following:

begin apex_p280.show_xml(p_dak_id => v('P280_DAK_ID'));end;

This prints a few pieces of text to the screen, nothing special. Everything works except the refresh of the detail region.This is due to the fact that the new value of P280_DAK_ID is not in the session state yet. So my question is: what would be a nice solution to set the item in the session state without a submit? With a normal region I could fill in 'Page items to submit', but with a pl/sql region I can't. 

View 1 Replies View Related

Application Express :: Refresh Previous Page With JQuery Or DOM?

Jul 30, 2013

1.) So I have a page, call it Page1. I do some 'not very important' things on this page, and then I use a dynamic action to open a new page, call it Page2.

2.) I do some other things on Page2, and then close it.

3.) It just so happens that when some things are changed on Page2, some things are changed on Page1.

4.) When I close Page2 I do not see those changes, because it needs to be refreshed or reloaded. So, I would like to be able to--from any page--reference this page and refresh it. I come from an object oriented language background.

View 2 Replies View Related

Application Express :: Show Progress Bar While Only On Page Load?

Nov 13, 2012

I want to show progress bar every time when page loads.

Progress bar is coming on the page. but it is not going off after page is loaded.Below is the code which i added for the Progress bar.

//written on Header Text of Page
<script type="text/javascript">
<!--
function html_Submit_Progress(pThis){
$x_Show('AjaxLoading');
window.setTimeout('$s("AjaxLoading",$x("AjaxLoading").innerHTML)', 100);
}

[code]...

I want only to show only page loads.

Apex Version : Apex 4.1
DB Version : 10g

View 2 Replies View Related

Application Express :: Stop Submission Of Process On Refresh Page

Jun 25, 2013

I used to have a button, that called an after submit page process and everything ran fine.The page had loads of buttons, so I got rid of the buttons and created a list instead.I have an entry in a list. Target Type: Page, Page 1, Request is set to RUN_PLAN.This calls a before header page process with a condition of Request = Exp1 and Exp1 is set to RUN_PLAN. When the user clicks the list item, the process is run. This works fine.I also have a report on this page.As the process runs, it is updating a table.The user needs to watch this process running (via the report), so they need to keep refreshing the page.The problem is, that when they refresh the page via the browser refresh button the process is called again. How can I stop the process from running, every time the user refreshes the page. 

View 6 Replies View Related

Application Express :: How To Show Alert Message In Home Page

Jun 11, 2012

I have leave application form based on the LEAVE table, it has the following columns,

leave_id(primary key)
emp_name
from_date
to_date
no_of_days

Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?

View 5 Replies View Related

Application Express :: Dynamically Hide Show Page Items

Dec 14, 2012

Im tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.

In my page (form) I have 5 fileds iitems.

- Customer No
- Edit
- First Name
- Last Name
- Address

I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.

So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes

But it not working for me? Where am I go wrong?

View 2 Replies View Related

Application Express :: Hide And Show Region In A Page With Some Validations

Aug 4, 2012

I am using Apex 4.1 and theme 24. I have a hide and show region in a page with some validations. On any validation error the region refreshes and closes. I don't want the region to close on refresh except Submit.

View 2 Replies View Related

Application Express :: Get Part Of URL As Part Of Dynamic Action When Clicking A Button?

Nov 3, 2013

I have 3 pages: - Classes: a Classic Report that shows a list of classes and summarises attendance- Class Attendance Report: An Interactive Report that shows a row for each student that attended a class- Attendance Add / Edit Form On the Classes page, the Date value is a Link which passes a filter in the URL to the Class Attendance Report, showing only students who attended the class held on this date On the Class Attendance Report, I want to have a Region Button that, when clicked, goes to the Attendance Add / Edit Form and the Class Date field on this form is automatically populated with the same date value as was being used for the filter on the Interactive Report on the Class Attendance Report Page. So, I click on the Class Date link for 2013-11-01, this takes me to the Class Attendance Report and filters for students who have been already entered as attending on 2013-11-01. If I click on the "Add Attendance" button, it goes to the Attendance Add / Edit form and the Class Date is automatically set to 2013-11-01. I assume I need to do this via a Dynamic Action that runs when the "Add Attendance" button on the Class Attendance Report page is clicked?

View 6 Replies View Related

Application Express :: Dynamic Page Item Name

Nov 1, 2012

I have a from with some fields (VELD01, VELD02...VELD11) and a page process that fills that field. I want to make that more dynamic using a loop. Is it possible to use some 'dynamic SQL' like:

l_cnt := 1;
for r in c
loop
P1210_VELD0||l_cnt;
l_cnt := l_cnt + 1;
end loop;

Example above does not work of course...

View 3 Replies View Related

Application Express :: Dynamic Alignment Of Report Column And Page Item Value?

May 7, 2013

I have an interactive report which contains the columns like

<li>empno
<li>Name

In the above i have "empno" with a column alignment of left and a "Name" with a column alignment of left.

Whether it is possible to override the data alignment that we set in the report according to the value of the application item like

If my application item value is US, then i need the column alignment of both the column"empno" and "Name" to be left and if my application item value is AR, then i need the column alignment of both the column "empno" and "Name" to be right. Whether is it possible to achieve the dynamic alignment to the report data of both the columns "empno" and "Name" according to the application page item value.And also in the case of page item i have a page item with a name P1_NAME in which it has a Element Horizontal/Vertical alignment to left.

I need that element alignment of the page item to behave dynamically according to the application page item, like if the application page item is US then the element alignment of the page item has to be left and if the application page item is AR then the element alignment of the page item has to be right.

View 14 Replies View Related

Application Express :: To Change The Default Behavior Of Hide / Show Region To Show

Jun 26, 2012

I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.

View 16 Replies View Related

Application Express :: Checkbox On Click Action

Jan 15, 2013

I am working in apex 4.2.1.

I'm having an odd problem with a checkbox on a tabular form. I created the checkbox by setting hte display as to "Simple Checkbox". The value of the underlying column sets to "Y" wehn checked and "N" when unchecked. This is what I want. The next thing I was trying to accomplish is to call a javascript function when the checkbox is clicked. So I put onclick="calculateTotal(this);" in the element attributes field. The code that it is calling is listed below. When I run the app and check the box I can seee I am entering the calculate Total function. Each of the alert functions is displaying what I would expect until I get to alerts 'IAH5' and 'IAH6'. For each of those I get an "undefined" in the alert.

So to see if this had something to do with the checkbox and added an onchange="calculateTotal(this);" to another field in my tabular form and ran it. This time I did not click on the checkbox but went into the field that I put the onchange on. When I changed this field and navigated away from it the function worked as I would expect. It displayed the appropriate values for each of the alerts and updated the fields on the screen as designed.

<script type="text/javascript">
function calculateTotal(pThis)
{
alert('IAH1');
var vRow = pThis.id.substr(pThis.id.indexOf('_')+1);
alert('IAH2');
[code].......

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved