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.

[Home] [Help]

APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_NITS

Line 9: x_nit jl_co_gl_nits.nit%TYPE;

5: x_message VARCHAR2(2000);
6: x_trx_count NUMBER;
7: x_bal_count NUMBER;
8:
9: x_nit jl_co_gl_nits.nit%TYPE;
10: x_name jl_co_gl_nits.name%TYPE;
11: x_type jl_co_gl_nits.type%TYPE;
12: x_verifying_digit jl_co_gl_nits.verifying_digit%TYPE;
13:

Line 10: x_name jl_co_gl_nits.name%TYPE;

6: x_trx_count NUMBER;
7: x_bal_count NUMBER;
8:
9: x_nit jl_co_gl_nits.nit%TYPE;
10: x_name jl_co_gl_nits.name%TYPE;
11: x_type jl_co_gl_nits.type%TYPE;
12: x_verifying_digit jl_co_gl_nits.verifying_digit%TYPE;
13:
14: x_literal_code jl_co_gl_mg_literals.literal_code%TYPE;

Line 11: x_type jl_co_gl_nits.type%TYPE;

7: x_bal_count NUMBER;
8:
9: x_nit jl_co_gl_nits.nit%TYPE;
10: x_name jl_co_gl_nits.name%TYPE;
11: x_type jl_co_gl_nits.type%TYPE;
12: x_verifying_digit jl_co_gl_nits.verifying_digit%TYPE;
13:
14: x_literal_code jl_co_gl_mg_literals.literal_code%TYPE;
15:

Line 12: x_verifying_digit jl_co_gl_nits.verifying_digit%TYPE;

8:
9: x_nit jl_co_gl_nits.nit%TYPE;
10: x_name jl_co_gl_nits.name%TYPE;
11: x_type jl_co_gl_nits.type%TYPE;
12: x_verifying_digit jl_co_gl_nits.verifying_digit%TYPE;
13:
14: x_literal_code jl_co_gl_mg_literals.literal_code%TYPE;
15:
16: x_reported_flag jl_co_gl_mg_lines.reported_flag%TYPE;

Line 34: nit_id jl_co_gl_nits.nit_id%TYPE,

30: foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE,
31: foreign_description jl_co_gl_mg_literals.foreign_description%TYPE,
32: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,
33: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
34: nit_id jl_co_gl_nits.nit_id%TYPE,
35: config_id jl_co_gl_mg_configs.config_id%TYPE,
36: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
37: range_id jl_co_gl_mg_ranges.range_id%TYPE,
38: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,

Line 158: Procedure to get nit information from jl_co_gl_nits for a given nit_id

154:
155:
156:
157: /**********************************************************************
158: Procedure to get nit information from jl_co_gl_nits for a given nit_id
159: **********************************************************************/
160:
161: PROCEDURE get_nit_info
162: (p_nit_id IN jl_co_gl_nits.nit_id%TYPE

Line 162: (p_nit_id IN jl_co_gl_nits.nit_id%TYPE

158: Procedure to get nit information from jl_co_gl_nits for a given nit_id
159: **********************************************************************/
160:
161: PROCEDURE get_nit_info
162: (p_nit_id IN jl_co_gl_nits.nit_id%TYPE
163: ) IS
164: BEGIN
165:
166: /*****************************************

Line 167: Select NIT information from jl_co_gl_nits

163: ) IS
164: BEGIN
165:
166: /*****************************************
167: Select NIT information from jl_co_gl_nits
168: *****************************************/
169:
170: SELECT nit,
171: name,

Line 178: FROM jl_co_gl_nits

174: INTO x_nit,
175: x_name,
176: x_type,
177: x_verifying_digit
178: FROM jl_co_gl_nits
179: WHERE nit_id = p_nit_id;
180:
181: EXCEPTION
182:

Line 187: 'Exception "NO_DATA_FOUND" for selection of nit information from JL_CO_GL_NITS table');

183: WHEN NO_DATA_FOUND THEN
184:
185: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
186: fnd_message.set_token('GENERIC_TEXT',
187: 'Exception "NO_DATA_FOUND" for selection of nit information from JL_CO_GL_NITS table');
188: x_error_text := SUBSTR(fnd_message.get, 1, 100);
189: app_exception.raise_exception (exception_type => 'APP',
190: exception_code =>
191: jl_zz_fa_utilities_pkg.get_app_errnum('AR', 'GENERIC_MESSAGE'),

Line 198: 'Exception "OTHERS" for selection of nit information from JL_CO_GL_NITS table');

194: WHEN OTHERS THEN
195:
196: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
197: fnd_message.set_token('GENERIC_TEXT',
198: 'Exception "OTHERS" for selection of nit information from JL_CO_GL_NITS table');
199: x_error_text := SUBSTR(fnd_message.get, 1, 100);
200: app_exception.raise_exception (exception_type => 'APP',
201: exception_code =>
202: jl_zz_fa_utilities_pkg.get_app_errnum('AR', 'GENERIC_MESSAGE'),

Line 452: jl_co_gl_nits nit,

448: '4', SUM(NVL(t.accounted_cr, 0)) - SUM(NVL(t.accounted_dr, 0)),
449: 0
450: ) amount
451: FROM jl_co_gl_trx t,
452: jl_co_gl_nits nit,
453: gl_sets_of_books sob1
454: WHERE t.set_of_books_id = sob1.set_of_books_id
455: AND nit.nit_id = t.nit_id
456: AND sob1.set_of_books_id = p_set_of_books_id

Line 1465: jl_co_gl_nits n,

1461: nit_number,
1462: SUM(mgl.first_reported_value) first_reported_value,
1463: SUM(mgl.second_reported_value) second_reported_value
1464: FROM jl_co_gl_mg_lines mgl,
1465: jl_co_gl_nits n,
1466: jl_co_gl_mg_literals mglit,
1467: jl_co_gl_mg_headers mgh
1468: WHERE mgl.mg_header_id = mgh.mg_header_id
1469: AND mgh.reported_year = p_reported_year

Line 1675: FROM jl_co_gl_nits

1671: SELECT name,
1672: NVL(verifying_digit, ' ') vd
1673: INTO x_name,
1674: x_verifying_digit
1675: FROM jl_co_gl_nits
1676: WHERE nit = generate_rec.nit_number;
1677:
1678: EXCEPTION
1679: