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_HEADERS

Line 890: FROM po_approval_list_headers

886: last_update_date
887: INTO l_approval_list_header_id,
888: l_current_sequence_num,
889: l_last_update_date
890: FROM po_approval_list_headers
891: WHERE document_id = p_document_id
892: AND document_type = p_document_type
893: AND document_subtype = p_document_subtype
894: AND latest_revision = 'Y';

Line 1006: FROM po_approval_list_headers

1002: IF (p_approval_list_header_id IS NOT NULL) THEN
1003: BEGIN
1004: SELECT last_update_date
1005: INTO l_old_last_update_date
1006: FROM po_approval_list_headers
1007: WHERE document_id = p_document_id
1008: AND document_type = p_document_type
1009: AND document_subtype = p_document_subtype
1010: AND approval_list_header_id = p_approval_list_header_id

Line 1064: FROM po_approval_list_headers

1060: l_old_approval_path_id,
1061: l_old_last_update_date,
1062: l_old_wf_item_type,
1063: l_old_wf_item_key
1064: FROM po_approval_list_headers
1065: WHERE document_id = p_document_id
1066: AND document_type = p_document_type
1067: AND document_subtype = p_document_subtype
1068: AND latest_revision = 'Y'

Line 1116: SELECT po_approval_list_headers_s.nextval

1112: END;
1113:
1114: l_progress := '012';
1115:
1116: SELECT po_approval_list_headers_s.nextval
1117: INTO l_new_approval_list_header_id
1118: FROM sys.dual;
1119:
1120: l_progress := '013';

Line 1122: INSERT INTO po_approval_list_headers (

1118: FROM sys.dual;
1119:
1120: l_progress := '013';
1121:
1122: INSERT INTO po_approval_list_headers (
1123: approval_list_header_id,
1124: document_id,
1125: document_type,
1126: document_subtype,

Line 1272: UPDATE po_approval_list_headers

1268: END IF;
1269:
1270: IF (l_old_approval_list_header_id IS NOT NULL) THEN
1271: l_progress := '020';
1272: UPDATE po_approval_list_headers
1273: SET latest_revision = 'N',
1274: last_update_date = SYSDATE,
1275: last_updated_by = fnd_global.user_id,
1276: last_update_login = fnd_global.login_id

Line 1482: FROM po_approval_list_headers

1478: l_old_first_approver_id,
1479: l_old_approval_path_id,
1480: l_old_current_sequence_num,
1481: l_old_last_update_date1
1482: FROM po_approval_list_headers
1483: WHERE document_id = p_document_id
1484: AND document_type = p_document_type
1485: AND document_subtype = p_document_subtype
1486: AND wf_item_key = l_old_wf_item_key1

Line 1935: FROM po_approval_list_headers

1931: l_old_approval_path_id,
1932: l_old_last_update_date2,
1933: l_old_wf_item_type2,
1934: l_old_wf_item_key2
1935: FROM po_approval_list_headers
1936: WHERE document_id = p_document_id
1937: AND document_type = p_document_type
1938: AND document_subtype = p_document_subtype
1939: AND wf_item_type = l_old_wf_item_type1

Line 1980: SELECT po_approval_list_headers_s.nextval

1976: END;
1977:
1978: l_progress := '017';
1979:
1980: SELECT po_approval_list_headers_s.nextval
1981: INTO l_new_approval_list_header_id
1982: FROM sys.dual;
1983:
1984: l_progress := '018';

Line 1986: INSERT INTO po_approval_list_headers (

1982: FROM sys.dual;
1983:
1984: l_progress := '018';
1985:
1986: INSERT INTO po_approval_list_headers (
1987: approval_list_header_id,
1988: document_id,
1989: document_type,
1990: document_subtype,

Line 2147: UPDATE po_approval_list_headers

2143: END IF;
2144:
2145: l_progress := '023';
2146:
2147: UPDATE po_approval_list_headers
2148: SET latest_revision = 'N',
2149: last_update_date = SYSDATE,
2150: last_updated_by = fnd_global.user_id,
2151: last_update_login = fnd_global.login_id

Line 2159: UPDATE po_approval_list_headers

2155: AND approval_list_header_id = l_old_approval_list_header_id2;
2156:
2157: l_progress := '024';
2158:
2159: UPDATE po_approval_list_headers
2160: SET last_update_date = SYSDATE
2161: WHERE document_id = p_document_id
2162: AND document_type = p_document_type
2163: AND document_subtype = p_document_subtype

Line 2353: FROM po_approval_list_headers

2349: INTO l_old_approval_list_header_id,
2350: l_old_current_sequence_num,
2351: l_old_wf_item_type,
2352: l_old_wf_item_key
2353: FROM po_approval_list_headers
2354: WHERE document_id = p_document_id
2355: AND document_type = p_document_type
2356: AND document_subtype = p_document_subtype
2357: AND latest_revision = 'Y'

Line 2365: ** before we update the po_approval_list_headers

2361: ** set appropriate value for workflow attribute
2362: ** FORWARD_FROM_ID,
2363: ** FORWARD_FROM_USER_NAME,
2364: ** FORWARD_FROM_DISP_NAME
2365: ** before we update the po_approval_list_headers
2366: */
2367:
2368: IF (l_old_current_sequence_num > 0 ) THEN
2369:

Line 2442: UPDATE po_approval_list_headers

2438: END IF;
2439:
2440: l_progress := '003';
2441:
2442: UPDATE po_approval_list_headers
2443: SET current_sequence_num = l_sequence_num,
2444: last_update_date = SYSDATE,
2445: last_updated_by = fnd_global.user_id,
2446: last_update_login = fnd_global.login_id

Line 2494: FROM po_approval_list_headers

2490: l_progress := '001';
2491:
2492: SELECT approval_list_header_id
2493: INTO p_approval_list_header_id
2494: FROM po_approval_list_headers
2495: WHERE document_id = p_document_id
2496: AND document_type = p_document_type
2497: AND document_subtype = p_document_subtype
2498: AND latest_revision = 'Y'

Line 2524: UPDATE po_approval_list_headers

2520: BEGIN
2521:
2522: l_progress := '001';
2523:
2524: UPDATE po_approval_list_headers
2525: SET wf_item_type = p_itemtype,
2526: wf_item_key = p_itemkey,
2527: last_update_date = SYSDATE,
2528: last_updated_by = fnd_global.user_id,

Line 2569: FROM po_approval_list_headers

2565: SELECT approval_list_header_id,
2566: NVL(current_sequence_num, 0)
2567: INTO l_approval_list_header_id,
2568: l_current_sequence_num
2569: FROM po_approval_list_headers
2570: WHERE document_id = p_document_id
2571: AND document_type = p_document_type
2572: AND document_subtype = p_document_subtype
2573: AND wf_item_type = p_itemtype

Line 2617: UPDATE po_approval_list_headers

2613: last_updated_by = fnd_global.user_id,
2614: last_update_login = fnd_global.login_id
2615: WHERE approval_list_line_id = l_approval_list_line_id;
2616:
2617: UPDATE po_approval_list_headers
2618: SET last_update_date = SYSDATE,
2619: last_updated_by = fnd_global.user_id,
2620: last_update_login = fnd_global.login_id
2621: WHERE approval_list_header_id = l_approval_list_header_id;

Line 2672: UPDATE po_approval_list_headers

2668: fnd_global.user_id,
2669: SYSDATE
2670: );
2671:
2672: UPDATE po_approval_list_headers
2673: SET current_sequence_num = 1,
2674: last_update_date = SYSDATE,
2675: last_updated_by = fnd_global.user_id,
2676: last_update_login = fnd_global.login_id

Line 2715: FROM po_approval_list_headers

2711: SELECT approval_list_header_id,
2712: NVL(current_sequence_num, 0)
2713: INTO l_approval_list_header_id,
2714: l_current_sequence_num
2715: FROM po_approval_list_headers
2716: WHERE document_id = p_document_id
2717: AND document_type = p_document_type
2718: AND document_subtype = p_document_subtype
2719: AND wf_item_type = p_itemtype