APPS.EDR_RULE_TEMP dependencies on EDR_AMERULE_INPUT_VAR

Line 103: and description in ( select distinct rule_name from edr_amerule_input_var

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);
107: and (sysdate between START_DATE AND NVL(END_DATE, SYSDATE));

Line 335: and description in ( select distinct rule_name from edr_amerule_input_var

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
339: l_deft_use := 'N';

Line 541: and description in ( select distinct rule_name from edr_amerule_input_var

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
545: -- 3075902 end: change equal test on transName to IN operation based on transId

Line 622: from edr_amerule_input_var where rule_config_id = TO_NUMBER(p_rule_config_id,'999999999999.999999');

618: BEGIN
619:
620: --Bug : 3499311 : Start - Specified Number Format in call TO_NUMBER
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:

Line 746: EDR_AMERULE_INPUT_VAR RULE_VAR

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
750: AND RULE_VAR.INPUT_NAME = P_VARIABLE_NAME

Line 917: DELETE FROM EDR_AMERULE_INPUT_VAR RULE_VAR

913: PRAGMA AUTONOMOUS_TRANSACTION;
914:
915: BEGIN
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

Line 953: SELECT COUNT(*) INTO L_COUNT FROM EDR_AMERULE_INPUT_VAR RULE_VAR

949: L_COUNT NUMBER;
950:
951: BEGIN
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