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_NIT_MANAGEMENT dependencies on JL_CO_GL_NITS

Line 10: g_default_nit_id jl_co_gl_nits.nit_id%TYPE;

6: g_chart_of_accounts_id fnd_segment_attribute_values.id_flex_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_period_year gl_periods.period_year%TYPE;
9: g_func_currency gl_sets_of_books.currency_code%TYPE;
10: g_default_nit_id jl_co_gl_nits.nit_id%TYPE;
11: g_login_id jl_co_gl_trx.last_update_login%TYPE;
12:
13: PROCEDURE Create_Balances(
14: p_period IN VARCHAR2,

Line 112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,

108: set_of_books_id jl_co_gl_conc_ctrl.set_of_books_id%type,
109: user_id jl_co_gl_conc_ctrl.created_by%type,
110: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
111:
112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
113: nit jl_co_gl_nits.nit%type,
114: nit_name jl_co_gl_nits.name%type,
115: nit_type jl_co_gl_nits.type%type,
116: verifying_digit jl_co_gl_nits.verifying_digit%type);

Line 113: nit jl_co_gl_nits.nit%type,

109: user_id jl_co_gl_conc_ctrl.created_by%type,
110: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
111:
112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
113: nit jl_co_gl_nits.nit%type,
114: nit_name jl_co_gl_nits.name%type,
115: nit_type jl_co_gl_nits.type%type,
116: verifying_digit jl_co_gl_nits.verifying_digit%type);
117:

Line 114: nit_name jl_co_gl_nits.name%type,

110: rev_cid jl_co_gl_conc_ctrl.reversed_process_id%type);
111:
112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
113: nit jl_co_gl_nits.nit%type,
114: nit_name jl_co_gl_nits.name%type,
115: nit_type jl_co_gl_nits.type%type,
116: verifying_digit jl_co_gl_nits.verifying_digit%type);
117:
118: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%type,

Line 115: nit_type jl_co_gl_nits.type%type,

111:
112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
113: nit jl_co_gl_nits.nit%type,
114: nit_name jl_co_gl_nits.name%type,
115: nit_type jl_co_gl_nits.type%type,
116: verifying_digit jl_co_gl_nits.verifying_digit%type);
117:
118: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%type,
119: je_line_num jl_co_gl_trx.je_line_num%type,

Line 116: verifying_digit jl_co_gl_nits.verifying_digit%type);

112: TYPE t_nits IS RECORD (nit_id jl_co_gl_nits.nit_id%type,
113: nit jl_co_gl_nits.nit%type,
114: nit_name jl_co_gl_nits.name%type,
115: nit_type jl_co_gl_nits.type%type,
116: verifying_digit jl_co_gl_nits.verifying_digit%type);
117:
118: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%type,
119: je_line_num jl_co_gl_trx.je_line_num%type,
120: identifier jl_co_gl_conc_errs.identifier%type);

Line 172: -- Validate nit information against jl_co_gl_nits.

168: FUNCTION Validate_NIT
169: (p_nit_rec IN OUT NOCOPY t_nits,
170: p_identifier_type IN VARCHAR2 ) RETURN BOOLEAN IS
171:
172: -- Validate nit information against jl_co_gl_nits.
173: -- If a corresponding record does not exist in jl_co_gl_nits,
174: -- insert a new nit record
175:
176: l_master_nit_rec t_nits;

Line 173: -- If a corresponding record does not exist in jl_co_gl_nits,

169: (p_nit_rec IN OUT NOCOPY t_nits,
170: p_identifier_type IN VARCHAR2 ) RETURN BOOLEAN IS
171:
172: -- Validate nit information against jl_co_gl_nits.
173: -- If a corresponding record does not exist in jl_co_gl_nits,
174: -- insert a new nit record
175:
176: l_master_nit_rec t_nits;
177: l_nit_valid BOOLEAN := TRUE;

Line 198: FROM jl_co_gl_nits

194: name,
195: type,
196: verifying_digit
197: INTO l_master_nit_rec
198: FROM jl_co_gl_nits
199: WHERE nit = p_nit_rec.nit;
200:
201:
202: EXCEPTION

Line 215: FROM jl_co_gl_nits

211: nit,name,
212: type,
213: verifying_digit
214: INTO l_master_nit_rec
215: FROM jl_co_gl_nits
216: WHERE UPPER(name) = UPPER(p_nit_rec.nit_name);
217:
218: FND_FILE.PUT_LINE(FND_FILE.log,'p_nit_rec.nit_name : '||p_nit_rec.nit_name);
219:

Line 325: INSERT INTO jl_co_gl_nits (nit_id,

321:
322: -- insert validated NIT record
323: IF l_nit_valid THEN
324:
325: INSERT INTO jl_co_gl_nits (nit_id,
326: nit,
327: type,
328: verifying_digit,
329: name,

Line 335: VALUES (jl_co_gl_nits_s.nextval,

331: created_by,
332: last_update_date,
333: last_updated_by,
334: last_update_login)
335: VALUES (jl_co_gl_nits_s.nextval,
336: p_nit_rec.nit,
337: p_nit_rec.nit_type,
338: p_nit_rec.verifying_digit,
339: p_nit_rec.nit_name,

Line 346: SELECT jl_co_gl_nits_s.currval

342: sysdate,
343: NVL(g_parameter_rec.user_id,-1),
344: g_login_id);
345:
346: SELECT jl_co_gl_nits_s.currval
347: INTO p_nit_rec.nit_id
348: FROM DUAL ;
349:
350: END IF;

Line 396: FROM jl_co_gl_nits jlcgn

392:
393: BEGIN
394: SELECT nit_id
395: INTO g_nit_rec.nit_id
396: FROM jl_co_gl_nits jlcgn
397: WHERE nit = DECODE(p_journal_rec.source,
398: 'Payables','0',
399: 'Purchasing','0',
400: 'Receivables','0',

Line 777: FROM jl_co_gl_nits jlcgn, po_vendors pov

773: g_nit_rec.nit_name,
774: g_nit_rec.nit_type,
775: g_nit_rec.verifying_digit,
776: l_supplier_num
777: FROM jl_co_gl_nits jlcgn, po_vendors pov
778: WHERE NVL(l_supplier_num,TO_CHAR(ap_trx.party_id)) =
779: DECODE(l_supplier_num, NULL,TO_CHAR(pov.vendor_id),pov.segment1)
780: AND jlcgn.nit(+) = REPLACE(pov.num_1099,'-') ; */
781:

Line 797: FROM jl_co_gl_nits jlcgn, (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,

793: g_nit_rec.nit_name,
794: g_nit_rec.nit_type,
795: g_nit_rec.verifying_digit,
796: l_supplier_num
797: FROM jl_co_gl_nits jlcgn, (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,
798: aps.vendor_name,
799: aps.global_attribute10,
800: aps.global_attribute12,
801: aps.segment1,

Line 825: FROM jl_co_gl_nits jlcgn, (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,

821: g_nit_rec.nit_name,
822: g_nit_rec.nit_type,
823: g_nit_rec.verifying_digit,
824: l_supplier_num
825: FROM jl_co_gl_nits jlcgn, (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,
826: aps.vendor_name,
827: aps.global_attribute10,
828: aps.global_attribute12,
829: aps.segment1,

Line 1022: FROM jl_co_gl_nits jlcgn,

1018: g_nit_rec.verifying_digit,
1019: g_gl_je_rec.identifier,
1020: g_gl_je_rec.je_header_id,
1021: g_gl_je_rec.je_line_num
1022: FROM jl_co_gl_nits jlcgn,
1023: po_headers_all poha,
1024: (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,
1025: aps.vendor_name,
1026: aps.global_attribute10,

Line 1281: FROM jl_co_gl_nits nit,

1277: g_nit_rec.nit_name,
1278: l_branch_country_code, --g_nit_rec.nit_type,
1279: g_nit_rec.verifying_digit,
1280: g_gl_je_rec.identifier
1281: FROM jl_co_gl_nits nit,
1282: hz_parties party,
1283: ce_bank_branches_v br,
1284: ce_bank_accounts ce_accts,
1285: ce_bank_acct_uses_all acctuse,

Line 1326: FROM jl_co_gl_nits jlcgn,

1322: g_nit_rec.nit_name,
1323: g_nit_rec.nit_type,
1324: g_nit_rec.verifying_digit,
1325: l_customer_num
1326: FROM jl_co_gl_nits jlcgn,
1327: hz_parties rac,
1328: hz_cust_accounts custacct
1329: WHERE custacct.cust_account_id = ar_trx.party_id
1330: AND REPLACE(rac.jgzz_fiscal_code,'-') = jlcgn.nit(+)

Line 1347: FROM jl_co_gl_nits

1343: g_nit_rec.nit,
1344: g_nit_rec.nit_name,
1345: g_nit_rec.nit_type,
1346: g_nit_rec.verifying_digit
1347: FROM jl_co_gl_nits
1348: WHERE nit_id = g_default_nit_id;
1349: FND_FILE.PUT_LINE(FND_FILE.log,'Exception Non Misc : g_nit_rec : '||g_nit_rec.nit||'-'||g_nit_rec.nit_name);
1350:
1351: END;

Line 1515: FROM jl_co_gl_nits jlcgn

1511:
1512: BEGIN
1513: SELECT nit_id
1514: INTO g_nit_rec.nit_id
1515: FROM jl_co_gl_nits jlcgn
1516: WHERE nit = p_journal_rec.ext_nit;
1517:
1518: EXCEPTION
1519: WHEN no_data_found THEN

Line 2198: FROM jl_co_gl_nits

2194: BEGIN
2195:
2196: SELECT nit_id
2197: INTO g_default_nit_id
2198: FROM jl_co_gl_nits
2199: WHERE nit = '0';
2200:
2201: EXCEPTION
2202: WHEN no_data_found THEN

Line 2204: INSERT INTO jl_co_gl_nits (

2200:
2201: EXCEPTION
2202: WHEN no_data_found THEN
2203: BEGIN
2204: INSERT INTO jl_co_gl_nits (
2205: nit_id,
2206: nit,
2207: type,
2208: verifying_digit,

Line 2215: VALUES ( jl_co_gl_nits_s.nextval,

2211: created_by,
2212: last_update_date,
2213: last_updated_by,
2214: last_update_login)
2215: VALUES ( jl_co_gl_nits_s.nextval,
2216: 0,
2217: 'LEGAL_ENTITY',
2218: '0',
2219: 'Default',

Line 2228: FROM jl_co_gl_nits

2224: null);
2225:
2226: SELECT nit_id
2227: INTO g_default_nit_id
2228: FROM jl_co_gl_nits
2229: WHERE nit = '0';
2230: END;
2231: END;
2232: