APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 52: x_clm_source_document_id PO_HEADERS_DRAFT_ALL.clm_source_document_id%TYPE;

48: x_return_status VARCHAR2(50);
49: x_err_msg VARCHAR2(2000);
50: x_template_id NUMBER;
51: x_dodaac VARCHAR2(150);
52: x_clm_source_document_id PO_HEADERS_DRAFT_ALL.clm_source_document_id%TYPE;
53:
54: x_errorcode NUMBER;
55: x_msg_count NUMBER;
56: x_msg_data VARCHAR2(2000);

Line 187: UPDATE po_headers_draft_all

183: FROM po_headers_all
184: WHERE po_header_id =po_autocreate_params.g_clm_source_document_id;
185:
186: -- Bug 10057141: Removed the additional WHERE condition
187: UPDATE po_headers_draft_all
188: SET clm_source_document_id = po_autocreate_params.g_clm_source_document_id,
189: /*umbrella program changes*/
190: umbrella_program_id = nvl(umbrella_program_id,l_umbrella_program_id),
191: /*umbrella program changes*/

Line 204: FROM po_headers_draft_all phda,

200: BEGIN
201:
202: SELECT phda.clm_source_document_id
203: INTO x_clm_source_document_id
204: FROM po_headers_draft_all phda,
205: po_headers_all pha
206: WHERE phda.po_header_id = l_doc_row.po_header_id
207: AND pha.po_header_id = phda.clm_source_document_id
208: AND pha.clm_award_type IS NOT NULL

Line 314: UPDATE po_headers_draft_all

310: p_org_id => po_autocreate_params.g_purchasing_ou_id
311: );
312: END IF;
313:
314: UPDATE po_headers_draft_all
315: SET segment1 = x_document_num,
316: clm_document_number = x_doc_number
317: WHERE po_header_id = l_doc_row.po_header_id;
318:

Line 406: --FROM po_headers_draft_all

402: --Document is an Order Off IDV if the award type is either BPA Call or Delivery Order
403:
404: --SELECT nvl2(clm_source_document_id, 'Y', nvl2(clm_external_idv, 'Y', 'N'))
405: --INTO l_is_ord_off_idv
406: --FROM po_headers_draft_all
407: --WHERE po_header_id = l_doc_row.po_header_id
408: --AND draft_id = l_doc_row.draft_id;
409:
410: SELECT Decode(Nvl(clm_award_type,'*'),

Line 415: FROM po_headers_draft_all

411: 'DELIVERY_ORD', 'Y',
412: 'BPA_CALL', 'Y',
413: 'N')
414: INTO l_is_ord_off_idv
415: FROM po_headers_draft_all
416: WHERE po_header_id = l_doc_row.po_header_id
417: AND draft_id = l_doc_row.draft_id;
418: --
419:

Line 495: UPDATE po_headers_draft_all

491: p_style_id => l_doc_row.po_style_id,
492: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);
493: --
494:
495: UPDATE po_headers_draft_all
496: SET clm_standard_form = l_standard_form,
497: clm_document_format = l_document_format,
498: clm_default_dist_flag = l_clm_default_dist
499: WHERE po_header_id = l_doc_row.po_header_id;

Line 546: UPDATE po_headers_draft_all

542: p_style_id => l_doc_row.po_style_id,
543: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);
544: --
545:
546: UPDATE po_headers_draft_all
547: SET ame_approval_id = l_ame_approval_id,
548: ame_transaction_type = l_ame_transaction_type,
549: clm_default_dist_flag = l_clm_default_dist
550: WHERE po_header_id = l_doc_row.po_header_id

Line 851: UPDATE po_headers_draft_all

847: FROM po_doc_style_headers pdsh, po_headers_all pha
848: WHERE pha.po_header_id = l_doc_row.po_header_id
849: AND pha.style_id = pdsh.style_id;
850:
851: UPDATE po_headers_draft_all
852: SET ame_approval_id = l_ame_approval_id,
853: ame_transaction_type = l_ame_transaction_type
854: WHERE po_header_id = l_doc_row.po_header_id
855: AND draft_id = l_doc_row.draft_id;

Line 2488: UPDATE po_headers_draft_all

2484:
2485: /* bug 10202181 : After autocreating the PO ,
2486: the UDA_TEMPLATE_DATE was getting stamped with
2487: null value, now stamping it with sysdate*/
2488: UPDATE po_headers_draft_all
2489: SET uda_template_id = l_header_uda_tmpl_id
2490: , uda_template_date = sysdate -- bug 10202181
2491: WHERE po_header_id = po_autocreate_params.g_po_header_id
2492: AND draft_id = po_autocreate_params.g_draft_id;