APPS.PO_DRAFTS_PVT dependencies on PO_DRAFTS_S

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 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 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 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 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 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 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