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_DRAFTS_PVT dependencies on PO_DRAFTS

Line 1: PACKAGE BODY PO_DRAFTS_PVT AS

1: PACKAGE BODY PO_DRAFTS_PVT AS
2: /* $Header: PO_DRAFTS_PVT.plb 120.32 2006/11/21 03:08:36 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_DRAFTS_PVT');

Line 2: /* $Header: PO_DRAFTS_PVT.plb 120.32 2006/11/21 03:08:36 bao noship $ */

1: PACKAGE BODY PO_DRAFTS_PVT AS
2: /* $Header: PO_DRAFTS_PVT.plb 120.32 2006/11/21 03:08:36 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_DRAFTS_PVT');
6:

Line 5: PO_LOG.get_package_base('PO_DRAFTS_PVT');

1: PACKAGE BODY PO_DRAFTS_PVT AS
2: /* $Header: PO_DRAFTS_PVT.plb 120.32 2006/11/21 03:08:36 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_DRAFTS_PVT');
6:
7:
8: -------------------------------------------------------
9: ----------- PRIVATE PROCEDURES PROTOTYPE --------------

Line 46: -- Return next draft id from sequence PO_DRAFTS_S

42: --Pre-reqs: None
43: --Modifies:
44: --Locks:
45: --Function:
46: -- Return next draft id from sequence PO_DRAFTS_S
47: --Parameters:
48: --IN:
49: --IN OUT:
50: --OUT:

Line 62: SELECT PO_DRAFTS_S.nextval

58: RETURN NUMBER IS
59:
60: l_draft_id NUMBER;
61: BEGIN
62: SELECT PO_DRAFTS_S.nextval
63: INTO l_draft_id
64: FROM DUAL;
65:
66: RETURN l_draft_id;

Line 88: -- If 'X', drafts records except for the one in PO_DRAFTS will be removed

84: --p_delete_processed_draft
85: -- indicates whether draft changes should be removed after the process
86: -- If FND_API.G_TRUE, draft records will be removed after the process
87: -- If FND_API.G_FALSE, draft records will retain after the process
88: -- If 'X', drafts records except for the one in PO_DRAFTS will be removed
89: -- after the process
90: --IN OUT:
91: --OUT:
92: --x_return_status

Line 280: -- FND_API.G_TRUE if PO_DRAFTS should be excluded

276: --p_draft_id
277: -- draft unique identifier
278: --p_exclude_ctrl_tbl
279: -- determines whether control table should be excluded from deletion
280: -- FND_API.G_TRUE if PO_DRAFTS should be excluded
281: -- FND_API.G_FALSE if PO_DRAFTS should not be excluded
282: --IN OUT:
283: --OUT:
284: --x_return_status

Line 281: -- FND_API.G_FALSE if PO_DRAFTS should not be excluded

277: -- draft unique identifier
278: --p_exclude_ctrl_tbl
279: -- determines whether control table should be excluded from deletion
280: -- FND_API.G_TRUE if PO_DRAFTS should be excluded
281: -- FND_API.G_FALSE if PO_DRAFTS should not be excluded
282: --IN OUT:
283: --OUT:
284: --x_return_status
285: -- return status of the procedure

Line 367: DELETE FROM po_drafts

363: d_position := 90;
364:
365: IF (NVL(p_exclude_ctrl_tbl, FND_API.G_FALSE) = FND_API.G_FALSE) THEN
366: -- delete draft control table as well
367: DELETE FROM po_drafts
368: WHERE draft_id = p_draft_id;
369: END IF;
370:
371: d_position := 100;

Line 701: FROM po_drafts DFT

697: DFT.owner_role
698: INTO x_draft_id,
699: x_draft_status,
700: x_draft_owner_role
701: FROM po_drafts DFT
702: WHERE DFT.document_id = p_po_header_id
703: AND DFT.status <> g_status_COMPLETED;
704:
705: d_position := 10;

Line 749: l_draft_status PO_DRAFTS.status%TYPE;

745: d_api_name CONSTANT VARCHAR2(30) := 'find_draft';
746: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
747: d_position NUMBER;
748:
749: l_draft_status PO_DRAFTS.status%TYPE;
750: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
751:
752: BEGIN
753: d_position := 0;

Line 750: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;

746: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
747: d_position NUMBER;
748:
749: l_draft_status PO_DRAFTS.status%TYPE;
750: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
751:
752: BEGIN
753: d_position := 0;
754: IF (PO_LOG.d_proc) THEN

Line 805: FROM po_drafts

801: END IF;
802:
803: SELECT request_id
804: INTO x_request_id
805: FROM po_drafts
806: WHERE draft_id = p_draft_id;
807:
808: IF (PO_LOG.d_proc) THEN
809: PO_LOG.proc_end(d_module);

Line 968: l_draft_id PO_DRAFTS.draft_id%TYPE;

964: d_api_name CONSTANT VARCHAR2(30) := 'update_permission_check';
965: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
966: d_position NUMBER;
967:
968: l_draft_id PO_DRAFTS.draft_id%TYPE;
969: l_draft_status PO_DRAFTS.status%TYPE;
970: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
971:
972: l_calling_module VARCHAR2(100);

Line 969: l_draft_status PO_DRAFTS.status%TYPE;

965: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
966: d_position NUMBER;
967:
968: l_draft_id PO_DRAFTS.draft_id%TYPE;
969: l_draft_status PO_DRAFTS.status%TYPE;
970: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
971:
972: l_calling_module VARCHAR2(100);
973: l_upload_in_progress VARCHAR2(1);

Line 970: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;

966: d_position NUMBER;
967:
968: l_draft_id PO_DRAFTS.draft_id%TYPE;
969: l_draft_status PO_DRAFTS.status%TYPE;
970: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
971:
972: l_calling_module VARCHAR2(100);
973: l_upload_in_progress VARCHAR2(1);
974: l_upload_status_code VARCHAR2(30);

Line 975: l_upload_requestor_role PO_DRAFTS.owner_role%TYPE;

971:
972: l_calling_module VARCHAR2(100);
973: l_upload_in_progress VARCHAR2(1);
974: l_upload_status_code VARCHAR2(30);
975: l_upload_requestor_role PO_DRAFTS.owner_role%TYPE;
976: l_upload_requestor_role_id PO_DRAFTS.owner_user_id%TYPE;
977: l_upload_job_number NUMBER;
978: l_upload_status_display VARCHAR2(80);
979:

Line 976: l_upload_requestor_role_id PO_DRAFTS.owner_user_id%TYPE;

972: l_calling_module VARCHAR2(100);
973: l_upload_in_progress VARCHAR2(1);
974: l_upload_status_code VARCHAR2(30);
975: l_upload_requestor_role PO_DRAFTS.owner_role%TYPE;
976: l_upload_requestor_role_id PO_DRAFTS.owner_user_id%TYPE;
977: l_upload_job_number NUMBER;
978: l_upload_status_display VARCHAR2(80);
979:
980: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

Line 1402: l_draft_id PO_DRAFTS.draft_id%TYPE;

1398: d_api_name CONSTANT VARCHAR2(30) := 'unlock_document';
1399: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1400: d_position NUMBER;
1401:
1402: l_draft_id PO_DRAFTS.draft_id%TYPE;
1403: l_draft_status PO_DRAFTS.status%TYPE;
1404: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1405:
1406: l_return_status VARCHAR2(1);

Line 1403: l_draft_status PO_DRAFTS.status%TYPE;

1399: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1400: d_position NUMBER;
1401:
1402: l_draft_id PO_DRAFTS.draft_id%TYPE;
1403: l_draft_status PO_DRAFTS.status%TYPE;
1404: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1405:
1406: l_return_status VARCHAR2(1);
1407:

Line 1404: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;

1400: d_position NUMBER;
1401:
1402: l_draft_id PO_DRAFTS.draft_id%TYPE;
1403: l_draft_status PO_DRAFTS.status%TYPE;
1404: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1405:
1406: l_return_status VARCHAR2(1);
1407:
1408: BEGIN

Line 1429: PO_DRAFTS_PVT.remove_draft_changes

1425: IF (PO_LOG.d_stmt) THEN
1426: PO_LOG.stmt(d_module, d_position, 'need to remove draft changes');
1427: END IF;
1428:
1429: PO_DRAFTS_PVT.remove_draft_changes
1430: ( p_draft_id => l_draft_id,
1431: p_exclude_ctrl_tbl => FND_API.G_FALSE,
1432: x_return_status => l_return_status
1433: );

Line 1776: UPDATE po_drafts

1772: PO_LOG.proc_begin(d_module);
1773: END IF;
1774:
1775: -- for request id, populate only if the draft is being processed by PDOI
1776: UPDATE po_drafts
1777: SET status = p_new_status,
1778: request_id = DECODE (p_new_status,
1779: g_status_PDOI_PROCESSING, l_cur_conc_request_id,
1780: NULL)

Line 1809: l_draft_id PO_DRAFTS.draft_id%TYPE;

1805: d_api_name CONSTANT VARCHAR2(30) := 'pending_changes_exist';
1806: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1807: d_position NUMBER;
1808:
1809: l_draft_id PO_DRAFTS.draft_id%TYPE;
1810: l_draft_status PO_DRAFTS.status%TYPE;
1811: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1812:
1813: l_pending_changes_exist VARCHAR2(1) := FND_API.G_FALSE;

Line 1810: l_draft_status PO_DRAFTS.status%TYPE;

1806: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1807: d_position NUMBER;
1808:
1809: l_draft_id PO_DRAFTS.draft_id%TYPE;
1810: l_draft_status PO_DRAFTS.status%TYPE;
1811: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1812:
1813: l_pending_changes_exist VARCHAR2(1) := FND_API.G_FALSE;
1814: BEGIN

Line 1811: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;

1807: d_position NUMBER;
1808:
1809: l_draft_id PO_DRAFTS.draft_id%TYPE;
1810: l_draft_status PO_DRAFTS.status%TYPE;
1811: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1812:
1813: l_pending_changes_exist VARCHAR2(1) := FND_API.G_FALSE;
1814: BEGIN
1815:

Line 2032: l_draft_id PO_DRAFTS.draft_id%TYPE;

2028: d_api_name CONSTANT VARCHAR2(30) := 'is_pending_buyer_acceptance';
2029: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2030: d_position NUMBER;
2031:
2032: l_draft_id PO_DRAFTS.draft_id%TYPE;
2033: l_draft_status PO_DRAFTS.status%TYPE;
2034: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
2035:
2036: l_pending_acceptance VARCHAR2(1) := FND_API.G_FALSE;

Line 2033: l_draft_status PO_DRAFTS.status%TYPE;

2029: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2030: d_position NUMBER;
2031:
2032: l_draft_id PO_DRAFTS.draft_id%TYPE;
2033: l_draft_status PO_DRAFTS.status%TYPE;
2034: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
2035:
2036: l_pending_acceptance VARCHAR2(1) := FND_API.G_FALSE;
2037: BEGIN

Line 2034: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;

2030: d_position NUMBER;
2031:
2032: l_draft_id PO_DRAFTS.draft_id%TYPE;
2033: l_draft_status PO_DRAFTS.status%TYPE;
2034: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
2035:
2036: l_pending_acceptance VARCHAR2(1) := FND_API.G_FALSE;
2037: BEGIN
2038:

Line 3122: -- delete_draft = 'X' means that the PO_DRAFTS table should be

3118: IF (PO_LOG.d_proc) THEN
3119: PO_LOG.proc_begin(d_module);
3120: END IF;
3121:
3122: -- delete_draft = 'X' means that the PO_DRAFTS table should be
3123: -- excluded from deletion. We should just mark it as 'COMPLETED'
3124:
3125: IF (p_delete_draft = FND_API.G_FALSE OR
3126: p_delete_draft = 'X') THEN

Line 3293: END PO_DRAFTS_PVT;

3289: );
3290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3291: END update_acceptance_status;
3292:
3293: END PO_DRAFTS_PVT;