APPS.PO_MOD_CONTROL_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 54: update po_headers_draft_all

50:
51: d_position := 50;
52: -- If return status success, then go ahead
53:
54: update po_headers_draft_all
55: set control_action = p_action
56: where draft_id = p_draft_id;
57:
58: d_position := 60;

Line 87: l_po_header_id po_headers_draft_all.po_header_id%TYPE;

83: d_api_name CONSTANT VARCHAR2(30) := 'process_mod_withdraw_action';
84: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
85: d_position NUMBER;
86: l_conterms_exist_flag VARCHAR2(1);
87: l_po_header_id po_headers_draft_all.po_header_id%TYPE;
88: l_type_lookup_code po_headers_draft_all.type_lookup_code%TYPE;
89: l_contract_document_type VARCHAR2(30);
90: x_return_status VARCHAR2 (1) ;
91: x_msg_count NUMBER;

Line 88: l_type_lookup_code po_headers_draft_all.type_lookup_code%TYPE;

84: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
85: d_position NUMBER;
86: l_conterms_exist_flag VARCHAR2(1);
87: l_po_header_id po_headers_draft_all.po_header_id%TYPE;
88: l_type_lookup_code po_headers_draft_all.type_lookup_code%TYPE;
89: l_contract_document_type VARCHAR2(30);
90: x_return_status VARCHAR2 (1) ;
91: x_msg_count NUMBER;
92: x_msg_data VARCHAR2(100) ;

Line 125: FROM po_headers_draft_all

121:
122: -- Release OKC locks
123: SELECT NVL (l_conterms_exist_flag, 'N'), po_header_id, type_lookup_code
124: INTO l_conterms_exist_flag, l_po_header_id, l_type_lookup_code
125: FROM po_headers_draft_all
126: WHERE draft_id = p_draft_id;
127:
128: IF l_conterms_exist_flag = 'Y' THEN
129: l_contract_document_type :=

Line 293: FROM po_headers_draft_all phd, po_requisition_headers_all prh

289: last_update_login = FND_GLOBAL.LOGIN_ID
290: WHERE par_line_id IS NULL
291: AND clm_info_flag = 'Y'
292: AND par_draft_id = ( SELECT phd.draft_id
293: FROM po_headers_draft_all phd, po_requisition_headers_all prh
294: WHERE phd.mod_draft_id = p_draft_id
295: AND prh.requisition_header_id = prl.requisition_header_id
296: AND Nvl(prh.par_flag, 'N') = 'Y'
297: );

Line 319: l_type_lookup_code PO_HEADERS_DRAFT_ALL.type_lookup_code%type;

315: d_position NUMBER;
316: l_contract_document_type VARCHAR2(20);
317: l_po_header_id NUMBER;
318: l_conterms_exist_flag VARCHAR2(1);
319: l_type_lookup_code PO_HEADERS_DRAFT_ALL.type_lookup_code%type;
320: l_functional_area_code VARCHAR2(500);
321: l_document_style_id NUMBER;
322: l_uda_enabled_flag VARCHAR2(5);
323: l_errorcode VARCHAR2(50);

Line 392: FROM po_headers_draft_all

388: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID,
389: nvl(conterms_exist_flag, 'N'), po_header_id, type_lookup_code
390: INTO l_functional_area_code, l_type_lookup_code,
391: l_document_style_id, l_conterms_exist_flag, l_po_header_id, l_type_lookup_code
392: FROM po_headers_draft_all
393: WHERE draft_id = p_draft_id;
394:
395: PO_CLM_CLO_UTIL.check_po_uda_enabled(
396: p_document_type_code => l_type_lookup_code,