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.PO_APPROVALLIST_S1 dependencies on PO_APPROVAL_LIST_LINES

Line 868: FROM po_approval_list_lines

864: status,
865: response_date,
866: mandatory_flag,
867: approver_type
868: FROM po_approval_list_lines
869: WHERE approval_list_header_id = p_approval_list_header_id
870: ORDER BY sequence_num;
871:
872: l_progress VARCHAR2(10) := '000';

Line 980: FROM po_approval_list_lines

976: p_error_stack OUT NOCOPY ErrorStackType) IS
977:
978: CURSOR c_lock_approval_list_lines(p_approval_list_header_id NUMBER) IS
979: SELECT approval_list_line_id
980: FROM po_approval_list_lines
981: WHERE approval_list_header_id = p_approval_list_header_id
982: FOR UPDATE NOWAIT;
983:
984: l_progress VARCHAR2(10) := '000';

Line 1161: INSERT INTO po_approval_list_lines (

1157: IF (p_approval_list_header_id IS NOT NULL) THEN
1158: BEGIN
1159: l_progress := '014';
1160:
1161: INSERT INTO po_approval_list_lines (
1162: approval_list_header_id,
1163: approval_list_line_id,
1164: next_element_id,
1165: approver_id,

Line 1183: po_approval_list_lines_s.nextval,

1179: last_update_login,
1180: last_updated_by,
1181: last_update_date)
1182: SELECT l_new_approval_list_header_id,
1183: po_approval_list_lines_s.nextval,
1184: NULL,
1185: approver_id,
1186: sequence_num,
1187: notification_id,

Line 1202: FROM po_approval_list_lines

1198: SYSDATE,
1199: fnd_global.login_id,
1200: fnd_global.user_id,
1201: SYSDATE
1202: FROM po_approval_list_lines
1203: WHERE approval_list_header_id = p_approval_list_header_id
1204: AND sequence_num <= l_old_current_sequence_num;
1205:
1206: EXCEPTION

Line 1223: INSERT INTO po_approval_list_lines (

1219: p_approval_list(l_index).sequence_num > NVL(l_old_current_sequence_num, 0)) THEN
1220:
1221: l_progress := '017.'||to_char(l_index);
1222:
1223: INSERT INTO po_approval_list_lines (
1224: approval_list_header_id,
1225: approval_list_line_id,
1226: next_element_id,
1227: approver_id,

Line 1245: po_approval_list_lines_s.nextval,

1241: last_update_login,
1242: last_updated_by,
1243: last_update_date)
1244: SELECT l_new_approval_list_header_id,
1245: po_approval_list_lines_s.nextval,
1246: NULL,
1247: p_approval_list(l_index).approver_id,
1248: p_approval_list(l_index).sequence_num,
1249: NULL,

Line 1320: FROM po_approval_list_lines

1316: p_approval_list_header_id OUT NOCOPY NUMBER) IS
1317:
1318: CURSOR c_lock_approval_list_lines(p_approval_list_header_id NUMBER) IS
1319: SELECT approval_list_line_id
1320: FROM po_approval_list_lines
1321: WHERE approval_list_header_id = p_approval_list_header_id
1322: FOR UPDATE;
1323:
1324: CURSOR c_find_last_forward_to(p_approval_list_header_id NUMBER,

Line 1328: FROM po_approval_list_lines

1324: CURSOR c_find_last_forward_to(p_approval_list_header_id NUMBER,
1325: p_current_sequence_num NUMBER) IS
1326: SELECT forward_to_id,
1327: sequence_num
1328: FROM po_approval_list_lines
1329: WHERE approval_list_header_id = p_approval_list_header_id
1330: AND forward_to_id IS NOT NULL
1331: AND sequence_num <= p_current_sequence_num
1332: ORDER BY sequence_num DESC;

Line 1339: FROM po_approval_list_lines

1335: p_current_sequence_num NUMBER) IS
1336: SELECT approver_id,
1337: sequence_num,
1338: approver_type
1339: FROM po_approval_list_lines
1340: WHERE approval_list_header_id = p_approval_list_header_id
1341: AND approver_type IN ('SYSTEM', 'FORWARD')
1342: AND sequence_num <= p_current_sequence_num
1343: AND approval_list_line_id <> (select min(l2.approval_list_line_id)

Line 1344: from po_approval_list_lines l2

1340: WHERE approval_list_header_id = p_approval_list_header_id
1341: AND approver_type IN ('SYSTEM', 'FORWARD')
1342: AND sequence_num <= p_current_sequence_num
1343: AND approval_list_line_id <> (select min(l2.approval_list_line_id)
1344: from po_approval_list_lines l2
1345: where l2.approval_list_header_id = p_approval_list_header_id)
1346: ORDER BY sequence_num DESC;
1347:
1348: CURSOR c_future_approver(p_approval_list_header_id NUMBER,

Line 1356: FROM po_approval_list_lines

1352: sequence_num,
1353: approver_type,
1354: status,
1355: mandatory_flag
1356: FROM po_approval_list_lines
1357: WHERE approval_list_header_id = p_approval_list_header_id
1358: AND sequence_num > NVL(p_current_sequence_num, 0)
1359: ORDER BY sequence_num;
1360:

Line 1502: FROM po_approval_list_lines

1498: l_progress := '003';
1499:
1500: SELECT forward_to_id
1501: INTO l_start_approver_id
1502: FROM po_approval_list_lines
1503: WHERE approval_list_header_id = l_old_approval_list_header_id1
1504: AND sequence_num = l_old_current_sequence_num;
1505:
1506: IF (l_start_approver_id IS NULL OR

Line 1529: UPDATE po_approval_list_lines

1525: p_error_stack=>p_error_stack,
1526: p_approval_list=>l_default_approval_list);
1527: IF (l_return_code <> E_SUCCESS) THEN
1528:
1529: UPDATE po_approval_list_lines
1530: SET sequence_num = sequence_num + 1
1531: WHERE sequence_num > l_old_current_sequence_num
1532: AND approval_list_header_id = l_old_approval_list_header_id1;
1533:

Line 1535: INSERT INTO po_approval_list_lines (

1531: WHERE sequence_num > l_old_current_sequence_num
1532: AND approval_list_header_id = l_old_approval_list_header_id1;
1533:
1534:
1535: INSERT INTO po_approval_list_lines (
1536: approval_list_header_id,
1537: approval_list_line_id,
1538: next_element_id,
1539: approver_id,

Line 1550: po_approval_list_lines_s.nextval,

1546: last_update_login,
1547: last_updated_by,
1548: last_update_date)
1549: SELECT l_old_approval_list_header_id1,
1550: po_approval_list_lines_s.nextval,
1551: NULL, -- next_element_id
1552: l_start_approver_id,
1553: l_old_current_sequence_num+1,
1554: 'N',

Line 1647: FROM po_approval_list_lines

1643: -- then build the list from preparer
1644: begin
1645: SELECT APPROVER_TYPE
1646: INTO l_first_approver_type
1647: FROM po_approval_list_lines
1648: WHERE APPROVAL_LIST_HEADER_ID = l_old_approval_list_header_id1
1649: AND SEQUENCE_NUM=1;
1650: exception
1651: when others then

Line 1717: FROM po_approval_list_lines

1713:
1714: -- remove user add/forward approvers in the future
1715: SELECT COUNT(*)
1716: INTO l_count
1717: FROM po_approval_list_lines
1718: WHERE approval_list_header_id = l_old_approval_list_header_id1
1719: AND approver_id = l_default_approval_list(l_index1).approver_id
1720: AND (sequence_num >= l_old_current_sequence_num AND approver_type <> 'SYSTEM' AND approver_type <> 'FORWARD');
1721:

Line 1730: FROM po_approval_list_lines

1726:
1727: ElSE
1728: SELECT COUNT(*)
1729: INTO l_count
1730: FROM po_approval_list_lines
1731: WHERE approval_list_header_id = l_old_approval_list_header_id1
1732: AND approver_id = l_default_approval_list(l_index1).approver_id
1733: AND ((sequence_num = l_old_current_sequence_num) OR
1734: (sequence_num >= l_old_current_sequence_num AND approver_type <> 'SYSTEM'));

Line 1737: -- Hence knock off preparer as he isnt present in po_approval_list_lines

1733: AND ((sequence_num = l_old_current_sequence_num) OR
1734: (sequence_num >= l_old_current_sequence_num AND approver_type <> 'SYSTEM'));
1735:
1736: --Bug:8793063 When rebuilded from preparer the list contains preparer also
1737: -- Hence knock off preparer as he isnt present in po_approval_list_lines
1738:
1739: IF ((l_count > 0) OR (l_default_approval_list(l_index1).approver_id=l_preparer_id)) THEN
1740: l_default_approval_list.DELETE(l_index1);
1741: RAISE L_CONTINUE_LOOP;

Line 1755: FROM po_approval_list_lines

1751: -- Find out whether or not the person has already responded
1752: l_progress := '009.'||to_char(l_index1);
1753: SELECT COUNT(*)
1754: INTO l_count
1755: FROM po_approval_list_lines
1756: WHERE approval_list_header_id = l_old_approval_list_header_id1
1757: AND approver_id = l_default_approval_list(l_index1).approver_id
1758: AND sequence_num <= l_old_current_sequence_num;
1759:

Line 1764: FROM po_approval_list_lines

1760: IF (l_count > 0) THEN
1761: l_progress := '010.'||to_char(l_index1);
1762: SELECT COUNT(*)
1763: INTO l_count
1764: FROM po_approval_list_lines
1765: WHERE approval_list_header_id = l_old_approval_list_header_id1
1766: AND approver_id = l_default_approval_list(l_index1).approver_id
1767: AND sequence_num <= l_old_current_sequence_num
1768: AND requires_reapproval_flag = 'Y';

Line 1779: FROM po_approval_list_lines

1775: -- then we remove him.
1776: l_progress := '011.'||to_char(l_index1);
1777: SELECT COUNT(*)
1778: INTO l_count
1779: FROM po_approval_list_lines
1780: WHERE approval_list_header_id = l_old_approval_list_header_id1
1781: AND approver_id = l_default_approval_list(l_index1).approver_id
1782: AND sequence_num <= l_old_current_sequence_num
1783: AND status in ('APPROVE', 'APPROVE_AND_FORWARD');

Line 1797: FROM po_approval_list_lines

1793: -- then we remove him.
1794:
1795: SELECT COUNT(*)
1796: INTO l_count
1797: FROM po_approval_list_lines
1798: WHERE approval_list_header_id = l_old_approval_list_header_id1
1799: AND approver_id = l_default_approval_list(l_index1).approver_id
1800: AND sequence_num <= l_old_current_sequence_num
1801: AND status in ('FORWARD');

Line 2024: INSERT INTO po_approval_list_lines (

2020:
2021: BEGIN
2022: l_progress := '019';
2023:
2024: INSERT INTO po_approval_list_lines (
2025: approval_list_header_id,
2026: approval_list_line_id,
2027: next_element_id,
2028: approver_id,

Line 2046: po_approval_list_lines_s.nextval,

2042: last_update_login,
2043: last_updated_by,
2044: last_update_date)
2045: SELECT l_new_approval_list_header_id,
2046: po_approval_list_lines_s.nextval,
2047: NULL, -- next_element_id
2048: approver_id,
2049: sequence_num,
2050: notification_id,

Line 2067: FROM po_approval_list_lines

2063: SYSDATE,
2064: fnd_global.login_id,
2065: fnd_global.user_id,
2066: SYSDATE
2067: FROM po_approval_list_lines
2068: WHERE approval_list_header_id = l_old_approval_list_header_id2
2069: AND sequence_num <= l_old_current_sequence_num;
2070:
2071: EXCEPTION

Line 2081: FROM po_approval_list_lines

2077: l_progress := '020';
2078:
2079: SELECT NVL(max(sequence_num), 0)
2080: INTO l_max_sequence_num
2081: FROM po_approval_list_lines
2082: WHERE approval_list_header_id = l_new_approval_list_header_id;
2083:
2084: IF (l_complete_approval_list.COUNT > 0) THEN
2085: l_index1 := l_complete_approval_list.FIRST;

Line 2098: INSERT INTO po_approval_list_lines (

2094: IF (l_complete_approval_list(l_index1).sequence_num > l_max_sequence_num) THEN
2095: l_max_sequence_num := l_complete_approval_list(l_index1).sequence_num;
2096: END IF;
2097: l_progress := '022.'||to_char(l_index1);
2098: INSERT INTO po_approval_list_lines (
2099: approval_list_header_id,
2100: approval_list_line_id,
2101: next_element_id,
2102: approver_id,

Line 2120: po_approval_list_lines_s.nextval,

2116: last_update_login,
2117: last_updated_by,
2118: last_update_date)
2119: SELECT l_new_approval_list_header_id,
2120: po_approval_list_lines_s.nextval,
2121: NULL, -- next_element_id
2122: l_complete_approval_list(l_index1).approver_id,
2123: l_complete_approval_list(l_index1).sequence_num,
2124: NULL, -- notification_id

Line 2311: FROM po_approval_list_lines

2307: p_approver_type OUT NOCOPY VARCHAR2) IS
2308:
2309: CURSOR c_lock_approval_list_lines(p_approval_list_header_id NUMBER) IS
2310: SELECT approval_list_line_id
2311: FROM po_approval_list_lines
2312: WHERE approval_list_header_id = p_approval_list_header_id
2313: FOR UPDATE;
2314:
2315: CURSOR c_find_next_approver(p_approval_list_header_id NUMBER,

Line 2320: FROM po_approval_list_lines

2316: p_current_sequence_num NUMBER) IS
2317: SELECT approver_id,
2318: sequence_num,
2319: approver_type
2320: FROM po_approval_list_lines
2321: WHERE approval_list_header_id = p_approval_list_header_id
2322: AND sequence_num > p_current_sequence_num
2323: ORDER BY sequence_num;
2324:

Line 2372: FROM po_approval_list_lines

2368: IF (l_old_current_sequence_num > 0 ) THEN
2369:
2370: SELECT approver_id
2371: INTO l_current_approver_id
2372: FROM po_approval_list_lines
2373: WHERE approval_list_header_id = l_old_approval_list_header_id
2374: AND sequence_num = l_old_current_sequence_num;
2375:
2376:

Line 2583: FROM po_approval_list_lines

2579: l_progress := '006';
2580:
2581: SELECT approval_list_line_id
2582: INTO l_approval_list_line_id
2583: FROM po_approval_list_lines
2584: WHERE approval_list_header_id = l_approval_list_header_id
2585: AND approver_id = p_approver_id
2586: AND sequence_num = l_current_sequence_num
2587: FOR UPDATE;

Line 2606: UPDATE po_approval_list_lines

2602: l_progress := '007';
2603:
2604: IF l_line_found THEN
2605:
2606: UPDATE po_approval_list_lines
2607: SET status = p_response,
2608: forward_to_id = p_forward_to_id,
2609: responder_id = p_responder_id,
2610: response_date = p_response_date,

Line 2627: INSERT INTO po_approval_list_lines (

2623: ELSE
2624:
2625: /* Bug 2092663: Add a new line if there is header but no line */
2626:
2627: INSERT INTO po_approval_list_lines (
2628: approval_list_header_id,
2629: approval_list_line_id,
2630: next_element_id,
2631: approver_id,

Line 2651: po_approval_list_lines_s.nextval,

2647: last_update_date)
2648: VALUES
2649: (
2650: l_approval_list_header_id,
2651: po_approval_list_lines_s.nextval,
2652: NULL,
2653: p_responder_id,
2654: 1,
2655: null,

Line 2727: FROM po_approval_list_lines

2723: l_progress := '002';
2724:
2725: SELECT COUNT(*)
2726: INTO l_count
2727: FROM po_approval_list_lines
2728: WHERE approval_list_header_id = l_approval_list_header_id
2729: AND sequence_num > l_current_sequence_num;
2730:
2731: p_return_code := E_SUCCESS;