183: org_id)
184: SELECT sca_rule_attribute_id,
185: get_attr_rec.rule_attr_comb_value,
186: p_transaction_source,
187: fnd_global.user_id,
188: SYSDATE,
189: fnd_global.user_id,
190: SYSDATE,
191: fnd_global.login_id,
185: get_attr_rec.rule_attr_comb_value,
186: p_transaction_source,
187: fnd_global.user_id,
188: SYSDATE,
189: fnd_global.user_id,
190: SYSDATE,
191: fnd_global.login_id,
192: p_org_id
193: FROM cn_sca_rule_cond_vals_mv mv
187: fnd_global.user_id,
188: SYSDATE,
189: fnd_global.user_id,
190: SYSDATE,
191: fnd_global.login_id,
192: p_org_id
193: FROM cn_sca_rule_cond_vals_mv mv
194: WHERE mv.sca_credit_rule_id IN (
195: SELECT sca_credit_rule_id
282: cn_message_pkg.begin_batch (
283: x_process_type => 'SCA Rules Sync',
284: x_parent_proc_audit_id => null,
285: x_process_audit_id => l_process_audit_id,
286: x_request_id => fnd_global.conc_request_id,
287: p_org_id => p_org_id);
288:
289: debugmsg('Rules Sync : Start of the Rules Synchronization');
290: debugmsg('Rules Sync : l_process_audit_id - '||l_process_audit_id);
401: level,
402: 1/(NVL(DECODE(rank,0,0.1,rank),l_max_rank)*POWER(l_max_rank,level)), -- relative rank
403: DECODE(NVL(parent_rule_id,0),0,'Y','N'), -- root flag
404: p_txn_src,
405: fnd_global.user_id,
406: SYSDATE,
407: fnd_global.user_id,
408: SYSDATE,
409: fnd_global.login_id,
403: DECODE(NVL(parent_rule_id,0),0,'Y','N'), -- root flag
404: p_txn_src,
405: fnd_global.user_id,
406: SYSDATE,
407: fnd_global.user_id,
408: SYSDATE,
409: fnd_global.login_id,
410: p_org_id
411: FROM cn_sca_credit_rules cscr
405: fnd_global.user_id,
406: SYSDATE,
407: fnd_global.user_id,
408: SYSDATE,
409: fnd_global.login_id,
410: p_org_id
411: FROM cn_sca_credit_rules cscr
412: WHERE transaction_source = p_txn_src
413: AND org_id = p_org_id
450: c1_rec.level_from_root,
451: c1_rec.relative_rank,
452: c1_rec.root_flag,
453: p_txn_src,
454: fnd_global.user_id,
455: SYSDATE,
456: fnd_global.user_id,
457: SYSDATE,
458: fnd_global.login_id,
452: c1_rec.root_flag,
453: p_txn_src,
454: fnd_global.user_id,
455: SYSDATE,
456: fnd_global.user_id,
457: SYSDATE,
458: fnd_global.login_id,
459: p_org_id
460: FROM cn_sca_credit_rules
454: fnd_global.user_id,
455: SYSDATE,
456: fnd_global.user_id,
457: SYSDATE,
458: fnd_global.login_id,
459: p_org_id
460: FROM cn_sca_credit_rules
461: WHERE sca_credit_rule_id <> c1_rec.sca_credit_rule_id
462: AND transaction_source = p_txn_src