APPS.PA_BUDGET_FUND_PKG dependencies on IGC_CC_INTERFACE

Line 88: l_header_id number; --IGC_CC_INTERFACE.cc_header_id%TYPE ;

84:
85: l_funds_chk_rsrv_status VARCHAR2(1);
86:
87:
88: l_header_id number; --IGC_CC_INTERFACE.cc_header_id%TYPE ;
89: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
90: l_category_name gl_je_categories.user_je_category_name%type ;
91: l_source_name gl_je_sources.user_je_source_name%type;
92: l_batch_line_num number; --IGC_CC_INTERFACE.batch_line_num%TYPE ;

Line 92: l_batch_line_num number; --IGC_CC_INTERFACE.batch_line_num%TYPE ;

88: l_header_id number; --IGC_CC_INTERFACE.cc_header_id%TYPE ;
89: l_set_of_books_id pa_implementations_all.set_of_books_id%type;
90: l_category_name gl_je_categories.user_je_category_name%type ;
91: l_source_name gl_je_sources.user_je_source_name%type;
92: l_batch_line_num number; --IGC_CC_INTERFACE.batch_line_num%TYPE ;
93: l_code_combination_id gl_code_combinations.code_combination_id%TYPE ;
94: l_actual_flag gl_bc_packets.actual_flag%TYPE ;
95: l_currency_code gl_sets_of_books.currency_code%TYPE ;
96: l_last_update_date DATE;

Line 103: --l_result_code IGC_CC_INTERFACE.cbc_result_code%TYPE;

99: l_created_by NUMBER(15);
100: l_last_update_login NUMBER(15);
101: l_call_mode VARCHAR2(1) ;
102: l_ret_code boolean ;
103: --l_result_code IGC_CC_INTERFACE.cbc_result_code%TYPE;
104: l_result_code pa_bc_packets.result_code%TYPE;
105: l_return_status VARCHAR2(100) ;
106: l_msg_index_out NUMBER ;
107: l_chk_res_unres_multi NUMBER ;

Line 162: delete from IGC_CC_INTERFACE

158: -----------------------------------------------------------------
159: end if;
160:
161: begin
162: delete from IGC_CC_INTERFACE
163: where cc_header_id = p_budget_version_id
164: and document_type = 'PA';
165: exception
166: when no_data_found then

Line 203: log_message('inserting into table IGC_CC_INTERFACE ..... ');

199: pa_budget_versions bv
200: where p.project_id = bv.project_id
201: and bv.budget_version_id = p_budget_version_id;
202:
203: log_message('inserting into table IGC_CC_INTERFACE ..... ');
204:
205: Insert INTO IGC_CC_INTERFACE (
206: CC_HEADER_ID ,
207: DOCUMENT_TYPE ,

Line 205: Insert INTO IGC_CC_INTERFACE (

201: and bv.budget_version_id = p_budget_version_id;
202:
203: log_message('inserting into table IGC_CC_INTERFACE ..... ');
204:
205: Insert INTO IGC_CC_INTERFACE (
206: CC_HEADER_ID ,
207: DOCUMENT_TYPE ,
208: CODE_COMBINATION_ID ,
209: PERIOD_SET_NAME ,

Line 336: FROM IGC_CC_INTERFACE ICC

332: UPDATE PA_BUDGET_ACCT_LINES PBA
333: SET (PBA.funds_check_status_code,
334: PBA.funds_check_result_code) = (SELECT ICC.status_code,
335: ICC.cbc_result_code
336: FROM IGC_CC_INTERFACE ICC
337: WHERE ICC.DOCUMENT_TYPE = 'PA'
338: AND ICC.CC_HEADER_ID = p_budget_version_id
339: AND ICC.reference_1 = 'PA'
340: AND ICC.reference_2 = PBA.budget_version_id

Line 346: FROM IGC_CC_INTERFACE ICC

342: WHERE ((PBA.budget_version_id,
343: PBA.budget_acct_line_id) IN
344: (SELECT ICC.reference_2,
345: ICC.reference_3
346: FROM IGC_CC_INTERFACE ICC
347: WHERE ICC.cc_header_id = p_budget_version_id
348: AND ICC.DOCUMENT_TYPE = 'PA'
349: AND ICC.reference_1 = 'PA')) ;
350: log_message('rows updated into PA_BUDGET_ACCT_LINES Table .. '||sql%rowcount);