APPS.PO_DRAFTS_PVT dependencies on PO_DRAFTS_S

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

180: --Pre-reqs: None
181: --Modifies:
182: --Locks:
183: --Function:
184: -- Return next draft id from sequence PO_DRAFTS_S
185: --Parameters:
186: --IN:
187: --IN OUT:
188: --OUT:

Line 200: SELECT PO_DRAFTS_S.nextval

196: RETURN NUMBER IS
197:
198: l_draft_id NUMBER;
199: BEGIN
200: SELECT PO_DRAFTS_S.nextval
201: INTO l_draft_id
202: FROM DUAL;
203:
204: RETURN l_draft_id;

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

575: --p_draft_id
576: -- draft unique identifier
577: --p_exclude_ctrl_tbl
578: -- determines whether control table should be excluded from deletion
579: -- FND_API.G_TRUE if PO_DRAFTS should be excluded
580: -- FND_API.G_FALSE if PO_DRAFTS should not be excluded
581: --IN OUT:
582: --OUT:
583: --x_return_status

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

576: -- draft unique identifier
577: --p_exclude_ctrl_tbl
578: -- determines whether control table should be excluded from deletion
579: -- FND_API.G_TRUE if PO_DRAFTS should be excluded
580: -- FND_API.G_FALSE if PO_DRAFTS should not be excluded
581: --IN OUT:
582: --OUT:
583: --x_return_status
584: -- return status of the procedure

Line 1111: l_draft_status PO_DRAFTS.status%TYPE;

1107: d_api_name CONSTANT VARCHAR2(30) := 'find_draft';
1108: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1109: d_position NUMBER;
1110:
1111: l_draft_status PO_DRAFTS.status%TYPE;
1112: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1113:
1114: BEGIN
1115: d_position := 0;

Line 1331: l_draft_status PO_DRAFTS.status%TYPE;

1327: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1328: d_position NUMBER;
1329:
1330: l_draft_id PO_DRAFTS.draft_id%TYPE;
1331: l_draft_status PO_DRAFTS.status%TYPE;
1332: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1333:
1334: l_calling_module VARCHAR2(100);
1335: l_upload_in_progress VARCHAR2(1);

Line 1805: l_draft_status PO_DRAFTS.status%TYPE;

1801: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1802: d_position NUMBER;
1803:
1804: l_draft_id PO_DRAFTS.draft_id%TYPE;
1805: l_draft_status PO_DRAFTS.status%TYPE;
1806: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
1807:
1808: l_return_status VARCHAR2(1);
1809:

Line 2214: --l_draft_status PO_DRAFTS.status%TYPE;

2210: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2211: d_position NUMBER;
2212:
2213: --l_draft_id PO_DRAFTS.draft_id%TYPE;
2214: --l_draft_status PO_DRAFTS.status%TYPE;
2215: --l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
2216:
2217: l_pending_changes_exist VARCHAR2(1) := FND_API.G_FALSE;
2218: BEGIN

Line 2472: l_draft_status PO_DRAFTS.status%TYPE;

2468: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2469: d_position NUMBER;
2470:
2471: l_draft_id PO_DRAFTS.draft_id%TYPE;
2472: l_draft_status PO_DRAFTS.status%TYPE;
2473: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
2474:
2475: l_pending_acceptance VARCHAR2(1) := FND_API.G_FALSE;
2476: BEGIN