APPS.CN_SCA_CREDITS_BATCH_PVT dependencies on CN_SCA_HEADERS_INTERFACE

Line 70: IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE;

66: --+ PL/SQL Tables and Records
67: --+
68:
69: TYPE interface_id_tbl_type
70: IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE;
71:
72: TYPE credit_rule_id_tbl_type
73: IS TABLE OF cn_sca_credit_rules.sca_credit_rule_id%TYPE;
74:

Line 76: IS TABLE OF cn_sca_headers_interface.process_status%TYPE;

72: TYPE credit_rule_id_tbl_type
73: IS TABLE OF cn_sca_credit_rules.sca_credit_rule_id%TYPE;
74:
75: TYPE process_status_tbl_type
76: IS TABLE OF cn_sca_headers_interface.process_status%TYPE;
77:
78: TYPE rounding_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
79:
80: TYPE lines_output_id_tbl_type

Line 416: --+ Update STATUS flag in the cn_sca_headers_interface table. First update

412: RAISE;
413: END;
414:
415: --+
416: --+ Update STATUS flag in the cn_sca_headers_interface table. First update
417: --+ 'ALLOCATED' and 'REV NOT 100' Flags.
418: --+
419:
420: debugmsg('Process Batch Rules: Updating ALLOCATED and REV NOT 100 flag');

Line 431: UPDATE cn_sca_headers_interface h

427: CLOSE ps_cur;
428:
429: IF (l_sca_winners_tbl_rec.interface_id_tbl.COUNT > 0) THEN
430: FORALL indx IN l_sca_winners_tbl_rec.interface_id_tbl.FIRST .. l_sca_winners_tbl_rec.interface_id_tbl.LAST
431: UPDATE cn_sca_headers_interface h
432: SET credit_rule_id = l_sca_winners_tbl_rec.credit_rule_id_tbl(indx),
433: process_status = l_sca_winners_tbl_rec.process_status_tbl(indx)
434: WHERE h.sca_headers_interface_id = l_sca_winners_tbl_rec.interface_id_tbl(indx);
435:

Line 450: 'UPDATE cn_sca_headers_interface h '||

446: --+ 8.1.7
447: --+
448:
449: l_not_allocated_sql :=
450: 'UPDATE cn_sca_headers_interface h '||
451: ' SET (credit_rule_id,process_status) = ( '||
452: ' SELECT b.sca_credit_rule_id, '||
453: ' ''NOT ALLOCATED'' '||
454: ' FROM (SELECT sca_headers_interface_id,sca_credit_rule_id, '||

Line 499: UPDATE cn_sca_headers_interface h

495: END;
496:
497: COMMIT WORK;
498: --
499: UPDATE cn_sca_headers_interface h
500: SET process_status = 'NO RULE'
501: WHERE h.credit_rule_id IS NULL
502: AND h.process_status IS NULL
503: AND h.org_id = p_org_id -- added org_id here