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

Line 11: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,

7:
8: Cursor Fundscntrl_Itr_Cur(
9: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
10: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
11: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
12: p_parent_value IN igi_itr_charge_lines.entered_dr%type) IS
13: Select
14: A.rowid,
15: A.it_service_line_id,

Line 12: p_parent_value IN igi_itr_charge_lines.entered_dr%type) IS

8: Cursor Fundscntrl_Itr_Cur(
9: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
10: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
11: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
12: p_parent_value IN igi_itr_charge_lines.entered_dr%type) IS
13: Select
14: A.rowid,
15: A.it_service_line_id,
16: decode(nvl(A.entered_dr,0),0,A.creation_code_combination_id,A.receiving_code_combination_id),

Line 34: igi_itr_charge_lines L,

30: A.prevent_encumbrance_flag,
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

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 83: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,

79: End Writelog;
80:
81: Procedure Process_Fundschk_Failure_Code(
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,

Line 84: p_status_flag IN igi_itr_charge_lines.status_flag%type,

80:
81: Procedure Process_Fundschk_Failure_Code(
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,

Line 85: p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%type,

81: Procedure Process_Fundschk_Failure_Code(
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,

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 94: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,

90: p_calling_sequence IN varchar2);
91:
92: Procedure Itr_Enc_Update(
93: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
94: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
95: p_status_flag IN varchar2,
96: p_prevent_encumbrance_flag IN varchar2,
97: p_packet_id IN number,
98: p_fc_result_code 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 256: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,

252: End Get_Gl_Fundschk_Packet_Id;
253:
254: PROCEDURE Funds_Check_Reserve(
255: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
256: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
257: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
258: p_reversal_amount IN igi_itr_charge_lines.entered_dr%type,
259: p_called_by IN varchar2, -- fundschecker(F)/approval(A)
260: p_return_message_name IN OUT NOCOPY varchar2,

Line 258: p_reversal_amount IN igi_itr_charge_lines.entered_dr%type,

254: PROCEDURE Funds_Check_Reserve(
255: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
256: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
257: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
258: p_reversal_amount IN igi_itr_charge_lines.entered_dr%type,
259: p_called_by IN varchar2, -- fundschecker(F)/approval(A)
260: p_return_message_name IN OUT NOCOPY varchar2,
261: p_calling_sequence IN varchar2) IS
262: l_rowid varchar2(100);

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 519: Update igi_itr_charge_lines

515: l_debug_info := 'Rejection Lines Passed Updating Charge Lines'
516: || ' and Audit Tables ';
517: -- set the unencumbered amount = parent_value and the reversal flag = N
518: -----------------------------------------------------------------------
519: Update igi_itr_charge_lines
520: Set failed_funds_lookup_code = 'N',
521: status_flag = 'N',
522: encumbrance_flag = 'Y',
523: encumbered_amount = l_amount,

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 560: Update igi_itr_charge_lines

556: ------------------------------------------------------------
557: l_debug_info := 'Cancellation Passed, Updating Charge Lines'
558: || ' and Audit Tables ';
559: ------------------------------------------------------------
560: Update igi_itr_charge_lines
561: Set unencumbered_amount = l_amount * -1,
562: encumbrance_flag = 'N',
563: gl_cancelled_date = l_gl_encumbered_date,
564: packet_id = l_packet_id

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 582: Update igi_itr_charge_lines

578: -------------------------------------------------------------
579: l_debug_info := 'Unreservation Passed, Updating Charge Lines'
580: || ' and Audit Tables ';
581: -------------------------------------------------------------
582: Update igi_itr_charge_lines
583: Set failed_funds_lookup_code = 'N',
584: status_flag = 'U',
585: prevent_encumbrance_flag = 'N',
586: unencumbered_amount = l_amount,

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 606: Update igi_itr_charge_lines

602: ----------------------------------------------------------
603: l_debug_info := 'Reservation Passed, Updating Charge Lines'
604: || ' and Audit Tables ';
605: ----------------------------------------------------------
606: Update igi_itr_charge_lines
607: Set failed_funds_lookup_code = 'N',
608: status_flag = 'N',
609: encumbrance_flag = 'Y',
610: encumbered_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 637: Update igi_itr_charge_lines

633: ----------------------------------------------------------
634: l_debug_info := 'Fundscheck Passed, Updating Charge Lines'
635: || ' and Audit Tables ';
636: ----------------------------------------------------------
637: Update igi_itr_charge_lines
638: Set status_flag = 'C',
639: failed_funds_lookup_code = 'N',
640: packet_id = l_packet_id
641: Where it_header_id = p_it_header_id

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 771: p_status_flag IN igi_itr_charge_lines.status_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,
775: p_calling_sequence IN varchar2) IS PRAGMA AUTONOMOUS_TRANSACTION;

Line 772: p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%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,
775: p_calling_sequence IN varchar2) IS PRAGMA AUTONOMOUS_TRANSACTION;
776: l_ins_dr number := NULL;

Line 876: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,

872: End BC_Packets_Insert;
873:
874: Procedure Process_Fundschk_Failure_Code(
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,

Line 877: p_status_flag IN igi_itr_charge_lines.status_flag%type,

873:
874: Procedure Process_Fundschk_Failure_Code(
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,

Line 878: p_prevent_encumbrance_flag IN igi_itr_charge_lines.prevent_encumbrance_flag%type,

874: Procedure Process_Fundschk_Failure_Code(
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,

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 950: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,

946: End Process_Fundschk_Failure_Code;
947:
948: Procedure Itr_Enc_Update(
949: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,
950: p_it_service_line_id IN igi_itr_charge_lines.it_service_line_id%type,
951: p_status_flag IN varchar2,
952: p_prevent_encumbrance_flag IN varchar2,
953: p_packet_id IN number,
954: p_fc_result_code IN varchar2,

Line 968: Update igi_itr_charge_lines

964: If (p_status_flag = 'L' or p_prevent_encumbrance_flag = 'Y') Then
965: -------------------------------------------------------------------------------------------
966: l_debug_info := 'Cancelled , Unreservation Lines , updating Charge Lines and Audit Tables';
967: -------------------------------------------------------------------------------------------
968: Update igi_itr_charge_lines
969: Set failed_funds_lookup_code = 'Y',
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;

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 984: Update igi_itr_charge_lines

980: Else
981: -------------------------------------------------------------------------------------------
982: l_debug_info := 'Updating Charge Lines and Audit Tables';
983: -------------------------------------------------------------------------------------------
984: Update igi_itr_charge_lines
985: Set failed_funds_lookup_code = 'Y',
986: status_flag = 'F',
987: packet_id = p_packet_id
988: Where it_header_id = p_it_header_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