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_GL_INTERFACE_PKG dependencies on IGI_ITR_CHARGE_HEADERS

Line 4: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,

1: PACKAGE BODY IGI_ITR_GL_INTERFACE_PKG AS
2: -- $Header: igiitrpb.pls 120.10.12020000.1 2012/06/27 10:56:36 appldev ship $
3: Cursor C_period(
4: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
5: p_period_name IN igi_itr_charge_headers.it_period_name%type) IS
6: Select
7: period_type,
8: period_year,

Line 5: p_period_name IN igi_itr_charge_headers.it_period_name%type) IS

1: PACKAGE BODY IGI_ITR_GL_INTERFACE_PKG AS
2: -- $Header: igiitrpb.pls 120.10.12020000.1 2012/06/27 10:56:36 appldev ship $
3: Cursor C_period(
4: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
5: p_period_name IN igi_itr_charge_headers.it_period_name%type) IS
6: Select
7: period_type,
8: period_year,
9: period_num

Line 29: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,

25: From gl_je_sources
26: Where je_source_name = 'Internal Trading';
27:
28: Cursor C_charge_lines(
29: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
30: p_period_type IN gl_period_statuses.period_type%type,
31: p_start_period_year IN gl_period_statuses.period_year%type,
32: p_start_period_num IN gl_period_statuses.period_num%type,
33: p_end_period_year IN gl_period_statuses.period_year%type,

Line 60: igi_itr_charge_headers h,

56: l.charge_service_id,
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

Line 82: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type ) IS

78: and nvl(l.posting_flag,'N') = 'N'
79: and l.charge_service_id = ssv.charge_service_id;
80:
81: Cursor C_current_period(
82: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type ) IS
83: Select
84: period_name,
85: period_num,
86: period_year,

Line 152: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,

148:
149: PROCEDURE Create_Actuals (
150: errbuf OUT NOCOPY varchar2,
151: retcode OUT NOCOPY number,
152: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
153: p_start_period IN igi_itr_charge_headers.it_period_name%type,
154: p_end_period IN igi_itr_charge_headers.it_period_name%type) IS
155: l_int_control glcontrol;
156: l_chart_of_accounts_id number;

Line 153: p_start_period IN igi_itr_charge_headers.it_period_name%type,

149: PROCEDURE Create_Actuals (
150: errbuf OUT NOCOPY varchar2,
151: retcode OUT NOCOPY number,
152: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
153: p_start_period IN igi_itr_charge_headers.it_period_name%type,
154: p_end_period IN igi_itr_charge_headers.it_period_name%type) IS
155: l_int_control glcontrol;
156: l_chart_of_accounts_id number;
157: l_itr_enc_type_id number;

Line 154: p_end_period IN igi_itr_charge_headers.it_period_name%type) IS

150: errbuf OUT NOCOPY varchar2,
151: retcode OUT NOCOPY number,
152: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
153: p_start_period IN igi_itr_charge_headers.it_period_name%type,
154: p_end_period IN igi_itr_charge_headers.it_period_name%type) IS
155: l_int_control glcontrol;
156: l_chart_of_accounts_id number;
157: l_itr_enc_type_id number;
158: l_gl_user_id number;

Line 159: l_current_period_name igi_itr_charge_headers.it_period_name%type;

155: l_int_control glcontrol;
156: l_chart_of_accounts_id number;
157: l_itr_enc_type_id number;
158: l_gl_user_id number;
159: l_current_period_name igi_itr_charge_headers.it_period_name%type;
160: l_current_period_num gl_period_statuses.period_num%type;
161: l_current_period_year gl_period_statuses.period_year%type;
162: l_current_quarter_num gl_period_statuses.quarter_num%type;
163: l_period_name igi_itr_charge_headers.it_period_name%type;

Line 163: l_period_name igi_itr_charge_headers.it_period_name%type;

159: l_current_period_name igi_itr_charge_headers.it_period_name%type;
160: l_current_period_num gl_period_statuses.period_num%type;
161: l_current_period_year gl_period_statuses.period_year%type;
162: l_current_quarter_num gl_period_statuses.quarter_num%type;
163: l_period_name igi_itr_charge_headers.it_period_name%type;
164: l_period_type gl_period_statuses.period_type%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;

Line 179: l_currency_code igi_itr_charge_headers.currency_code%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;
183: l_charge_name igi_itr_charge_headers.name%type; --shsaxena for bug 294823

Line 183: l_charge_name igi_itr_charge_headers.name%type; --shsaxena for bug 294823

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;
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;

Line 187: l_originator_id igi_itr_charge_headers.it_originator_id%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;
191: l_fundschk_mode varchar2(1);