APPS.PO_MOD_CONTROL_PVT dependencies on PO_DRAFTS

Line 29: -- Call PO_DRAFTS_PVT.remove_draft_changes to remove all draft entries

25: resultout := FND_API.G_RET_STS_SUCCESS;
26:
27: d_position := 10;
28:
29: -- Call PO_DRAFTS_PVT.remove_draft_changes to remove all draft entries
30: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id => p_draft_id,
31: p_exclude_ctrl_tbl => FND_API.G_TRUE,
32: x_return_status => resultout);
33:

Line 30: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id => p_draft_id,

26:
27: d_position := 10;
28:
29: -- Call PO_DRAFTS_PVT.remove_draft_changes to remove all draft entries
30: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id => p_draft_id,
31: p_exclude_ctrl_tbl => FND_API.G_TRUE,
32: x_return_status => resultout);
33:
34: d_position := 20;

Line 94: l_mod_number po_drafts.modification_number%TYPE;

90: x_return_status VARCHAR2 (1) ;
91: x_msg_count NUMBER;
92: x_msg_data VARCHAR2(100) ;
93: l_item_key_tbl po_tbl_varchar100;
94: l_mod_number po_drafts.modification_number%TYPE;
95: l_item_status varchar2(10);
96: l_result VARCHAR2(10);
97: --bug 15905347 start
98: --l_withdrawn_par_dist_list PO_TBL_NUMBER;

Line 113: PO_DRAFTS_PVT.update_draft_status(p_draft_id,status);

109: END IF;
110: result := FND_API.G_RET_STS_SUCCESS;
111:
112: d_position := 10;
113: PO_DRAFTS_PVT.update_draft_status(p_draft_id,status);
114:
115: --
116: -- Delete locks
117: PO_DRAFT_MERGE_PKG.delete_entity_locks(

Line 147: FROM po_drafts

143:
144: --delete the workflow (notification)process related to this modification
145: SELECT modification_number
146: INTO l_mod_number
147: FROM po_drafts
148: WHERE draft_id = p_draft_id;
149:
150: BEGIN
151: SELECT item_key

Line 329: l_mod_number po_drafts.modification_number%TYPE;

325: l_return_status VARCHAR2(1);
326: l_msg_data VARCHAR2(2000);
327: l_msg_count NUMBER;
328: l_item_key_tbl po_tbl_varchar100;
329: l_mod_number po_drafts.modification_number%TYPE;
330: l_item_status varchar2(10);
331: l_result varchar2(10);
332:
333: l_deleted_line_list PO_TBL_NUMBER;

Line 422: FROM PO_DRAFTS

418: SELECT DECODE(draft_type,
419: 'MOD', 'Y',
420: 'PAR', 'N')
421: INTO l_release_locks_yn
422: FROM PO_DRAFTS
423: WHERE draft_id = p_draft_id;
424:
425: OKC_TERMS_UTIL_GRP.delete_doc
426: ( p_api_version => 1.0

Line 518: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id,FND_API.G_FALSE,result);

514: x_return_status => l_return_status);
515:
516: -- SBCR Integration Code to Delete associated SBCR Records END.
517:
518: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id,FND_API.G_FALSE,result);
519:
520: IF (PO_LOG.d_proc) THEN
521: PO_LOG.proc_end(d_module);
522: END IF;

Line 1327: UPDATE po_drafts

1323: IF(line_status_code IN ('NULL', 'WITHDRAWN')) THEN
1324:
1325: d_position := 140;
1326:
1327: UPDATE po_drafts
1328: SET status = 'WITHDRAWN'
1329: WHERE draft_id = p_draft_id;
1330:
1331: -- Insert In Action History