APPS.IGC_CBC_GL_FC_PKG dependencies on GL_BC_PACKETS

Line 32: CURSOR c_gl_bc_packets(p_event_id NUMBER, p_ledger_id in NUMBER,p_document_type IN VARCHAR2) IS

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;
31:
32: CURSOR c_gl_bc_packets(p_event_id NUMBER, p_ledger_id in NUMBER,p_document_type IN VARCHAR2) IS
33: SELECT
34: xte.source_id_int_1 CC_HEADER_ID
35: ,pck.source_distribution_id_num_1 CC_ACCT_LINE_ID
36: ,pck.code_combination_id CODE_COMBINATION_ID

Line 66: ,gl_bc_packets pck

62: ,pck.source_distribution_type
63: FROM xla_ae_headers xah
64: ,xla_ae_lines xal
65: ,xla_transaction_entities xte
66: ,gl_bc_packets pck
67: WHERE xah.ae_header_id = pck.ae_header_id
68: AND xal.ae_header_id = pck.ae_header_id
69: AND xal.ae_line_num = pck.ae_line_num
70: AND xte.entity_id = xah.entity_id

Line 75: TYPE t_tbl_gl_bc_packets IS TABLE OF c_gl_bc_packets%ROWTYPE index by PLS_INTEGER;

71: AND pck.event_id = p_event_id
72: AND pck.ledger_id = p_ledger_id
73: Order by pck.event_id,pck.source_distribution_id_num_1;
74:
75: TYPE t_tbl_gl_bc_packets IS TABLE OF c_gl_bc_packets%ROWTYPE index by PLS_INTEGER;
76:
77: g_gl_pck_count NUMBER;
78:
79:

Line 90: p_t_tbl_gl_pck IN t_tbl_gl_bc_packets

86: p_document_type IN VARCHAR2, p_document_id IN NUMBER
87: );
88:
89: PROCEDURE populate_sbc_records(
90: p_t_tbl_gl_pck IN t_tbl_gl_bc_packets
91: );
92:
93: PROCEDURE populate_igc_cc_int (
94: p_tbl_igc_cc_int IN t_tbl_igc_cc_int

Line 149: p_t_tbl_gl_pck IN t_tbl_gl_bc_packets

145: END;
146:
147:
148: PROCEDURE populate_sbc_records(
149: p_t_tbl_gl_pck IN t_tbl_gl_bc_packets
150: ) IS
151: PRAGMA AUTONOMOUS_TRANSACTION;
152: l_batch_line_num NUMBER := g_gl_pck_count;
153: l_user_id NUMBER := fnd_global.user_id ;

Line 376: From gl_bc_packets pck,

372: l_event_details t_event_details;
373:
374: CURSOR c_ledger_details(p_event_id in NUMBER) is
375: Select distinct ledger_id, nvl(cbc_po_enable, 'N') cbc_enable
376: From gl_bc_packets pck,
377: igc_cc_bc_enable cbc
378: where event_id = p_event_id
379: and actual_flag = 'E'
380: and pck.ledger_id = cbc.set_of_books_id(+)

Line 457: l_t_gl_bc_packets_sbc t_tbl_gl_bc_packets;

453: l_bc_return_status VARCHAR2(2) := null ;
454: l_batch_result_code VARCHAR2(3) ;
455: l_tbl_igc_cc_int t_tbl_igc_cc_int;
456:
457: l_t_gl_bc_packets_sbc t_tbl_gl_bc_packets;
458:
459: l_process_record VARCHAR2(1) := 'N';
460: l_return_status VARCHAR2(1) ;
461: l_msg_count NUMBER ;

Line 673: open c_gl_bc_packets(l_event_details(i_evt).event_id, l_ledger_id, l_document_type);

669: Put_Debug_Msg(l_full_path, 'value of l_main_type '|| l_main_type || ' l_main_doc_id ' ||l_main_doc_id);
670: /* Delete old records from IGC_CC_INTERFACE table */
671: purge_igc_cc_int(l_main_type, l_main_doc_id);
672:
673: open c_gl_bc_packets(l_event_details(i_evt).event_id, l_ledger_id, l_document_type);
674: FETCH c_gl_bc_packets
675: BULK COLLECT INTO l_t_gl_bc_packets_sbc;
676: CLOSE c_gl_bc_packets;
677:

Line 674: FETCH c_gl_bc_packets

670: /* Delete old records from IGC_CC_INTERFACE table */
671: purge_igc_cc_int(l_main_type, l_main_doc_id);
672:
673: open c_gl_bc_packets(l_event_details(i_evt).event_id, l_ledger_id, l_document_type);
674: FETCH c_gl_bc_packets
675: BULK COLLECT INTO l_t_gl_bc_packets_sbc;
676: CLOSE c_gl_bc_packets;
677:
678: g_gl_pck_count := l_t_gl_bc_packets_sbc.LAST;

Line 675: BULK COLLECT INTO l_t_gl_bc_packets_sbc;

671: purge_igc_cc_int(l_main_type, l_main_doc_id);
672:
673: open c_gl_bc_packets(l_event_details(i_evt).event_id, l_ledger_id, l_document_type);
674: FETCH c_gl_bc_packets
675: BULK COLLECT INTO l_t_gl_bc_packets_sbc;
676: CLOSE c_gl_bc_packets;
677:
678: g_gl_pck_count := l_t_gl_bc_packets_sbc.LAST;
679:

Line 676: CLOSE c_gl_bc_packets;

672:
673: open c_gl_bc_packets(l_event_details(i_evt).event_id, l_ledger_id, l_document_type);
674: FETCH c_gl_bc_packets
675: BULK COLLECT INTO l_t_gl_bc_packets_sbc;
676: CLOSE c_gl_bc_packets;
677:
678: g_gl_pck_count := l_t_gl_bc_packets_sbc.LAST;
679:
680: /* Number of records in gl_bc_packets */

Line 678: g_gl_pck_count := l_t_gl_bc_packets_sbc.LAST;

674: FETCH c_gl_bc_packets
675: BULK COLLECT INTO l_t_gl_bc_packets_sbc;
676: CLOSE c_gl_bc_packets;
677:
678: g_gl_pck_count := l_t_gl_bc_packets_sbc.LAST;
679:
680: /* Number of records in gl_bc_packets */
681:
682: IF (g_debug_mode = 'Y') THEN

Line 680: /* Number of records in gl_bc_packets */

676: CLOSE c_gl_bc_packets;
677:
678: g_gl_pck_count := l_t_gl_bc_packets_sbc.LAST;
679:
680: /* Number of records in gl_bc_packets */
681:
682: IF (g_debug_mode = 'Y') THEN
683: Put_Debug_Msg(l_full_path, 'Document Id'||l_main_doc_id || ' Records in gl_bc_packets '||l_t_gl_bc_packets_sbc.LAST);
684: END IF;

Line 683: Put_Debug_Msg(l_full_path, 'Document Id'||l_main_doc_id || ' Records in gl_bc_packets '||l_t_gl_bc_packets_sbc.LAST);

679:
680: /* Number of records in gl_bc_packets */
681:
682: IF (g_debug_mode = 'Y') THEN
683: Put_Debug_Msg(l_full_path, 'Document Id'||l_main_doc_id || ' Records in gl_bc_packets '||l_t_gl_bc_packets_sbc.LAST);
684: END IF;
685:
686: FOR l_ind IN l_t_gl_bc_packets_sbc.FIRST..l_t_gl_bc_packets_sbc.LAST
687: LOOP

Line 686: FOR l_ind IN l_t_gl_bc_packets_sbc.FIRST..l_t_gl_bc_packets_sbc.LAST

682: IF (g_debug_mode = 'Y') THEN
683: Put_Debug_Msg(l_full_path, 'Document Id'||l_main_doc_id || ' Records in gl_bc_packets '||l_t_gl_bc_packets_sbc.LAST);
684: END IF;
685:
686: FOR l_ind IN l_t_gl_bc_packets_sbc.FIRST..l_t_gl_bc_packets_sbc.LAST
687: LOOP
688: IF l_document_type = 'REL' THEN
689: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID := l_main_doc_id;
690: l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE := l_main_type ;

Line 689: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID := l_main_doc_id;

685:
686: FOR l_ind IN l_t_gl_bc_packets_sbc.FIRST..l_t_gl_bc_packets_sbc.LAST
687: LOOP
688: IF l_document_type = 'REL' THEN
689: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID := l_main_doc_id;
690: l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE := l_main_type ;
691: END IF;
692: IF (l_t_gl_bc_packets_sbc(l_ind).ENCUMBRANCE_TYPE_ID IS NOT NULL) THEN
693: SELECT e.encumbrance_type_key

Line 690: l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE := l_main_type ;

686: FOR l_ind IN l_t_gl_bc_packets_sbc.FIRST..l_t_gl_bc_packets_sbc.LAST
687: LOOP
688: IF l_document_type = 'REL' THEN
689: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID := l_main_doc_id;
690: l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE := l_main_type ;
691: END IF;
692: IF (l_t_gl_bc_packets_sbc(l_ind).ENCUMBRANCE_TYPE_ID IS NOT NULL) THEN
693: SELECT e.encumbrance_type_key
694: INTO l_encumbrance_type_key

Line 692: IF (l_t_gl_bc_packets_sbc(l_ind).ENCUMBRANCE_TYPE_ID IS NOT NULL) THEN

688: IF l_document_type = 'REL' THEN
689: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID := l_main_doc_id;
690: l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE := l_main_type ;
691: END IF;
692: IF (l_t_gl_bc_packets_sbc(l_ind).ENCUMBRANCE_TYPE_ID IS NOT NULL) THEN
693: SELECT e.encumbrance_type_key
694: INTO l_encumbrance_type_key
695: FROM gl_encumbrance_types e
696: WHERE e.encumbrance_type_id = l_t_gl_bc_packets_sbc(l_ind).ENCUMBRANCE_TYPE_ID;

Line 696: WHERE e.encumbrance_type_id = l_t_gl_bc_packets_sbc(l_ind).ENCUMBRANCE_TYPE_ID;

692: IF (l_t_gl_bc_packets_sbc(l_ind).ENCUMBRANCE_TYPE_ID IS NOT NULL) THEN
693: SELECT e.encumbrance_type_key
694: INTO l_encumbrance_type_key
695: FROM gl_encumbrance_types e
696: WHERE e.encumbrance_type_id = l_t_gl_bc_packets_sbc(l_ind).ENCUMBRANCE_TYPE_ID;
697: END IF;
698: Insert into igc_cc_interface
699: (
700: CC_HEADER_ID

Line 728: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID

724: ,encumbrance_type_key
725: )
726: Values
727: (
728: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID
729: ,l_t_gl_bc_packets_sbc(l_ind).CC_ACCT_LINE_ID
730: ,l_t_gl_bc_packets_sbc(l_ind).CODE_COMBINATION_ID
731: ,g_batch_line_const + l_ind
732: ,l_accounting_date

Line 729: ,l_t_gl_bc_packets_sbc(l_ind).CC_ACCT_LINE_ID

725: )
726: Values
727: (
728: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID
729: ,l_t_gl_bc_packets_sbc(l_ind).CC_ACCT_LINE_ID
730: ,l_t_gl_bc_packets_sbc(l_ind).CODE_COMBINATION_ID
731: ,g_batch_line_const + l_ind
732: ,l_accounting_date
733: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_DR_AMT

Line 730: ,l_t_gl_bc_packets_sbc(l_ind).CODE_COMBINATION_ID

726: Values
727: (
728: l_t_gl_bc_packets_sbc(l_ind).CC_HEADER_ID
729: ,l_t_gl_bc_packets_sbc(l_ind).CC_ACCT_LINE_ID
730: ,l_t_gl_bc_packets_sbc(l_ind).CODE_COMBINATION_ID
731: ,g_batch_line_const + l_ind
732: ,l_accounting_date
733: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_DR_AMT
734: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_CR_AMT

Line 733: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_DR_AMT

729: ,l_t_gl_bc_packets_sbc(l_ind).CC_ACCT_LINE_ID
730: ,l_t_gl_bc_packets_sbc(l_ind).CODE_COMBINATION_ID
731: ,g_batch_line_const + l_ind
732: ,l_accounting_date
733: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_DR_AMT
734: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_CR_AMT
735: ,l_t_gl_bc_packets_sbc(l_ind).ACTUAL_FLAG
736: ,'C'
737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID

Line 734: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_CR_AMT

730: ,l_t_gl_bc_packets_sbc(l_ind).CODE_COMBINATION_ID
731: ,g_batch_line_const + l_ind
732: ,l_accounting_date
733: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_DR_AMT
734: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_CR_AMT
735: ,l_t_gl_bc_packets_sbc(l_ind).ACTUAL_FLAG
736: ,'C'
737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID
738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE

Line 735: ,l_t_gl_bc_packets_sbc(l_ind).ACTUAL_FLAG

731: ,g_batch_line_const + l_ind
732: ,l_accounting_date
733: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_DR_AMT
734: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_CR_AMT
735: ,l_t_gl_bc_packets_sbc(l_ind).ACTUAL_FLAG
736: ,'C'
737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID
738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE
739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE

Line 737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID

733: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_DR_AMT
734: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_CR_AMT
735: ,l_t_gl_bc_packets_sbc(l_ind).ACTUAL_FLAG
736: ,'C'
737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID
738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE
739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE
740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION
741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1

Line 738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE

734: ,l_t_gl_bc_packets_sbc(l_ind).CC_FUNC_CR_AMT
735: ,l_t_gl_bc_packets_sbc(l_ind).ACTUAL_FLAG
736: ,'C'
737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID
738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE
739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE
740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION
741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1
742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2

Line 739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE

735: ,l_t_gl_bc_packets_sbc(l_ind).ACTUAL_FLAG
736: ,'C'
737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID
738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE
739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE
740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION
741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1
742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2
743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3

Line 740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION

736: ,'C'
737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID
738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE
739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE
740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION
741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1
742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2
743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3
744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4

Line 741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1

737: ,l_t_gl_bc_packets_sbc(l_ind).SET_OF_BOOKS_ID
738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE
739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE
740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION
741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1
742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2
743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3
744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4
745: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_5

Line 742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2

738: ,l_t_gl_bc_packets_sbc(l_ind).CURRENCY_CODE
739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE
740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION
741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1
742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2
743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3
744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4
745: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_5
746: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_6

Line 743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3

739: ,l_t_gl_bc_packets_sbc(l_ind).DOCUMENT_TYPE
740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION
741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1
742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2
743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3
744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4
745: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_5
746: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_6
747: ,'N'

Line 744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4

740: ,l_t_gl_bc_packets_sbc(l_ind).TRANSACTION_DESCRIPTION
741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1
742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2
743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3
744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4
745: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_5
746: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_6
747: ,'N'
748: ,l_t_gl_bc_packets_sbc(l_ind).LAST_UPDATE_DATE

Line 745: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_5

741: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_1
742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2
743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3
744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4
745: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_5
746: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_6
747: ,'N'
748: ,l_t_gl_bc_packets_sbc(l_ind).LAST_UPDATE_DATE
749: ,l_user_id

Line 746: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_6

742: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_2
743: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_3
744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4
745: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_5
746: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_6
747: ,'N'
748: ,l_t_gl_bc_packets_sbc(l_ind).LAST_UPDATE_DATE
749: ,l_user_id
750: ,l_t_gl_bc_packets_sbc(l_ind).CREATION_DATE

Line 748: ,l_t_gl_bc_packets_sbc(l_ind).LAST_UPDATE_DATE

744: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_4
745: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_5
746: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_6
747: ,'N'
748: ,l_t_gl_bc_packets_sbc(l_ind).LAST_UPDATE_DATE
749: ,l_user_id
750: ,l_t_gl_bc_packets_sbc(l_ind).CREATION_DATE
751: ,l_user_id
752: ,l_encumbrance_type_key

Line 750: ,l_t_gl_bc_packets_sbc(l_ind).CREATION_DATE

746: ,l_t_gl_bc_packets_sbc(l_ind).REFERENCE_6
747: ,'N'
748: ,l_t_gl_bc_packets_sbc(l_ind).LAST_UPDATE_DATE
749: ,l_user_id
750: ,l_t_gl_bc_packets_sbc(l_ind).CREATION_DATE
751: ,l_user_id
752: ,l_encumbrance_type_key
753: );
754: END LOOP;

Line 758: Put_Debug_Msg(l_full_path, 'Calling PSA Budgetary Control : '||l_t_gl_bc_packets_sbc.LAST);

754: END LOOP;
755:
756:
757: IF (g_debug_mode = 'Y') THEN
758: Put_Debug_Msg(l_full_path, 'Calling PSA Budgetary Control : '||l_t_gl_bc_packets_sbc.LAST);
759: END IF;
760:
761: l_bc_success := igc_cbc_pa_bc_pkg.igcpafck(
762: l_ledger_id,

Line 810: populate_sbc_records(l_t_gl_bc_packets_sbc);

806: This procedure will be called in autonomous transaction mode
807: */
808: populate_igc_cc_int(l_tbl_igc_cc_int);
809:
810: populate_sbc_records(l_t_gl_bc_packets_sbc);
811:
812: IF (g_debug_mode = 'Y') THEN
813: Put_Debug_Msg(l_full_path, 'Call to populate_igc_cc_int is successful');
814: END IF;