APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on PO_DRAFTS

Line 1209: x_draft_id PO_DRAFTS.draft_id%TYPE;

1205: IS
1206:
1207: l_progress VARCHAR2(3) := '000';
1208: l_api_name CONSTANT VARCHAR2(30) := 'merge_to_headers_draft';
1209: x_draft_id PO_DRAFTS.draft_id%TYPE;
1210: l_draft_type VARCHAR2(3) := NULL; --bug 16425245
1211: l_create_doc_from_draft VARCHAR2(1) := 'Y'; --bug 16425245
1212:
1213: BEGIN

Line 1234: -- Update the PO drafts

1230: PO_AUTOCREATE_PARAMS.g_is_mod_exists := TRUE;
1231: -- Use the existing draft
1232: x_headers.draft_id := PO_AUTOCREATE_PARAMS.g_draft_id;
1233:
1234: -- Update the PO drafts
1235: UPDATE po_drafts
1236: SET last_update_date = x_headers.last_update_date,
1237: last_updated_by = x_headers.last_updated_by,
1238: created_by = x_headers.created_by,

Line 1235: UPDATE po_drafts

1231: -- Use the existing draft
1232: x_headers.draft_id := PO_AUTOCREATE_PARAMS.g_draft_id;
1233:
1234: -- Update the PO drafts
1235: UPDATE po_drafts
1236: SET last_update_date = x_headers.last_update_date,
1237: last_updated_by = x_headers.last_updated_by,
1238: created_by = x_headers.created_by,
1239: last_update_login = x_headers.last_update_login

Line 1267: x_headers.draft_id := PO_DRAFTS_PVT.draft_id_nextval;

1263: END IF;
1264: -- bug 16425245
1265:
1266: -- Get the new Draft Id
1267: x_headers.draft_id := PO_DRAFTS_PVT.draft_id_nextval;
1268: po_autocreate_params.g_draft_id := x_headers.draft_id;
1269: -- Indicates Draft exists for that document
1270: PO_AUTOCREATE_PARAMS.g_is_mod_exists := FALSE;
1271:

Line 1280: INTO po_drafts

1276: -- If draft not exists then create a new entry in drafts and headers
1277: -- draft table.
1278: -- Insert into Draft table
1279: INSERT
1280: INTO po_drafts
1281: (
1282: draft_id,
1283: document_id,
1284: revision_num,

Line 1580: x_headers.draft_id := PO_DRAFTS_PVT.draft_id_nextval;

1576: ELSE -- g_mode = 'NEW'
1577:
1578: l_progress := '060';
1579: -- Get the new Draft Id
1580: x_headers.draft_id := PO_DRAFTS_PVT.draft_id_nextval;
1581: po_autocreate_params.g_draft_id := x_headers.draft_id;
1582: PO_FED_FIELD_FUNCTIONS.XPD_DRAFT_ID := x_headers.draft_id; --Bug 11894977
1583: -- Indecates Draft exists for that document
1584: PO_AUTOCREATE_PARAMS.g_is_mod_exists := FALSE;

Line 1593: INTO po_drafts

1589: -- Create a new entry in drafts and headers draft table
1590: -- for new document
1591: -- Insert into Draft table
1592: INSERT
1593: INTO po_drafts
1594: (
1595: draft_id,
1596: document_id,
1597: revision_num,