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 AME_CALLING_APPS

Line 77: from ame_calling_apps

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
78: where transaction_type_id = p_trans_id
79: --Bug 4652277: Start
80: --and end_Date is null;
81: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);

Line 182: -- 3171627 note: this procedure is obsolete. ame_calling_apps.end_date cannot be in future.

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
185: where application_name = p_trans_name
186: --Bug 4652277: Start

Line 184: from ame_calling_apps

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
185: where application_name = p_trans_name
186: --Bug 4652277: Start
187: --and end_Date is null;
188: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));

Line 312: -- ame_calling_apps' end_date can only be null or outdated, no end_date>sysdate

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
315: where transaction_type_id = p_trans_id
316: --Bug 4652277: Start

Line 314: from ame_calling_apps

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
315: where transaction_type_id = p_trans_id
316: --Bug 4652277: Start
317: --AND end_date is null ;
318: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);

Line 417: -- ame_calling_apps' end_date can only be null or outdated, transName/transId must be unique

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
420: where application_name = p_trans_name
421: --Bug 4652277: Start

Line 419: from ame_calling_apps

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
420: where application_name = p_trans_name
421: --Bug 4652277: Start
422: --and end_date is null;
423: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);

Line 519: from ame_calling_apps

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
521: --Bug 4652277: Start
522: --and end_date is null;
523: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);

Line 542: where ame_trans_name in (select distinct application_name from ame_calling_apps

538: -- 3075902 note: trans/ruleName may be changed and names in ruleVar table become old
539: -- no need for end_date constraint because it's validated above
540: select count(*) into l_count_num from ame_rules where rule_id = l_rule_ids(ith)
541: and description in ( select distinct rule_name from edr_amerule_input_var
542: where ame_trans_name in (select distinct application_name from ame_calling_apps
543: where transaction_type_id = p_trans_id) and input_name = p_input_var );
544: -- 3075902 fix doesn't help here if ruleVar not touched but need correct default usage
545: -- 3075902 end: change equal test on transName to IN operation based on transId
546:

Line 629: from ame_calling_apps

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
630: where application_name = p_trans_name
631: --Bug 4652277: Start
632: --and end_date is null;
633: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);

Line 727: FROM AME_CALLING_APPS_VL

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
728: WHERE TRANSACTION_TYPE_ID = P_TRANSACTION_ID
729: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
730:
731: --Obtain all the applicable AME rules in one shot.

Line 833: FROM AME_CALLING_APPS_VL

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
835: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
836:
837:

Line 920: FROM AME_CALLING_APPS_VL AME_APPS,

916:
917: DELETE FROM EDR_AMERULE_INPUT_VAR RULE_VAR
918: WHERE RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID
919: AND RULE_VAR.RULE_ID NOT IN (SELECT AME_USAGES.RULE_ID
920: FROM AME_CALLING_APPS_VL AME_APPS,
921: AME_RULE_USAGES AME_USAGES
922: WHERE AME_APPS.TRANSACTION_TYPE_ID = P_TRANSACTION_ID
923: AND AME_APPS.APPLICATION_ID = AME_USAGES.ITEM_ID
924: AND SYSDATE <= NVL(AME_USAGES.END_DATE,SYSDATE));

Line 956: FROM AME_CALLING_APPS_VL AME_APPS,

952:
953: SELECT COUNT(*) INTO L_COUNT FROM EDR_AMERULE_INPUT_VAR RULE_VAR
954: WHERE RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID
955: AND RULE_VAR.RULE_ID NOT IN (SELECT AME_USAGES.RULE_ID
956: FROM AME_CALLING_APPS_VL AME_APPS,
957: AME_RULE_USAGES AME_USAGES
958: WHERE AME_APPS.TRANSACTION_TYPE_ID = P_TRANSACTION_ID
959: AND AME_APPS.APPLICATION_ID = AME_USAGES.ITEM_ID
960: AND SYSDATE <= NVL(AME_USAGES.END_DATE,SYSDATE));