DBA Data[Home] [Help]

APPS.PO_PDOI_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 579: PO_SYSTEM_PARAMETERS.enforce_buyer_name_flag %TYPE;

575: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
576: d_position NUMBER;
577:
578: l_enforce_buyer_name
579: PO_SYSTEM_PARAMETERS.enforce_buyer_name_flag %TYPE;
580: l_enforce_buyer_auth_flag
581: PO_SYSTEM_PARAMETERS.enforce_buyer_authority_flag%TYPE;
582: l_security_structure_id
583: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;

Line 581: PO_SYSTEM_PARAMETERS.enforce_buyer_authority_flag%TYPE;

577:
578: l_enforce_buyer_name
579: PO_SYSTEM_PARAMETERS.enforce_buyer_name_flag %TYPE;
580: l_enforce_buyer_auth_flag
581: PO_SYSTEM_PARAMETERS.enforce_buyer_authority_flag%TYPE;
582: l_security_structure_id
583: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;
584: l_rev_sort_ordering
585: FINANCIALS_SYSTEM_PARAMETERS.revision_sort_ordering%TYPE;

Line 583: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;

579: PO_SYSTEM_PARAMETERS.enforce_buyer_name_flag %TYPE;
580: l_enforce_buyer_auth_flag
581: PO_SYSTEM_PARAMETERS.enforce_buyer_authority_flag%TYPE;
582: l_security_structure_id
583: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;
584: l_rev_sort_ordering
585: FINANCIALS_SYSTEM_PARAMETERS.revision_sort_ordering%TYPE;
586: l_notify_blanket_flag
587: PO_SYSTEM_PARAMETERS.notify_if_blanket_flag%TYPE;

Line 587: PO_SYSTEM_PARAMETERS.notify_if_blanket_flag%TYPE;

583: PO_SYSTEM_PARAMETERS.security_position_structure_id%TYPE;
584: l_rev_sort_ordering
585: FINANCIALS_SYSTEM_PARAMETERS.revision_sort_ordering%TYPE;
586: l_notify_blanket_flag
587: PO_SYSTEM_PARAMETERS.notify_if_blanket_flag%TYPE;
588: l_budgetary_control_flag
589: GL_SETS_OF_BOOKS.enable_budgetary_control_flag%TYPE;
590: l_user_defined_req_num_code
591: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;

Line 591: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;

587: PO_SYSTEM_PARAMETERS.notify_if_blanket_flag%TYPE;
588: l_budgetary_control_flag
589: GL_SETS_OF_BOOKS.enable_budgetary_control_flag%TYPE;
590: l_user_defined_req_num_code
591: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;
592: l_rfq_required_flag
593: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;
594: l_manual_req_num_type
595: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;

Line 593: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;

589: GL_SETS_OF_BOOKS.enable_budgetary_control_flag%TYPE;
590: l_user_defined_req_num_code
591: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;
592: l_rfq_required_flag
593: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;
594: l_manual_req_num_type
595: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
596: l_enforce_full_lot_qty
597: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;

Line 595: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;

591: PO_SYSTEM_PARAMETERS.user_defined_req_num_code%TYPE;
592: l_rfq_required_flag
593: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;
594: l_manual_req_num_type
595: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
596: l_enforce_full_lot_qty
597: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;
598: l_disposition_warning_flag
599: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;

Line 597: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;

593: PO_SYSTEM_PARAMETERS.rfq_required_flag%TYPE;
594: l_manual_req_num_type
595: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
596: l_enforce_full_lot_qty
597: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;
598: l_disposition_warning_flag
599: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;
600: l_reserve_at_completion_flag
601: FINANCIALS_SYSTEM_PARAMETERS.reserve_at_completion_flag%TYPE;

Line 599: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;

595: PO_SYSTEM_PARAMETERS.manual_req_num_type%TYPE;
596: l_enforce_full_lot_qty
597: PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%TYPE;
598: l_disposition_warning_flag
599: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;
600: l_reserve_at_completion_flag
601: FINANCIALS_SYSTEM_PARAMETERS.reserve_at_completion_flag%TYPE;
602: l_user_defined_rcpt_num_code
603: PO_SYSTEM_PARAMETERS.user_defined_receipt_num_code%TYPE;

Line 603: PO_SYSTEM_PARAMETERS.user_defined_receipt_num_code%TYPE;

599: PO_SYSTEM_PARAMETERS.disposition_warning_flag%TYPE;
600: l_reserve_at_completion_flag
601: FINANCIALS_SYSTEM_PARAMETERS.reserve_at_completion_flag%TYPE;
602: l_user_defined_rcpt_num_code
603: PO_SYSTEM_PARAMETERS.user_defined_receipt_num_code%TYPE;
604: l_manual_rcpt_num_type
605: PO_SYSTEM_PARAMETERS.manual_receipt_num_type%TYPE;
606: l_use_positions_flag
607: FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;

Line 605: PO_SYSTEM_PARAMETERS.manual_receipt_num_type%TYPE;

601: FINANCIALS_SYSTEM_PARAMETERS.reserve_at_completion_flag%TYPE;
602: l_user_defined_rcpt_num_code
603: PO_SYSTEM_PARAMETERS.user_defined_receipt_num_code%TYPE;
604: l_manual_rcpt_num_type
605: PO_SYSTEM_PARAMETERS.manual_receipt_num_type%TYPE;
606: l_use_positions_flag
607: FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
608: l_user_defined_rfq_num_code
609: PO_SYSTEM_PARAMETERS.user_defined_rfq_num_code%TYPE;

Line 609: PO_SYSTEM_PARAMETERS.user_defined_rfq_num_code%TYPE;

605: PO_SYSTEM_PARAMETERS.manual_receipt_num_type%TYPE;
606: l_use_positions_flag
607: FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
608: l_user_defined_rfq_num_code
609: PO_SYSTEM_PARAMETERS.user_defined_rfq_num_code%TYPE;
610: l_manual_rfq_num_type
611: PO_SYSTEM_PARAMETERS.manual_rfq_num_type%TYPE;
612:
613:

Line 611: PO_SYSTEM_PARAMETERS.manual_rfq_num_type%TYPE;

607: FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
608: l_user_defined_rfq_num_code
609: PO_SYSTEM_PARAMETERS.user_defined_rfq_num_code%TYPE;
610: l_manual_rfq_num_type
611: PO_SYSTEM_PARAMETERS.manual_rfq_num_type%TYPE;
612:
613:
614: BEGIN
615:

Line 679: FROM po_system_parameters;

675: cat_admin_authoring_acceptance
676: INTO PO_PDOI_PARAMS.g_sys.price_break_lookup_code,
677: PO_PDOI_PARAMS.g_sys.supplier_auth_acc,
678: PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc
679: FROM po_system_parameters;
680:
681: d_position := 20;
682: SELECT match_option,
683: business_group_id