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 DUAL

Line 301: ('LEGAL_ENTITY','INDIVIDUAL','FOREIGN_ENTITY')) THEN

297: l_nit_valid := FALSE;
298: END IF;
299:
300: IF (p_nit_rec.nit_type IS NULL) OR (p_nit_rec.nit_type NOT IN
301: ('LEGAL_ENTITY','INDIVIDUAL','FOREIGN_ENTITY')) THEN
302: FND_MESSAGE.SET_NAME('JL','JL_CO_GL_NIT_TYPE_REQUIRED');
303: FND_MESSAGE.SET_TOKEN('IDENTIFIER_TYPE',p_identifier_type,TRUE);
304: FND_MESSAGE.SET_TOKEN('IDENTIFIER',g_gl_je_rec.identifier);
305: FND_MESSAGE.SET_TOKEN('TAXID_TYPE', 'LEGAL_ENTITY, INDIVIDUAL and FOREIGN_ENTITY');

Line 305: FND_MESSAGE.SET_TOKEN('TAXID_TYPE', 'LEGAL_ENTITY, INDIVIDUAL and FOREIGN_ENTITY');

301: ('LEGAL_ENTITY','INDIVIDUAL','FOREIGN_ENTITY')) THEN
302: FND_MESSAGE.SET_NAME('JL','JL_CO_GL_NIT_TYPE_REQUIRED');
303: FND_MESSAGE.SET_TOKEN('IDENTIFIER_TYPE',p_identifier_type,TRUE);
304: FND_MESSAGE.SET_TOKEN('IDENTIFIER',g_gl_je_rec.identifier);
305: FND_MESSAGE.SET_TOKEN('TAXID_TYPE', 'LEGAL_ENTITY, INDIVIDUAL and FOREIGN_ENTITY');
306: FND_MESSAGE.SET_TOKEN('ADD_TEXT',l_add_text,TRUE);
307: l_message_text := FND_MESSAGE.GET;
308: Insert_Error_Rec(l_message_text);
309: l_nit_valid := FALSE;

Line 348: FROM DUAL ;

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;
351:
352: ELSIF l_nit_valid THEN

Line 412: FROM DUAL;

408: SELECT p_journal_rec.je_header_id,
409: p_journal_rec.je_line_num,
410: null
411: INTO g_gl_je_rec
412: FROM DUAL;
413:
414: IF p_journal_rec.source in ('Payables','Purchasing','Receivables') THEN
415: -- Its here probably because import references dont exist or is in
416: -- summary because of which the AR, AP or PO routine couldn't process

Line 526: FROM DUAL

522: /* bug 7045429
523: BEGIN
524: SELECT 'TRUE'
525: INTO g_error_exists
526: FROM DUAL
527: WHERE EXISTS (SELECT '1'
528: FROM jl_co_gl_conc_errs jlcgce
529: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
530: AND jlcgce.je_line_num = p_journal_rec.je_line_num);

Line 736: FROM DUAL;

732: SELECT p_journal_rec.je_header_id,
733: p_journal_rec.je_line_num,
734: p_journal_rec.ext_nit
735: INTO g_gl_je_rec
736: FROM DUAL;
737:
738: FND_FILE.PUT_LINE(FND_FILE.log,'Generate_ap_trx : Begin ');
739:
740: FOR ap_trx IN ap_detail_lines LOOP

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 911: FROM DUAL

907: /* Commented for bug3840010
908:
909: SELECT 'TRUE'
910: INTO g_error_exists
911: FROM DUAL
912: WHERE EXISTS (SELECT '1'
913: FROM jl_co_gl_conc_errs jlcgce
914: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
915: AND jlcgce.je_line_num = p_journal_rec.je_line_num); */

Line 954: FROM DUAL

950: BEGIN
951:
952: SELECT 'TRUE'
953: INTO g_error_exists
954: FROM DUAL
955: WHERE EXISTS (SELECT '1'
956: FROM jl_co_gl_conc_errs jlcgce
957: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
958: AND jlcgce.je_line_num = p_journal_rec.je_line_num);

Line 1024: (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,

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,
1027: aps.global_attribute12,
1028: aps.segment1,

Line 1117: FROM DUAL

1113: BEGIN
1114:
1115: SELECT 'TRUE'
1116: INTO g_error_exists
1117: FROM DUAL
1118: WHERE EXISTS (SELECT '1'
1119: FROM jl_co_gl_conc_errs jlcgce
1120: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1121: AND jlcgce.je_line_num = p_journal_rec.je_line_num);

Line 1248: FROM DUAL;

1244: SELECT p_journal_rec.je_header_id,
1245: p_journal_rec.je_line_num,
1246: p_journal_rec.ext_nit
1247: INTO g_gl_je_rec
1248: FROM DUAL;
1249: FND_FILE.PUT_LINE(FND_FILE.log,'je_header_id, je_line_num : '||to_char(p_journal_rec.je_header_id)
1250: ||'-'||to_char(p_journal_rec.je_line_num));
1251:
1252: FOR ar_trx IN ar_detail_lines LOOP

Line 1420: FROM DUAL

1416: BEGIN
1417:
1418: SELECT 'TRUE'
1419: INTO g_error_exists
1420: FROM DUAL
1421: WHERE EXISTS (SELECT '1'
1422: FROM jl_co_gl_conc_errs jlcgce
1423: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1424: AND jlcgce.je_line_num = p_journal_rec.je_line_num);

Line 1459: FROM DUAL

1455: BEGIN
1456:
1457: SELECT 'TRUE'
1458: INTO g_error_exists
1459: FROM DUAL
1460: WHERE EXISTS (SELECT '1'
1461: FROM jl_co_gl_conc_errs jlcgce
1462: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1463: AND jlcgce.je_line_num = p_journal_rec.je_line_num);

Line 1510: FROM DUAL;

1506: p_journal_rec.ext_nit_name,
1507: p_journal_rec.ext_nit_type,
1508: p_journal_rec.ext_nit_v_digit
1509: INTO g_nit_rec
1510: FROM DUAL;
1511:
1512: BEGIN
1513: SELECT nit_id
1514: INTO g_nit_rec.nit_id

Line 1526: INTO g_gl_je_rec FROM DUAL;

1522:
1523: SELECT p_journal_rec.je_header_id,
1524: p_journal_rec.je_line_num,
1525: p_journal_rec.ext_nit
1526: INTO g_gl_je_rec FROM DUAL;
1527:
1528: IF Validate_NIT(g_nit_rec,'JL_CO_GL_NIT') THEN
1529: NULL;
1530: ELSE

Line 1618: FROM DUAL

1614: BEGIN
1615:
1616: SELECT 'TRUE'
1617: INTO g_error_exists
1618: FROM DUAL
1619: WHERE EXISTS (SELECT '1'
1620: FROM jl_co_gl_conc_errs jlcgce
1621: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1622: AND jlcgce.je_line_num = p_journal_rec.je_line_num);

Line 2159: FROM DUAL;

2155:
2156:
2157: SELECT TO_NUMBER(NVL(fnd_profile.value('LOGIN_ID'),-1))
2158: INTO g_login_id
2159: FROM DUAL;
2160:
2161: SELECT jl_co_gl_conc_ctrl_s.nextval,
2162: p_sobid,
2163: TO_NUMBER(NVL(fnd_profile.value('USER_ID') ,-1)),

Line 2166: FROM dual;

2162: p_sobid,
2163: TO_NUMBER(NVL(fnd_profile.value('USER_ID') ,-1)),
2164: p_rcid
2165: INTO g_parameter_rec
2166: FROM dual;
2167:
2168: INSERT INTO jl_co_gl_conc_ctrl (
2169: process_id,
2170: set_of_books_id,