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 365: FROM cn_sca_credit_rules csca

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

Line 370: FROM cn_sca_credit_rules csca

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

Line 411: FROM cn_sca_credit_rules cscr

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

Line 460: FROM cn_sca_credit_rules

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

Line 485: cn_sca_credit_rules s,

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

Line 500: UPDATE cn_sca_credit_rules

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

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

598: message => '');
599:
600: WHEN l_no_rule_ex THEN
601: ROLLBACK;
602: debugmsg('Rules Sync : No Rules available in CN_SCA_CREDIT_RULES table');
603: cn_message_pkg.end_batch(l_process_audit_id);
604: conc_status := fnd_concurrent.set_completion_status(
605: status => 'ERROR',
606: message => '');