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 716: UPDATE ar_late_charge_doc_gt

712: iv_create_flag := 'Y';
713: END IF;
714:
715:
716: UPDATE ar_late_charge_doc_gt
717: SET execution_status = 'R' --Ready
718: WHERE interest_header_id = iv_curr_header_id;
719:
720: log( message => 'The interest header with the interest_header_id:'||iv_curr_header_id||' is ready for process');

Line 770: FROM ar_late_charge_doc_gt a

766: SELECT a.interest_line_id,
767: --{HYU update late_charge_Date
768: a.payment_schedule_id
769: --}
770: FROM ar_late_charge_doc_gt a
771: WHERE a.interest_batch_id = g_interest_batch_id
772: AND a.execution_status = 'R'
773: AND NOT EXISTS
774: (SELECT NULL

Line 775: FROM ar_late_charge_doc_gt b

771: WHERE a.interest_batch_id = g_interest_batch_id
772: AND a.execution_status = 'R'
773: AND NOT EXISTS
774: (SELECT NULL
775: FROM ar_late_charge_doc_gt b
776: WHERE b.interest_header_id = a.interest_header_id
777: AND b.interest_batch_id = g_interest_batch_id
778: AND b.execution_status = 'E');
779:

Line 887: UPDATE ar_late_charge_doc_gt

883:
884: IF l_header_upg.COUNT > 0 THEN
885:
886: FORALL i IN l_header_upg.FIRST..l_header_upg.LAST
887: UPDATE ar_late_charge_doc_gt
888: SET execution_status = 'E',
889: hdr_err_msg = l_header_text(i)
890: WHERE interest_header_id = l_header_upg(i)
891: AND interest_batch_id = g_interest_batch_id;

Line 944: UPDATE ar_late_charge_doc_gt

940:
941: IF l_line_upg.COUNT >0 THEN
942:
943: FORALL i IN l_line_upg.FIRST..l_line_upg.LAST
944: UPDATE ar_late_charge_doc_gt
945: SET execution_status = 'E',
946: line_err_msg = l_line_text(i)
947: WHERE interest_line_id = l_line_upg(i);
948:

Line 963: UPDATE ar_late_charge_doc_gt

959: CLOSE c_s;
960:
961: IF l_sucess_line_id.COUNT > 0 THEN
962: FORALL i IN l_sucess_line_id.FIRST..l_sucess_line_id.LAST
963: UPDATE ar_late_charge_doc_gt
964: SET execution_status = 'S'
965: WHERE execution_status = 'R'
966: AND interest_batch_id = g_interest_batch_id
967: AND interest_line_id = l_sucess_line_id(i);

Line 1071: FROM ar_late_charge_doc_gt

1067: l_sp csp%ROWTYPE;
1068:
1069: CURSOR c IS
1070: SELECT NULL
1071: FROM ar_late_charge_doc_gt
1072: WHERE interest_batch_id = g_interest_batch_id
1073: AND header_type IN ('INV','DM')
1074: AND NVL(p_worker_num,-9) = NVL(worker_num, -9)
1075: AND execution_status = 'I';

Line 1082: INSERT INTO ar_late_charge_doc_gt

1078: log( message => 'get_the_row_to_process +');
1079: OPEN csp;
1080: FETCH csp INTO l_sp;
1081: CLOSE csp;
1082: INSERT INTO ar_late_charge_doc_gt
1083: (interest_header_id ,
1084: CURRENCY_CODE ,
1085: HEADER_TYPE ,
1086: cust_trx_type_id ,

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

1166: ORDER BY h.INTEREST_HEADER_ID,
1167: l.interest_line_id;
1168:
1169:
1170: --INSERT INTO hy_late_charge_doc_gt select * from ar_late_charge_doc_gt;
1171:
1172: OPEN c;
1173: FETCH c INTO lf;
1174: IF c%FOUND THEN

Line 1190: FROM ar_late_charge_doc_gt

1186: (x_nb_row_ready OUT NOCOPY NUMBER)
1187: IS
1188: CURSOR c IS
1189: SELECT COUNT(*)
1190: FROM ar_late_charge_doc_gt
1191: WHERE execution_status = 'R'
1192: AND interest_batch_id = g_interest_batch_id;
1193: BEGIN
1194: log( message => 'get_nb_row_ready +');

Line 1213: FROM ar_late_charge_doc_gt

1209: p_worker_num IN NUMBER DEFAULT NULL)
1210: IS
1211: CURSOR nb_headers IS
1212: SELECT DISTINCT interest_header_id
1213: FROM ar_late_charge_doc_gt
1214: WHERE execution_status = 'I'
1215: AND interest_batch_id = g_interest_batch_id
1216: AND NVL(p_worker_num,-9) = NVL(worker_num,-9)
1217: AND header_type IN ('INV','DM');

Line 1271: FROM ar_late_charge_doc_gt lgt,

1267: lgt.INTEREST_RATE ,
1268: lgt.gl_id_rev,
1269: su.contact_id,
1270: su.cust_acct_site_id
1271: FROM ar_late_charge_doc_gt lgt,
1272: hz_cust_site_uses_all su
1273: WHERE interest_header_id = p_header_id
1274: AND interest_batch_id = g_interest_batch_id
1275: AND execution_status = p_exec_status

Line 1517: FROM ar_late_charge_doc_gt

1513: AND display_flag = 'Y' --HYU CDI only document generating the Late Charge s Doc
1514: AND DECODE(p_worker_num,NULL,NVL(worker_num,-9),p_worker_num)=NVL(worker_num,-9)
1515: AND interest_header_id IN
1516: (SELECT MAX(interest_header_id)
1517: FROM ar_late_charge_doc_gt
1518: WHERE interest_batch_id = g_interest_batch_id
1519: AND execution_status = 'S'
1520: AND NVL(p_worker_num,-9)= NVL(worker_num,-9)
1521: AND header_type IN ('INV','DM')

Line 1587: SELECT COUNT(*) FROM ar_late_charge_doc_gt

1583: FROM ar_system_parameters;
1584: l_sp csp%ROWTYPE;
1585:
1586: CURSOR c IS
1587: SELECT COUNT(*) FROM ar_late_charge_doc_gt
1588: WHERE interest_batch_id = g_interest_batch_id
1589: AND NVL(p_worker_num,-9) = NVL(p_worker_num,worker_num)
1590: AND execution_status = 'I'
1591: AND header_type = 'ADJ';

Line 1598: INSERT INTO ar_late_charge_doc_gt

1594: OPEN csp;
1595: FETCH csp INTO l_sp;
1596: CLOSE csp;
1597:
1598: INSERT INTO ar_late_charge_doc_gt
1599: ( INTEREST_CHARGED,
1600: PAYMENT_SCHEDULE_ID,
1601: TYPE,
1602: ORIGINAL_TRX_ID,

Line 1684: FROM ar_late_charge_doc_gt

1680: receivables_trx_id,
1681: receivables_trx_name,
1682: g_interest_batch_id,
1683: worker_num
1684: FROM ar_late_charge_doc_gt
1685: WHERE interest_batch_id = g_interest_batch_id
1686: AND header_type = 'ADJ'
1687: AND execution_status = 'I'
1688: AND NVL(p_worker_num,-9) = NVL(worker_num,-9);

Line 1904: UPDATE ar_late_charge_doc_gt

1900: --}
1901:
1902: IF l_interest_line_id.COUNT > 0 THEN
1903: FORALL i IN l_interest_line_id.FIRST .. l_interest_line_id.LAST
1904: UPDATE ar_late_charge_doc_gt
1905: SET execution_status = l_process_status(i),
1906: LINE_ERR_MSG = l_process_msg(i)
1907: WHERE interest_line_id = l_interest_line_id(i)
1908: AND interest_batch_id = g_interest_batch_id;

Line 2013: FROM ar_late_charge_doc_gt

2009: SELECT count(*) nb,
2010: execution_status status
2011: FROM (select interest_header_id interest_header_id,
2012: MIN(execution_status) execution_status
2013: FROM ar_late_charge_doc_gt
2014: WHERE interest_batch_id = g_interest_batch_id
2015: AND header_type = 'INV'
2016: AND execution_status IN ('E','S')
2017: GROUP BY interest_header_id) b

Line 2026: FROM ar_late_charge_doc_gt

2022: SELECT count(*) nb,
2023: execution_status status
2024: FROM (select interest_header_id interest_header_id,
2025: MIN(execution_status) execution_status
2026: FROM ar_late_charge_doc_gt
2027: WHERE interest_batch_id = g_interest_batch_id
2028: AND header_type = 'DM'
2029: AND execution_status IN ('E','S')
2030: GROUP BY interest_header_id) b

Line 2037: FROM ar_late_charge_doc_gt

2033:
2034: CURSOR nb_of_adjustment IS
2035: SELECT count(*) nb,
2036: execution_status status
2037: FROM ar_late_charge_doc_gt
2038: WHERE interest_batch_id = g_interest_batch_id
2039: AND header_type = 'ADJ'
2040: GROUP BY execution_status;
2041: l_count DBMS_SQL.NUMBER_TABLE;

Line 2168: DELETE FROM ar_late_charge_doc_gt;

2164:
2165: BEGIN
2166: log('create_late_charge +');
2167:
2168: DELETE FROM ar_late_charge_doc_gt;
2169:
2170: UPDATE ar_interest_headers a
2171: SET a.process_message = ''
2172: WHERE a.interest_batch_id = p_batch_id

Line 2791: DELETE FROM ar_late_charge_doc_gt;

2787: outandlog( message =>' p_gl_date :'||p_gl_date);
2788: outandlog( message =>' p_api_bulk_size :'||p_api_bulk_size);
2789:
2790:
2791: DELETE FROM ar_late_charge_doc_gt;
2792:
2793: UPDATE ar_interest_headers a
2794: SET a.process_message = ''
2795: WHERE a.interest_batch_id = p_batch_id