APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on JL_CO_GL_CONC_ERRS

Line 120: identifier jl_co_gl_conc_errs.identifier%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);
121:
122: g_jl_trx jl_co_gl_trx%ROWTYPE;
123: g_journal_rec journals%ROWTYPE;
124: g_parameter_rec t_parameters;

Line 137: INSERT INTO jl_co_gl_conc_errs (message_text,

133: (p_message_text IN VARCHAR2 ) IS
134:
135: BEGIN
136:
137: INSERT INTO jl_co_gl_conc_errs (message_text,
138: process_id,
139: je_header_id,
140: je_line_num,
141: identifier,

Line 178: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;

174: -- insert a new nit record
175:
176: l_master_nit_rec t_nits;
177: l_nit_valid BOOLEAN := TRUE;
178: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;
179: l_add_text VARCHAR2(30):= NULL;
180:
181: BEGIN
182:

Line 389: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;

385: PROCEDURE Generate_GL_trx
386: (p_journal_rec IN journals%ROWTYPE ) IS
387:
388: l_add_text VARCHAR2(30):= NULL;
389: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;
390:
391: BEGIN
392:
393: BEGIN

Line 528: FROM jl_co_gl_conc_errs jlcgce

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);
531:
532: EXCEPTION

Line 913: FROM jl_co_gl_conc_errs jlcgce

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); */
916:
917: -- New statement for bug 3840010

Line 920: FROM jl_co_gl_conc_errs jlcgce

916:
917: -- New statement for bug 3840010
918: SELECT 'TRUE'
919: INTO g_error_exists
920: FROM jl_co_gl_conc_errs jlcgce
921: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
922: AND jlcgce.je_line_num = p_journal_rec.je_line_num and rownum = 1;
923:
924: EXCEPTION

Line 956: FROM jl_co_gl_conc_errs jlcgce

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);
959: EXCEPTION
960: WHEN no_data_found THEN

Line 1119: FROM jl_co_gl_conc_errs jlcgce

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);
1122:
1123: EXCEPTION

Line 1422: FROM jl_co_gl_conc_errs jlcgce

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);
1425:
1426: EXCEPTION

Line 1461: FROM jl_co_gl_conc_errs jlcgce

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);
1464:
1465: EXCEPTION

Line 1620: FROM jl_co_gl_conc_errs jlcgce

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);
1623:
1624: EXCEPTION

Line 2132: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;

2128:
2129: l_request_id NUMBER := 0;
2130: i NUMBER := 1;
2131: l_rows NUMBER := 0;
2132: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;
2133:
2134: BEGIN
2135:
2136: FND_FILE.PUT_LINE(FND_FILE.log,'Create_Trx_Balance: Start');

Line 2138: DELETE FROM jl_co_gl_conc_errs;

2134: BEGIN
2135:
2136: FND_FILE.PUT_LINE(FND_FILE.log,'Create_Trx_Balance: Start');
2137:
2138: DELETE FROM jl_co_gl_conc_errs;
2139:
2140: -- Find out which segment IS the natural account segment
2141: SELECT application_column_name,
2142: id_flex_num