582: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
583: d_position NUMBER;
584:
585: l_enforce_buyer_name
586: PO_SYSTEM_PARAMETERS.enforce_buyer_name_flag %TYPE;
587: l_enforce_buyer_auth_flag
588: PO_SYSTEM_PARAMETERS.enforce_buyer_authority_flag%TYPE;
589: l_security_structure_id
590: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;
584:
585: l_enforce_buyer_name
586: PO_SYSTEM_PARAMETERS.enforce_buyer_name_flag %TYPE;
587: l_enforce_buyer_auth_flag
588: PO_SYSTEM_PARAMETERS.enforce_buyer_authority_flag%TYPE;
589: l_security_structure_id
590: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;
591: l_rev_sort_ordering
592: FINANCIALS_SYSTEM_PARAMETERS.revision_sort_ordering%TYPE;
586: PO_SYSTEM_PARAMETERS.enforce_buyer_name_flag %TYPE;
587: l_enforce_buyer_auth_flag
588: PO_SYSTEM_PARAMETERS.enforce_buyer_authority_flag%TYPE;
589: l_security_structure_id
590: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;
591: l_rev_sort_ordering
592: FINANCIALS_SYSTEM_PARAMETERS.revision_sort_ordering%TYPE;
593: l_notify_blanket_flag
594: PO_SYSTEM_PARAMETERS.notify_if_blanket_flag%TYPE;
590: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;
591: l_rev_sort_ordering
592: FINANCIALS_SYSTEM_PARAMETERS.revision_sort_ordering%TYPE;
593: l_notify_blanket_flag
594: PO_SYSTEM_PARAMETERS.notify_if_blanket_flag%TYPE;
595: l_budgetary_control_flag
596: GL_SETS_OF_BOOKS.enable_budgetary_control_flag%TYPE;
597: l_user_defined_req_num_code
598: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;
594: PO_SYSTEM_PARAMETERS.notify_if_blanket_flag%TYPE;
595: l_budgetary_control_flag
596: GL_SETS_OF_BOOKS.enable_budgetary_control_flag%TYPE;
597: l_user_defined_req_num_code
598: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;
599: l_rfq_required_flag
600: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;
601: l_manual_req_num_type
602: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
596: GL_SETS_OF_BOOKS.enable_budgetary_control_flag%TYPE;
597: l_user_defined_req_num_code
598: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;
599: l_rfq_required_flag
600: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;
601: l_manual_req_num_type
602: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
603: l_enforce_full_lot_qty
604: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;
598: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;
599: l_rfq_required_flag
600: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;
601: l_manual_req_num_type
602: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
603: l_enforce_full_lot_qty
604: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;
605: l_disposition_warning_flag
606: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;
600: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;
601: l_manual_req_num_type
602: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
603: l_enforce_full_lot_qty
604: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;
605: l_disposition_warning_flag
606: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;
607: l_reserve_at_completion_flag
608: FINANCIALS_SYSTEM_PARAMETERS.reserve_at_completion_flag%TYPE;
602: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
603: l_enforce_full_lot_qty
604: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;
605: l_disposition_warning_flag
606: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;
607: l_reserve_at_completion_flag
608: FINANCIALS_SYSTEM_PARAMETERS.reserve_at_completion_flag%TYPE;
609: l_user_defined_rcpt_num_code
610: PO_SYSTEM_PARAMETERS.user_defined_receipt_num_code%TYPE;
606: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;
607: l_reserve_at_completion_flag
608: FINANCIALS_SYSTEM_PARAMETERS.reserve_at_completion_flag%TYPE;
609: l_user_defined_rcpt_num_code
610: PO_SYSTEM_PARAMETERS.user_defined_receipt_num_code%TYPE;
611: l_manual_rcpt_num_type
612: PO_SYSTEM_PARAMETERS.manual_receipt_num_type%TYPE;
613: l_use_positions_flag
614: FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
608: FINANCIALS_SYSTEM_PARAMETERS.reserve_at_completion_flag%TYPE;
609: l_user_defined_rcpt_num_code
610: PO_SYSTEM_PARAMETERS.user_defined_receipt_num_code%TYPE;
611: l_manual_rcpt_num_type
612: PO_SYSTEM_PARAMETERS.manual_receipt_num_type%TYPE;
613: l_use_positions_flag
614: FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
615: l_user_defined_rfq_num_code
616: PO_SYSTEM_PARAMETERS.user_defined_rfq_num_code%TYPE;
612: PO_SYSTEM_PARAMETERS.manual_receipt_num_type%TYPE;
613: l_use_positions_flag
614: FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
615: l_user_defined_rfq_num_code
616: PO_SYSTEM_PARAMETERS.user_defined_rfq_num_code%TYPE;
617: l_manual_rfq_num_type
618: PO_SYSTEM_PARAMETERS.manual_rfq_num_type%TYPE;
619:
620:
614: FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
615: l_user_defined_rfq_num_code
616: PO_SYSTEM_PARAMETERS.user_defined_rfq_num_code%TYPE;
617: l_manual_rfq_num_type
618: PO_SYSTEM_PARAMETERS.manual_rfq_num_type%TYPE;
619:
620:
621: BEGIN
622:
682: cat_admin_authoring_acceptance
683: INTO PO_PDOI_PARAMS.g_sys.price_break_lookup_code,
684: PO_PDOI_PARAMS.g_sys.supplier_auth_acc,
685: PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc
686: FROM po_system_parameters;
687:
688: d_position := 20;
689: SELECT match_option,
690: business_group_id