APPS.CN_SCA_DENORM_RULES_PVT dependencies on CN_SCA_CREDIT_RULES

Line 227: IS TABLE OF cn_sca_credit_rules.sca_credit_rule_id%TYPE;

223: --+ PL/SQL Tables and Records
224: --+
225:
226: TYPE credit_rule_id_tbl_type
227: IS TABLE OF cn_sca_credit_rules.sca_credit_rule_id%TYPE;
228:
229: l_credit_rule_id_tbl credit_rule_id_tbl_type;
230:
231: --+

Line 265: FROM cn_sca_credit_rules csca

261: WHERE transaction_source = p_txn_src
262: AND org_id = p_org_id
263: AND EXISTS (
264: SELECT 'S'
265: FROM cn_sca_credit_rules csca
266: WHERE csca.sca_credit_rule_id = csdr.sca_credit_rule_id
267: AND transaction_source = p_txn_src
268: AND NVL(IS_DENORMED,'N') = 'N');
269:

Line 272: FROM cn_sca_credit_rules csca

268: AND NVL(IS_DENORMED,'N') = 'N');
269:
270: CURSOR c2 IS
271: SELECT csca.sca_credit_rule_id
272: FROM cn_sca_credit_rules csca
273: WHERE transaction_source = p_txn_src
274: AND org_id = p_org_id
275: AND NVL(IS_DENORMED,'N') = 'N';
276: --

Line 304: cn_sca_credit_rules b

300:
301: SELECT count(1)
302: INTO l_invalid_rules
303: FROM cn_sca_conditions a,
304: cn_sca_credit_rules b
305: WHERE a.sca_credit_rule_id = b.sca_credit_rule_id
306: AND b.org_id = p_org_id
307: AND NOT EXISTS(
308: SELECT 'X'

Line 329: FROM cn_sca_credit_rules

325:
326: BEGIN
327: SELECT max(rank)
328: INTO l_max_rank
329: FROM cn_sca_credit_rules
330: WHERE transaction_source = p_txn_src
331: AND org_id = p_org_id;
332:
333: IF (l_max_rank IS NULL) THEN

Line 364: FROM cn_sca_credit_rules csca

360: WHERE transaction_source = p_txn_src
361: AND org_id = p_org_id
362: AND (EXISTS
363: (SELECT 'S'
364: FROM cn_sca_credit_rules csca
365: WHERE csca.sca_credit_rule_id = csdr.sca_credit_rule_id
366: AND NVL(IS_DENORMED,'N') = 'N')
367: OR NOT EXISTS
368: (SELECT 'S'

Line 369: FROM cn_sca_credit_rules csca

365: WHERE csca.sca_credit_rule_id = csdr.sca_credit_rule_id
366: AND NVL(IS_DENORMED,'N') = 'N')
367: OR NOT EXISTS
368: (SELECT 'S'
369: FROM cn_sca_credit_rules csca
370: WHERE csca.sca_credit_rule_id = csdr.sca_credit_rule_id));
371:
372: debugmsg('Rules Sync : Total Rules Deleted - '||SQL%ROWCOUNT);
373: debugmsg('Rules Sync : l_max_rank - '||l_max_rank);

Line 410: FROM cn_sca_credit_rules cscr

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
413: AND NVL(IS_DENORMED,'N') = 'N'
414: CONNECT BY PRIOR sca_credit_rule_id = parent_rule_id

Line 459: FROM cn_sca_credit_rules

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
462: AND org_id = p_org_id
463: CONNECT BY PRIOR parent_rule_id = sca_credit_rule_id

Line 484: cn_sca_credit_rules s,

480: AND r2.ancestor_rule_id = r1.ancestor_rule_id),
481: num_rule_attributes = (
482: SELECT count(distinct c.sca_rule_attribute_id)
483: FROM cn_sca_denorm_rules r,
484: cn_sca_credit_rules s,
485: cn_sca_conditions c
486: WHERE r.transaction_source = p_txn_src
487: AND s.transaction_source = p_txn_src
488: AND r.sca_credit_rule_id = c1_rec.sca_credit_rule_id

Line 499: UPDATE cn_sca_credit_rules

495: --+
496: --+ Resetting the is_denormed flag
497: --+
498:
499: UPDATE cn_sca_credit_rules
500: SET is_denormed = 'Y'
501: WHERE sca_credit_rule_id = c1_rec.sca_credit_rule_id
502: AND transaction_source = p_txn_src
503: AND org_id = p_org_id;

Line 596: debugmsg('Rules Sync : No Rules available in CN_SCA_CREDIT_RULES table');

592: message => '');
593:
594: WHEN l_no_rule_ex THEN
595: ROLLBACK;
596: debugmsg('Rules Sync : No Rules available in CN_SCA_CREDIT_RULES table');
597: cn_message_pkg.end_batch(l_process_audit_id);
598: conc_status := fnd_concurrent.set_completion_status(
599: status => 'ERROR',
600: message => '');