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_CONTROL_PVT dependencies on PO_RELEASES

Line 66: FROM po_releases por

62: FOR UPDATE NOWAIT;
63: ELSIF (p_doc_type = 'RELEASE') THEN
64: SELECT 'Lock release'
65: INTO l_lock_row
66: FROM po_releases por
67: WHERE por.po_release_id = p_doc_id
68: FOR UPDATE NOWAIT;
69: ELSIF (p_doc_type = 'REQUISITION') THEN
70: SELECT 'Lock req'

Line 226: l_rel_doc_num PO_RELEASES.release_num%TYPE;

222: l_req_line_id_tbl PO_ReqChangeRequestWF_PVT.ReqLineID_tbl_type;
223:
224: l_request_id NUMBER := 0;
225: l_doc_num PO_HEADERS.segment1%TYPE;
226: l_rel_doc_num PO_RELEASES.release_num%TYPE;
227:
228: --< Bug 3554754 > Removed unnecessary CancelPO FPJ variables. Added variable for
229: -- approved_date.
230: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;

Line 424: FROM po_releases_all

420: -- when PO is in Requires reapprovalstate.
421: IF (p_doc_type = 'RELEASE') THEN
422: SELECT authorization_status
423: INTO l_authorization_status
424: FROM po_releases_all
425: WHERE po_release_id = p_doc_id;
426: ELSE
427: SELECT authorization_status
428: INTO l_authorization_status

Line 754: -- xml_flag on PO_HEADERS_ALL/PO_RELEASES_ALL accordingly.

750: --
751:
752: -- Bug 5407459 START
753: -- Pass p_xml_flag to start_wf_process so it can update the
754: -- xml_flag on PO_HEADERS_ALL/PO_RELEASES_ALL accordingly.
755: IF (l_default_method = 'XML') THEN
756: l_xml_flag := 'Y';
757: ELSE
758: l_xml_flag := 'N';

Line 820: FROM po_releases por,

816: -- SQL Why: Need this data to create a print request
817: -- SQL Join: po_header_id
818: SELECT por.release_num, poh.segment1
819: INTO l_rel_doc_num, l_doc_num
820: FROM po_releases por,
821: po_headers poh
822: WHERE por.po_release_id = p_doc_id AND
823: por.po_header_id = poh.po_header_id;
824: ELSE

Line 1960: po_releases por

1956: -- release.
1957: SELECT polc.displayed_field,
1958: polc.lookup_code
1959: FROM po_lookup_codes polc,
1960: po_releases por
1961: WHERE por.po_release_id = p_doc_id
1962: AND polc.lookup_type = 'CONTROL ACTIONS'
1963: AND NVL(por.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1964: AND ( NVL(por.cancel_flag, 'N') IN ('N','I')

Line 2160: po_releases por

2156: SELECT polc.displayed_field,
2157: polc.lookup_code
2158: FROM po_lookup_codes polc,
2159: po_line_locations poll,
2160: po_releases por
2161: WHERE poll.line_location_id = p_doc_line_loc_id
2162: AND poll.po_release_id = por.po_release_id
2163: AND polc.lookup_type = 'CONTROL ACTIONS'
2164: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2608: -- SQL What: Querying PO_HEADERS, PO_RELEASES for unapproved releases

2604: SELECT poh.wf_item_type, poh.wf_item_key
2605: FROM po_headers poh
2606: WHERE poh.po_header_id = p_doc_id;
2607: CURSOR l_unapproved_releases_csr IS
2608: -- SQL What: Querying PO_HEADERS, PO_RELEASES for unapproved releases
2609: -- SQL Why: Need to stop wf processes for unapproved releases
2610: -- SQL Join: po_header_id
2611: SELECT por.po_release_id, poh.type_lookup_code,
2612: por.wf_item_type, por.wf_item_key

Line 2613: FROM po_releases por,

2609: -- SQL Why: Need to stop wf processes for unapproved releases
2610: -- SQL Join: po_header_id
2611: SELECT por.po_release_id, poh.type_lookup_code,
2612: por.wf_item_type, por.wf_item_key
2613: FROM po_releases por,
2614: po_headers poh
2615: WHERE por.po_header_id = p_doc_id AND
2616: por.po_header_id = poh.po_header_id AND
2617: NVL(por.authorization_status,'INCOMPLETE') IN

Line 2623: TYPE release_id_tbl_type IS TABLE OF PO_RELEASES.po_release_id%TYPE

2619: NVL(por.cancel_flag,'N') = 'N' AND
2620: NVL(por.closed_code,'OPEN') <> 'FINALLY CLOSED';
2621:
2622: -- Bulk processing types and variables
2623: TYPE release_id_tbl_type IS TABLE OF PO_RELEASES.po_release_id%TYPE
2624: INDEX BY BINARY_INTEGER;
2625: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE
2626: INDEX BY BINARY_INTEGER;
2627: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE

Line 2627: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE

2623: TYPE release_id_tbl_type IS TABLE OF PO_RELEASES.po_release_id%TYPE
2624: INDEX BY BINARY_INTEGER;
2625: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE
2626: INDEX BY BINARY_INTEGER;
2627: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE
2628: INDEX BY BINARY_INTEGER;
2629: TYPE wf_item_key_tbl_type IS TABLE OF PO_RELEASES.wf_item_key%TYPE
2630: INDEX BY BINARY_INTEGER;
2631: l_release_id_tbl release_id_tbl_type;

Line 2629: TYPE wf_item_key_tbl_type IS TABLE OF PO_RELEASES.wf_item_key%TYPE

2625: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE
2626: INDEX BY BINARY_INTEGER;
2627: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE
2628: INDEX BY BINARY_INTEGER;
2629: TYPE wf_item_key_tbl_type IS TABLE OF PO_RELEASES.wf_item_key%TYPE
2630: INDEX BY BINARY_INTEGER;
2631: l_release_id_tbl release_id_tbl_type;
2632: l_doc_subtype_tbl doc_subtype_tbl_type;
2633: l_wf_item_type_tbl wf_item_type_tbl_type;

Line 2777: FROM po_releases por

2773: IS
2774:
2775: CURSOR l_rel_wf_csr IS
2776: SELECT por.wf_item_type, por.wf_item_key
2777: FROM po_releases por
2778: WHERE por.po_release_id = p_doc_id;
2779:
2780: l_api_name CONSTANT VARCHAR2(30) := 'rel_stop_wf_process';
2781: l_api_version CONSTANT NUMBER := 1.0;

Line 2782: l_wf_item_type PO_RELEASES.wf_item_type%TYPE;

2778: WHERE por.po_release_id = p_doc_id;
2779:
2780: l_api_name CONSTANT VARCHAR2(30) := 'rel_stop_wf_process';
2781: l_api_version CONSTANT NUMBER := 1.0;
2782: l_wf_item_type PO_RELEASES.wf_item_type%TYPE;
2783: l_wf_item_key PO_RELEASES.wf_item_key%TYPE;
2784:
2785: BEGIN
2786: -- Start standard API initialization

Line 2783: l_wf_item_key PO_RELEASES.wf_item_key%TYPE;

2779:
2780: l_api_name CONSTANT VARCHAR2(30) := 'rel_stop_wf_process';
2781: l_api_version CONSTANT NUMBER := 1.0;
2782: l_wf_item_type PO_RELEASES.wf_item_type%TYPE;
2783: l_wf_item_key PO_RELEASES.wf_item_key%TYPE;
2784:
2785: BEGIN
2786: -- Start standard API initialization
2787: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3288: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message

3284:
3285: /**
3286: * Public Procedure: update_note_to_vendor
3287: * Requires: API message list has been initialized if p_init_msg_list is false.
3288: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message
3289: * list.
3290: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or
3291: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the
3292: * document is not a RELEASE, then updates PO_LINES. All changes will be

Line 3291: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the

3287: * Requires: API message list has been initialized if p_init_msg_list is false.
3288: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message
3289: * list.
3290: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or
3291: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the
3292: * document is not a RELEASE, then updates PO_LINES. All changes will be
3293: * committed upon success if p_commit is FND_API.G_TRUE. Appends to API
3294: * message list on error.
3295: * Returns:

Line 3405: UPDATE po_releases por

3401: END IF; --
3402:
3403: ELSIF (p_doc_type = 'RELEASE') THEN
3404:
3405: UPDATE po_releases por
3406: SET por.note_to_vendor = p_note_to_vendor
3407: WHERE por.po_release_id = p_doc_id;
3408:
3409: --

Line 3427: UPDATE po_releases_archive pra

3423:
3424: /* Bug 2781710: We should update the note_to_vendor column
3425: in the archive table also. */
3426:
3427: UPDATE po_releases_archive pra
3428: SET pra.note_to_vendor = p_note_to_vendor
3429: WHERE pra.po_release_id = p_doc_id AND
3430: pra.revision_num = (SELECT por.revision_num
3431: FROM po_releases por

Line 3431: FROM po_releases por

3427: UPDATE po_releases_archive pra
3428: SET pra.note_to_vendor = p_note_to_vendor
3429: WHERE pra.po_release_id = p_doc_id AND
3430: pra.revision_num = (SELECT por.revision_num
3431: FROM po_releases por
3432: WHERE por.po_release_id = p_doc_id);
3433: ELSE
3434: -- This document type is not supported
3435: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');

Line 3531: FROM po_releases por

3527: WHERE porh.requisition_header_id = p_doc_id;
3528: ELSIF (p_doc_type = 'RELEASE') THEN
3529: SELECT por.agent_id
3530: INTO l_doc_agent_id
3531: FROM po_releases por
3532: WHERE por.po_release_id = p_doc_id;
3533: ELSE
3534: SELECT poh.agent_id
3535: INTO l_doc_agent_id