[Home] [Help]
35: l_progress VARCHAR2 (3) := '000';
36: x_create_doc_flag VARCHAR2 (1);
37: l_return_status VARCHAR2 (1);
38: l_doc_row doc_row_type;
39: x_document_num po_headers_all.clm_document_number%TYPE; --
41: x_bid_number NUMBER;
42: l_msg_data VARCHAR2 (2000);
43: l_msg_count NUMBER;
55: x_msg_count NUMBER;
56: x_msg_data VARCHAR2(2000);
57:
58: l_draft_id NUMBER;
59: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;
60: l_ame_transaction_type po_headers_all.ame_transaction_type%TYPE;
61: l_create_doc_from_draft VARCHAR2(1);
62:
63: l_uda_template_exception EXCEPTION;
56: x_msg_data VARCHAR2(2000);
57:
58: l_draft_id NUMBER;
59: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;
60: l_ame_transaction_type po_headers_all.ame_transaction_type%TYPE;
61: l_create_doc_from_draft VARCHAR2(1);
62:
63: l_uda_template_exception EXCEPTION;
64: l_default_doc_number_exception EXCEPTION;
66: l_is_ord_off_idv VARCHAR2(2);
67: l_print_doc_type VARCHAR2(2000);
68: l_standard_form VARCHAR2(200);
69: l_document_format VARCHAR2(200);
70: l_authorization_status po_headers_all.AUTHORIZATION_STATUS%TYPE; /*bug 12611018*/
71: l_clm_default_dist VARCHAR2(1);
72: l_clm_mipr_type VARCHAR2(15);
73: l_clm_contract_fin_code VARCHAR2(30);
74: l_umbrella_program_id NUMBER ;
133: should be PO_UDA_ADDRESS_TYPES. When modification is created from BWC, award related address fields
134: have value PO_UDA_ADDRESS_TYPES.
135: */
136:
137: UPDATE po_headers_all_ext_b
138: SET c_ext_attr40 = 'PO_UDA_ADDRESS_TYPES'
139: WHERE po_header_id = po_autocreate_params.g_po_header_id
140: AND draft_id = -1
141: AND c_ext_attr39 NOT IN ('MOD_ADMIN_OFFICE', 'MOD_ISSUING_OFFICE')
179: SELECT umbrella_program_id,
180: clm_contract_finance_code
181: INTO l_umbrella_program_id,
182: l_clm_contract_fin_code
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
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
209: AND PO_AUTOCREATE_PARAMS.g_document_type <> 'PA'; --Bug 13787095
325: BEGIN
326:
327: select authorization_status
328: INTO l_authorization_status
329: FROM po_headers_all
330: WHERE po_header_id = PO_AUTOCREATE_PARAMS.g_po_header_id;
331:
332: EXCEPTION
333: WHEN No_Data_Found THEN
530: END IF;
531:
532: SELECT mod_ame_transaction_type
533: INTO l_ame_transaction_type
534: FROM po_doc_style_headers pdsh, po_headers_all pha
535: WHERE pha.po_header_id = l_doc_row.po_header_id
536: AND pha.style_id = pdsh.style_id;
537:
538: --
690: l_clm_mipr_type := POR_UTIL_PKG.G_REQ_TYPE;
691: IF Nvl(l_clm_mipr_type,'PR') = 'MIPR' AND l_draft_id = -1
692: THEN
693:
694: UPDATE po_headers_all
695: SET CLM_SPECIAL_CONTRACT_TYPE = 'OBLIGATION_DOC'
696: WHERE po_header_id = po_autocreate_params.g_po_header_id;
697:
698: PO_CLM_CAR_UTIL.car_for_control_type
843:
844:
845: SELECT pdsh.ame_transaction_type
846: INTO l_ame_transaction_type
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
1710: END IF;
1711:
1712: SELECT 'N'
1713: INTO x_create_doc_flag
1714: FROM po_headers_all poh, po_doc_style_headers pdsh
1715: WHERE poh.po_header_id = p_po_header_id
1716: AND poh.style_id = pdsh.style_id
1717: AND poh.approved_flag = 'Y'
1718: AND pdsh.change_process_type = 'MODIFICATION';