DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_PVT dependencies on STANDARD

Line 378: -- 4. Default Standard Doc/Standard Form fields

374: --Function:
375: -- 1. Copy UDA Data from Base Document to the new Mod
376: -- 2. Copy Multi-Mod UDA Data from Base document to the new Mod
377: -- 3. Default Document Number for the newly created Mod
378: -- 4. Default Standard Doc/Standard Form fields
379: -- 5. Default AME Data
380: -- 6. Update PO_DRAFTS/ PO_DRAFT_HEADERS_ALL with the Multi-Mod data and other defaults
381: -- 7. Copy Contract terms to the new Mod
382: --Parameters:

Line 435: l_standard_form po_headers_all.clm_standard_form%TYPE;

431:
432: l_record_already_exists VARCHAR2(1);
433: l_clm_source_document_id NUMBER;
434: l_doc_number po_drafts.modification_number%TYPE;
435: l_standard_form po_headers_all.clm_standard_form%TYPE;
436: l_document_format po_headers_all.clm_document_format%TYPE;
437: l_ame_transaction_type po_headers_all.ame_transaction_type%TYPE;
438: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;
439: l_clm_default_dist VARCHAR2(1);

Line 585: debug(d_module, d_position, 'Fetch defaults for CLM Standard Form and CLM Document Format');

581:
582: END IF; --IF check_uda_enabled(p_po_header_id)
583:
584: d_position := 50;
585: debug(d_module, d_position, 'Fetch defaults for CLM Standard Form and CLM Document Format');
586:
587: l_print_doc_type := 'PO_MOD_STD_FORM';
588:
589: -- Getting Standard Form and Document Format of the output document

Line 589: -- Getting Standard Form and Document Format of the output document

585: debug(d_module, d_position, 'Fetch defaults for CLM Standard Form and CLM Document Format');
586:
587: l_print_doc_type := 'PO_MOD_STD_FORM';
588:
589: -- Getting Standard Form and Document Format of the output document
590: BEGIN
591: --Default the standard_form and document_format
592: SELECT standard_form,
593: document_format

Line 591: --Default the standard_form and document_format

587: l_print_doc_type := 'PO_MOD_STD_FORM';
588:
589: -- Getting Standard Form and Document Format of the output document
590: BEGIN
591: --Default the standard_form and document_format
592: SELECT standard_form,
593: document_format
594: INTO l_standard_form,
595: l_document_format

Line 592: SELECT standard_form,

588:
589: -- Getting Standard Form and Document Format of the output document
590: BEGIN
591: --Default the standard_form and document_format
592: SELECT standard_form,
593: document_format
594: INTO l_standard_form,
595: l_document_format
596: FROM po_print_form_formats

Line 594: INTO l_standard_form,

590: BEGIN
591: --Default the standard_form and document_format
592: SELECT standard_form,
593: document_format
594: INTO l_standard_form,
595: l_document_format
596: FROM po_print_form_formats
597: WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
598: AND default_flag = 'Y'

Line 606: SELECT standard_form,

602: EXCEPTION
603: WHEN No_Data_Found THEN
604: BEGIN
605: -- If default not available, use the first as default
606: SELECT standard_form,
607: document_format
608: INTO l_standard_form,
609: l_document_format
610: FROM po_print_form_formats

Line 608: INTO l_standard_form,

604: BEGIN
605: -- If default not available, use the first as default
606: SELECT standard_form,
607: document_format
608: INTO l_standard_form,
609: l_document_format
610: FROM po_print_form_formats
611: WHERE NVL(inactive_date, SYSDATE+1) > SYSDATE
612: AND style_id = p_style_id

Line 618: l_standard_form := NULL;

614: AND rownum =1;
615:
616: EXCEPTION
617: WHEN No_Data_Found THEN
618: l_standard_form := NULL;
619: l_document_format := NULL;
620: WHEN OTHERS THEN
621: l_standard_form := NULL;
622: l_document_format := NULL;

Line 621: l_standard_form := NULL;

617: WHEN No_Data_Found THEN
618: l_standard_form := NULL;
619: l_document_format := NULL;
620: WHEN OTHERS THEN
621: l_standard_form := NULL;
622: l_document_format := NULL;
623: END;
624: WHEN OTHERS THEN
625: l_standard_form := NULL;

Line 625: l_standard_form := NULL;

621: l_standard_form := NULL;
622: l_document_format := NULL;
623: END;
624: WHEN OTHERS THEN
625: l_standard_form := NULL;
626: l_document_format := NULL;
627: END;
628:
629: d_position := 55;

Line 656: clm_standard_form = l_standard_form,

652: debug(d_module, d_position, 'Update PO_DRAFTS with the Mod-specific defaults and Multi-mod fields', FND_API.G_TRUE);
653:
654: UPDATE po_drafts
655: SET modification_number = l_doc_number,
656: clm_standard_form = l_standard_form,
657: clm_document_format = l_document_format,
658: mod_effective_date = p_multi_mod_request_record.mod_effective_date,
659: clm_noofcopies = p_multi_mod_request_record.clm_noofcopies,
660: clm_contract_officer = p_multi_mod_request_record.clm_contract_officer,

Line 1589: -- XML delivery only applies to Standard POs and Blanket Releases

1585: PO_LOG.proc_begin(d_module,'p_vendor_contact_id',p_vendor_contact_id);
1586: END IF;
1587:
1588: -- Query setup to get the XML_FLAG default
1589: -- XML delivery only applies to Standard POs and Blanket Releases
1590: IF (p_doc_sub_type = 'STANDARD') THEN
1591:
1592: d_position := 10;
1593: debug(d_module, d_position, 'Query setup to get the XML_FLAG default');

Line 1590: IF (p_doc_sub_type = 'STANDARD') THEN

1586: END IF;
1587:
1588: -- Query setup to get the XML_FLAG default
1589: -- XML delivery only applies to Standard POs and Blanket Releases
1590: IF (p_doc_sub_type = 'STANDARD') THEN
1591:
1592: d_position := 10;
1593: debug(d_module, d_position, 'Query setup to get the XML_FLAG default');
1594:

Line 1615: END IF;-- IF (l_doc_subtype = 'STANDARD')

1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_xml_flag := 'N';
1614: END;
1615: END IF;-- IF (l_doc_subtype = 'STANDARD')
1616:
1617: -- Query setup to get the EDI Flag
1618: d_position := 20;
1619: debug(d_module, d_position, 'Query setup to get the EDI_FLAG default');

Line 2416: IF (l_headers_draft_rec.type_lookup_code = 'STANDARD') THEN

2412: WHERE po_header_id = p_po_header_id
2413: AND draft_id = p_draft_id;
2414:
2415: -- Derive Document Type Code
2416: IF (l_headers_draft_rec.type_lookup_code = 'STANDARD') THEN
2417: l_doc_type_code := 'PO';
2418: ELSE
2419: l_doc_type_code := 'PA';
2420: END IF;