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_TRX

Line 11: g_login_id jl_co_gl_trx.last_update_login%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,
15: p_period_year IN NUMBER,

Line 138: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%type,

134: nit_name jl_co_gl_nits.name%type,
135: nit_type jl_co_gl_nits.type%type,
136: verifying_digit jl_co_gl_nits.verifying_digit%type);
137:
138: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%type,
139: je_line_num jl_co_gl_trx.je_line_num%type,
140: identifier jl_co_gl_conc_errs.identifier%type);
141:
142: g_jl_trx jl_co_gl_trx%ROWTYPE;

Line 139: je_line_num jl_co_gl_trx.je_line_num%type,

135: nit_type jl_co_gl_nits.type%type,
136: verifying_digit jl_co_gl_nits.verifying_digit%type);
137:
138: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%type,
139: je_line_num jl_co_gl_trx.je_line_num%type,
140: identifier jl_co_gl_conc_errs.identifier%type);
141:
142: g_jl_trx jl_co_gl_trx%ROWTYPE;
143: g_journal_rec journals%ROWTYPE;

Line 142: g_jl_trx jl_co_gl_trx%ROWTYPE;

138: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%type,
139: je_line_num jl_co_gl_trx.je_line_num%type,
140: identifier jl_co_gl_conc_errs.identifier%type);
141:
142: g_jl_trx jl_co_gl_trx%ROWTYPE;
143: g_journal_rec journals%ROWTYPE;
144: g_parameter_rec t_parameters;
145: g_nit_rec t_nits;
146: g_gl_je_rec t_gl_je;

Line 545: INSERT INTO jl_co_gl_trx (transaction_id,

541:
542: -- Bug 9710493 Start
543: If l_flag = 0 Then
544: -- Bug 9710493 End
545: INSERT INTO jl_co_gl_trx (transaction_id,
546: process_id,
547: set_of_books_id,
548: code_combination_id,
549: account_code,

Line 571: VALUES (jl_co_gl_trx_s.nextval,

567: accounted_dr,
568: accounted_cr,
569: entered_dr,
570: entered_cr)
571: VALUES (jl_co_gl_trx_s.nextval,
572: g_parameter_rec.cid,
573: g_parameter_rec.set_of_books_id,
574: p_journal_rec.code_combination_id,
575: p_journal_rec.account_code,

Line 633: DELETE FROM jl_co_gl_trx jlcgt

629: NULL;
630: END;
631:
632: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
633: DELETE FROM jl_co_gl_trx jlcgt
634: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
635: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
636: ELSE */ -- Bug 8215616
637: UPDATE gl_je_lines gljl

Line 642: FROM jl_co_gl_trx jlcgt

638: SET co_processed_flag = 'Y'
639: WHERE gljl.je_header_id = p_journal_rec.je_header_id
640: AND gljl.je_line_num = p_journal_rec.je_line_num
641: AND EXISTS (SELECT 'Y'
642: FROM jl_co_gl_trx jlcgt
643: WHERE jlcgt.je_header_id = gljl.je_header_id
644: AND jlcgt.je_line_num = gljl.je_line_num); /*
645: END IF;
646: */

Line 1136: INSERT INTO jl_co_gl_trx (transaction_id,

1132: FND_FILE.PUT_LINE(FND_FILE.log,'AP : acc_dr, acc_cr,ent_dr, ent_dr : '
1133: ||to_char(ap_trx.accounted_dr)||'-'||to_char(ap_trx.accounted_cr)
1134: ||'-'||to_char(ap_trx.entered_dr)||'-'||to_char(ap_trx.entered_cr));
1135:
1136: INSERT INTO jl_co_gl_trx (transaction_id,
1137: process_id,
1138: set_of_books_id,
1139: code_combination_id,
1140: account_code,

Line 1162: VALUES (jl_co_gl_trx_s.nextval,

1158: accounted_dr,
1159: accounted_cr,
1160: entered_dr,
1161: entered_cr)
1162: VALUES (jl_co_gl_trx_s.nextval,
1163: g_parameter_rec.cid,
1164: g_parameter_rec.set_of_books_id,
1165: p_journal_rec.code_combination_id,
1166: p_journal_rec.account_code,

Line 1220: FROM jl_co_gl_trx jlcgt

1216: SET co_processed_flag = 'N'
1217: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1218: AND gljl.je_line_num = p_journal_rec.je_line_num
1219: AND EXISTS (SELECT 'Y'
1220: FROM jl_co_gl_trx jlcgt
1221: WHERE jlcgt.je_header_id = gljl.je_header_id
1222: AND jlcgt.je_line_num = gljl.je_line_num);
1223: DELETE FROM jl_co_gl_trx jlcgt
1224: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id

Line 1223: DELETE FROM jl_co_gl_trx jlcgt

1219: AND EXISTS (SELECT 'Y'
1220: FROM jl_co_gl_trx jlcgt
1221: WHERE jlcgt.je_header_id = gljl.je_header_id
1222: AND jlcgt.je_line_num = gljl.je_line_num);
1223: DELETE FROM jl_co_gl_trx jlcgt
1224: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1225: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1226:
1227: ELSE

Line 1233: FROM jl_co_gl_trx jlcgt

1229: SET co_processed_flag = 'Y'
1230: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1231: AND gljl.je_line_num = p_journal_rec.je_line_num
1232: AND EXISTS (SELECT 'Y'
1233: FROM jl_co_gl_trx jlcgt
1234: WHERE jlcgt.je_header_id = gljl.je_header_id
1235: AND jlcgt.je_line_num = gljl.je_line_num);
1236:
1237: END IF;

Line 1264: FROM jl_co_gl_trx jlcgt

1260: SET co_processed_flag = 'N'
1261: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1262: AND gljl.je_line_num = p_journal_rec.je_line_num
1263: AND EXISTS (SELECT 'Y'
1264: FROM jl_co_gl_trx jlcgt
1265: WHERE jlcgt.je_header_id = gljl.je_header_id
1266: AND jlcgt.je_line_num = gljl.je_line_num);
1267: FND_FILE.PUT_LINE(FND_FILE.log,'Delete jl_co_gl_trx');
1268: DELETE FROM jl_co_gl_trx jlcgt

Line 1267: FND_FILE.PUT_LINE(FND_FILE.log,'Delete jl_co_gl_trx');

1263: AND EXISTS (SELECT 'Y'
1264: FROM jl_co_gl_trx jlcgt
1265: WHERE jlcgt.je_header_id = gljl.je_header_id
1266: AND jlcgt.je_line_num = gljl.je_line_num);
1267: FND_FILE.PUT_LINE(FND_FILE.log,'Delete jl_co_gl_trx');
1268: DELETE FROM jl_co_gl_trx jlcgt
1269: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1270: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1271: END IF;

Line 1268: DELETE FROM jl_co_gl_trx jlcgt

1264: FROM jl_co_gl_trx jlcgt
1265: WHERE jlcgt.je_header_id = gljl.je_header_id
1266: AND jlcgt.je_line_num = gljl.je_line_num);
1267: FND_FILE.PUT_LINE(FND_FILE.log,'Delete jl_co_gl_trx');
1268: DELETE FROM jl_co_gl_trx jlcgt
1269: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1270: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1271: END IF;
1272:

Line 1402: INSERT INTO jl_co_gl_trx (transaction_id,

1398: FND_FILE.PUT_LINE(FND_FILE.log,'Inside PO Before Validate - 002');
1399:
1400: IF Validate_NIT(g_nit_rec, 'JL_CO_GL_SUPPLIER') THEN
1401: FND_FILE.PUT_LINE(FND_FILE.log,'Inside Validate');
1402: INSERT INTO jl_co_gl_trx (transaction_id,
1403: process_id,
1404: set_of_books_id,
1405: code_combination_id,
1406: account_code,

Line 1428: VALUES (jl_co_gl_trx_s.nextval,

1424: accounted_dr,
1425: accounted_cr,
1426: entered_dr,
1427: entered_cr )
1428: VALUES (jl_co_gl_trx_s.nextval,
1429: g_parameter_rec.cid,
1430: g_parameter_rec.set_of_books_id,
1431: p_journal_rec.code_combination_id,
1432: p_journal_rec.account_code,

Line 1497: FROM jl_co_gl_trx jlcgt

1493: SET co_processed_flag = 'N'
1494: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1495: AND gljl.je_line_num = p_journal_rec.je_line_num
1496: AND EXISTS (SELECT 'Y'
1497: FROM jl_co_gl_trx jlcgt
1498: WHERE jlcgt.je_header_id = gljl.je_header_id
1499: AND jlcgt.je_line_num = gljl.je_line_num);
1500:
1501: DELETE FROM jl_co_gl_trx jlcgt

Line 1501: DELETE FROM jl_co_gl_trx jlcgt

1497: FROM jl_co_gl_trx jlcgt
1498: WHERE jlcgt.je_header_id = gljl.je_header_id
1499: AND jlcgt.je_line_num = gljl.je_line_num);
1500:
1501: DELETE FROM jl_co_gl_trx jlcgt
1502: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1503: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1504:
1505: ELSE

Line 1512: FROM jl_co_gl_trx jlcgt

1508: SET co_processed_flag = 'Y'
1509: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1510: AND gljl.je_line_num = p_journal_rec.je_line_num
1511: AND EXISTS (SELECT 'Y'
1512: FROM jl_co_gl_trx jlcgt
1513: WHERE jlcgt.je_header_id = gljl.je_header_id
1514: AND jlcgt.je_line_num = gljl.je_line_num);
1515:
1516: END IF;

Line 1586: INSERT INTO jl_co_gl_trx (

1582:
1583: FND_FILE.PUT_LINE(FND_FILE.log,'Select successfull for 11i PO, executing Validate_NIT');
1584: IF Validate_NIT(g_nit_rec, 'JL_CO_GL_SUPPLIER') THEN
1585:
1586: INSERT INTO jl_co_gl_trx (
1587: transaction_id,
1588: process_id,
1589: set_of_books_id,
1590: code_combination_id,

Line 1613: VALUES ( jl_co_gl_trx_s.nextval,

1609: accounted_dr,
1610: accounted_cr,
1611: entered_dr,
1612: entered_cr )
1613: VALUES ( jl_co_gl_trx_s.nextval,
1614: g_parameter_rec.cid,
1615: g_parameter_rec.set_of_books_id,
1616: p_journal_rec.code_combination_id,
1617: p_journal_rec.account_code,

Line 1659: FND_FILE.PUT_LINE(FND_FILE.log,'11i PO, insered record into jl_co_gl_trx');

1655: NVL(DECODE(sign(p_journal_rec.entered_cr),
1656: 1,p_journal_rec.entered_cr,NULL),0)),
1657: DECODE(sign(p_journal_rec.entered_cr),-1,
1658: NULL,p_journal_rec.entered_cr)) );
1659: FND_FILE.PUT_LINE(FND_FILE.log,'11i PO, insered record into jl_co_gl_trx');
1660:
1661: END IF;
1662:
1663: END IF;

Line 1819: INSERT INTO jl_co_gl_trx (

1815:
1816:
1817: IF Validate_NIT(g_nit_rec,l_identifier_type) THEN
1818:
1819: INSERT INTO jl_co_gl_trx (
1820: transaction_id,
1821: process_id,
1822: set_of_books_id,
1823: code_combination_id,

Line 1846: VALUES ( jl_co_gl_trx_s.nextval,

1842: accounted_dr,
1843: accounted_cr,
1844: entered_dr,
1845: entered_cr)
1846: VALUES ( jl_co_gl_trx_s.nextval,
1847: g_parameter_rec.cid,
1848: g_parameter_rec.set_of_books_id,
1849: p_journal_rec.code_combination_id,
1850: p_journal_rec.account_code,

Line 1897: DELETE FROM jl_co_gl_trx jlcgt

1893: NULL;
1894: END;
1895:
1896: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
1897: DELETE FROM jl_co_gl_trx jlcgt
1898: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1899: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1900: END IF;
1901:

Line 2147: INSERT INTO jl_co_gl_trx (transaction_id,

2143:
2144: IF Validate_NIT(g_nit_rec,l_identifier_type) THEN
2145: FND_FILE.PUT_LINE(FND_FILE.log,'After Validate :'||g_gl_je_rec.identifier);
2146:
2147: INSERT INTO jl_co_gl_trx (transaction_id,
2148: process_id,
2149: set_of_books_id,
2150: code_combination_id,
2151: account_code,

Line 2173: VALUES (jl_co_gl_trx_s.nextval,

2169: accounted_dr,
2170: accounted_cr,
2171: entered_dr,
2172: entered_cr)
2173: VALUES (jl_co_gl_trx_s.nextval,
2174: g_parameter_rec.cid,
2175: g_parameter_rec.set_of_books_id,
2176: p_journal_rec.code_combination_id,
2177: p_journal_rec.account_code,

Line 2225: FROM jl_co_gl_trx jlcgt

2221: SET co_processed_flag = 'N'
2222: WHERE gljl.je_header_id = p_journal_rec.je_header_id
2223: AND gljl.je_line_num = p_journal_rec.je_line_num
2224: AND EXISTS (SELECT 'Y'
2225: FROM jl_co_gl_trx jlcgt
2226: WHERE jlcgt.je_header_id = gljl.je_header_id
2227: AND jlcgt.je_line_num = gljl.je_line_num);
2228:
2229: DELETE FROM jl_co_gl_trx jlcgt

Line 2229: DELETE FROM jl_co_gl_trx jlcgt

2225: FROM jl_co_gl_trx jlcgt
2226: WHERE jlcgt.je_header_id = gljl.je_header_id
2227: AND jlcgt.je_line_num = gljl.je_line_num);
2228:
2229: DELETE FROM jl_co_gl_trx jlcgt
2230: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
2231: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
2232: ELSE
2233: FND_FILE.PUT_LINE(FND_FILE.log,'Stage2.2');

Line 2239: FROM jl_co_gl_trx jlcgt

2235: SET co_processed_flag = 'Y'
2236: WHERE gljl.je_header_id = p_journal_rec.je_header_id
2237: AND gljl.je_line_num = p_journal_rec.je_line_num
2238: AND EXISTS (SELECT 'Y'
2239: FROM jl_co_gl_trx jlcgt
2240: WHERE jlcgt.je_header_id = gljl.je_header_id
2241: AND jlcgt.je_line_num = gljl.je_line_num);
2242:
2243: END IF;

Line 2276: FROM jl_co_gl_trx jlcgt

2272: SET co_processed_flag = 'N'
2273: WHERE gljl.je_header_id = p_journal_rec.je_header_id
2274: AND gljl.je_line_num = p_journal_rec.je_line_num
2275: AND EXISTS (SELECT 'Y'
2276: FROM jl_co_gl_trx jlcgt
2277: WHERE jlcgt.je_header_id = gljl.je_header_id
2278: AND jlcgt.je_line_num = gljl.je_line_num);
2279:
2280: DELETE FROM jl_co_gl_trx jlcgt

Line 2280: DELETE FROM jl_co_gl_trx jlcgt

2276: FROM jl_co_gl_trx jlcgt
2277: WHERE jlcgt.je_header_id = gljl.je_header_id
2278: AND jlcgt.je_line_num = gljl.je_line_num);
2279:
2280: DELETE FROM jl_co_gl_trx jlcgt
2281: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
2282: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
2283: END IF;
2284:

Line 2377: FND_FILE.PUT_LINE(FND_FILE.log,'Before insert into jl_co_gl_trx');

2373: -- with the interfaced records */
2374: g_nit_rec.nit_id := g_default_nit_id;
2375: END IF;
2376:
2377: FND_FILE.PUT_LINE(FND_FILE.log,'Before insert into jl_co_gl_trx');
2378:
2379:
2380: FND_FILE.PUT_LINE(FND_FILE.log,'g_parameter_rec.cid '|| g_parameter_rec.cid);
2381: FND_FILE.PUT_LINE(FND_FILE.log,'p_journal_rec.je_batch_id '|| p_journal_rec.je_batch_id);

Line 2389: INSERT INTO jl_co_gl_trx (transaction_id,

2385: FND_FILE.PUT_LINE(FND_FILE.log,'p_journal_rec.ext_doc_num '|| p_journal_rec.ext_doc_num);
2386: FND_FILE.PUT_LINE(FND_FILE.log,'p_journal_rec.accounting_date '|| p_journal_rec.accounting_date);
2387: FND_FILE.PUT_LINE(FND_FILE.log,'p_journal_rec.subl_doc_num'|| p_journal_rec.category);
2388:
2389: INSERT INTO jl_co_gl_trx (transaction_id,
2390: process_id,
2391: set_of_books_id,
2392: code_combination_id,
2393: account_code,

Line 2415: VALUES (jl_co_gl_trx_s.nextval,

2411: accounted_dr,
2412: accounted_cr,
2413: entered_dr,
2414: entered_cr)
2415: VALUES (jl_co_gl_trx_s.nextval,
2416: g_parameter_rec.cid,
2417: g_parameter_rec.set_of_books_id,
2418: p_journal_rec.code_combination_id,
2419: p_journal_rec.account_code,

Line 2480: DELETE FROM jl_co_gl_trx jlcgt

2476: NULL;
2477: END;
2478:
2479: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
2480: DELETE FROM jl_co_gl_trx jlcgt
2481: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
2482: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
2483: ELSE */ -- Bug 8215616
2484: UPDATE gl_je_lines gljl

Line 2489: FROM jl_co_gl_trx jlcgt

2485: SET co_processed_flag = 'Y'
2486: WHERE gljl.je_header_id = p_journal_rec.je_header_id
2487: AND gljl.je_line_num = p_journal_rec.je_line_num
2488: AND EXISTS (SELECT 'Y'
2489: FROM jl_co_gl_trx jlcgt
2490: WHERE jlcgt.je_header_id = gljl.je_header_id
2491: AND jlcgt.je_line_num = gljl.je_line_num); /*
2492:
2493: END IF;

Line 2642: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt

2638: jlcgt.period_num pernum,
2639: glcc.account_type acctype,
2640: sum(nvl(jlcgt.accounted_dr,0)) acc_dr, --bug 10207969
2641: sum(nvl(jlcgt.accounted_cr,0)) acc_cr --bug 10207969
2642: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt
2643: WHERE jlcgt.process_id IN ( SELECT process_id
2644: FROM jl_co_gl_conc_ctrl
2645: WHERE NVL(balance_calculated,'N') <> 'Y'
2646: AND set_of_books_id

Line 2867: jl_co_gl_trx jlcgt

2863: glcc.account_type acctype,
2864: sum(nvl(jlcgt.accounted_dr,0)) acc_dr, --bug 10207969
2865: sum(nvl(jlcgt.accounted_cr,0)) acc_cr --bug 10207969
2866: FROM gl_code_combinations glcc,
2867: jl_co_gl_trx jlcgt
2868: WHERE process_id = p_rcid
2869: AND jlcgt.code_combination_id = glcc.code_combination_id
2870: GROUP BY jlcgt.set_of_books_id,
2871: jlcgt.nit_id,

Line 2923: -- in jl_co_gl_trx and jl_co_gl_balances for that NIT

2919: -- After the update if the period_net_dr and cr amounts are 0
2920: -- delete the balance record so that one would be able to delete
2921: -- an invalid NIT via the Define Third Party form.
2922: -- The form does not let you delete a NIT if there are records
2923: -- in jl_co_gl_trx and jl_co_gl_balances for that NIT
2924:
2925: /* Bug 8339893: Irrespective of balances being ZERO or not, if there are
2926: * NO records in table JL_CO_GL_TRX for same SOB, NIT, CCID and PERIOD NEITHER
2927: * for OTHER PROCESS_ID, then we can safely delete balances for SAME SOB,

Line 2926: * NO records in table JL_CO_GL_TRX for same SOB, NIT, CCID and PERIOD NEITHER

2922: -- The form does not let you delete a NIT if there are records
2923: -- in jl_co_gl_trx and jl_co_gl_balances for that NIT
2924:
2925: /* Bug 8339893: Irrespective of balances being ZERO or not, if there are
2926: * NO records in table JL_CO_GL_TRX for same SOB, NIT, CCID and PERIOD NEITHER
2927: * for OTHER PROCESS_ID, then we can safely delete balances for SAME SOB,
2928: * NIT, CCID and PERIOD since this cursor already grouped this info for
2929: * current PROCESS_ID, meaning there are NO other TRXs using such balance */
2930:

Line 2937: AND NOT EXISTS (SELECT 1 FROM jl_co_gl_trx jlcgt

2933: AND jlcgb.nit_id = trx.nitid
2934: AND jlcgb.code_combination_id = trx.ccid
2935: AND jlcgb.period_name = trx.period_name
2936: -- bug 8339893 AND jlcgb.period_net_dr = 0 AND jlcgb.period_net_cr = 0
2937: AND NOT EXISTS (SELECT 1 FROM jl_co_gl_trx jlcgt
2938: WHERE jlcgt.nit_id = trx.nitid
2939: AND jlcgt.code_combination_id = trx.ccid
2940: AND jlcgt.period_name = trx.period_name
2941: AND jlcgt.set_of_books_id = trx.sobid

Line 2953: FROM jl_co_gl_trx jlcgt

2949: SET co_processed_flag = 'N'
2950: WHERE co_processed_flag = 'Y'
2951: AND status = 'P'
2952: AND EXISTS (SELECT 1
2953: FROM jl_co_gl_trx jlcgt
2954: WHERE jlcgt.process_id = p_rcid
2955: AND jlcgt.je_header_id = gljl.je_header_id
2956: AND jlcgt.je_line_num = gljl.je_line_num );
2957:

Line 2958: DELETE FROM jl_co_gl_trx

2954: WHERE jlcgt.process_id = p_rcid
2955: AND jlcgt.je_header_id = gljl.je_header_id
2956: AND jlcgt.je_line_num = gljl.je_line_num );
2957:
2958: DELETE FROM jl_co_gl_trx
2959: WHERE process_id = p_rcid ;
2960:
2961: UPDATE jl_co_gl_conc_ctrl
2962: SET status = 'P',

Line 3250: INSERT INTO jl_co_gl_trx(

3246: -- Insert Reversed Journals
3247: l_rows := nvl(reverse_rec_tbl.last,0);
3248: FOR j_line IN 1..l_rows
3249: LOOP
3250: INSERT INTO jl_co_gl_trx(
3251: transaction_id,
3252: process_id,
3253: set_of_books_id,
3254: code_combination_id,

Line 3277: (SELECT jl_co_gl_trx_s.nextval,

3273: accounted_dr,
3274: accounted_cr,
3275: entered_dr,
3276: entered_cr)
3277: (SELECT jl_co_gl_trx_s.nextval,
3278: g_parameter_rec.cid,
3279: g_parameter_rec.set_of_books_id,
3280: reverse_rec_tbl(j_line).code_combination_id,
3281: reverse_rec_tbl(j_line).account_code,

Line 3305: FROM jl_co_gl_trx jlcgt

3301: reverse_rec_tbl(j_line).accounted_cr,
3302: reverse_rec_tbl(j_line).entered_dr,
3303: reverse_rec_tbl(j_line).entered_cr
3304: -- Bug 9441034 Start
3305: FROM jl_co_gl_trx jlcgt
3306: WHERE jlcgt.je_header_id
3307: = reverse_rec_tbl(j_line).reversed_je_header_id
3308: AND jlcgt.je_line_num
3309: = reverse_rec_tbl(j_line).je_line_num );

Line 3320: FROM jl_co_gl_trx jlcgt

3316: SET co_processed_flag = 'Y'
3317: WHERE gljl.je_header_id = reverse_rec_tbl(j_line).je_header_id
3318: AND gljl.je_line_num = reverse_rec_tbl(j_line).je_line_num
3319: AND EXISTS (SELECT 'Y'
3320: FROM jl_co_gl_trx jlcgt
3321: WHERE jlcgt.je_header_id = gljl.je_header_id
3322: AND jlcgt.je_line_num = gljl.je_line_num);
3323: --bug 8845393 Ends
3324: