eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_RULE_TEMP dependencies on DUAL

Line 73: select USERENV('SESSIONID') into l_ssnid from dual;

69: l_appr_desc VARCHAR2(100);
70:
71: BEGIN
72:
73: select USERENV('SESSIONID') into l_ssnid from dual;
74:
75: -- 3171627 note: this procedure is obsolete due to new ConfigVar ERES key.
76: select distinct application_id, application_name into l_apps_id, l_apps_name
77: from ame_calling_apps

Line 180: select USERENV('SESSIONID') into l_ssnid from dual;

176: l_appr_type VARCHAR2(100);
177: l_appr_desc VARCHAR2(100);
178:
179: BEGIN
180: select USERENV('SESSIONID') into l_ssnid from dual;
181:
182: -- 3171627 note: this procedure is obsolete. ame_calling_apps.end_date cannot be in future.
183: select transaction_type_id, application_id into l_trans_id, l_apps_id
184: from ame_calling_apps

Line 253: select USERENV('SESSIONID') into l_ssnid from dual;

249: PROCEDURE CLEAR_DETAILS_TRANS ( p_trans_id IN VARCHAR2
250: ) IS
251: l_ssnid NUMBER;
252: BEGIN
253: select USERENV('SESSIONID') into l_ssnid from dual;
254:
255: delete edr_rule_detail_temp where transaction_type_id = p_trans_id and SESSION_ID = l_ssnid;
256:
257: delete edr_rule_condition_temp where transaction_type_id = p_trans_id and SESSION_ID = l_ssnid;

Line 268: select USERENV('SESSIONID') into l_ssnid from dual;

264: ) IS
265: l_ssnid NUMBER;
266: l_apps_id NUMBER;
267: BEGIN
268: select USERENV('SESSIONID') into l_ssnid from dual;
269:
270: delete edr_rule_detail_temp where transaction_type_id = p_trans_id
271: and RULE_ID = p_rule_id and SESSION_ID = l_ssnid;
272:

Line 307: select substr( p_trans_var, 1, instr(p_trans_var,'-')-1 ) into p_trans_id from dual;

303: l_appr_type VARCHAR2(100);
304: l_appr_desc VARCHAR2(100);
305:
306: BEGIN
307: select substr( p_trans_var, 1, instr(p_trans_var,'-')-1 ) into p_trans_id from dual;
308: select substr( p_trans_var, 1+instr(p_trans_var,'-') ) into p_input_var from dual;
309:
310: select USERENV('SESSIONID') into l_ssnid from dual;
311:

Line 308: select substr( p_trans_var, 1+instr(p_trans_var,'-') ) into p_input_var from dual;

304: l_appr_desc VARCHAR2(100);
305:
306: BEGIN
307: select substr( p_trans_var, 1, instr(p_trans_var,'-')-1 ) into p_trans_id from dual;
308: select substr( p_trans_var, 1+instr(p_trans_var,'-') ) into p_input_var from dual;
309:
310: select USERENV('SESSIONID') into l_ssnid from dual;
311:
312: -- ame_calling_apps' end_date can only be null or outdated, no end_date>sysdate

Line 310: select USERENV('SESSIONID') into l_ssnid from dual;

306: BEGIN
307: select substr( p_trans_var, 1, instr(p_trans_var,'-')-1 ) into p_trans_id from dual;
308: select substr( p_trans_var, 1+instr(p_trans_var,'-') ) into p_input_var from dual;
309:
310: select USERENV('SESSIONID') into l_ssnid from dual;
311:
312: -- ame_calling_apps' end_date can only be null or outdated, no end_date>sysdate
313: select distinct application_id, application_name into l_apps_id, l_apps_name
314: from ame_calling_apps

Line 407: select substr( p_trans_rule, 1, instr(p_trans_rule,'-')-1 ) into p_trans_name from dual;

403: l_appr_type VARCHAR2(100);
404: l_appr_desc VARCHAR2(100);
405:
406: BEGIN
407: select substr( p_trans_rule, 1, instr(p_trans_rule,'-')-1 ) into p_trans_name from dual;
408: select instr(p_trans_rule, '-', 1+instr(p_trans_rule,'-')) into l_position from dual;
409:
410: --Bug : 3499311 : Start - Specified Number Format in call TO_NUMBER
411: select TO_NUMBER( substr( p_trans_rule, 1+instr(p_trans_rule,'-'),

Line 408: select instr(p_trans_rule, '-', 1+instr(p_trans_rule,'-')) into l_position from dual;

404: l_appr_desc VARCHAR2(100);
405:
406: BEGIN
407: select substr( p_trans_rule, 1, instr(p_trans_rule,'-')-1 ) into p_trans_name from dual;
408: select instr(p_trans_rule, '-', 1+instr(p_trans_rule,'-')) into l_position from dual;
409:
410: --Bug : 3499311 : Start - Specified Number Format in call TO_NUMBER
411: select TO_NUMBER( substr( p_trans_rule, 1+instr(p_trans_rule,'-'),
412: l_position - instr(p_trans_rule,'-') - 1 ),'999999999999.999999' ) into p_rule_id from dual;

Line 412: l_position - instr(p_trans_rule,'-') - 1 ),'999999999999.999999' ) into p_rule_id from dual;

408: select instr(p_trans_rule, '-', 1+instr(p_trans_rule,'-')) into l_position from dual;
409:
410: --Bug : 3499311 : Start - Specified Number Format in call TO_NUMBER
411: select TO_NUMBER( substr( p_trans_rule, 1+instr(p_trans_rule,'-'),
412: l_position - instr(p_trans_rule,'-') - 1 ),'999999999999.999999' ) into p_rule_id from dual;
413: --Bug : 3499311 : End
414:
415: select USERENV('SESSIONID') into l_ssnid from dual;
416:

Line 415: select USERENV('SESSIONID') into l_ssnid from dual;

411: select TO_NUMBER( substr( p_trans_rule, 1+instr(p_trans_rule,'-'),
412: l_position - instr(p_trans_rule,'-') - 1 ),'999999999999.999999' ) into p_rule_id from dual;
413: --Bug : 3499311 : End
414:
415: select USERENV('SESSIONID') into l_ssnid from dual;
416:
417: -- ame_calling_apps' end_date can only be null or outdated, transName/transId must be unique
418: select transaction_type_id, application_id into l_trans_id, l_apps_id
419: from ame_calling_apps

Line 516: select USERENV('SESSIONID') into l_ssnid from dual;

512: select distinct ame_trans_id, input_name into p_trans_id, p_input_var
513: from edr_ametran_input_var where tran_config_id = TO_NUMBER(p_trans_config_id,'999999999999.999999');
514: --Bug : 3499311 : End
515:
516: select USERENV('SESSIONID') into l_ssnid from dual;
517:
518: select distinct application_id, application_name into l_apps_id, l_apps_name
519: from ame_calling_apps
520: where transaction_type_id = p_trans_id

Line 625: select USERENV('SESSIONID') into l_ssnid from dual;

621: select distinct ame_trans_name, rule_id into p_trans_name, p_rule_id
622: from edr_amerule_input_var where rule_config_id = TO_NUMBER(p_rule_config_id,'999999999999.999999');
623: --Bug : 3499311 : End
624:
625: select USERENV('SESSIONID') into l_ssnid from dual;
626:
627: -- 3075902 note: shall be ok below, b'coz ame_trans_name has been updated to the new name
628: select transaction_type_id, application_id into l_trans_id, l_apps_id
629: from ame_calling_apps

Line 723: SELECT USERENV('SESSIONID') INTO L_SSNID FROM DUAL;

719:
720: BEGIN
721:
722: --Set the session ID value.
723: SELECT USERENV('SESSIONID') INTO L_SSNID FROM DUAL;
724:
725: --Obtain the application ID and application Name from the AME tables.
726: SELECT DISTINCT APPLICATION_ID, APPLICATION_NAME INTO L_APPS_ID, L_APPS_NAME
727: FROM AME_CALLING_APPS_VL

Line 830: SELECT USERENV('SESSIONID') INTO L_SSNID FROM DUAL;

826:
827: BEGIN
828:
829:
830: SELECT USERENV('SESSIONID') INTO L_SSNID FROM DUAL;
831:
832: SELECT APPLICATION_ID INTO L_APPS_ID
833: FROM AME_CALLING_APPS_VL
834: WHERE TRANSACTION_TYPE_ID = P_TRANSACTION_ID