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.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 43: nit_id jl_co_gl_nits.nit_id%TYPE,

39: foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE,
40: foreign_description jl_co_gl_mg_literals.foreign_description%TYPE,
41: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,
42: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
43: nit_id jl_co_gl_nits.nit_id%TYPE,
44: config_id jl_co_gl_mg_configs.config_id%TYPE,
45: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
46: range_id jl_co_gl_mg_ranges.range_id%TYPE,
47: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,

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

163:
164:
165:
166: /**********************************************************************
167: Procedure to get nit information from jl_co_gl_nits for a given nit_id
168: **********************************************************************/
169:
170: PROCEDURE get_nit_info
171: (p_nit_id IN jl_co_gl_nits.nit_id%TYPE

Line 171: (p_nit_id IN jl_co_gl_nits.nit_id%TYPE

167: Procedure to get nit information from jl_co_gl_nits for a given nit_id
168: **********************************************************************/
169:
170: PROCEDURE get_nit_info
171: (p_nit_id IN jl_co_gl_nits.nit_id%TYPE
172: ) IS
173: BEGIN
174:
175: /*****************************************

Line 176: Select NIT information from jl_co_gl_nits

172: ) IS
173: BEGIN
174:
175: /*****************************************
176: Select NIT information from jl_co_gl_nits
177: *****************************************/
178:
179: SELECT nit,
180: name,

Line 187: FROM jl_co_gl_nits

183: INTO x_nit,
184: x_name,
185: x_type,
186: x_verifying_digit
187: FROM jl_co_gl_nits
188: WHERE nit_id = p_nit_id;
189:
190: EXCEPTION
191:

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

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

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

203: WHEN OTHERS THEN
204:
205: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
206: fnd_message.set_token('GENERIC_TEXT',
207: 'Exception "OTHERS" for selection of nit information from JL_CO_GL_NITS table');
208: x_error_text := SUBSTR(fnd_message.get, 1, 100);
209: app_exception.raise_exception (exception_type => 'APP',
210: exception_code =>
211: jl_zz_fa_utilities_pkg.get_app_errnum('AR', 'GENERIC_MESSAGE'),

Line 510: FROM JL_CO_GL_NITS NIT

506: -- bug 9384107
507: gl_sets_of_books sob1
508: WHERE t.set_of_books_id = sob1.set_of_books_id
509: AND exists (SELECT /*+ NO_UNNEST */ 'X'
510: FROM JL_CO_GL_NITS NIT
511: WHERE NIT.NIT_ID = T.NIT_ID)
512: -- bug 9384107
513: AND sob1.set_of_books_id = p_set_of_books_id
514: AND t.period_name IN (SELECT p.period_name

Line 1572: jl_co_gl_nits n,

1568: nit_number,
1569: SUM(mgl.first_reported_value) first_reported_value,
1570: SUM(mgl.second_reported_value) second_reported_value
1571: FROM jl_co_gl_mg_lines mgl,
1572: jl_co_gl_nits n,
1573: jl_co_gl_mg_literals mglit,
1574: jl_co_gl_mg_headers mgh
1575: WHERE mgl.mg_header_id = mgh.mg_header_id
1576: AND mgh.reported_year = p_reported_year

Line 1782: FROM jl_co_gl_nits

1778: SELECT name,
1779: NVL(verifying_digit, ' ') vd
1780: INTO x_name,
1781: x_verifying_digit
1782: FROM jl_co_gl_nits
1783: WHERE nit = generate_rec.nit_number;
1784:
1785: EXCEPTION
1786: