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 869: FROM po_approval_list_headers

865: last_update_date
866: INTO l_approval_list_header_id,
867: l_current_sequence_num,
868: l_last_update_date
869: FROM po_approval_list_headers
870: WHERE document_id = p_document_id
871: AND document_type = p_document_type
872: AND document_subtype = p_document_subtype
873: AND latest_revision = 'Y';

Line 985: FROM po_approval_list_headers

981: IF (p_approval_list_header_id IS NOT NULL) THEN
982: BEGIN
983: SELECT last_update_date
984: INTO l_old_last_update_date
985: FROM po_approval_list_headers
986: WHERE document_id = p_document_id
987: AND document_type = p_document_type
988: AND document_subtype = p_document_subtype
989: AND approval_list_header_id = p_approval_list_header_id

Line 1043: FROM po_approval_list_headers

1039: l_old_approval_path_id,
1040: l_old_last_update_date,
1041: l_old_wf_item_type,
1042: l_old_wf_item_key
1043: FROM po_approval_list_headers
1044: WHERE document_id = p_document_id
1045: AND document_type = p_document_type
1046: AND document_subtype = p_document_subtype
1047: AND latest_revision = 'Y'

Line 1095: SELECT po_approval_list_headers_s.nextval

1091: END;
1092:
1093: l_progress := '012';
1094:
1095: SELECT po_approval_list_headers_s.nextval
1096: INTO l_new_approval_list_header_id
1097: FROM sys.dual;
1098:
1099: l_progress := '013';

Line 1101: INSERT INTO po_approval_list_headers (

1097: FROM sys.dual;
1098:
1099: l_progress := '013';
1100:
1101: INSERT INTO po_approval_list_headers (
1102: approval_list_header_id,
1103: document_id,
1104: document_type,
1105: document_subtype,

Line 1251: UPDATE po_approval_list_headers

1247: END IF;
1248:
1249: IF (l_old_approval_list_header_id IS NOT NULL) THEN
1250: l_progress := '020';
1251: UPDATE po_approval_list_headers
1252: SET latest_revision = 'N',
1253: last_update_date = SYSDATE,
1254: last_updated_by = fnd_global.user_id,
1255: last_update_login = fnd_global.login_id

Line 1460: FROM po_approval_list_headers

1456: l_old_first_approver_id,
1457: l_old_approval_path_id,
1458: l_old_current_sequence_num,
1459: l_old_last_update_date1
1460: FROM po_approval_list_headers
1461: WHERE document_id = p_document_id
1462: AND document_type = p_document_type
1463: AND document_subtype = p_document_subtype
1464: AND wf_item_key = l_old_wf_item_key1

Line 1823: FROM po_approval_list_headers

1819: l_old_approval_path_id,
1820: l_old_last_update_date2,
1821: l_old_wf_item_type2,
1822: l_old_wf_item_key2
1823: FROM po_approval_list_headers
1824: WHERE document_id = p_document_id
1825: AND document_type = p_document_type
1826: AND document_subtype = p_document_subtype
1827: AND wf_item_type = l_old_wf_item_type1

Line 1868: SELECT po_approval_list_headers_s.nextval

1864: END;
1865:
1866: l_progress := '017';
1867:
1868: SELECT po_approval_list_headers_s.nextval
1869: INTO l_new_approval_list_header_id
1870: FROM sys.dual;
1871:
1872: l_progress := '018';

Line 1874: INSERT INTO po_approval_list_headers (

1870: FROM sys.dual;
1871:
1872: l_progress := '018';
1873:
1874: INSERT INTO po_approval_list_headers (
1875: approval_list_header_id,
1876: document_id,
1877: document_type,
1878: document_subtype,

Line 2035: UPDATE po_approval_list_headers

2031: END IF;
2032:
2033: l_progress := '023';
2034:
2035: UPDATE po_approval_list_headers
2036: SET latest_revision = 'N',
2037: last_update_date = SYSDATE,
2038: last_updated_by = fnd_global.user_id,
2039: last_update_login = fnd_global.login_id

Line 2047: UPDATE po_approval_list_headers

2043: AND approval_list_header_id = l_old_approval_list_header_id2;
2044:
2045: l_progress := '024';
2046:
2047: UPDATE po_approval_list_headers
2048: SET last_update_date = SYSDATE
2049: WHERE document_id = p_document_id
2050: AND document_type = p_document_type
2051: AND document_subtype = p_document_subtype

Line 2241: FROM po_approval_list_headers

2237: INTO l_old_approval_list_header_id,
2238: l_old_current_sequence_num,
2239: l_old_wf_item_type,
2240: l_old_wf_item_key
2241: FROM po_approval_list_headers
2242: WHERE document_id = p_document_id
2243: AND document_type = p_document_type
2244: AND document_subtype = p_document_subtype
2245: AND latest_revision = 'Y'

Line 2253: ** before we update the po_approval_list_headers

2249: ** set appropriate value for workflow attribute
2250: ** FORWARD_FROM_ID,
2251: ** FORWARD_FROM_USER_NAME,
2252: ** FORWARD_FROM_DISP_NAME
2253: ** before we update the po_approval_list_headers
2254: */
2255:
2256: IF (l_old_current_sequence_num > 0 ) THEN
2257:

Line 2330: UPDATE po_approval_list_headers

2326: END IF;
2327:
2328: l_progress := '003';
2329:
2330: UPDATE po_approval_list_headers
2331: SET current_sequence_num = l_sequence_num,
2332: last_update_date = SYSDATE,
2333: last_updated_by = fnd_global.user_id,
2334: last_update_login = fnd_global.login_id

Line 2382: FROM po_approval_list_headers

2378: l_progress := '001';
2379:
2380: SELECT approval_list_header_id
2381: INTO p_approval_list_header_id
2382: FROM po_approval_list_headers
2383: WHERE document_id = p_document_id
2384: AND document_type = p_document_type
2385: AND document_subtype = p_document_subtype
2386: AND latest_revision = 'Y'

Line 2412: UPDATE po_approval_list_headers

2408: BEGIN
2409:
2410: l_progress := '001';
2411:
2412: UPDATE po_approval_list_headers
2413: SET wf_item_type = p_itemtype,
2414: wf_item_key = p_itemkey,
2415: last_update_date = SYSDATE,
2416: last_updated_by = fnd_global.user_id,

Line 2457: FROM po_approval_list_headers

2453: SELECT approval_list_header_id,
2454: NVL(current_sequence_num, 0)
2455: INTO l_approval_list_header_id,
2456: l_current_sequence_num
2457: FROM po_approval_list_headers
2458: WHERE document_id = p_document_id
2459: AND document_type = p_document_type
2460: AND document_subtype = p_document_subtype
2461: AND wf_item_type = p_itemtype

Line 2505: UPDATE po_approval_list_headers

2501: last_updated_by = fnd_global.user_id,
2502: last_update_login = fnd_global.login_id
2503: WHERE approval_list_line_id = l_approval_list_line_id;
2504:
2505: UPDATE po_approval_list_headers
2506: SET last_update_date = SYSDATE,
2507: last_updated_by = fnd_global.user_id,
2508: last_update_login = fnd_global.login_id
2509: WHERE approval_list_header_id = l_approval_list_header_id;

Line 2560: UPDATE po_approval_list_headers

2556: fnd_global.user_id,
2557: SYSDATE
2558: );
2559:
2560: UPDATE po_approval_list_headers
2561: SET current_sequence_num = 1,
2562: last_update_date = SYSDATE,
2563: last_updated_by = fnd_global.user_id,
2564: last_update_login = fnd_global.login_id

Line 2603: FROM po_approval_list_headers

2599: SELECT approval_list_header_id,
2600: NVL(current_sequence_num, 0)
2601: INTO l_approval_list_header_id,
2602: l_current_sequence_num
2603: FROM po_approval_list_headers
2604: WHERE document_id = p_document_id
2605: AND document_type = p_document_type
2606: AND document_subtype = p_document_subtype
2607: AND wf_item_type = p_itemtype