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 232: FROM po_releases_all

228: l_progress :='002';
229:
230: SELECT authorization_status
231: INTO l_auth_status
232: FROM po_releases_all
233: WHERE po_release_id=p_doc_id;
234: END IF;
235:
236: EXCEPTION

Line 526: FROM po_releases_all

522: l_progress :='002';
523:
524: SELECT authorization_status
525: INTO l_old_auth_status
526: FROM po_releases_all
527: WHERE po_release_id=p_doc_id;
528: END IF;
529:
530: EXCEPTION

Line 1811: po_releases por

1807: -- release.
1808: SELECT polc.displayed_field,
1809: polc.lookup_code
1810: FROM po_lookup_codes polc,
1811: po_releases por
1812: WHERE por.po_release_id = p_doc_id
1813: AND polc.lookup_type = 'CONTROL ACTIONS'
1814: AND NVL(por.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1815: AND ( NVL(por.cancel_flag, 'N') IN ('N','I')

Line 2012: po_releases por

2008: SELECT polc.displayed_field,
2009: polc.lookup_code
2010: FROM po_lookup_codes polc,
2011: po_line_locations poll,
2012: po_releases por
2013: WHERE poll.line_location_id = p_doc_line_loc_id
2014: AND poll.po_release_id = por.po_release_id
2015: AND polc.lookup_type = 'CONTROL ACTIONS'
2016: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

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

2457: SELECT poh.wf_item_type, poh.wf_item_key
2458: FROM po_headers poh
2459: WHERE poh.po_header_id = p_doc_id;
2460: CURSOR l_unapproved_releases_csr IS
2461: -- SQL What: Querying PO_HEADERS, PO_RELEASES for unapproved releases
2462: -- SQL Why: Need to stop wf processes for unapproved releases
2463: -- SQL Join: po_header_id
2464: SELECT por.po_release_id, poh.type_lookup_code,
2465: por.wf_item_type, por.wf_item_key

Line 2466: FROM po_releases por,

2462: -- SQL Why: Need to stop wf processes for unapproved releases
2463: -- SQL Join: po_header_id
2464: SELECT por.po_release_id, poh.type_lookup_code,
2465: por.wf_item_type, por.wf_item_key
2466: FROM po_releases por,
2467: po_headers poh
2468: WHERE por.po_header_id = p_doc_id AND
2469: por.po_header_id = poh.po_header_id AND
2470: NVL(por.authorization_status,'INCOMPLETE') IN

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

2472: NVL(por.cancel_flag,'N') = 'N' AND
2473: NVL(por.closed_code,'OPEN') <> 'FINALLY CLOSED';
2474:
2475: -- Bulk processing types and variables
2476: TYPE release_id_tbl_type IS TABLE OF PO_RELEASES.po_release_id%TYPE
2477: INDEX BY BINARY_INTEGER;
2478: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE
2479: INDEX BY BINARY_INTEGER;
2480: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE

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

2476: TYPE release_id_tbl_type IS TABLE OF PO_RELEASES.po_release_id%TYPE
2477: INDEX BY BINARY_INTEGER;
2478: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE
2479: INDEX BY BINARY_INTEGER;
2480: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE
2481: INDEX BY BINARY_INTEGER;
2482: TYPE wf_item_key_tbl_type IS TABLE OF PO_RELEASES.wf_item_key%TYPE
2483: INDEX BY BINARY_INTEGER;
2484: l_release_id_tbl release_id_tbl_type;

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

2478: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE
2479: INDEX BY BINARY_INTEGER;
2480: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE
2481: INDEX BY BINARY_INTEGER;
2482: TYPE wf_item_key_tbl_type IS TABLE OF PO_RELEASES.wf_item_key%TYPE
2483: INDEX BY BINARY_INTEGER;
2484: l_release_id_tbl release_id_tbl_type;
2485: l_doc_subtype_tbl doc_subtype_tbl_type;
2486: l_wf_item_type_tbl wf_item_type_tbl_type;

Line 2630: FROM po_releases por

2626: IS
2627:
2628: CURSOR l_rel_wf_csr IS
2629: SELECT por.wf_item_type, por.wf_item_key
2630: FROM po_releases por
2631: WHERE por.po_release_id = p_doc_id;
2632:
2633: l_api_name CONSTANT VARCHAR2(30) := 'rel_stop_wf_process';
2634: l_api_version CONSTANT NUMBER := 1.0;

Line 2635: l_wf_item_type PO_RELEASES.wf_item_type%TYPE;

2631: WHERE por.po_release_id = p_doc_id;
2632:
2633: l_api_name CONSTANT VARCHAR2(30) := 'rel_stop_wf_process';
2634: l_api_version CONSTANT NUMBER := 1.0;
2635: l_wf_item_type PO_RELEASES.wf_item_type%TYPE;
2636: l_wf_item_key PO_RELEASES.wf_item_key%TYPE;
2637:
2638: BEGIN
2639: -- Start standard API initialization

Line 2636: l_wf_item_key PO_RELEASES.wf_item_key%TYPE;

2632:
2633: l_api_name CONSTANT VARCHAR2(30) := 'rel_stop_wf_process';
2634: l_api_version CONSTANT NUMBER := 1.0;
2635: l_wf_item_type PO_RELEASES.wf_item_type%TYPE;
2636: l_wf_item_key PO_RELEASES.wf_item_key%TYPE;
2637:
2638: BEGIN
2639: -- Start standard API initialization
2640: IF FND_API.to_boolean(p_init_msg_list) THEN

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

3139:
3140: /**
3141: * Public Procedure: update_note_to_vendor
3142: * Requires: API message list has been initialized if p_init_msg_list is false.
3143: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message
3144: * list.
3145: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or
3146: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the
3147: * document is not a RELEASE, then updates PO_LINES. All changes will be

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

3142: * Requires: API message list has been initialized if p_init_msg_list is false.
3143: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message
3144: * list.
3145: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or
3146: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the
3147: * document is not a RELEASE, then updates PO_LINES. All changes will be
3148: * committed upon success if p_commit is FND_API.G_TRUE. Appends to API
3149: * message list on error.
3150: * Returns:

Line 3260: UPDATE po_releases por

3256: END IF; --
3257:
3258: ELSIF (p_doc_type = 'RELEASE') THEN
3259:
3260: UPDATE po_releases por
3261: SET por.note_to_vendor = p_note_to_vendor
3262: WHERE por.po_release_id = p_doc_id;
3263:
3264: --

Line 3282: UPDATE po_releases_archive pra

3278:
3279: /* Bug 2781710: We should update the note_to_vendor column
3280: in the archive table also. */
3281:
3282: UPDATE po_releases_archive pra
3283: SET pra.note_to_vendor = p_note_to_vendor
3284: WHERE pra.po_release_id = p_doc_id AND
3285: pra.revision_num = (SELECT por.revision_num
3286: FROM po_releases por

Line 3286: FROM po_releases por

3282: UPDATE po_releases_archive pra
3283: SET pra.note_to_vendor = p_note_to_vendor
3284: WHERE pra.po_release_id = p_doc_id AND
3285: pra.revision_num = (SELECT por.revision_num
3286: FROM po_releases por
3287: WHERE por.po_release_id = p_doc_id);
3288: ELSE
3289: -- This document type is not supported
3290: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_TYPE');

Line 3386: FROM po_releases por

3382: WHERE porh.requisition_header_id = p_doc_id;
3383: ELSIF (p_doc_type = 'RELEASE') THEN
3384: SELECT por.agent_id
3385: INTO l_doc_agent_id
3386: FROM po_releases por
3387: WHERE por.po_release_id = p_doc_id;
3388: ELSE
3389: SELECT poh.agent_id
3390: INTO l_doc_agent_id

Line 5279: FROM po_releases_all

5275: revision_num
5276: INTO l_conterms_exist_flag,
5277: l_auth_status,
5278: l_revision_num
5279: FROM po_releases_all
5280: WHERE po_release_id = p_doc_id;
5281:
5282: END IF;
5283:

Line 5316: FROM po_releases_archive_all

5312: ELSE
5313: l_progress :='004';
5314: SELECT Count(1)
5315: INTO l_archive_count
5316: FROM po_releases_archive_all
5317: WHERE po_release_id = p_doc_id;
5318:
5319: END IF;
5320: