18: fob_lookup_code financials_system_parameters.fob_lookup_code % type,
19: freight_terms_lookup_code
20: financials_system_parameters.freight_terms_lookup_code % type,
21: terms_id number,
22: default_rate_type po_system_parameters.default_rate_type % type,
23: taxable_flag varchar2(1),
24: receiving_flag varchar2(1),
25: enforce_buyer_name_flag varchar2(1),
26: enforce_buyer_auth_flag varchar2(1),
24: receiving_flag varchar2(1),
25: enforce_buyer_name_flag varchar2(1),
26: enforce_buyer_auth_flag varchar2(1),
27: line_type_id number:= null,
28: manual_po_num_type po_system_parameters.manual_po_num_type % type,
29: po_num_code po_system_parameters.user_defined_po_num_code % type,
30: price_type_lookup_code po_system_parameters.price_type_lookup_code % type,
31: invoice_close_tolerance number,
32: receive_close_tolerance number,
25: enforce_buyer_name_flag varchar2(1),
26: enforce_buyer_auth_flag varchar2(1),
27: line_type_id number:= null,
28: manual_po_num_type po_system_parameters.manual_po_num_type % type,
29: po_num_code po_system_parameters.user_defined_po_num_code % type,
30: price_type_lookup_code po_system_parameters.price_type_lookup_code % type,
31: invoice_close_tolerance number,
32: receive_close_tolerance number,
33: security_structure_id number,
26: enforce_buyer_auth_flag varchar2(1),
27: line_type_id number:= null,
28: manual_po_num_type po_system_parameters.manual_po_num_type % type,
29: po_num_code po_system_parameters.user_defined_po_num_code % type,
30: price_type_lookup_code po_system_parameters.price_type_lookup_code % type,
31: invoice_close_tolerance number,
32: receive_close_tolerance number,
33: security_structure_id number,
34: expense_accrual_code po_system_parameters.price_type_lookup_code % type,
30: price_type_lookup_code po_system_parameters.price_type_lookup_code % type,
31: invoice_close_tolerance number,
32: receive_close_tolerance number,
33: security_structure_id number,
34: expense_accrual_code po_system_parameters.price_type_lookup_code % type,
35: inventory_organization_id number,
36: rev_sort_ordering number,
37: min_rel_amount number,
38: notify_blanket_flag varchar2(1),
36: rev_sort_ordering number,
37: min_rel_amount number,
38: notify_blanket_flag varchar2(1),
39: budgetary_control_flag varchar2(1),
40: user_defined_req_num_code po_system_parameters.user_defined_req_num_code % type,
41: rfq_required_flag varchar2(1),
42: manual_req_num_type po_system_parameters.manual_req_num_type % type,
43: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities % type,
44: disposition_warning_flag varchar2(1),
38: notify_blanket_flag varchar2(1),
39: budgetary_control_flag varchar2(1),
40: user_defined_req_num_code po_system_parameters.user_defined_req_num_code % type,
41: rfq_required_flag varchar2(1),
42: manual_req_num_type po_system_parameters.manual_req_num_type % type,
43: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities % type,
44: disposition_warning_flag varchar2(1),
45: reserve_at_completion_flag varchar2(1),
46: user_defined_rcpt_num_code
39: budgetary_control_flag varchar2(1),
40: user_defined_req_num_code po_system_parameters.user_defined_req_num_code % type,
41: rfq_required_flag varchar2(1),
42: manual_req_num_type po_system_parameters.manual_req_num_type % type,
43: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities % type,
44: disposition_warning_flag varchar2(1),
45: reserve_at_completion_flag varchar2(1),
46: user_defined_rcpt_num_code
47: po_system_parameters.user_defined_receipt_num_code % type,
43: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities % type,
44: disposition_warning_flag varchar2(1),
45: reserve_at_completion_flag varchar2(1),
46: user_defined_rcpt_num_code
47: po_system_parameters.user_defined_receipt_num_code % type,
48: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type % type,
49: use_positions_flag varchar2(1),
50: default_quote_warning_delay number,
51: inspection_required_flag varchar2(1),
44: disposition_warning_flag varchar2(1),
45: reserve_at_completion_flag varchar2(1),
46: user_defined_rcpt_num_code
47: po_system_parameters.user_defined_receipt_num_code % type,
48: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type % type,
49: use_positions_flag varchar2(1),
50: default_quote_warning_delay number,
51: inspection_required_flag varchar2(1),
52: user_defined_quote_num_code
49: use_positions_flag varchar2(1),
50: default_quote_warning_delay number,
51: inspection_required_flag varchar2(1),
52: user_defined_quote_num_code
53: po_system_parameters.user_defined_quote_num_code % type,
54: manual_quote_num_type po_system_parameters.manual_quote_num_type % type,
55: user_defined_rfq_num_code
56: po_system_parameters.user_defined_rfq_num_code % type,
57: manual_rfq_num_type po_system_parameters.manual_rfq_num_type % type,
50: default_quote_warning_delay number,
51: inspection_required_flag varchar2(1),
52: user_defined_quote_num_code
53: po_system_parameters.user_defined_quote_num_code % type,
54: manual_quote_num_type po_system_parameters.manual_quote_num_type % type,
55: user_defined_rfq_num_code
56: po_system_parameters.user_defined_rfq_num_code % type,
57: manual_rfq_num_type po_system_parameters.manual_rfq_num_type % type,
58: ship_via_lookup_code financials_system_parameters.ship_via_lookup_code % type,
52: user_defined_quote_num_code
53: po_system_parameters.user_defined_quote_num_code % type,
54: manual_quote_num_type po_system_parameters.manual_quote_num_type % type,
55: user_defined_rfq_num_code
56: po_system_parameters.user_defined_rfq_num_code % type,
57: manual_rfq_num_type po_system_parameters.manual_rfq_num_type % type,
58: ship_via_lookup_code financials_system_parameters.ship_via_lookup_code % type,
59: qty_rcv_tolerance number,
60: period_name gl_period_statuses.period_name % type);
53: po_system_parameters.user_defined_quote_num_code % type,
54: manual_quote_num_type po_system_parameters.manual_quote_num_type % type,
55: user_defined_rfq_num_code
56: po_system_parameters.user_defined_rfq_num_code % type,
57: manual_rfq_num_type po_system_parameters.manual_rfq_num_type % type,
58: ship_via_lookup_code financials_system_parameters.ship_via_lookup_code % type,
59: qty_rcv_tolerance number,
60: period_name gl_period_statuses.period_name % type);
61:
172:
173: x_progress:= '004';
174: SELECT nvl(default_quote_warning_delay, 0)
175: INTO x_default_quote_warning_delay
176: FROM po_system_parameters;
177: ELSE
178: x_default_quote_warning_delay:= null;
179: END IF;
180: