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 GL_PERIOD_STATUSES

Line 10: From gl_period_statuses

6: Select
7: period_type,
8: period_year,
9: period_num
10: From gl_period_statuses
11: Where period_name = p_period_name
12: And set_of_books_id = p_set_of_books_id
13: And nvl(adjustment_period_flag,'N') = 'N'
14: And application_id = (Select application_id

Line 30: p_period_type IN gl_period_statuses.period_type%type,

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,
34: p_end_period_num IN gl_period_statuses.period_num%type) IS

Line 31: p_start_period_year IN gl_period_statuses.period_year%type,

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,
34: p_end_period_num IN gl_period_statuses.period_num%type) IS
35:

Line 32: p_start_period_num IN gl_period_statuses.period_num%type,

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,
34: p_end_period_num IN gl_period_statuses.period_num%type) IS
35:
36: --Bug 2885987. Modified to remove Multi Join Cartesian.

Line 33: p_end_period_year IN gl_period_statuses.period_year%type,

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,
34: p_end_period_num IN gl_period_statuses.period_num%type) IS
35:
36: --Bug 2885987. Modified to remove Multi Join Cartesian.
37:

Line 34: p_end_period_num IN gl_period_statuses.period_num%type) IS

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,
34: p_end_period_num IN gl_period_statuses.period_num%type) IS
35:
36: --Bug 2885987. Modified to remove Multi Join Cartesian.
37:
38: select

Line 63: gl_period_statuses p1

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
66: and nvl(p1.adjustment_period_flag,'N') = 'N'
67: and p1.application_id = (select application_id

Line 88: From gl_period_statuses

84: period_name,
85: period_num,
86: period_year,
87: quarter_num
88: From gl_period_statuses
89: Where trunc(sysdate) Between trunc(start_date) And trunc(end_date)
90: And set_of_books_id = p_set_of_books_id
91: And NVL(adjustment_period_flag,'N') = 'N'
92: And application_id = (Select application_id

Line 160: l_current_period_num gl_period_statuses.period_num%type;

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;
164: l_period_type gl_period_statuses.period_type%type;

Line 161: l_current_period_year gl_period_statuses.period_year%type;

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;
164: l_period_type gl_period_statuses.period_type%type;
165: l_start_period_year gl_period_statuses.period_year%type;

Line 162: l_current_quarter_num gl_period_statuses.quarter_num%type;

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

Line 164: l_period_type gl_period_statuses.period_type%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;
168: l_end_period_num gl_period_statuses.period_num%type;

Line 165: l_start_period_year gl_period_statuses.period_year%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;
168: l_end_period_num gl_period_statuses.period_num%type;
169: l_it_header_id igi_itr_charge_lines.it_header_id%type;

Line 166: l_start_period_num gl_period_statuses.period_num%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;
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;

Line 167: l_end_period_year gl_period_statuses.period_year%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;
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;

Line 168: l_end_period_num gl_period_statuses.period_num%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;
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;

Line 180: l_period_num gl_period_statuses.period_num%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
184: l_description igi_itr_charge_lines.description%type;

Line 181: l_period_year gl_period_statuses.period_year%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
184: l_description igi_itr_charge_lines.description%type;
185: l_reference_10 gl_interface.reference10%TYPE; --shsaxena for bug 2948237

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