DBA Data[Home] [Help]

APPS.PO_PDOI_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 586: PO_SYSTEM_PARAMETERS.enforce_buyer_name_flag %TYPE;

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;

Line 588: PO_SYSTEM_PARAMETERS.enforce_buyer_authority_flag%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;

Line 590: PO_SYSTEM_PARAMETERS.security_position_structure_id%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;

Line 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;

Line 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;

Line 600: PO_SYSTEM_PARAMETERS.rfq_required_flag%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;

Line 602: PO_SYSTEM_PARAMETERS.manual_req_num_type%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;

Line 604: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%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;

Line 606: PO_SYSTEM_PARAMETERS.disposition_warning_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;

Line 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;

Line 612: PO_SYSTEM_PARAMETERS.manual_receipt_num_type%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;

Line 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:

Line 618: PO_SYSTEM_PARAMETERS.manual_rfq_num_type%TYPE;

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:

Line 686: FROM po_system_parameters;

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