APPS.IBY_ROUTINGINFO_PKG dependencies on IBY_PMTMTHD_CONDITIONS

Line 58: INSERT INTO iby_pmtmthd_conditions

54: i_rules.priority, sysdate, fnd_global.user_id, sysdate,
55: fnd_global.user_id, fnd_global.login_id, i_rules.hitcounter, 1);
56:
57: FOR v_count in 1..i_conditions.COUNT LOOP
58: INSERT INTO iby_pmtmthd_conditions
59: (paymentmethodid, parameter_code, operation_code, value,
60: is_value_string, entry_sequence, condition_name, last_update_date,
61: last_updated_by, creation_date, created_by, last_update_login,
62: object_version_number)

Line 137: DELETE FROM iby_pmtmthd_conditions

133: END LOOP;
134:
135: COMMIT;
136: IF ( i_conditions.COUNT > 0 ) THEN
137: DELETE FROM iby_pmtmthd_conditions
138: WHERE l_ruleId = iby_pmtmthd_conditions.PAYMENTMETHODID ;
139:
140: FOR v_count in 1..i_conditions.COUNT LOOP
141: iby_pmtmthd_conditions_pkg.createCondition(l_ruleId,

Line 138: WHERE l_ruleId = iby_pmtmthd_conditions.PAYMENTMETHODID ;

134:
135: COMMIT;
136: IF ( i_conditions.COUNT > 0 ) THEN
137: DELETE FROM iby_pmtmthd_conditions
138: WHERE l_ruleId = iby_pmtmthd_conditions.PAYMENTMETHODID ;
139:
140: FOR v_count in 1..i_conditions.COUNT LOOP
141: iby_pmtmthd_conditions_pkg.createCondition(l_ruleId,
142: i_conditions(v_count).parameter,

Line 141: iby_pmtmthd_conditions_pkg.createCondition(l_ruleId,

137: DELETE FROM iby_pmtmthd_conditions
138: WHERE l_ruleId = iby_pmtmthd_conditions.PAYMENTMETHODID ;
139:
140: FOR v_count in 1..i_conditions.COUNT LOOP
141: iby_pmtmthd_conditions_pkg.createCondition(l_ruleId,
142: i_conditions(v_count).parameter,
143: i_conditions(v_count).operation,
144: i_conditions(v_count).value,
145: i_conditions(v_count).is_value_string,

Line 200: DELETE FROM iby_pmtmthd_conditions a

196: IF c_routingInfo%ISOPEN THEN
197: CLOSE c_routingInfo;
198: END IF;
199:
200: DELETE FROM iby_pmtmthd_conditions a
201: WHERE a.paymentmethodid = i_paymentmethodId;
202:
203: COMMIT;
204: