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.AR_LATE_CHARGE_PKG dependencies on AR_LATE_CHARGE_DOC_GT

Line 693: UPDATE ar_late_charge_doc_gt

689: iv_create_flag := 'Y';
690: END IF;
691:
692:
693: UPDATE ar_late_charge_doc_gt
694: SET execution_status = 'R' --Ready
695: WHERE interest_header_id = iv_curr_header_id;
696:
697: log( message => 'The interest header with the interest_header_id:'||iv_curr_header_id||' is ready for process');

Line 747: FROM ar_late_charge_doc_gt a

743: SELECT a.interest_line_id,
744: --{HYU update late_charge_Date
745: a.payment_schedule_id
746: --}
747: FROM ar_late_charge_doc_gt a
748: WHERE a.interest_batch_id = g_interest_batch_id
749: AND a.execution_status = 'R'
750: AND NOT EXISTS
751: (SELECT NULL

Line 752: FROM ar_late_charge_doc_gt b

748: WHERE a.interest_batch_id = g_interest_batch_id
749: AND a.execution_status = 'R'
750: AND NOT EXISTS
751: (SELECT NULL
752: FROM ar_late_charge_doc_gt b
753: WHERE b.interest_header_id = a.interest_header_id
754: AND b.interest_batch_id = g_interest_batch_id
755: AND b.execution_status = 'E');
756:

Line 863: UPDATE ar_late_charge_doc_gt

859:
860: IF l_header_upg.COUNT > 0 THEN
861:
862: FORALL i IN l_header_upg.FIRST..l_header_upg.LAST
863: UPDATE ar_late_charge_doc_gt
864: SET execution_status = 'E',
865: hdr_err_msg = l_header_text(i)
866: WHERE interest_header_id = l_header_upg(i)
867: AND interest_batch_id = g_interest_batch_id;

Line 920: UPDATE ar_late_charge_doc_gt

916:
917: IF l_line_upg.COUNT >0 THEN
918:
919: FORALL i IN l_line_upg.FIRST..l_line_upg.LAST
920: UPDATE ar_late_charge_doc_gt
921: SET execution_status = 'E',
922: line_err_msg = l_line_text(i)
923: WHERE interest_line_id = l_line_upg(i);
924:

Line 939: UPDATE ar_late_charge_doc_gt

935: CLOSE c_s;
936:
937: IF l_sucess_line_id.COUNT > 0 THEN
938: FORALL i IN l_sucess_line_id.FIRST..l_sucess_line_id.LAST
939: UPDATE ar_late_charge_doc_gt
940: SET execution_status = 'S'
941: WHERE execution_status = 'R'
942: AND interest_batch_id = g_interest_batch_id
943: AND interest_line_id = l_sucess_line_id(i);

Line 1043: FROM ar_late_charge_doc_gt

1039: l_sp csp%ROWTYPE;
1040:
1041: CURSOR c IS
1042: SELECT NULL
1043: FROM ar_late_charge_doc_gt
1044: WHERE interest_batch_id = g_interest_batch_id
1045: AND header_type IN ('INV','DM')
1046: AND NVL(p_worker_num,-9) = NVL(worker_num, -9)
1047: AND execution_status = 'I';

Line 1054: INSERT INTO ar_late_charge_doc_gt

1050: log( message => 'get_the_row_to_process +');
1051: OPEN csp;
1052: FETCH csp INTO l_sp;
1053: CLOSE csp;
1054: INSERT INTO ar_late_charge_doc_gt
1055: (interest_header_id ,
1056: CURRENCY_CODE ,
1057: HEADER_TYPE ,
1058: cust_trx_type_id ,

Line 1142: --INSERT INTO hy_late_charge_doc_gt select * from ar_late_charge_doc_gt;

1138: ORDER BY h.INTEREST_HEADER_ID,
1139: l.interest_line_id;
1140:
1141:
1142: --INSERT INTO hy_late_charge_doc_gt select * from ar_late_charge_doc_gt;
1143:
1144: OPEN c;
1145: FETCH c INTO lf;
1146: IF c%FOUND THEN

Line 1162: FROM ar_late_charge_doc_gt

1158: (x_nb_row_ready OUT NOCOPY NUMBER)
1159: IS
1160: CURSOR c IS
1161: SELECT COUNT(*)
1162: FROM ar_late_charge_doc_gt
1163: WHERE execution_status = 'R'
1164: AND interest_batch_id = g_interest_batch_id;
1165: BEGIN
1166: log( message => 'get_nb_row_ready +');

Line 1185: FROM ar_late_charge_doc_gt

1181: p_worker_num IN NUMBER DEFAULT NULL)
1182: IS
1183: CURSOR nb_headers IS
1184: SELECT DISTINCT interest_header_id
1185: FROM ar_late_charge_doc_gt
1186: WHERE execution_status = 'I'
1187: AND interest_batch_id = g_interest_batch_id
1188: AND NVL(p_worker_num,-9) = NVL(worker_num,-9)
1189: AND header_type IN ('INV','DM');

Line 1240: FROM ar_late_charge_doc_gt

1236: PAYMENT_DATE ,
1237: LAST_CHARGE_DATE ,
1238: INTEREST_RATE ,
1239: gl_id_rev
1240: FROM ar_late_charge_doc_gt
1241: WHERE interest_header_id = p_header_id
1242: AND interest_batch_id = g_interest_batch_id
1243: AND execution_status = p_exec_status
1244: AND header_type IN ('INV','DM');

Line 1482: FROM ar_late_charge_doc_gt

1478: AND display_flag = 'Y' --HYU CDI only document generating the Late Charge s Doc
1479: AND DECODE(p_worker_num,NULL,NVL(worker_num,-9),p_worker_num)=NVL(worker_num,-9)
1480: AND interest_header_id IN
1481: (SELECT MAX(interest_header_id)
1482: FROM ar_late_charge_doc_gt
1483: WHERE interest_batch_id = g_interest_batch_id
1484: AND execution_status = 'S'
1485: AND NVL(p_worker_num,-9)= NVL(worker_num,-9)
1486: AND header_type IN ('INV','DM')

Line 1552: SELECT COUNT(*) FROM ar_late_charge_doc_gt

1548: FROM ar_system_parameters;
1549: l_sp csp%ROWTYPE;
1550:
1551: CURSOR c IS
1552: SELECT COUNT(*) FROM ar_late_charge_doc_gt
1553: WHERE interest_batch_id = g_interest_batch_id
1554: AND NVL(p_worker_num,-9) = NVL(p_worker_num,worker_num)
1555: AND execution_status = 'I'
1556: AND header_type = 'ADJ';

Line 1563: INSERT INTO ar_late_charge_doc_gt

1559: OPEN csp;
1560: FETCH csp INTO l_sp;
1561: CLOSE csp;
1562:
1563: INSERT INTO ar_late_charge_doc_gt
1564: ( INTEREST_CHARGED,
1565: PAYMENT_SCHEDULE_ID,
1566: TYPE,
1567: ORIGINAL_TRX_ID,

Line 1644: FROM ar_late_charge_doc_gt

1640: receivables_trx_id,
1641: receivables_trx_name,
1642: g_interest_batch_id,
1643: worker_num
1644: FROM ar_late_charge_doc_gt
1645: WHERE interest_batch_id = g_interest_batch_id
1646: AND header_type = 'ADJ'
1647: AND execution_status = 'I'
1648: AND NVL(p_worker_num,-9) = NVL(worker_num,-9);

Line 1864: UPDATE ar_late_charge_doc_gt

1860: --}
1861:
1862: IF l_interest_line_id.COUNT > 0 THEN
1863: FORALL i IN l_interest_line_id.FIRST .. l_interest_line_id.LAST
1864: UPDATE ar_late_charge_doc_gt
1865: SET execution_status = l_process_status(i),
1866: LINE_ERR_MSG = l_process_msg(i)
1867: WHERE interest_line_id = l_interest_line_id(i)
1868: AND interest_batch_id = g_interest_batch_id;

Line 1973: FROM ar_late_charge_doc_gt

1969: SELECT count(*) nb,
1970: execution_status status
1971: FROM (select interest_header_id interest_header_id,
1972: MIN(execution_status) execution_status
1973: FROM ar_late_charge_doc_gt
1974: WHERE interest_batch_id = g_interest_batch_id
1975: AND header_type = 'INV'
1976: AND execution_status IN ('E','S')
1977: GROUP BY interest_header_id) b

Line 1986: FROM ar_late_charge_doc_gt

1982: SELECT count(*) nb,
1983: execution_status status
1984: FROM (select interest_header_id interest_header_id,
1985: MIN(execution_status) execution_status
1986: FROM ar_late_charge_doc_gt
1987: WHERE interest_batch_id = g_interest_batch_id
1988: AND header_type = 'DM'
1989: AND execution_status IN ('E','S')
1990: GROUP BY interest_header_id) b

Line 1997: FROM ar_late_charge_doc_gt

1993:
1994: CURSOR nb_of_adjustment IS
1995: SELECT count(*) nb,
1996: execution_status status
1997: FROM ar_late_charge_doc_gt
1998: WHERE interest_batch_id = g_interest_batch_id
1999: AND header_type = 'ADJ'
2000: GROUP BY execution_status;
2001: l_count DBMS_SQL.NUMBER_TABLE;

Line 2128: DELETE FROM ar_late_charge_doc_gt;

2124:
2125: BEGIN
2126: log('create_late_charge +');
2127:
2128: DELETE FROM ar_late_charge_doc_gt;
2129:
2130: UPDATE ar_interest_headers a
2131: SET a.process_message = ''
2132: WHERE a.interest_batch_id = p_batch_id

Line 2751: DELETE FROM ar_late_charge_doc_gt;

2747: outandlog( message =>' p_gl_date :'||p_gl_date);
2748: outandlog( message =>' p_api_bulk_size :'||p_api_bulk_size);
2749:
2750:
2751: DELETE FROM ar_late_charge_doc_gt;
2752:
2753: UPDATE ar_interest_headers a
2754: SET a.process_message = ''
2755: WHERE a.interest_batch_id = p_batch_id