APPS.IGC_CBC_GL_FC_PKG dependencies on IGC_CC_INTERFACE

Line 26: SELECT * from IGC_CC_INTERFACE

22: */
23: g_batch_line_const NUMBER := 100000;
24:
25: CURSOR c_igc_cc_int(p_doc_id in NUMBER, p_doc_type IN VARCHAR2) IS
26: SELECT * from IGC_CC_INTERFACE
27: WHERE cc_header_id = p_doc_id
28: AND document_type = p_doc_type;
29: TYPE t_tbl_igc_cc_int IS TABLE OF c_igc_cc_int%ROWTYPE index by PLS_INTEGER;
30: g_tbl_igc_cc_int t_tbl_igc_cc_int;

Line 128: DELETE FROM IGC_CC_INTERFACE

124: IF (g_debug_mode = 'Y') THEN
125: Put_Debug_Msg(l_full_path, 'Start of purge_igc_cc_int');
126: END IF;
127:
128: DELETE FROM IGC_CC_INTERFACE
129: WHERE cc_header_id = p_document_id
130: AND document_type = p_document_type;
131:
132: COMMIT;

Line 162: INSERT INTO igc_cc_interface

158: END IF;
159: FOR i in p_t_tbl_gl_pck.FIRST..p_t_tbl_gl_pck.LAST
160: LOOP
161: l_batch_line_num := l_batch_line_num+1;
162: INSERT INTO igc_cc_interface
163: (
164: CC_HEADER_ID
165: ,CC_ACCT_LINE_ID
166: ,CODE_COMBINATION_ID

Line 254: Insert into igc_cc_interface

250: Put_Debug_Msg(l_full_path, 'Start of populate_igc_cc_int');
251: END IF;
252: FOR i IN p_tbl_igc_cc_int.FIRST..p_tbl_igc_cc_int.LAST
253: LOOP
254: Insert into igc_cc_interface
255: (
256: CC_HEADER_ID
257: ,CC_ACCT_LINE_ID
258: ,CODE_COMBINATION_ID

Line 649: /* Delete old records from IGC_CC_INTERFACE table */

645:
646: l_main_type := Nvl(l_main_type, l_document_type);
647: l_main_doc_id := Nvl(l_main_doc_id, l_document_id);
648:
649: /* Delete old records from IGC_CC_INTERFACE table */
650: purge_igc_cc_int(l_main_type, l_main_doc_id);
651:
652: open c_gl_bc_packets(l_event_details(i_evt).event_id, l_ledger_id, l_document_type);
653: FETCH c_gl_bc_packets

Line 671: Insert into igc_cc_interface

667: IF l_document_type = 'REL' THEN
668: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID := l_main_doc_id;
669: l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE := l_main_type ;
670: END IF;
671: Insert into igc_cc_interface
672: (
673: CC_HEADER_ID
674: ,CC_ACCT_LINE_ID
675: ,CODE_COMBINATION_ID

Line 766: /* Populate PL-SQL table with igc_cc_interface data */

762: IF (g_debug_mode = 'Y') THEN
763: Put_Debug_Msg(l_full_path, 'Populating PL-SQL table');
764: END IF;
765:
766: /* Populate PL-SQL table with igc_cc_interface data */
767: open c_igc_cc_int(l_main_doc_id, l_main_type);
768: FETCH c_igc_cc_int
769: BULK COLLECT INTO l_tbl_igc_cc_int;
770: CLOSE c_igc_cc_int;

Line 771: /* Delete records from IGC_CC_INTERFACE table */

767: open c_igc_cc_int(l_main_doc_id, l_main_type);
768: FETCH c_igc_cc_int
769: BULK COLLECT INTO l_tbl_igc_cc_int;
770: CLOSE c_igc_cc_int;
771: /* Delete records from IGC_CC_INTERFACE table */
772: DELETE FROM igc_cc_interface
773: WHERE cc_header_id = l_main_doc_id
774: AND document_type = l_main_type;
775:

Line 772: DELETE FROM igc_cc_interface

768: FETCH c_igc_cc_int
769: BULK COLLECT INTO l_tbl_igc_cc_int;
770: CLOSE c_igc_cc_int;
771: /* Delete records from IGC_CC_INTERFACE table */
772: DELETE FROM igc_cc_interface
773: WHERE cc_header_id = l_main_doc_id
774: AND document_type = l_main_type;
775:
776: /* Now, populate back IGC_CC_INTERFACE table from PL-SQL table.

Line 776: /* Now, populate back IGC_CC_INTERFACE table from PL-SQL table.

772: DELETE FROM igc_cc_interface
773: WHERE cc_header_id = l_main_doc_id
774: AND document_type = l_main_type;
775:
776: /* Now, populate back IGC_CC_INTERFACE table from PL-SQL table.
777: This procedure will be called in autonomous transaction mode
778: */
779: populate_igc_cc_int(l_tbl_igc_cc_int);
780: