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_RULES

Line 102: select count(*) into l_count_num from ame_rules where rule_id = l_rule_ids(ith)

98:
99: /* determine if the rule defines its own value for the variable */
100:
101: -- 3171627 note: deleted rule doesn't count for transVar default usage
102: select count(*) into l_count_num from ame_rules where rule_id = l_rule_ids(ith)
103: and description in ( select distinct rule_name from edr_amerule_input_var
104: where ame_trans_name = l_apps_name and input_name = p_input_var )
105: --Bug 4652277: Start
106: -- and (end_date is null or end_date > sysdate);

Line 138: select distinct description into l_rule_name from ame_rules where rule_id = l_rule_ids(ith);

134: END LOOP;
135:
136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN
138: select distinct description into l_rule_name from ame_rules where rule_id = l_rule_ids(ith);
139:
140: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name,
141: default_var, start_date, end_date) values ( l_ssnid, p_trans_id, l_rule_ids(ith),
142: l_rule_name, l_deft_use, l_date_0s(ith), l_date_1s(ith) );

Line 194: select distinct rule_id into l_rule_id from ame_rules where description = p_rule_name

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

Line 334: select count(*) into l_count_num from ame_rules where rule_id = l_rule_ids(ith)

330: FOR ith IN 1..l_rule_ids.count LOOP
331:
332: BEGIN
333:
334: select count(*) into l_count_num from ame_rules where rule_id = l_rule_ids(ith)
335: and description in ( select distinct rule_name from edr_amerule_input_var
336: where ame_trans_name = l_apps_name and input_name = p_input_var );
337:
338: IF l_count_num > 0 THEN

Line 365: select distinct description into l_rule_name from ame_rules where rule_id = l_rule_ids(ith);

361: END LOOP;
362:
363: EXCEPTION
364: WHEN NO_DATA_FOUND THEN
365: select distinct description into l_rule_name from ame_rules where rule_id = l_rule_ids(ith);
366: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name, default_var,
367: start_date, end_date) values ( l_ssnid, p_trans_id, l_rule_ids(ith),
368: l_rule_name, l_deft_use, l_date_0s(ith), l_date_1s(ith) );
369: /* insert into edr_rule_condition_temp ( session_id, transaction_type_id, rule_id, condition_id,

Line 430: select distinct description into p_rule_name from ame_rules

426:
427: l_rule_id := p_rule_id;
428:
429: -- 3171627 start: rule name can be changed in AME
430: select distinct description into p_rule_name from ame_rules
431: where rule_id = l_rule_id
432: --Bug 4652277: Start
433: --and (end_date is null or end_date > sysdate);
434: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));

Line 540: select count(*) into l_count_num from ame_rules where rule_id = l_rule_ids(ith)

536: BEGIN
537:
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

Line 574: select distinct description into l_rule_name from ame_rules

570:
571: EXCEPTION
572: WHEN NO_DATA_FOUND THEN
573: -- 3171627 start: rule description can be changed in AME, rule_usages validation doesn't help here
574: select distinct description into l_rule_name from ame_rules
575: where rule_id = l_rule_ids(ith) and (end_date is null or end_date > sysdate);
576: -- 3171627 end: add end_date constraint to prevent multiple matches
577: insert into edr_rule_detail_temp ( session_id, transaction_type_id, rule_id, rule_name, default_var,
578: start_date, end_date) values ( l_ssnid, p_trans_id, l_rule_ids(ith),

Line 638: select distinct description into p_rule_name from ame_rules

634: --Bug 4652277: End
635:
636: l_rule_id := p_rule_id;
637: -- 3171627 start: rule description can be changed in AME, rule_usages validation doesn't help here
638: select distinct description into p_rule_name from ame_rules
639: where rule_id = l_rule_id
640: --Bug 4652277: Start
641: --and (end_date is null or end_date > sysdate);
642: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));

Line 731: --Obtain all the applicable AME rules in one shot.

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.
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);

Line 745: FROM AME_RULES_VL AME_RULES,

741: BEGIN
742:
743: SELECT COUNT(*)
744: INTO L_COUNT_NUM
745: FROM AME_RULES_VL AME_RULES,
746: EDR_AMERULE_INPUT_VAR RULE_VAR
747: WHERE AME_RULES.RULE_ID = L_RULE_IDS(ith)
748: AND AME_RULES.RULE_ID = RULE_VAR.RULE_ID
749: AND RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID

Line 747: WHERE AME_RULES.RULE_ID = L_RULE_IDS(ith)

743: SELECT COUNT(*)
744: INTO L_COUNT_NUM
745: FROM AME_RULES_VL AME_RULES,
746: EDR_AMERULE_INPUT_VAR RULE_VAR
747: WHERE AME_RULES.RULE_ID = L_RULE_IDS(ith)
748: AND AME_RULES.RULE_ID = RULE_VAR.RULE_ID
749: AND RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID
750: AND RULE_VAR.INPUT_NAME = P_VARIABLE_NAME
751: AND SYSDATE <= NVL(AME_RULES.END_DATE,SYSDATE);

Line 748: AND AME_RULES.RULE_ID = RULE_VAR.RULE_ID

744: INTO L_COUNT_NUM
745: FROM AME_RULES_VL AME_RULES,
746: EDR_AMERULE_INPUT_VAR RULE_VAR
747: WHERE AME_RULES.RULE_ID = L_RULE_IDS(ith)
748: AND AME_RULES.RULE_ID = RULE_VAR.RULE_ID
749: AND RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID
750: AND RULE_VAR.INPUT_NAME = P_VARIABLE_NAME
751: AND SYSDATE <= NVL(AME_RULES.END_DATE,SYSDATE);
752:

Line 751: AND SYSDATE <= NVL(AME_RULES.END_DATE,SYSDATE);

747: WHERE AME_RULES.RULE_ID = L_RULE_IDS(ith)
748: AND AME_RULES.RULE_ID = RULE_VAR.RULE_ID
749: AND RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID
750: AND RULE_VAR.INPUT_NAME = P_VARIABLE_NAME
751: AND SYSDATE <= NVL(AME_RULES.END_DATE,SYSDATE);
752:
753: IF L_COUNT_NUM > 0 THEN
754: L_DEFT_USE := 'N';
755: ELSE

Line 784: INTO L_RULE_NAME FROM AME_RULES_VL

780: EXCEPTION
781: WHEN NO_DATA_FOUND THEN
782:
783: SELECT DISTINCT DESCRIPTION
784: INTO L_RULE_NAME FROM AME_RULES_VL
785: WHERE RULE_ID = L_RULE_IDS(ith) AND (END_DATE IS NULL OR END_DATE > SYSDATE);
786:
787: INSERT INTO EDR_RULE_DETAIL_TEMP ( SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME,
788: DEFAULT_VAR, START_DATE, END_DATE)

Line 839: INTO L_RULE_NAME FROM AME_RULES_VL

835: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
836:
837:
838: SELECT DISTINCT DESCRIPTION
839: INTO L_RULE_NAME FROM AME_RULES_VL
840: WHERE RULE_ID = P_RULE_ID
841: AND SYSDATE <= NVL(END_DATE,SYSDATE);
842:
843: