[Home] [Help]
240: --IN:
241: --p_multi_mod_requests
242: -- po_multi_mod_requests table data for validation
243: --p_multi_mod_docs
244: -- po_multi_mod_docs table data for validation
245: --p_multi_mod_changes
246: -- po_multi_mod_changes table data for validation
247: --p_validation_type
248: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
267: l_clm_noofcopies PO_MULTI_MOD_REQUESTS.clm_noofcopies%TYPE;
268: l_exemption_reason PO_MULTI_MOD_REQUESTS.exemption_reason%TYPE;
269: l_initiate_approval_flag PO_MULTI_MOD_REQUESTS.initiate_approval_flag%TYPE;
270: l_clm_contract_officer PO_MULTI_MOD_REQUESTS.clm_contract_officer%TYPE;
271: l_multi_mod_docs PO_MULTI_MOD_DOCS_VAL_TYPE ;
272: l_multi_mod_changes PO_MULTI_MOD_CHANGES_VAL_TYPE;
273: d_mod CONSTANT VARCHAR2(100) := D_validate_multi_mod;
274: d_position NUMBER := 0;
275:
343: PO_LOG.stmt(d_mod,d_position,'l_initiate_approval_flag',l_initiate_approval_flag);
344: PO_LOG.stmt(d_mod,d_position,'l_clm_contract_officer',l_clm_contract_officer);
345: END IF;
346:
347: --populate po_multi_mod_docs records into p_multi_mod_docs object type
348: d_position := 40;
349: BEGIN
350: SELECT multi_mod_doc_id
351: ,multi_mod_request_id
357: ,l_multi_mod_docs.multi_mod_request_id
358: ,l_multi_mod_docs.document_id
359: ,l_multi_mod_docs.status
360: ,l_multi_mod_docs.draft_id
361: FROM po_multi_mod_docs
362: WHERE multi_mod_request_id = p_multi_mod_request_id;
363: EXCEPTION
364: WHEN OTHERS THEN
365: null;
516: -- Specifies the validations to perform.
517: --p_multi_mod_requests
518: -- po_multi_mod_requests table data for validation
519: --p_multi_mod_docs
520: -- po_multi_mod_docs table data for validation
521: --p_multi_mod_changes
522: -- po_multi_mod_changes table data for validation
523: --p_validation_type
524: -- Parameter to identify if the validations are 'pre-submit' or 'concurrent'
538: ,p_clm_noofcopies IN NUMBER
539: ,p_exemption_reason IN VARCHAR2
540: ,p_initiate_approval_flag IN VARCHAR2
541: ,p_clm_contract_officer IN NUMBER
542: ,p_multi_mod_docs IN PO_MULTI_MOD_DOCS_VAL_TYPE
543: ,p_multi_mod_changes IN PO_MULTI_MOD_CHANGES_VAL_TYPE
544: ,p_validation_type IN VARCHAR2
545: ,x_result_type OUT NOCOPY VARCHAR2
546: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
2772:
2773: SELECT pmmd.document_id, pha.clm_document_number, pd.modification_number
2774: BULK COLLECT INTO l_document_id_tbl, l_document_num_tbl, l_modification_num_tbl
2775: FROM po_entity_locks pel,
2776: po_multi_mod_docs pmmd,
2777: po_headers_all pha,
2778: po_doc_style_headers pdsh,
2779: po_drafts pd
2780: WHERE pmmd.multi_mod_request_id = p_request_id
2892: l_sum_check_tbl
2893: FROM po_headers_all_ext_b ext,
2894: po_multi_mod_requests multimod,
2895: po_entity_locks pel,
2896: po_multi_mod_docs pmmd,
2897: po_headers_all pha,
2898: po_doc_style_headers pdsh,
2899: po_drafts pd
2900: WHERE ext.po_header_id = multimod.uda_key_po_header_id
2991:
2992: --collect all document_ids which are being updated
2993: SELECT pha.clm_document_number
2994: BULK COLLECT INTO l_document_num_tbl
2995: FROM po_multi_mod_docs pmmd,
2996: po_headers_all pha,
2997: po_doc_style_headers pdsh
2998: WHERE pmmd.multi_mod_request_id = p_request_id
2999: AND pmmd.document_id = pha.po_header_id
3109: BULK COLLECT INTO l_document_id_tbl
3110: ,l_document_number_tbl
3111: ,l_related_document_id_tbl
3112: ,l_related_doc_number_tbl
3113: FROM po_multi_mod_docs pmmd_a,/*current set of documents being validated*/
3114: po_headers_all ph_a, /*current document joined to headers, filtered by BLANKET/CONTRACT*/
3115: po_headers_all ph_e /*list of execution documents tied to the agreement*/
3116: WHERE pmmd_a.document_id = ph_a.po_header_id
3117: AND pmmd_a.multi_mod_request_id = p_request_id
3119: AND ph_e.clm_source_document_id = ph_a.po_header_id
3120: AND NVL(ph_e.closed_code,'OPEN') <> 'FINALLY CLOSED'
3121: AND NVL(ph_e.authorization_status,'INCOMPLETE') = 'APPROVED'
3122: AND ph_e.po_header_id NOT IN /*Subquery to retrieve all the documents in current batch*/
3123: (SELECT pmmd_e.document_id FROM po_multi_mod_docs pmmd_e WHERE pmmd_e.multi_mod_request_id = p_request_id );
3124:
3125: FOR i IN 1..l_document_id_tbl.COUNT LOOP
3126: d_position := 30;
3127: x_results.add_result(
3235: BULK COLLECT INTO l_document_id_tbl
3236: ,l_document_number_tbl
3237: ,l_related_document_id_tbl
3238: ,l_related_doc_number_tbl
3239: FROM po_multi_mod_docs pmmd_e,
3240: po_headers_all ph_e,
3241: po_headers_all ph_a
3242: WHERE pmmd_e.multi_mod_request_id = p_request_id
3243: AND ph_e.po_header_id = pmmd_e.document_id
3243: AND ph_e.po_header_id = pmmd_e.document_id
3244: AND ph_e.type_lookup_code = 'STANDARD'
3245: AND ph_e.clm_source_document_id = ph_a.po_header_id
3246: AND ph_e.clm_source_document_id IS NOT NULL
3247: AND ph_e.clm_source_document_id NOT IN (SELECT pmmd_a.document_id FROM po_multi_mod_docs pmmd_a WHERE pmmd_a.multi_mod_request_id = p_request_id);
3248:
3249: FOR i IN 1..l_document_id_tbl.COUNT LOOP
3250: d_position := 30;
3251:
4534: --Start of Comments
4535: --Name: set_validation_status
4536: --Pre-reqs: None.
4537: --Function:
4538: -- sets the status of the po_multi_mod_docs
4539: --Parameters:
4540: --IN:
4541: --p_vendor_id
4542: --End of Comments