39: bill_to_location_id FINANCIALS_SYSTEM_PARAMETERS.bill_to_location_id%TYPE,
40: fob_lookup_code FINANCIALS_SYSTEM_PARAMETERS.fob_lookup_code%TYPE,
41: freight_terms_lookup_code FINANCIALS_SYSTEM_PARAMETERS.freight_terms_lookup_code%TYPE,
42: terms_id FINANCIALS_SYSTEM_PARAMETERS.terms_id%TYPE,
43: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,
44: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
45: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
46: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
47: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
40: fob_lookup_code FINANCIALS_SYSTEM_PARAMETERS.fob_lookup_code%TYPE,
41: freight_terms_lookup_code FINANCIALS_SYSTEM_PARAMETERS.freight_terms_lookup_code%TYPE,
42: terms_id FINANCIALS_SYSTEM_PARAMETERS.terms_id%TYPE,
43: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,
44: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
45: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
46: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
47: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
48: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
41: freight_terms_lookup_code FINANCIALS_SYSTEM_PARAMETERS.freight_terms_lookup_code%TYPE,
42: terms_id FINANCIALS_SYSTEM_PARAMETERS.terms_id%TYPE,
43: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,
44: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
45: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
46: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
47: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
48: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
49: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
42: terms_id FINANCIALS_SYSTEM_PARAMETERS.terms_id%TYPE,
43: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,
44: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
45: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
46: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
47: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
48: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
49: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
50: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
43: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,
44: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
45: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
46: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
47: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
48: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
49: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
50: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
51: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
44: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
45: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
46: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
47: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
48: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
49: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
50: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
51: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
52: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
45: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
46: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
47: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
48: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
49: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
50: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
51: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
52: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
53: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
47: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
48: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
49: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
50: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
51: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
52: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
53: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
54: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
55: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
48: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
49: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
50: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
51: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
52: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
53: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
54: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
55: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
56: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
49: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
50: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
51: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
52: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
53: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
54: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
55: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
56: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
57: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
50: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
51: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
52: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
53: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
54: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
55: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
56: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
57: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
58: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
51: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
52: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
53: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
54: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
55: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
56: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
57: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
58: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
59: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
54: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
55: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
56: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
57: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
58: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
59: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
60: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,
61: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,
62: master_inv_org_id MTL_PARAMETERS.organization_id%TYPE,
55: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
56: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
57: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
58: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
59: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
60: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,
61: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,
62: master_inv_org_id MTL_PARAMETERS.organization_id%TYPE,
63: enforce_ship_to_loc RCV_PARAMETERS.enforce_ship_to_location_code%TYPE,
56: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
57: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
58: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
59: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
60: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,
61: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,
62: master_inv_org_id MTL_PARAMETERS.organization_id%TYPE,
63: enforce_ship_to_loc RCV_PARAMETERS.enforce_ship_to_location_code%TYPE,
64: allow_substitutes RCV_PARAMETERS.allow_substitute_receipts_flag%TYPE,
57: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
58: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
59: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
60: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,
61: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,
62: master_inv_org_id MTL_PARAMETERS.organization_id%TYPE,
63: enforce_ship_to_loc RCV_PARAMETERS.enforce_ship_to_location_code%TYPE,
64: allow_substitutes RCV_PARAMETERS.allow_substitute_receipts_flag%TYPE,
65: routing_id RCV_PARAMETERS.receiving_routing_id%TYPE,
66: qty_rcv_exception RCV_PARAMETERS.qty_rcv_exception_code%TYPE,
67: days_early_receipt RCV_PARAMETERS.days_early_receipt_allowed%TYPE,
68: days_late_receipt RCV_PARAMETERS.days_late_receipt_allowed%TYPE,
69: rcv_days_exception RCV_PARAMETERS.receipt_days_exception_code%TYPE,
70: supplier_auth_acc PO_SYSTEM_PARAMETERS.supplier_authoring_acceptance%TYPE,
71: cat_admin_auth_acc PO_SYSTEM_PARAMETERS.cat_admin_authoring_acceptance%TYPE,
72: invoice_match_option FINANCIALS_SYSTEM_PARAMETERS.match_option%TYPE,
73: when_to_archive_blanket PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE,
74: when_to_archive_std_po PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE,
67: days_early_receipt RCV_PARAMETERS.days_early_receipt_allowed%TYPE,
68: days_late_receipt RCV_PARAMETERS.days_late_receipt_allowed%TYPE,
69: rcv_days_exception RCV_PARAMETERS.receipt_days_exception_code%TYPE,
70: supplier_auth_acc PO_SYSTEM_PARAMETERS.supplier_authoring_acceptance%TYPE,
71: cat_admin_auth_acc PO_SYSTEM_PARAMETERS.cat_admin_authoring_acceptance%TYPE,
72: invoice_match_option FINANCIALS_SYSTEM_PARAMETERS.match_option%TYPE,
73: when_to_archive_blanket PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE,
74: when_to_archive_std_po PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE,
75: def_business_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE,
76: def_structure_id MTL_CATEGORY_SETS.structure_id%TYPE,
77: def_cat_set_id MTL_CATEGORY_SETS.category_set_id%TYPE,
78: def_category_id MTL_CATEGORY_SETS.default_category_id%TYPE,
79: is_federal_instance VARCHAR2(1),
80: acceptance_required_flag PO_SYSTEM_PARAMETERS.acceptance_required_flag%TYPE /* Bug 7518967 : Default Acceptance Required Check ER */
81: );
82:
83: -- Record type to store profile options
84: TYPE profile_param_rec_type IS RECORD