DBA Data[Home] [Help]

APPS.CN_SCA_DENORM_RULES_PVT dependencies on FND_GLOBAL

Line 187: fnd_global.user_id,

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,

Line 189: fnd_global.user_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

Line 191: fnd_global.login_id,

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

Line 286: x_request_id => fnd_global.conc_request_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);

Line 404: fnd_global.user_id,

400: level,
401: 1/(NVL(DECODE(rank,0,0.1,rank),l_max_rank)*POWER(l_max_rank,level)), -- relative rank
402: DECODE(NVL(parent_rule_id,0),0,'Y','N'), -- root flag
403: p_txn_src,
404: fnd_global.user_id,
405: SYSDATE,
406: fnd_global.user_id,
407: SYSDATE,
408: fnd_global.login_id,

Line 406: fnd_global.user_id,

402: DECODE(NVL(parent_rule_id,0),0,'Y','N'), -- root flag
403: p_txn_src,
404: fnd_global.user_id,
405: SYSDATE,
406: fnd_global.user_id,
407: SYSDATE,
408: fnd_global.login_id,
409: p_org_id
410: FROM cn_sca_credit_rules cscr

Line 408: fnd_global.login_id,

404: fnd_global.user_id,
405: SYSDATE,
406: fnd_global.user_id,
407: SYSDATE,
408: fnd_global.login_id,
409: p_org_id
410: FROM cn_sca_credit_rules cscr
411: WHERE transaction_source = p_txn_src
412: AND org_id = p_org_id

Line 453: fnd_global.user_id,

449: c1_rec.level_from_root,
450: c1_rec.relative_rank,
451: c1_rec.root_flag,
452: p_txn_src,
453: fnd_global.user_id,
454: SYSDATE,
455: fnd_global.user_id,
456: SYSDATE,
457: fnd_global.login_id,

Line 455: fnd_global.user_id,

451: c1_rec.root_flag,
452: p_txn_src,
453: fnd_global.user_id,
454: SYSDATE,
455: fnd_global.user_id,
456: SYSDATE,
457: fnd_global.login_id,
458: p_org_id
459: FROM cn_sca_credit_rules

Line 457: fnd_global.login_id,

453: fnd_global.user_id,
454: SYSDATE,
455: fnd_global.user_id,
456: SYSDATE,
457: fnd_global.login_id,
458: p_org_id
459: FROM cn_sca_credit_rules
460: WHERE sca_credit_rule_id <> c1_rec.sca_credit_rule_id
461: AND transaction_source = p_txn_src