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_UPGHARNESS_PKG dependencies on AR_SUBMISSION_CTRL_GT

Line 85: FROM ar_submission_ctrl_gt

81: PROCEDURE update_gl_period
82: IS
83: CURSOR c IS
84: SELECT 'Y'
85: FROM ar_submission_ctrl_gt
86: WHERE STATUS <> 'NORMAL';
87:
88: CURSOR update_gl_periods IS
89: SELECT application_id,

Line 188: FROM ar_submission_ctrl_gt

184: (p_batch_id IN NUMBER)
185: IS
186: CURSOR c_req IS
187: SELECT request_id
188: FROM ar_submission_ctrl_gt
189: WHERE batch_id = p_batch_id
190: AND status = 'SUBMITTED';
191: l_res BOOLEAN;
192: l_phase VARCHAR2(30);

Line 258: FROM ar_submission_ctrl_gt

254: table_name table_name,
255: worker_id worker_num,
256: order_num order_num,
257: rowid
258: FROM ar_submission_ctrl_gt
259: WHERE status = 'INSERTED'
260: AND batch_id = p_batch_id
261: ORDER BY order_num ASC;
262:

Line 266: FROM ar_submission_ctrl_gt

262:
263: -- Number of running workers
264: CURSOR c_run_workers IS
265: SELECT COUNT(*)
266: FROM ar_submission_ctrl_gt
267: WHERE status = 'SUBMITTED'
268: AND batch_id = p_batch_id;
269:
270: l_num_running_workers NUMBER;

Line 291: FROM ar_submission_ctrl_gt

287: IS
288: -- Get the max worker number submitted for all script
289: CURSOR c_max IS
290: SELECT MAX(worker_id) max_worker
291: FROM ar_submission_ctrl_gt
292: WHERE batch_id = p_batch_id
293: AND table_name = p_table_name
294: AND status <> 'INSERTED';
295: l_return NUMBER;

Line 349: UPDATE ar_submission_ctrl_gt

345: log('Error submitting request');
346: log(fnd_message.get);
347: l_prv_script_name := l_script_name;
348: l_prv_table_name := l_table_name;
349: UPDATE ar_submission_ctrl_gt
350: SET request_id = -9,
351: status = 'ABORTED'
352: WHERE rowid = l_rowid;
353: COMMIT;

Line 359: UPDATE ar_submission_ctrl_gt

355: outandlog('Submitted request ID : ' || l_req_id );
356: log('Request ID : ' || l_req_id);
357: l_prv_script_name := l_script_name;
358: l_prv_table_name := l_table_name;
359: UPDATE ar_submission_ctrl_gt
360: SET request_id = l_req_id,
361: status = 'SUBMITTED'
362: WHERE rowid = l_rowid;
363: COMMIT;

Line 386: log('updating ar_submission_ctrl_gt the process status to '||p_status||' for request_id '||p_request_id);

382: (p_request_id IN NUMBER
383: ,p_status IN VARCHAR2)
384: IS
385: BEGIN
386: log('updating ar_submission_ctrl_gt the process status to '||p_status||' for request_id '||p_request_id);
387: UPDATE ar_submission_ctrl_gt
388: SET status = p_status
389: WHERE request_id = p_request_id;
390: EXCEPTION

Line 387: UPDATE ar_submission_ctrl_gt

383: ,p_status IN VARCHAR2)
384: IS
385: BEGIN
386: log('updating ar_submission_ctrl_gt the process status to '||p_status||' for request_id '||p_request_id);
387: UPDATE ar_submission_ctrl_gt
388: SET status = p_status
389: WHERE request_id = p_request_id;
390: EXCEPTION
391: WHEN OTHERS THEN

Line 442: FROM ar_submission_ctrl_gt

438: l_ins_rec xla_upgrade_requests%ROWTYPE;
439:
440: CURSOR c_ord_num IS
441: SELECT order_num
442: FROM ar_submission_ctrl_gt
443: WHERE table_name = p_table_name
444: AND script_name = p_script_name
445: AND worker_id = p_worker_id;
446: l_ord_num NUMBER;

Line 951: INSERT INTO ar_submission_ctrl_gt

947: l_program_code := 'PSA_UPG';
948: l_phase := 5;
949: END IF;
950:
951: INSERT INTO ar_submission_ctrl_gt
952: (worker_id , --worker_number
953: batch_id , --batch_id
954: script_name , --script_name
955: status , --INSERTED, SUBMITTED, (NORMAL, ERROR, WARNING, CANCELLED, TERMINATED)

Line 1009: INSERT INTO ar_submission_ctrl_gt

1005: tab_table_name(i) := p_table_name;
1006: END LOOP;
1007:
1008: FORALL i IN tab_worker_number.FIRST .. tab_worker_number.LAST
1009: INSERT INTO ar_submission_ctrl_gt
1010: (worker_id , --worker_number
1011: batch_id , --batch_id
1012: script_name , --script_name
1013: status , --INSERTED, SUBMITTED, (NORMAL, ERROR, WARNING, CANCELLED, TERMINATED)

Line 1184: FROM ar_submission_ctrl_gt

1180: IS
1181: CURSOR c_req(p_batch_id IN NUMBER) IS
1182: SELECT status,
1183: request_id
1184: FROM ar_submission_ctrl_gt
1185: WHERE batch_id = p_batch_id
1186: AND status <> 'NORMAL';
1187: l_status VARCHAR2(30);
1188: l_request_id NUMBER;

Line 1228: FROM ar_submission_ctrl_gt

1224:
1225: CURSOR c(p_batch_id IN NUMBER)
1226: IS
1227: SELECT 'Y'
1228: FROM ar_submission_ctrl_gt
1229: WHERE status IN ('INSERTED','SUBMITTED')
1230: AND batch_id = p_batch_id;
1231:
1232:

Line 1548: DELETE FROM ar_submission_ctrl_gt;

1544: END IF;
1545:
1546: IF p_start_product = 'AR' THEN
1547:
1548: DELETE FROM ar_submission_ctrl_gt;
1549:
1550: l_current_product := 'GL';
1551:
1552: ar_master_upg_product

Line 1566: DELETE FROM ar_submission_ctrl_gt;

1562: IF x_return_status <> 'S' THEN
1563: RAISE stop_at_product;
1564: END IF;
1565:
1566: DELETE FROM ar_submission_ctrl_gt;
1567:
1568: l_current_product := 'MRC';
1569:
1570: ar_master_upg_product

Line 1586: DELETE FROM ar_submission_ctrl_gt;

1582: RAISE stop_at_product;
1583: END IF;
1584:
1585:
1586: DELETE FROM ar_submission_ctrl_gt;
1587:
1588: l_current_product := 'JL';
1589:
1590: ar_master_upg_product

Line 1605: DELETE FROM ar_submission_ctrl_gt;

1601: IF x_return_status <> 'S' THEN
1602: RAISE stop_at_product;
1603: END IF;
1604:
1605: DELETE FROM ar_submission_ctrl_gt;
1606:
1607: l_current_product := 'PSA';
1608:
1609: ar_master_upg_product

Line 1628: DELETE FROM ar_submission_ctrl_gt;

1624:
1625:
1626: ELSIF p_start_product = 'GL' THEN
1627:
1628: DELETE FROM ar_submission_ctrl_gt;
1629:
1630: l_current_product := 'MRC';
1631:
1632: ar_master_upg_product

Line 1648: DELETE FROM ar_submission_ctrl_gt;

1644: RAISE stop_at_product;
1645: END IF;
1646:
1647:
1648: DELETE FROM ar_submission_ctrl_gt;
1649:
1650: l_current_product := 'JL';
1651:
1652: ar_master_upg_product

Line 1667: DELETE FROM ar_submission_ctrl_gt;

1663: IF x_return_status <> 'S' THEN
1664: RAISE stop_at_product;
1665: END IF;
1666:
1667: DELETE FROM ar_submission_ctrl_gt;
1668:
1669: l_current_product := 'PSA';
1670:
1671: ar_master_upg_product

Line 1690: DELETE FROM ar_submission_ctrl_gt;

1686:
1687: ELSIF p_start_product = 'MRC' THEN
1688:
1689:
1690: DELETE FROM ar_submission_ctrl_gt;
1691:
1692: l_current_product := 'JL';
1693:
1694: ar_master_upg_product

Line 1709: DELETE FROM ar_submission_ctrl_gt;

1705: IF x_return_status <> 'S' THEN
1706: RAISE stop_at_product;
1707: END IF;
1708:
1709: DELETE FROM ar_submission_ctrl_gt;
1710:
1711: l_current_product := 'PSA';
1712:
1713: ar_master_upg_product

Line 1730: DELETE FROM ar_submission_ctrl_gt;

1726: END IF;
1727:
1728: ELSIF p_start_product = 'JL' THEN
1729:
1730: DELETE FROM ar_submission_ctrl_gt;
1731:
1732: l_current_product := 'PSA';
1733:
1734: ar_master_upg_product