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_RULE_USAGES

Line 89: into l_rule_ids, l_date_0s, l_date_1s from ame_rule_usages

85:
86: /* bulk collect use implicit cursor to pull out rule details from rule_usages */
87:
88: select distinct rule_id, start_date, end_date bulk collect
89: into l_rule_ids, l_date_0s, l_date_1s from ame_rule_usages
90: --Bug 4652277: Start
91: --where item_id = l_apps_id and (end_date is null OR end_date > sysdate);
92: where item_id = l_apps_id and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);
93: --Bug 4652277: End

Line 195: and rule_id in ( select distinct rule_id from ame_rule_usages where item_id = l_apps_id )

191: -- 3171627 end: restrict end_date for valid transaction with new description
192:
193: -- 3171627 note: this procedure is obsolete due to new ConfigVar ERES key.
194: select distinct rule_id into l_rule_id from ame_rules where description = p_rule_name
195: and rule_id in ( select distinct rule_id from ame_rule_usages where item_id = l_apps_id )
196: --Bug 4652277: Start
197: --and (end_date is null or end_date > sysdate);
198: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));
199: --Bug 4652277: End

Line 204: from ame_rule_usages

200:
201: -- 3171627 end: to avoid the deleted rule being recreated for the same transaction
202:
203: select start_date, end_date into l_date_frm, l_date_end
204: from ame_rule_usages
205: where rule_id = l_rule_id
206: --Bug 4652277: Start
207: --and (end_date is null or end_date > sysdate);
208: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));

Line 323: into l_rule_ids, l_date_0s, l_date_1s from ame_rule_usages

319: --Bug 4652277: End
320:
321:
322: select distinct rule_id, start_date, end_date bulk collect
323: into l_rule_ids, l_date_0s, l_date_1s from ame_rule_usages
324: where item_id = l_apps_id
325: --Bug 4652277: Start
326: --and (end_date is null OR end_date > sysdate);
327: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));

Line 440: from ame_rule_usages where rule_id = l_rule_id and item_id = l_apps_id

436:
437: -- 3171627 end: add constraint on end_date
438:
439: select start_date, end_date into l_date_frm, l_date_end
440: from ame_rule_usages where rule_id = l_rule_id and item_id = l_apps_id
441: --Bug 4652277: Start
442: --and (end_date is null OR end_date > sysdate);
443: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));
444: --Bug 4652277: End

Line 527: into l_rule_ids, l_date_0s, l_date_1s from ame_rule_usages

523: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);
524: --Bug 4652277: End
525:
526: select distinct rule_id, start_date, end_date bulk collect
527: into l_rule_ids, l_date_0s, l_date_1s from ame_rule_usages
528: where item_id = l_apps_id
529: --Bug 4652277: Start
530: --and (end_date is null OR end_date > sysdate);
531: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));

Line 648: from ame_rule_usages where rule_id = l_rule_id and item_id = l_apps_id

644:
645: -- 3171627 end: add end_date constraint to prevent multiple matches
646:
647: select distinct start_date, end_date into l_date_frm, l_date_end
648: from ame_rule_usages where rule_id = l_rule_id and item_id = l_apps_id
649: --Bug 4652277: Start
650: --and (end_date is null OR end_date > sysdate);
651: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));
652: --Bug 4652277: End

Line 733: INTO L_RULE_IDS, L_DATE_0S, L_DATE_1S FROM AME_RULE_USAGES

729: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
730:
731: --Obtain all the applicable AME rules in one shot.
732: SELECT DISTINCT RULE_ID, START_DATE, END_DATE BULK COLLECT
733: INTO L_RULE_IDS, L_DATE_0S, L_DATE_1S FROM AME_RULE_USAGES
734: WHERE ITEM_ID = L_APPS_ID
735: AND SYSDATE <= NVL(END_DATE,SYSDATE);
736:
737:

Line 845: FROM AME_RULE_USAGES

841: AND SYSDATE <= NVL(END_DATE,SYSDATE);
842:
843:
844: SELECT DISTINCT START_DATE, END_DATE INTO L_DATE_FRM, L_DATE_END
845: FROM AME_RULE_USAGES
846: WHERE RULE_ID = P_RULE_ID
847: AND ITEM_ID = L_APPS_ID
848: AND SYSDATE <= NVL(END_DATE,SYSDATE);
849:

Line 921: AME_RULE_USAGES AME_USAGES

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));
925:

Line 957: AME_RULE_USAGES AME_USAGES

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));
961: