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_HEADERS

Line 9: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,

5: -- Cursor to be used in Funds_Control for both Fundschecker and Approval
6: ------------------------------------------------------------------------
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

Line 10: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,

6: ------------------------------------------------------------------------
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,

Line 33: igi_itr_charge_headers H,

29: A.status_flag,
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

Line 82: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,

78: End if;
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,

Line 93: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,

89: p_rowid IN varchar2,
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,

Line 115: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type) Return Boolean IS

111: -- encumbrance is enabled, false otherwise.
112: --------------------------------------------------------------------
113:
114: Function Encumbrance_Enabled(
115: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type) Return Boolean IS
116: l_enc_enabled varchar2(1);
117: l_debug_loc varchar2(30) := 'Encumbrance_Enabled';
118: l_curr_calling_sequence varchar2(2000);
119: l_debug_info varchar2(100);

Line 255: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,

251: APP_EXCEPTION.RAISE_EXCEPTION;
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)

Line 257: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,

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,
261: p_calling_sequence IN varchar2) IS

Line 273: l_period_name igi_itr_charge_headers.it_period_name%type;

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;
277: l_quarter_num gl_period_statuses.quarter_num%type;

Line 274: l_currency_code igi_itr_charge_headers.currency_code%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;
277: l_quarter_num gl_period_statuses.quarter_num%type;
278: l_current_period_name igi_itr_charge_headers.it_period_name%type;

Line 278: l_current_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;
277: l_quarter_num gl_period_statuses.quarter_num%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;

Line 288: l_it_originator_id igi_itr_charge_headers.it_originator_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);
292: l_return_code varchar2(4);

Line 296: l_charge_name igi_itr_charge_headers.name%type;

292: l_return_code varchar2(4);
293: l_status_code varchar2(1); -- used in GL BC PACKETS C[fundschecking]/P[Reservation]
294: l_je_category_name gl_je_categories.je_category_name%type := 'IGIITRCC';
295: l_return_message_name_old varchar2(30);
296: l_charge_name igi_itr_charge_headers.name%type;
297: /*
298: Cursor C_cat_name IS
299: Select je_category_name
300: From gl_je_categories

Line 693: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,

689: End Funds_Check_Reserve;
690:
691: Procedure Fundscheck_Init(
692: p_chart_of_accounts_id IN OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%type,
693: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
694: p_itr_enc_type_id IN OUT NOCOPY igi_itr_charge_setup.encumbrance_type_id%type,
695: p_gl_user_id IN OUT NOCOPY number,
696: p_calling_sequence IN varchar2) IS
697: l_debug_loc varchar2(30) := 'Fundscheck_Init';

Line 773: p_charge_name IN igi_itr_charge_headers.name%type, --shsaxena for bug 2948237

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;
777: l_ins_cr number := NULL;

Line 781: l_charge_name igi_itr_charge_headers.name%type; --shsaxena for bug 2948237

777: l_ins_cr number := NULL;
778: l_debug_loc varchar2(30) := 'Bc_Packets_Insert';
779: l_curr_calling_sequence varchar2(2000);
780: l_debug_info varchar2(100);
781: l_charge_name igi_itr_charge_headers.name%type; --shsaxena for bug 2948237
782: l_session_id number := NULL;
783: l_serial_id number := NULL;
784: Begin
785:

Line 875: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,

871: APP_EXCEPTION.RAISE_EXCEPTION;
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,

Line 949: p_it_header_id IN igi_itr_charge_headers.it_header_id%type,

945: APP_EXCEPTION.RAISE_EXCEPTION;
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,