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 847: FROM po_approval_list_lines

843: status,
844: response_date,
845: mandatory_flag,
846: approver_type
847: FROM po_approval_list_lines
848: WHERE approval_list_header_id = p_approval_list_header_id
849: ORDER BY sequence_num;
850:
851: l_progress VARCHAR2(10) := '000';

Line 959: FROM po_approval_list_lines

955: p_error_stack OUT NOCOPY ErrorStackType) IS
956:
957: CURSOR c_lock_approval_list_lines(p_approval_list_header_id NUMBER) IS
958: SELECT approval_list_line_id
959: FROM po_approval_list_lines
960: WHERE approval_list_header_id = p_approval_list_header_id
961: FOR UPDATE NOWAIT;
962:
963: l_progress VARCHAR2(10) := '000';

Line 1140: INSERT INTO po_approval_list_lines (

1136: IF (p_approval_list_header_id IS NOT NULL) THEN
1137: BEGIN
1138: l_progress := '014';
1139:
1140: INSERT INTO po_approval_list_lines (
1141: approval_list_header_id,
1142: approval_list_line_id,
1143: next_element_id,
1144: approver_id,

Line 1162: po_approval_list_lines_s.nextval,

1158: last_update_login,
1159: last_updated_by,
1160: last_update_date)
1161: SELECT l_new_approval_list_header_id,
1162: po_approval_list_lines_s.nextval,
1163: NULL,
1164: approver_id,
1165: sequence_num,
1166: notification_id,

Line 1181: FROM po_approval_list_lines

1177: SYSDATE,
1178: fnd_global.login_id,
1179: fnd_global.user_id,
1180: SYSDATE
1181: FROM po_approval_list_lines
1182: WHERE approval_list_header_id = p_approval_list_header_id
1183: AND sequence_num <= l_old_current_sequence_num;
1184:
1185: EXCEPTION

Line 1202: INSERT INTO po_approval_list_lines (

1198: p_approval_list(l_index).sequence_num > NVL(l_old_current_sequence_num, 0)) THEN
1199:
1200: l_progress := '017.'||to_char(l_index);
1201:
1202: INSERT INTO po_approval_list_lines (
1203: approval_list_header_id,
1204: approval_list_line_id,
1205: next_element_id,
1206: approver_id,

Line 1224: po_approval_list_lines_s.nextval,

1220: last_update_login,
1221: last_updated_by,
1222: last_update_date)
1223: SELECT l_new_approval_list_header_id,
1224: po_approval_list_lines_s.nextval,
1225: NULL,
1226: p_approval_list(l_index).approver_id,
1227: p_approval_list(l_index).sequence_num,
1228: NULL,

Line 1299: FROM po_approval_list_lines

1295: p_approval_list_header_id OUT NOCOPY NUMBER) IS
1296:
1297: CURSOR c_lock_approval_list_lines(p_approval_list_header_id NUMBER) IS
1298: SELECT approval_list_line_id
1299: FROM po_approval_list_lines
1300: WHERE approval_list_header_id = p_approval_list_header_id
1301: FOR UPDATE;
1302:
1303: CURSOR c_find_last_forward_to(p_approval_list_header_id NUMBER,

Line 1307: FROM po_approval_list_lines

1303: CURSOR c_find_last_forward_to(p_approval_list_header_id NUMBER,
1304: p_current_sequence_num NUMBER) IS
1305: SELECT forward_to_id,
1306: sequence_num
1307: FROM po_approval_list_lines
1308: WHERE approval_list_header_id = p_approval_list_header_id
1309: AND forward_to_id IS NOT NULL
1310: AND sequence_num <= p_current_sequence_num
1311: ORDER BY sequence_num DESC;

Line 1318: FROM po_approval_list_lines

1314: p_current_sequence_num NUMBER) IS
1315: SELECT approver_id,
1316: sequence_num,
1317: approver_type
1318: FROM po_approval_list_lines
1319: WHERE approval_list_header_id = p_approval_list_header_id
1320: AND approver_type IN ('SYSTEM', 'FORWARD')
1321: AND sequence_num <= p_current_sequence_num
1322: AND approval_list_line_id <> (select min(l2.approval_list_line_id)

Line 1323: from po_approval_list_lines l2

1319: WHERE approval_list_header_id = p_approval_list_header_id
1320: AND approver_type IN ('SYSTEM', 'FORWARD')
1321: AND sequence_num <= p_current_sequence_num
1322: AND approval_list_line_id <> (select min(l2.approval_list_line_id)
1323: from po_approval_list_lines l2
1324: where l2.approval_list_header_id = p_approval_list_header_id)
1325: ORDER BY sequence_num DESC;
1326:
1327: CURSOR c_future_approver(p_approval_list_header_id NUMBER,

Line 1335: FROM po_approval_list_lines

1331: sequence_num,
1332: approver_type,
1333: status,
1334: mandatory_flag
1335: FROM po_approval_list_lines
1336: WHERE approval_list_header_id = p_approval_list_header_id
1337: AND sequence_num > NVL(p_current_sequence_num, 0)
1338: ORDER BY sequence_num;
1339:

Line 1480: FROM po_approval_list_lines

1476: l_progress := '003';
1477:
1478: SELECT forward_to_id
1479: INTO l_start_approver_id
1480: FROM po_approval_list_lines
1481: WHERE approval_list_header_id = l_old_approval_list_header_id1
1482: AND sequence_num = l_old_current_sequence_num;
1483:
1484: IF (l_start_approver_id IS NULL OR

Line 1623: FROM po_approval_list_lines

1619:
1620: -- remove user add/forward approvers in the future
1621: SELECT COUNT(*)
1622: INTO l_count
1623: FROM po_approval_list_lines
1624: WHERE approval_list_header_id = l_old_approval_list_header_id1
1625: AND approver_id = l_default_approval_list(l_index1).approver_id
1626: AND (sequence_num >= l_old_current_sequence_num AND approver_type <> 'SYSTEM' AND approver_type <> 'FORWARD');
1627:

Line 1636: FROM po_approval_list_lines

1632:
1633: ElSE
1634: SELECT COUNT(*)
1635: INTO l_count
1636: FROM po_approval_list_lines
1637: WHERE approval_list_header_id = l_old_approval_list_header_id1
1638: AND approver_id = l_default_approval_list(l_index1).approver_id
1639: AND ((sequence_num = l_old_current_sequence_num) OR
1640: (sequence_num >= l_old_current_sequence_num AND approver_type <> 'SYSTEM'));

Line 1658: FROM po_approval_list_lines

1654: -- Find out whether or not the person has already responded
1655: l_progress := '009.'||to_char(l_index1);
1656: SELECT COUNT(*)
1657: INTO l_count
1658: FROM po_approval_list_lines
1659: WHERE approval_list_header_id = l_old_approval_list_header_id1
1660: AND approver_id = l_default_approval_list(l_index1).approver_id
1661: AND sequence_num <= l_old_current_sequence_num;
1662:

Line 1667: FROM po_approval_list_lines

1663: IF (l_count > 0) THEN
1664: l_progress := '010.'||to_char(l_index1);
1665: SELECT COUNT(*)
1666: INTO l_count
1667: FROM po_approval_list_lines
1668: WHERE approval_list_header_id = l_old_approval_list_header_id1
1669: AND approver_id = l_default_approval_list(l_index1).approver_id
1670: AND sequence_num <= l_old_current_sequence_num
1671: AND requires_reapproval_flag = 'Y';

Line 1682: FROM po_approval_list_lines

1678: -- then we remove him.
1679: l_progress := '011.'||to_char(l_index1);
1680: SELECT COUNT(*)
1681: INTO l_count
1682: FROM po_approval_list_lines
1683: WHERE approval_list_header_id = l_old_approval_list_header_id1
1684: AND approver_id = l_default_approval_list(l_index1).approver_id
1685: AND sequence_num <= l_old_current_sequence_num
1686: AND status in ('APPROVE', 'APPROVE_AND_FORWARD');

Line 1700: FROM po_approval_list_lines

1696: -- then we remove him.
1697:
1698: SELECT COUNT(*)
1699: INTO l_count
1700: FROM po_approval_list_lines
1701: WHERE approval_list_header_id = l_old_approval_list_header_id1
1702: AND approver_id = l_default_approval_list(l_index1).approver_id
1703: AND sequence_num <= l_old_current_sequence_num
1704: AND status in ('FORWARD');

Line 1912: INSERT INTO po_approval_list_lines (

1908:
1909: BEGIN
1910: l_progress := '019';
1911:
1912: INSERT INTO po_approval_list_lines (
1913: approval_list_header_id,
1914: approval_list_line_id,
1915: next_element_id,
1916: approver_id,

Line 1934: po_approval_list_lines_s.nextval,

1930: last_update_login,
1931: last_updated_by,
1932: last_update_date)
1933: SELECT l_new_approval_list_header_id,
1934: po_approval_list_lines_s.nextval,
1935: NULL, -- next_element_id
1936: approver_id,
1937: sequence_num,
1938: notification_id,

Line 1955: FROM po_approval_list_lines

1951: SYSDATE,
1952: fnd_global.login_id,
1953: fnd_global.user_id,
1954: SYSDATE
1955: FROM po_approval_list_lines
1956: WHERE approval_list_header_id = l_old_approval_list_header_id2
1957: AND sequence_num <= l_old_current_sequence_num;
1958:
1959: EXCEPTION

Line 1969: FROM po_approval_list_lines

1965: l_progress := '020';
1966:
1967: SELECT NVL(max(sequence_num), 0)
1968: INTO l_max_sequence_num
1969: FROM po_approval_list_lines
1970: WHERE approval_list_header_id = l_new_approval_list_header_id;
1971:
1972: IF (l_complete_approval_list.COUNT > 0) THEN
1973: l_index1 := l_complete_approval_list.FIRST;

Line 1986: INSERT INTO po_approval_list_lines (

1982: IF (l_complete_approval_list(l_index1).sequence_num > l_max_sequence_num) THEN
1983: l_max_sequence_num := l_complete_approval_list(l_index1).sequence_num;
1984: END IF;
1985: l_progress := '022.'||to_char(l_index1);
1986: INSERT INTO po_approval_list_lines (
1987: approval_list_header_id,
1988: approval_list_line_id,
1989: next_element_id,
1990: approver_id,

Line 2008: po_approval_list_lines_s.nextval,

2004: last_update_login,
2005: last_updated_by,
2006: last_update_date)
2007: SELECT l_new_approval_list_header_id,
2008: po_approval_list_lines_s.nextval,
2009: NULL, -- next_element_id
2010: l_complete_approval_list(l_index1).approver_id,
2011: l_complete_approval_list(l_index1).sequence_num,
2012: NULL, -- notification_id

Line 2199: FROM po_approval_list_lines

2195: p_approver_type OUT NOCOPY VARCHAR2) IS
2196:
2197: CURSOR c_lock_approval_list_lines(p_approval_list_header_id NUMBER) IS
2198: SELECT approval_list_line_id
2199: FROM po_approval_list_lines
2200: WHERE approval_list_header_id = p_approval_list_header_id
2201: FOR UPDATE;
2202:
2203: CURSOR c_find_next_approver(p_approval_list_header_id NUMBER,

Line 2208: FROM po_approval_list_lines

2204: p_current_sequence_num NUMBER) IS
2205: SELECT approver_id,
2206: sequence_num,
2207: approver_type
2208: FROM po_approval_list_lines
2209: WHERE approval_list_header_id = p_approval_list_header_id
2210: AND sequence_num > p_current_sequence_num
2211: ORDER BY sequence_num;
2212:

Line 2260: FROM po_approval_list_lines

2256: IF (l_old_current_sequence_num > 0 ) THEN
2257:
2258: SELECT approver_id
2259: INTO l_current_approver_id
2260: FROM po_approval_list_lines
2261: WHERE approval_list_header_id = l_old_approval_list_header_id
2262: AND sequence_num = l_old_current_sequence_num;
2263:
2264:

Line 2471: FROM po_approval_list_lines

2467: l_progress := '006';
2468:
2469: SELECT approval_list_line_id
2470: INTO l_approval_list_line_id
2471: FROM po_approval_list_lines
2472: WHERE approval_list_header_id = l_approval_list_header_id
2473: AND approver_id = p_approver_id
2474: AND sequence_num = l_current_sequence_num
2475: FOR UPDATE;

Line 2494: UPDATE po_approval_list_lines

2490: l_progress := '007';
2491:
2492: IF l_line_found THEN
2493:
2494: UPDATE po_approval_list_lines
2495: SET status = p_response,
2496: forward_to_id = p_forward_to_id,
2497: responder_id = p_responder_id,
2498: response_date = p_response_date,

Line 2515: INSERT INTO po_approval_list_lines (

2511: ELSE
2512:
2513: /* Bug 2092663: Add a new line if there is header but no line */
2514:
2515: INSERT INTO po_approval_list_lines (
2516: approval_list_header_id,
2517: approval_list_line_id,
2518: next_element_id,
2519: approver_id,

Line 2539: po_approval_list_lines_s.nextval,

2535: last_update_date)
2536: VALUES
2537: (
2538: l_approval_list_header_id,
2539: po_approval_list_lines_s.nextval,
2540: NULL,
2541: p_responder_id,
2542: 1,
2543: null,

Line 2615: FROM po_approval_list_lines

2611: l_progress := '002';
2612:
2613: SELECT COUNT(*)
2614: INTO l_count
2615: FROM po_approval_list_lines
2616: WHERE approval_list_header_id = l_approval_list_header_id
2617: AND sequence_num > l_current_sequence_num;
2618:
2619: p_return_code := E_SUCCESS;