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 118: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%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);
121:
122: g_jl_trx jl_co_gl_trx%ROWTYPE;

Line 119: je_line_num jl_co_gl_trx.je_line_num%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);
121:
122: g_jl_trx jl_co_gl_trx%ROWTYPE;
123: g_journal_rec journals%ROWTYPE;

Line 122: g_jl_trx jl_co_gl_trx%ROWTYPE;

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;
125: g_nit_rec t_nits;
126: g_gl_je_rec t_gl_je;

Line 450: INSERT INTO jl_co_gl_trx (transaction_id,

446: Insert_Error_Rec(l_message_text);
447:
448: END IF;
449:
450: INSERT INTO jl_co_gl_trx (transaction_id,
451: process_id,
452: set_of_books_id,
453: code_combination_id,
454: account_code,

Line 476: VALUES (jl_co_gl_trx_s.nextval,

472: accounted_dr,
473: accounted_cr,
474: entered_dr,
475: entered_cr)
476: VALUES (jl_co_gl_trx_s.nextval,
477: g_parameter_rec.cid,
478: g_parameter_rec.set_of_books_id,
479: p_journal_rec.code_combination_id,
480: p_journal_rec.account_code,

Line 538: DELETE FROM jl_co_gl_trx jlcgt

534: NULL;
535: END;
536:
537: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
538: DELETE FROM jl_co_gl_trx jlcgt
539: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
540: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
541: ELSE
542: UPDATE gl_je_lines gljl

Line 547: FROM jl_co_gl_trx jlcgt

543: SET co_processed_flag = 'Y'
544: WHERE gljl.je_header_id = p_journal_rec.je_header_id
545: AND gljl.je_line_num = p_journal_rec.je_line_num
546: AND EXISTS (SELECT 'Y'
547: FROM jl_co_gl_trx jlcgt
548: WHERE jlcgt.je_header_id = gljl.je_header_id
549: AND jlcgt.je_line_num = gljl.je_line_num);
550: END IF;
551: */

Line 852: INSERT INTO jl_co_gl_trx (transaction_id,

848: FND_FILE.PUT_LINE(FND_FILE.log,'AP : acc_dr, acc_cr,ent_dr, ent_dr : '
849: ||to_char(ap_trx.accounted_dr)||'-'||to_char(ap_trx.accounted_cr)
850: ||'-'||to_char(ap_trx.entered_dr)||'-'||to_char(ap_trx.entered_cr));
851:
852: INSERT INTO jl_co_gl_trx (transaction_id,
853: process_id,
854: set_of_books_id,
855: code_combination_id,
856: account_code,

Line 878: VALUES (jl_co_gl_trx_s.nextval,

874: accounted_dr,
875: accounted_cr,
876: entered_dr,
877: entered_cr)
878: VALUES (jl_co_gl_trx_s.nextval,
879: g_parameter_rec.cid,
880: g_parameter_rec.set_of_books_id,
881: p_journal_rec.code_combination_id,
882: p_journal_rec.account_code,

Line 930: DELETE FROM jl_co_gl_trx jlcgt

926: NULL;
927: END;
928:
929: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
930: DELETE FROM jl_co_gl_trx jlcgt
931: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
932: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
933:
934: ELSE

Line 940: FROM jl_co_gl_trx jlcgt

936: SET co_processed_flag = 'Y'
937: WHERE gljl.je_header_id = p_journal_rec.je_header_id
938: AND gljl.je_line_num = p_journal_rec.je_line_num
939: AND EXISTS (SELECT 'Y'
940: FROM jl_co_gl_trx jlcgt
941: WHERE jlcgt.je_header_id = gljl.je_header_id
942: AND jlcgt.je_line_num = gljl.je_line_num);
943:
944: END IF;

Line 970: FROM jl_co_gl_trx jlcgt

966: SET co_processed_flag = NULL
967: WHERE gljl.je_header_id = p_journal_rec.je_header_id
968: AND gljl.je_line_num = p_journal_rec.je_line_num
969: AND EXISTS (SELECT 'Y'
970: FROM jl_co_gl_trx jlcgt
971: WHERE jlcgt.je_header_id = gljl.je_header_id
972: AND jlcgt.je_line_num = gljl.je_line_num);
973:
974: DELETE FROM jl_co_gl_trx jlcgt

Line 974: DELETE FROM jl_co_gl_trx jlcgt

970: FROM jl_co_gl_trx jlcgt
971: WHERE jlcgt.je_header_id = gljl.je_header_id
972: AND jlcgt.je_line_num = gljl.je_line_num);
973:
974: DELETE FROM jl_co_gl_trx jlcgt
975: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
976: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
977: END IF;
978:

Line 1040: INSERT INTO jl_co_gl_trx (transaction_id,

1036: AND REPLACE(povapf.num_1099,'-') = jlcgn.nit(+);
1037:
1038: IF Validate_NIT(g_nit_rec, 'JL_CO_GL_SUPPLIER') THEN
1039:
1040: INSERT INTO jl_co_gl_trx (transaction_id,
1041: process_id,
1042: set_of_books_id,
1043: code_combination_id,
1044: account_code,

Line 1066: VALUES (jl_co_gl_trx_s.nextval,

1062: accounted_dr,
1063: accounted_cr,
1064: entered_dr,
1065: entered_cr )
1066: VALUES (jl_co_gl_trx_s.nextval,
1067: g_parameter_rec.cid,
1068: g_parameter_rec.set_of_books_id,
1069: p_journal_rec.code_combination_id,
1070: p_journal_rec.account_code,

Line 1129: DELETE FROM jl_co_gl_trx jlcgt

1125: NULL;
1126: END;
1127:
1128: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
1129: DELETE FROM jl_co_gl_trx jlcgt
1130: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1131: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1132: ELSE
1133: UPDATE gl_je_lines gljl

Line 1138: FROM jl_co_gl_trx jlcgt

1134: SET co_processed_flag = 'Y'
1135: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1136: AND gljl.je_line_num = p_journal_rec.je_line_num
1137: AND EXISTS (SELECT 'Y'
1138: FROM jl_co_gl_trx jlcgt
1139: WHERE jlcgt.je_header_id = gljl.je_header_id
1140: AND jlcgt.je_line_num = gljl.je_line_num);
1141:
1142: END IF;

Line 1361: INSERT INTO jl_co_gl_trx (transaction_id,

1357:
1358: IF Validate_NIT(g_nit_rec,l_identifier_type) THEN
1359: FND_FILE.PUT_LINE(FND_FILE.log,'After Validate :'||g_gl_je_rec.identifier);
1360:
1361: INSERT INTO jl_co_gl_trx (transaction_id,
1362: process_id,
1363: set_of_books_id,
1364: code_combination_id,
1365: account_code,

Line 1387: VALUES (jl_co_gl_trx_s.nextval,

1383: accounted_dr,
1384: accounted_cr,
1385: entered_dr,
1386: entered_cr)
1387: VALUES (jl_co_gl_trx_s.nextval,
1388: g_parameter_rec.cid,
1389: g_parameter_rec.set_of_books_id,
1390: p_journal_rec.code_combination_id,
1391: p_journal_rec.account_code,

Line 1432: DELETE FROM jl_co_gl_trx jlcgt

1428: NULL;
1429: END;
1430:
1431: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
1432: DELETE FROM jl_co_gl_trx jlcgt
1433: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1434: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1435: ELSE
1436: UPDATE gl_je_lines gljl

Line 1441: FROM jl_co_gl_trx jlcgt

1437: SET co_processed_flag = 'Y'
1438: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1439: AND gljl.je_line_num = p_journal_rec.je_line_num
1440: AND EXISTS (SELECT 'Y'
1441: FROM jl_co_gl_trx jlcgt
1442: WHERE jlcgt.je_header_id = gljl.je_header_id
1443: AND jlcgt.je_line_num = gljl.je_line_num);
1444:
1445: END IF;

Line 1476: FROM jl_co_gl_trx jlcgt

1472: SET co_processed_flag = NULL
1473: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1474: AND gljl.je_line_num = p_journal_rec.je_line_num
1475: AND EXISTS (SELECT 'Y'
1476: FROM jl_co_gl_trx jlcgt
1477: WHERE jlcgt.je_header_id = gljl.je_header_id
1478: AND jlcgt.je_line_num = gljl.je_line_num);
1479:
1480: DELETE FROM jl_co_gl_trx jlcgt

Line 1480: DELETE FROM jl_co_gl_trx jlcgt

1476: FROM jl_co_gl_trx jlcgt
1477: WHERE jlcgt.je_header_id = gljl.je_header_id
1478: AND jlcgt.je_line_num = gljl.je_line_num);
1479:
1480: DELETE FROM jl_co_gl_trx jlcgt
1481: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1482: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1483: END IF;
1484:

Line 1539: INSERT INTO jl_co_gl_trx (transaction_id,

1535: -- with the interfaced records */
1536: g_nit_rec.nit_id := g_default_nit_id;
1537: END IF;
1538:
1539: INSERT INTO jl_co_gl_trx (transaction_id,
1540: process_id,
1541: set_of_books_id,
1542: code_combination_id,
1543: account_code,

Line 1565: VALUES (jl_co_gl_trx_s.nextval,

1561: accounted_dr,
1562: accounted_cr,
1563: entered_dr,
1564: entered_cr)
1565: VALUES (jl_co_gl_trx_s.nextval,
1566: g_parameter_rec.cid,
1567: g_parameter_rec.set_of_books_id,
1568: p_journal_rec.code_combination_id,
1569: p_journal_rec.account_code,

Line 1630: DELETE FROM jl_co_gl_trx jlcgt

1626: NULL;
1627: END;
1628:
1629: IF NVL(g_error_exists,'FALSE') = 'TRUE' THEN
1630: DELETE FROM jl_co_gl_trx jlcgt
1631: WHERE jlcgt.je_header_id = p_journal_rec.je_header_id
1632: AND jlcgt.je_line_num = p_journal_rec.je_line_num;
1633: ELSE
1634: UPDATE gl_je_lines gljl

Line 1639: FROM jl_co_gl_trx jlcgt

1635: SET co_processed_flag = 'Y'
1636: WHERE gljl.je_header_id = p_journal_rec.je_header_id
1637: AND gljl.je_line_num = p_journal_rec.je_line_num
1638: AND EXISTS (SELECT 'Y'
1639: FROM jl_co_gl_trx jlcgt
1640: WHERE jlcgt.je_header_id = gljl.je_header_id
1641: AND jlcgt.je_line_num = gljl.je_line_num);
1642:
1643: END IF;

Line 1781: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt

1777: jlcgt.period_num pernum,
1778: glcc.account_type acctype,
1779: NVL(sum(jlcgt.accounted_dr),0) acc_dr,
1780: NVL(sum(jlcgt.accounted_cr),0) acc_cr
1781: FROM gl_code_combinations glcc, jl_co_gl_trx jlcgt
1782: WHERE jlcgt.process_id IN ( SELECT process_id
1783: FROM jl_co_gl_conc_ctrl
1784: WHERE NVL(balance_calculated,'N') <> 'Y'
1785: AND set_of_books_id

Line 2007: jl_co_gl_trx jlcgt

2003: glcc.account_type acctype,
2004: NVL(sum(jlcgt.accounted_dr),0) acc_dr,
2005: NVL(sum(jlcgt.accounted_cr),0) acc_cr
2006: FROM gl_code_combinations glcc,
2007: jl_co_gl_trx jlcgt
2008: WHERE process_id = p_rcid
2009: AND jlcgt.code_combination_id = glcc.code_combination_id
2010: GROUP BY jlcgt.set_of_books_id,
2011: jlcgt.nit_id,

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

2059: -- After the update if the period_net_dr and cr amounts are 0
2060: -- delete the balance record so that one would be able to delete
2061: -- an invalid NIT via the Define Third Party form.
2062: -- The form does not let you delete a NIT if there are records
2063: -- in jl_co_gl_trx and jl_co_gl_balances for that NIT
2064:
2065: DELETE FROM jl_co_gl_balances jlcgb
2066: WHERE jlcgb.set_of_books_id = trx.sobid
2067: AND jlcgb.nit_id = trx.nitid

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

2067: AND jlcgb.nit_id = trx.nitid
2068: AND jlcgb.code_combination_id = trx.ccid
2069: AND jlcgb.period_name = trx.period_name
2070: AND jlcgb.period_net_dr = 0 AND jlcgb.period_net_cr = 0
2071: AND NOT EXISTS (SELECT 1 FROM jl_co_gl_trx jlcgt
2072: WHERE jlcgt.nit_id = trx.nitid
2073: AND jlcgt.code_combination_id = trx.ccid
2074: AND jlcgt.period_name = trx.period_name
2075: AND jlcgt.set_of_books_id = trx.sobid);

Line 2086: FROM jl_co_gl_trx jlcgt

2082: SET co_processed_flag = 'N'
2083: WHERE co_processed_flag = 'Y'
2084: AND status = 'P'
2085: AND EXISTS (SELECT 1
2086: FROM jl_co_gl_trx jlcgt
2087: WHERE jlcgt.process_id = p_rcid
2088: AND jlcgt.je_header_id = gljl.je_header_id
2089: AND jlcgt.je_line_num = gljl.je_line_num );
2090:

Line 2091: DELETE FROM jl_co_gl_trx

2087: WHERE jlcgt.process_id = p_rcid
2088: AND jlcgt.je_header_id = gljl.je_header_id
2089: AND jlcgt.je_line_num = gljl.je_line_num );
2090:
2091: DELETE FROM jl_co_gl_trx
2092: WHERE process_id = p_rcid ;
2093:
2094: UPDATE jl_co_gl_conc_ctrl
2095: SET status = 'P',

Line 2329: INSERT INTO jl_co_gl_trx(

2325: -- Insert Reversed Journals
2326: l_rows := nvl(reverse_rec_tbl.last,0);
2327: FOR j_line IN 1..l_rows
2328: LOOP
2329: INSERT INTO jl_co_gl_trx(
2330: transaction_id,
2331: process_id,
2332: set_of_books_id,
2333: code_combination_id,

Line 2356: (SELECT jl_co_gl_trx_s.nextval,

2352: accounted_dr,
2353: accounted_cr,
2354: entered_dr,
2355: entered_cr)
2356: (SELECT jl_co_gl_trx_s.nextval,
2357: g_parameter_rec.cid,
2358: g_parameter_rec.set_of_books_id,
2359: reverse_rec_tbl(j_line).code_combination_id,
2360: reverse_rec_tbl(j_line).account_code,

Line 2382: FROM jl_co_gl_trx jlcgt

2378: jlcgt.accounted_cr,
2379: jlcgt.accounted_dr,
2380: jlcgt.entered_cr,
2381: jlcgt.entered_dr
2382: FROM jl_co_gl_trx jlcgt
2383: WHERE jlcgt.je_header_id
2384: = reverse_rec_tbl(j_line).reversed_je_header_id
2385: AND jlcgt.je_line_num
2386: = reverse_rec_tbl(j_line).je_line_num );