APPS.IGI_ITR_GL_INTERFACE_PKG dependencies on IGI_ITR_CHARGE_LINES

Line 61: igi_itr_charge_lines l,

57: h.it_originator_id,
58: ssv.name
59: from
60: igi_itr_charge_headers h,
61: igi_itr_charge_lines l,
62: igi_itr_charge_service_ss_v ssv,
63: gl_period_statuses p1
64: where p1.period_type = p_period_type
65: and p1.set_of_books_id = p_set_of_books_id

Line 169: l_it_header_id igi_itr_charge_lines.it_header_id%type;

165: l_start_period_year gl_period_statuses.period_year%type;
166: l_start_period_num gl_period_statuses.period_num%type;
167: l_end_period_year gl_period_statuses.period_year%type;
168: l_end_period_num gl_period_statuses.period_num%type;
169: l_it_header_id igi_itr_charge_lines.it_header_id%type;
170: l_it_service_line_id igi_itr_charge_lines.it_service_line_id%type;
171: l_it_line_num igi_itr_charge_lines.it_line_num%type;
172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;
173: l_amount igi_itr_charge_lines.entered_dr%type;

Line 170: l_it_service_line_id igi_itr_charge_lines.it_service_line_id%type;

166: l_start_period_num gl_period_statuses.period_num%type;
167: l_end_period_year gl_period_statuses.period_year%type;
168: l_end_period_num gl_period_statuses.period_num%type;
169: l_it_header_id igi_itr_charge_lines.it_header_id%type;
170: l_it_service_line_id igi_itr_charge_lines.it_service_line_id%type;
171: l_it_line_num igi_itr_charge_lines.it_line_num%type;
172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;
173: l_amount igi_itr_charge_lines.entered_dr%type;
174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;

Line 171: l_it_line_num igi_itr_charge_lines.it_line_num%type;

167: l_end_period_year gl_period_statuses.period_year%type;
168: l_end_period_num gl_period_statuses.period_num%type;
169: l_it_header_id igi_itr_charge_lines.it_header_id%type;
170: l_it_service_line_id igi_itr_charge_lines.it_service_line_id%type;
171: l_it_line_num igi_itr_charge_lines.it_line_num%type;
172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;
173: l_amount igi_itr_charge_lines.entered_dr%type;
174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;
175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;

Line 172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;

168: l_end_period_num gl_period_statuses.period_num%type;
169: l_it_header_id igi_itr_charge_lines.it_header_id%type;
170: l_it_service_line_id igi_itr_charge_lines.it_service_line_id%type;
171: l_it_line_num igi_itr_charge_lines.it_line_num%type;
172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;
173: l_amount igi_itr_charge_lines.entered_dr%type;
174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;
175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;
176: l_encumbered_amount igi_itr_charge_lines.encumbered_amount%type;

Line 173: l_amount igi_itr_charge_lines.entered_dr%type;

169: l_it_header_id igi_itr_charge_lines.it_header_id%type;
170: l_it_service_line_id igi_itr_charge_lines.it_service_line_id%type;
171: l_it_line_num igi_itr_charge_lines.it_line_num%type;
172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;
173: l_amount igi_itr_charge_lines.entered_dr%type;
174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;
175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;
176: l_encumbered_amount igi_itr_charge_lines.encumbered_amount%type;
177: l_unencumbered_amount igi_itr_charge_lines.unencumbered_amount%type;

Line 174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;

170: l_it_service_line_id igi_itr_charge_lines.it_service_line_id%type;
171: l_it_line_num igi_itr_charge_lines.it_line_num%type;
172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;
173: l_amount igi_itr_charge_lines.entered_dr%type;
174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;
175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;
176: l_encumbered_amount igi_itr_charge_lines.encumbered_amount%type;
177: l_unencumbered_amount igi_itr_charge_lines.unencumbered_amount%type;
178: l_gl_encumbered_date igi_itr_charge_lines.gl_encumbered_date%type;

Line 175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;

171: l_it_line_num igi_itr_charge_lines.it_line_num%type;
172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;
173: l_amount igi_itr_charge_lines.entered_dr%type;
174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;
175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;
176: l_encumbered_amount igi_itr_charge_lines.encumbered_amount%type;
177: l_unencumbered_amount igi_itr_charge_lines.unencumbered_amount%type;
178: l_gl_encumbered_date igi_itr_charge_lines.gl_encumbered_date%type;
179: l_currency_code igi_itr_charge_headers.currency_code%type;

Line 176: l_encumbered_amount igi_itr_charge_lines.encumbered_amount%type;

172: l_ccid_dr igi_itr_charge_lines.creation_code_combination_id%type;
173: l_amount igi_itr_charge_lines.entered_dr%type;
174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;
175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;
176: l_encumbered_amount igi_itr_charge_lines.encumbered_amount%type;
177: l_unencumbered_amount igi_itr_charge_lines.unencumbered_amount%type;
178: l_gl_encumbered_date igi_itr_charge_lines.gl_encumbered_date%type;
179: l_currency_code igi_itr_charge_headers.currency_code%type;
180: l_period_num gl_period_statuses.period_num%type;

Line 177: l_unencumbered_amount igi_itr_charge_lines.unencumbered_amount%type;

173: l_amount igi_itr_charge_lines.entered_dr%type;
174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;
175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;
176: l_encumbered_amount igi_itr_charge_lines.encumbered_amount%type;
177: l_unencumbered_amount igi_itr_charge_lines.unencumbered_amount%type;
178: l_gl_encumbered_date igi_itr_charge_lines.gl_encumbered_date%type;
179: l_currency_code igi_itr_charge_headers.currency_code%type;
180: l_period_num gl_period_statuses.period_num%type;
181: l_period_year gl_period_statuses.period_year%type;

Line 178: l_gl_encumbered_date igi_itr_charge_lines.gl_encumbered_date%type;

174: l_ccid_cr igi_itr_charge_lines.creation_code_combination_id%type;
175: l_encumbrance_flag igi_itr_charge_lines.encumbrance_flag%type;
176: l_encumbered_amount igi_itr_charge_lines.encumbered_amount%type;
177: l_unencumbered_amount igi_itr_charge_lines.unencumbered_amount%type;
178: l_gl_encumbered_date igi_itr_charge_lines.gl_encumbered_date%type;
179: l_currency_code igi_itr_charge_headers.currency_code%type;
180: l_period_num gl_period_statuses.period_num%type;
181: l_period_year gl_period_statuses.period_year%type;
182: l_quarter_num gl_period_statuses.quarter_num%type;

Line 184: l_description igi_itr_charge_lines.description%type;

180: l_period_num gl_period_statuses.period_num%type;
181: l_period_year gl_period_statuses.period_year%type;
182: l_quarter_num gl_period_statuses.quarter_num%type;
183: l_charge_name igi_itr_charge_headers.name%type; --shsaxena for bug 294823
184: l_description igi_itr_charge_lines.description%type;
185: l_reference_10 gl_interface.reference10%TYPE; --shsaxena for bug 2948237
186: l_charge_service_id igi_itr_charge_lines.charge_service_id%type;
187: l_originator_id igi_itr_charge_headers.it_originator_id%type;
188: l_service_name igi_itr_service.name%type;

Line 186: l_charge_service_id igi_itr_charge_lines.charge_service_id%type;

182: l_quarter_num gl_period_statuses.quarter_num%type;
183: l_charge_name igi_itr_charge_headers.name%type; --shsaxena for bug 294823
184: l_description igi_itr_charge_lines.description%type;
185: l_reference_10 gl_interface.reference10%TYPE; --shsaxena for bug 2948237
186: l_charge_service_id igi_itr_charge_lines.charge_service_id%type;
187: l_originator_id igi_itr_charge_headers.it_originator_id%type;
188: l_service_name igi_itr_service.name%type;
189: l_status_code varchar2(1);
190: l_packet_id number;

Line 390: Update igi_itr_charge_lines_audit

386: l_debug_info := 'Fundscheck failed, updating audit table - packet id';
387: -------------------------------------------------------------------------
388: null;
389: /*
390: Update igi_itr_charge_lines_audit
391: Set packet_id = l_packet_id
392: Where it_header_id = l_it_header_id
393: And it_service_line_id = l_it_service_line_id
394: And reversal_flag = 'N';

Line 400: Update igi_itr_charge_lines

396: Else
397: -------------------------------------------------------------------------------
398: l_debug_info := 'Updating Charge Lines and Audit tables - unencumbered amount';
399: -------------------------------------------------------------------------------
400: Update igi_itr_charge_lines
401: Set unencumbered_amount = l_amount,
402: packet_id = l_packet_id
403: Where it_header_id = l_it_header_id
404: And it_service_line_id = l_it_service_line_id;

Line 406: Update igi_itr_charge_lines_audit

402: packet_id = l_packet_id
403: Where it_header_id = l_it_header_id
404: And it_service_line_id = l_it_service_line_id;
405:
406: Update igi_itr_charge_lines_audit
407: Set unencumbered_amount = l_amount,
408: packet_id = l_packet_id
409: Where it_header_id = l_it_header_id
410: And it_service_line_id = l_it_service_line_id

Line 476: Update igi_itr_charge_lines

472:
473: -----------------------------------------------------------------------
474: l_debug_info := 'Updating Charge Lines and Audit Table - posting flag';
475: -----------------------------------------------------------------------
476: Update igi_itr_charge_lines
477: Set posting_flag = 'Y'
478: Where it_header_id = l_it_header_id
479: And it_service_line_id = l_it_service_line_id;
480:

Line 481: Update igi_itr_charge_lines_audit

477: Set posting_flag = 'Y'
478: Where it_header_id = l_it_header_id
479: And it_service_line_id = l_it_service_line_id;
480:
481: Update igi_itr_charge_lines_audit
482: Set posting_flag = 'Y'
483: Where it_header_id = l_it_header_id
484: And reversal_flag = 'N';
485: End If;

Line 571: Update igi_itr_charge_lines

567:
568: -----------------------------------------------------------------------
569: l_debug_info := 'Updating Charge Lines and Audit Table - posting flag';
570: -----------------------------------------------------------------------
571: Update igi_itr_charge_lines
572: Set posting_flag = 'Y'
573: Where it_header_id = l_it_header_id
574: And it_service_line_id = l_it_service_line_id;
575:

Line 576: Update igi_itr_charge_lines_audit

572: Set posting_flag = 'Y'
573: Where it_header_id = l_it_header_id
574: And it_service_line_id = l_it_service_line_id;
575:
576: Update igi_itr_charge_lines_audit
577: Set posting_flag = 'Y'
578: Where it_header_id = l_it_header_id
579: And it_service_line_id = l_it_service_line_id
580: And reversal_flag = 'N';