eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_ITR_FUNDS_CONTROL_PKG dependencies on IGI_ITR_CHARGE_LINES_AUDIT

Line 35: igi_itr_charge_lines_audit A,

31: H.it_originator_id
32: From
33: igi_itr_charge_headers H,
34: igi_itr_charge_lines L,
35: igi_itr_charge_lines_audit A,
36: gl_period_statuses P1
37: Where H.it_header_id = p_it_header_id
38: And L.it_header_id = H.it_header_id
39: And A.it_header_id = L.it_header_id

Line 86: p_packet_id IN igi_itr_charge_lines_audit.packet_id%type,

82: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
83: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
84: p_status_flag IN igi_itr_charge_lines.status_flag%type,
85: p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%type,
86: p_packet_id IN igi_itr_charge_lines_audit.packet_id%type,
87: p_return_message_name IN OUT NOCOPY varchar2,
88: p_called_by IN varchar2,
89: p_rowid IN varchar2,
90: p_calling_sequence IN varchar2);

Line 156: p_packet_id IN OUT NOCOPY igi_itr_charge_lines_audit.packet_id%type,

152: APP_EXCEPTION.RAISE_EXCEPTION;
153: End Encumbrance_Enabled;
154:
155: Procedure Setup_Gl_Fundschk_Params(
156: p_packet_id IN OUT NOCOPY igi_itr_charge_lines_audit.packet_id%type,
157: p_mode IN OUT NOCOPY varchar2,
158: p_partial_resv_flag IN OUT NOCOPY varchar2,
159: p_called_by IN varchar2,
160: p_calling_sequence IN varchar2) IS

Line 164: l_packet_id_old igi_itr_charge_lines_audit.packet_id%type;

160: p_calling_sequence IN varchar2) IS
161: l_debug_loc varchar2(30) := 'Setup_Gl_Fundschk_Params';
162: l_curr_calling_sequence varchar2(2000);
163: l_debug_info varchar2(100);
164: l_packet_id_old igi_itr_charge_lines_audit.packet_id%type;
165: l_mode_old varchar2(1);
166: l_partial_resv_flag_old varchar2(1);
167: Begin
168: -----------------------------------------------------------------------------------------------

Line 217: p_packet_id IN OUT NOCOPY igi_itr_charge_lines_audit.packet_id%type) IS

213: End Setup_Gl_Fundschk_Params;
214:
215:
216: Procedure Get_Gl_Fundschk_Packet_Id(
217: p_packet_id IN OUT NOCOPY igi_itr_charge_lines_audit.packet_id%type) IS
218: l_debug_loc varchar2(30) := 'Get_Gl_Fundschk_Packet_Id';
219: l_curr_calling_sequence varchar2(2000);
220: l_debug_info varchar2(100);
221: l_packet_id_old igi_itr_charge_lines_audit.packet_id%type;

Line 221: l_packet_id_old igi_itr_charge_lines_audit.packet_id%type;

217: p_packet_id IN OUT NOCOPY igi_itr_charge_lines_audit.packet_id%type) IS
218: l_debug_loc varchar2(30) := 'Get_Gl_Fundschk_Packet_Id';
219: l_curr_calling_sequence varchar2(2000);
220: l_debug_info varchar2(100);
221: l_packet_id_old igi_itr_charge_lines_audit.packet_id%type;
222: Begin
223: ---------------------------------------------------------------
224: l_curr_calling_sequence := 'IGI_ITR_FUNDS_CONTROL_PKG.'||l_debug_loc;
225: l_debug_info := 'Retrieve next packet id from gl_bc_packets_s';

Line 269: l_it_service_line_id igi_itr_charge_lines_audit.it_service_line_id%type;

265: l_partial_reserv_flag varchar2(1);
266: l_chart_of_accounts_id number;
267: l_itr_enc_type_id number;
268: l_gl_user_id number;
269: l_it_service_line_id igi_itr_charge_lines_audit.it_service_line_id%type;
270: l_ccid igi_itr_charge_lines_audit.receiving_code_combination_id%type;
271: l_amount igi_itr_charge_lines_audit.entered_dr%type;
272: l_gl_encumbered_date igi_itr_charge_lines_audit.gl_encumbered_date%type;
273: l_period_name igi_itr_charge_headers.it_period_name%type;

Line 270: l_ccid igi_itr_charge_lines_audit.receiving_code_combination_id%type;

266: l_chart_of_accounts_id number;
267: l_itr_enc_type_id number;
268: l_gl_user_id number;
269: l_it_service_line_id igi_itr_charge_lines_audit.it_service_line_id%type;
270: l_ccid igi_itr_charge_lines_audit.receiving_code_combination_id%type;
271: l_amount igi_itr_charge_lines_audit.entered_dr%type;
272: l_gl_encumbered_date igi_itr_charge_lines_audit.gl_encumbered_date%type;
273: l_period_name igi_itr_charge_headers.it_period_name%type;
274: l_currency_code igi_itr_charge_headers.currency_code%type;

Line 271: l_amount igi_itr_charge_lines_audit.entered_dr%type;

267: l_itr_enc_type_id number;
268: l_gl_user_id number;
269: l_it_service_line_id igi_itr_charge_lines_audit.it_service_line_id%type;
270: l_ccid igi_itr_charge_lines_audit.receiving_code_combination_id%type;
271: l_amount igi_itr_charge_lines_audit.entered_dr%type;
272: l_gl_encumbered_date igi_itr_charge_lines_audit.gl_encumbered_date%type;
273: l_period_name igi_itr_charge_headers.it_period_name%type;
274: l_currency_code igi_itr_charge_headers.currency_code%type;
275: l_period_num gl_period_statuses.period_num%type;

Line 272: l_gl_encumbered_date igi_itr_charge_lines_audit.gl_encumbered_date%type;

268: l_gl_user_id number;
269: l_it_service_line_id igi_itr_charge_lines_audit.it_service_line_id%type;
270: l_ccid igi_itr_charge_lines_audit.receiving_code_combination_id%type;
271: l_amount igi_itr_charge_lines_audit.entered_dr%type;
272: l_gl_encumbered_date igi_itr_charge_lines_audit.gl_encumbered_date%type;
273: l_period_name igi_itr_charge_headers.it_period_name%type;
274: l_currency_code igi_itr_charge_headers.currency_code%type;
275: l_period_num gl_period_statuses.period_num%type;
276: l_period_year gl_period_statuses.period_year%type;

Line 282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;

278: l_current_period_name igi_itr_charge_headers.it_period_name%type;
279: l_current_period_num gl_period_statuses.period_num%type;
280: l_current_period_year gl_period_statuses.period_year%type;
281: l_current_quarter_num gl_period_statuses.quarter_num%type;
282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;
283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;
284: l_description igi_itr_charge_lines_audit.description%type;
285: l_charge_service_id igi_itr_charge_lines_audit.charge_service_id%type;
286: l_status_flag igi_itr_charge_lines_audit.status_flag%type;

Line 283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;

279: l_current_period_num gl_period_statuses.period_num%type;
280: l_current_period_year gl_period_statuses.period_year%type;
281: l_current_quarter_num gl_period_statuses.quarter_num%type;
282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;
283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;
284: l_description igi_itr_charge_lines_audit.description%type;
285: l_charge_service_id igi_itr_charge_lines_audit.charge_service_id%type;
286: l_status_flag igi_itr_charge_lines_audit.status_flag%type;
287: l_prevent_encumbrance_flag igi_itr_charge_lines_audit.prevent_encumbrance_flag%type;

Line 284: l_description igi_itr_charge_lines_audit.description%type;

280: l_current_period_year gl_period_statuses.period_year%type;
281: l_current_quarter_num gl_period_statuses.quarter_num%type;
282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;
283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;
284: l_description igi_itr_charge_lines_audit.description%type;
285: l_charge_service_id igi_itr_charge_lines_audit.charge_service_id%type;
286: l_status_flag igi_itr_charge_lines_audit.status_flag%type;
287: l_prevent_encumbrance_flag igi_itr_charge_lines_audit.prevent_encumbrance_flag%type;
288: l_it_originator_id igi_itr_charge_headers.it_originator_id%type;

Line 285: l_charge_service_id igi_itr_charge_lines_audit.charge_service_id%type;

281: l_current_quarter_num gl_period_statuses.quarter_num%type;
282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;
283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;
284: l_description igi_itr_charge_lines_audit.description%type;
285: l_charge_service_id igi_itr_charge_lines_audit.charge_service_id%type;
286: l_status_flag igi_itr_charge_lines_audit.status_flag%type;
287: l_prevent_encumbrance_flag igi_itr_charge_lines_audit.prevent_encumbrance_flag%type;
288: l_it_originator_id igi_itr_charge_headers.it_originator_id%type;
289: l_debug_loc varchar2(30) := 'Funds_Check_Reserve';

Line 286: l_status_flag igi_itr_charge_lines_audit.status_flag%type;

282: l_reversal_flag igi_itr_charge_lines_audit.reversal_flag%type;
283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;
284: l_description igi_itr_charge_lines_audit.description%type;
285: l_charge_service_id igi_itr_charge_lines_audit.charge_service_id%type;
286: l_status_flag igi_itr_charge_lines_audit.status_flag%type;
287: l_prevent_encumbrance_flag igi_itr_charge_lines_audit.prevent_encumbrance_flag%type;
288: l_it_originator_id igi_itr_charge_headers.it_originator_id%type;
289: l_debug_loc varchar2(30) := 'Funds_Check_Reserve';
290: l_curr_calling_sequence varchar2(2000);

Line 287: l_prevent_encumbrance_flag igi_itr_charge_lines_audit.prevent_encumbrance_flag%type;

283: l_old_packet_id igi_itr_charge_lines_audit.packet_id%type;
284: l_description igi_itr_charge_lines_audit.description%type;
285: l_charge_service_id igi_itr_charge_lines_audit.charge_service_id%type;
286: l_status_flag igi_itr_charge_lines_audit.status_flag%type;
287: l_prevent_encumbrance_flag igi_itr_charge_lines_audit.prevent_encumbrance_flag%type;
288: l_it_originator_id igi_itr_charge_headers.it_originator_id%type;
289: l_debug_loc varchar2(30) := 'Funds_Check_Reserve';
290: l_curr_calling_sequence varchar2(2000);
291: l_debug_info varchar2(100);

Line 531: Update igi_itr_charge_lines_audit

527: packet_id = l_packet_id
528: Where it_header_id = p_it_header_id
529: And it_service_line_id = l_it_service_line_id;
530:
531: Update igi_itr_charge_lines_audit
532: Set failed_funds_lookup_code = 'N',
533: status_flag = 'N',
534: encumbrance_flag = 'Y',
535: encumbered_amount = l_amount,

Line 545: Update igi_itr_charge_lines_audit

541: Where it_header_id = p_it_header_id
542: And it_service_line_id = l_it_service_line_id
543: And rowid = l_rowid;
544:
545: Update igi_itr_charge_lines_audit
546: Set unencumbered_amount = p_reversal_amount,
547: reversal_flag = 'O',
548: -- obselete so it doesn not get picked up in the cursor select again ,
549: -- problem in multiple modifications [N]

Line 568: Update igi_itr_charge_lines_audit

564: packet_id = l_packet_id
565: Where it_header_id = p_it_header_id
566: And it_service_line_id = l_it_service_line_id;
567:
568: Update igi_itr_charge_lines_audit
569: Set unencumbered_amount = l_amount * -1,
570: encumbrance_flag = 'N',
571: gl_cancelled_date = l_gl_encumbered_date,
572: --packet_id = NULL

Line 591: Update igi_itr_charge_lines_audit

587: packet_id = l_packet_id
588: Where it_header_id = p_it_header_id
589: And it_service_line_id = l_it_service_line_id;
590:
591: Update igi_itr_charge_lines_audit
592: Set failed_funds_lookup_code = 'N',
593: prevent_encumbrance_flag = 'N',
594: status_flag = 'U',
595: unencumbered_amount = l_amount,

Line 618: Update igi_itr_charge_lines_audit

614: packet_id = l_packet_id
615: Where it_header_id = p_it_header_id
616: And it_service_line_id = l_it_service_line_id;
617:
618: Update igi_itr_charge_lines_audit
619: Set failed_funds_lookup_code = 'N',
620: status_flag = 'N',
621: encumbrance_flag = 'Y',
622: encumbered_amount = l_amount,

Line 644: Update igi_itr_charge_lines_audit

640: packet_id = l_packet_id
641: Where it_header_id = p_it_header_id
642: And it_service_line_id = l_it_service_line_id;
643:
644: Update igi_itr_charge_lines_audit
645: Set status_flag = 'C',
646: failed_funds_lookup_code = 'N',
647: --packet_id = NULL
648: packet_id = l_packet_id

Line 770: p_reversal_flag IN igi_itr_charge_lines_audit.reversal_flag%type,

766: p_actual_flag IN gl_bc_packets.actual_flag%type,
767: p_period_name IN gl_bc_packets.period_name%type,
768: p_base_currency_code IN gl_bc_packets.currency_code%type,
769: p_status_code IN gl_bc_packets.status_code%type,
770: p_reversal_flag IN igi_itr_charge_lines_audit.reversal_flag%type,
771: p_status_flag IN igi_itr_charge_lines.status_flag%type,
772: p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%type,
773: p_charge_name IN igi_itr_charge_headers.name%type, --shsaxena for bug 2948237
774: --p_description IN varchar2,

Line 879: p_packet_id IN igi_itr_charge_lines_audit.packet_id%type,

875: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
876: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
877: p_status_flag IN igi_itr_charge_lines.status_flag%type,
878: p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%type,
879: p_packet_id IN igi_itr_charge_lines_audit.packet_id%type,
880: p_return_message_name IN OUT NOCOPY varchar2,
881: p_called_by IN varchar2,
882: p_rowid IN varchar2,
883: p_calling_sequence IN varchar2) IS

Line 974: Update igi_itr_charge_lines_audit

970: packet_id = p_packet_id
971: Where it_header_id = p_it_header_id
972: And it_service_line_id = p_it_service_line_id;
973:
974: Update igi_itr_charge_lines_audit
975: Set failed_funds_lookup_code = 'Y',
976: packet_id = p_packet_id
977: Where it_header_id = p_it_header_id
978: And it_service_line_id = p_it_service_line_id

Line 991: Update igi_itr_charge_lines_audit

987: packet_id = p_packet_id
988: Where it_header_id = p_it_header_id
989: And it_service_line_id = p_it_service_line_id;
990:
991: Update igi_itr_charge_lines_audit
992: Set failed_funds_lookup_code = 'Y',
993: status_flag = 'F',
994: packet_id = p_packet_id
995: Where it_header_id = p_it_header_id