APPS.PO_DRAFT_MERGE_PKG dependencies on PO_DRAFTS

Line 333: UPDATE po_drafts

329: SET approved_date = sysdate
330: WHERE draft_id = p_draft_id
331: AND po_header_id = p_document_id;
332:
333: UPDATE po_drafts
334: SET mod_effective_date = sysdate
335: WHERE draft_id = p_draft_id
336: AND mod_effective_date is NULL;
337:

Line 719: l_draft_id PO_DRAFTS.draft_id%TYPE;

715: funcmode in varchar2,
716: resultout out NOCOPY varchar2
717: )
718: is
719: l_draft_id PO_DRAFTS.draft_id%TYPE;
720: cursor control_action_line_c is
721: select nvl(pld.control_action, 'NULL') as control_action,
722: pld.po_line_id as po_line_id
723: from po_headers_draft_all phd,

Line 773: po_drafts pd

769: l_control_Action,
770: p_document_id,
771: l_date
772: from po_headers_draft_all phd,
773: po_drafts pd
774: where phd.draft_id = l_draft_id
775: and phd.draft_id = pd.draft_id;
776:
777: if (v_type_code in ('STANDARD','PLANNED')) then

Line 1044: PO_DRAFTS_PVT.TRANSFER_DRAFT_TO_TXN(

1040: p_mode => 'MERGE', --
1041: x_return_status => l_return_status);
1042: -- Bug 14277142 : Adding parameter p_caller => 'MERGE' so that ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index
1043: -- done as a part of bug fix is not called.
1044: PO_DRAFTS_PVT.TRANSFER_DRAFT_TO_TXN(
1045: p_api_version => 1.0,
1046: p_init_msg_list => FND_API.G_TRUE ,
1047: p_draft_id => p_draft_id,
1048: p_po_header_id => P_Document_Id,

Line 1128: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DRAFTS_PVT.update_revnum_headers_ext';

1124: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous: Merge Successful';
1125: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1126: End If;
1127:
1128: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DRAFTS_PVT.update_revnum_headers_ext';
1129: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1130: PO_DRAFTS_PVT.update_revnum_headers_ext(p_draft_id =>p_draft_id,
1131: p_po_header_id =>P_Document_Id);
1132:

Line 1130: PO_DRAFTS_PVT.update_revnum_headers_ext(p_draft_id =>p_draft_id,

1126: End If;
1127:
1128: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_DRAFTS_PVT.update_revnum_headers_ext';
1129: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);
1130: PO_DRAFTS_PVT.update_revnum_headers_ext(p_draft_id =>p_draft_id,
1131: p_po_header_id =>P_Document_Id);
1132:
1133: END IF;
1134: --End Mod Commercialization

Line 1408: FROM po_drafts

1404:
1405: BEGIN
1406: SELECT 'Y'
1407: INTO l_is_mod_document
1408: FROM po_drafts
1409: WHERE draft_id = l_draft_id
1410: AND draft_type = 'MOD';
1411: EXCEPTION
1412: WHEN No_Data_Found THEN

Line 1814: --Set authorization status to approved in po_drafts

1810: l_sequence_num NUMBER;
1811: l_object_rev_num NUMBER;
1812: l_approval_path_id NUMBER;
1813: BEGIN
1814: --Set authorization status to approved in po_drafts
1815: UPDATE PO_DRAFTS
1816: SET status = 'COMPLETED'
1817: WHERE draft_id = p_draft_id;
1818: -- Set draft_line_status as well.

Line 1815: UPDATE PO_DRAFTS

1811: l_object_rev_num NUMBER;
1812: l_approval_path_id NUMBER;
1813: BEGIN
1814: --Set authorization status to approved in po_drafts
1815: UPDATE PO_DRAFTS
1816: SET status = 'COMPLETED'
1817: WHERE draft_id = p_draft_id;
1818: -- Set draft_line_status as well.
1819: UPDATE PO_LINES_DRAFT_ALL

Line 2043: FROM po_headers_all pha, po_drafts pd

2039: ELSE
2040:
2041: SELECT pd.MOD_EFFECTIVE_DATE
2042: INTO l_effective_date
2043: FROM po_headers_all pha, po_drafts pd
2044: WHERE pha.po_header_id = p_document_id
2045: AND pha.po_header_id = pd.document_id
2046: AND pd.draft_id = p_draft_id;
2047: