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_DOCUMENT_ACTION_UTIL dependencies on PO_HEADERS

Line 144: FROM po_headers poh

140: nvl(poh.closed_code, 'OPEN'),
141: nvl(poh.frozen_flag, 'N'),
142: nvl(poh.user_hold_flag, 'N')
143:
144: FROM po_headers poh
145: WHERE poh.po_header_id = docid;
146:
147: -- CLM Apprvl
148: CURSOR state_mod(docid NUMBER, draftId NUMBER) IS

Line 153: FROM po_headers_merge_v phm

149: SELECT nvl(phm.status, 'DRAFT'),
150: nvl(phm.closed_code, 'OPEN'),
151: nvl(phm.frozen_flag, 'N'),
152: nvl(phm.user_hold_flag, 'N')
153: FROM po_headers_merge_v phm
154: WHERE phm.po_header_id = docid
155: and phm.draft_id= draftId;
156:
157: CURSOR state_req(docid NUMBER) IS

Line 636: FROM po_headers_merge_v poh

632: IF p_draft_id IS NOT NULL AND p_draft_id <> -1 THEN
633: BEGIN
634: SELECT poh.agent_id
635: INTO x_preparer_id
636: FROM po_headers_merge_v poh
637: WHERE poh.po_header_id = p_document_id
638: AND poh.draft_id = p_draft_id;
639: EXCEPTION
640: WHEN OTHERS THEN

Line 649: FROM po_headers_all poh

645: ELSE
646: BEGIN
647: SELECT poh.agent_id
648: INTO x_preparer_id
649: FROM po_headers_all poh
650: WHERE poh.po_header_id = p_document_id;
651: EXCEPTION
652: WHEN OTHERS THEN
653: IF (PO_LOG.d_stmt) THEN

Line 992: l_old_status PO_HEADERS.authorization_status%TYPE;

988:
989: l_emp_flag BOOLEAN;
990: l_emp_id PER_EMPLOYEES_CURRENT_X.employee_id%TYPE;
991:
992: l_old_status PO_HEADERS.authorization_status%TYPE;
993: l_creation_date PO_HEADERS.creation_date%TYPE;
994: l_revision_num PO_HEADERS.revision_num%TYPE;
995:
996: d_progress NUMBER;

Line 993: l_creation_date PO_HEADERS.creation_date%TYPE;

989: l_emp_flag BOOLEAN;
990: l_emp_id PER_EMPLOYEES_CURRENT_X.employee_id%TYPE;
991:
992: l_old_status PO_HEADERS.authorization_status%TYPE;
993: l_creation_date PO_HEADERS.creation_date%TYPE;
994: l_revision_num PO_HEADERS.revision_num%TYPE;
995:
996: d_progress NUMBER;
997: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state';

Line 994: l_revision_num PO_HEADERS.revision_num%TYPE;

990: l_emp_id PER_EMPLOYEES_CURRENT_X.employee_id%TYPE;
991:
992: l_old_status PO_HEADERS.authorization_status%TYPE;
993: l_creation_date PO_HEADERS.creation_date%TYPE;
994: l_revision_num PO_HEADERS.revision_num%TYPE;
995:
996: d_progress NUMBER;
997: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state';
998:

Line 1083: FROM PO_HEADERS_MERGE_V poh

1079: poh.revision_num
1080: INTO l_old_status,
1081: l_creation_date,
1082: l_revision_num
1083: FROM PO_HEADERS_MERGE_V poh
1084: WHERE poh.po_header_id = p_document_id
1085: AND poh.draft_id = p_draft_id;
1086:
1087: ELSE

Line 1094: FROM PO_HEADERS poh

1090: poh.revision_num
1091: INTO l_old_status,
1092: l_creation_date,
1093: l_revision_num
1094: FROM PO_HEADERS poh
1095: WHERE poh.po_header_id = p_document_id;
1096:
1097: END IF;
1098:

Line 1247: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

1243: l_rollup_msg VARCHAR2(256);
1244: l_ctl_replaced_null_entry BOOLEAN := FALSE;
1245: l_count_hist NUMBER;
1246:
1247: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
1248:
1249: BEGIN
1250:
1251: d_progress := 0;

Line 1440: FROM po_headers_all poh

1436: -- so we're safe using headers_all
1437:
1438: SELECT max(poh.revision_num)
1439: INTO l_revision_num
1440: FROM po_headers_all poh
1441: WHERE poh.po_header_id = p_document_id;
1442:
1443: d_progress := 160;
1444: IF (PO_LOG.d_stmt) THEN

Line 1816: l_conterms_exist PO_HEADERS.conterms_exist_flag%TYPE;

1812: , x_return_status OUT NOCOPY VARCHAR2
1813: )
1814: IS
1815:
1816: l_conterms_exist PO_HEADERS.conterms_exist_flag%TYPE;
1817: l_pending_signature PO_HEADERS.pending_signature_flag%TYPE;
1818: l_conformed_id PO_REQUISITION_HEADERS_ALL.conformed_header_id%TYPE;
1819:
1820: l_ret_sts VARCHAR2(1);

Line 1817: l_pending_signature PO_HEADERS.pending_signature_flag%TYPE;

1813: )
1814: IS
1815:
1816: l_conterms_exist PO_HEADERS.conterms_exist_flag%TYPE;
1817: l_pending_signature PO_HEADERS.pending_signature_flag%TYPE;
1818: l_conformed_id PO_REQUISITION_HEADERS_ALL.conformed_header_id%TYPE;
1819:
1820: l_ret_sts VARCHAR2(1);
1821: l_err_msg VARCHAR2(200);

Line 1902: /* UPDATE PO_HEADERS_DRAFT_ALL poh

1898:
1899: -- CLM Apprvl
1900: IF p_draft_id IS NOT NULL AND p_draft_id <> -1 THEN
1901:
1902: /* UPDATE PO_HEADERS_DRAFT_ALL poh
1903: SET poh.authorization_status = p_new_status,
1904: poh.approved_flag = DECODE(p_new_status,
1905: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1906: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',

Line 1932: UPDATE PO_HEADERS poh

1928:
1929: -- PO AME Project : need to retain pending_signature_flag as E in case of
1930: -- E-Signers do exists on the document
1931:
1932: UPDATE PO_HEADERS poh
1933: SET poh.authorization_status = p_new_status,
1934: poh.approved_flag = DECODE(p_new_status,
1935: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED, 'Y',
1936: PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL, 'R',

Line 1969: FROM PO_HEADERS poh

1965: d_progress := 30;
1966:
1967: SELECT NVL(poh.pending_signature_flag, 'N'), NVL(poh.conterms_exist_flag, 'N')
1968: INTO l_pending_signature, l_conterms_exist
1969: FROM PO_HEADERS poh
1970: WHERE po_header_id = p_document_id;
1971:
1972:
1973: d_progress := 40;

Line 2020: UPDATE PO_HEADERS poh

2016: END IF;
2017:
2018: d_progress := 80;
2019:
2020: UPDATE PO_HEADERS poh
2021: SET poh.authorization_status = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED
2022: , poh.approved_flag = 'N'
2023: , poh.last_update_date = SYSDATE
2024: , poh.last_updated_by = p_user_id

Line 2035: po_headers poh

2031: BEGIN
2032: SELECT clm_flag
2033: INTO l_is_clm_document
2034: FROM po_doc_style_headers psh,
2035: po_headers poh
2036: WHERE psh.style_id = poh.style_id
2037: AND poh.po_header_id = p_document_id;
2038: EXCEPTION
2039: WHEN no_data_found THEN

Line 2059: FROM po_headers_all poh

2055: undef_clm_document_number =
2056: Decode (p_draft_id,
2057: def_draft_id, undef_clm_document_number,
2058: -1, (SELECT clm_document_number
2059: FROM po_headers_all poh
2060: WHERE poh.po_header_id = p_document_id),
2061: (SELECT modification_number
2062: FROM po_drafts
2063: WHERE document_id = p_document_id

Line 2085: FROM PO_HEADERS_ALL poh

2081: WHERE poll.po_header_id = p_document_id
2082: AND poll.po_release_id IS NULL
2083: AND NVL(poll.approved_flag, 'N') <> 'Y'
2084: AND EXISTS ( SELECT 'PO Does not require signature'
2085: FROM PO_HEADERS_ALL poh
2086: WHERE poh.po_header_id = poll.po_header_id
2087: AND NVL(poh.pending_signature_flag, 'N') <> 'Y');
2088:
2089: IF ((l_ret_sts = FND_API.G_RET_STS_UNEXP_ERROR)

Line 2636: FROM po_headers_all

2632: -- Changed the above line to handle the CPA case also
2633: IF ( l_idv_header_id IS NOT NULL) THEN
2634:
2635: SELECT clm_amount_released INTO l_clm_amt_released_hdr
2636: FROM po_headers_all
2637: WHERE po_header_id = l_idv_header_id;
2638:
2639: -- Changed the above line to handle the BPA case only
2640: IF ( l_idv_line_id IS NOT NULL) THEN

Line 2772: UPDATE po_headers_all SET CLM_AMOUNT_RELEASED = l_clm_amt_released_hdr

2768: PO_LOG.stmt(d_module, d_progress, 'l_amt_ordered_idv_line ', l_amt_ordered_idv_line);
2769: PO_LOG.stmt(d_module, d_progress, 'l_qty_ordered_idv_line ', l_qty_ordered_idv_line);
2770: END IF;
2771:
2772: UPDATE po_headers_all SET CLM_AMOUNT_RELEASED = l_clm_amt_released_hdr
2773: WHERE po_header_id = l_idv_header_id;
2774:
2775: d_progress := 80;
2776: -- Changed the above line to handle the BPA case only