1 PACKAGE PO_SETUP_S2 AUTHID CURRENT_USER as
2 /* $Header: POXSES3S.pls 120.0.12010000.2 2008/11/11 11:26:20 bisdas ship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: PO_SETUP_S2
6
7 DESCRIPTION:
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME
12
13 OWNER:
14
15 PROCEDURE NAMES: get_combined_startup_values
16
17 ===========================================================================*/
18
19 /*===========================================================================
20 PROCEDURE NAME: get_combined_startup_values()
21
22 DESCRIPTION: This procedure combines the call to several server
23 procedures for getting the PO startup values.
24 The purpose is to enhance the PO startup performance by
25 reducing the number of server procedural calls from
26 the client procedure 'Init_PO_control_block'.
27
28
29 PARAMETERS:
30
31 DESIGN REFERENCES:
32
33 ALGORITHM:
34
35 NOTES: This procedure has reached the maxiumum number of parameters
36 that PL/SQL supports. If new parameters are to be added later,
37 it is recommended to combine parameters into one.
38
39 OPEN ISSUES:
40
41 CLOSED ISSUES:
42
43 CHANGE HISTORY: WLAU 7/3/1996 Created
44 ===========================================================================*/
45
46 PROCEDURE get_combined_startup_values
47 (x_sob_id IN OUT NOCOPY NUMBER,
48 x_inv_org_id IN OUT NOCOPY NUMBER,
49 x_ussgl_value OUT NOCOPY VARCHAR2 ,
50 x_flex_value OUT NOCOPY VARCHAR2,
51 x_inverse_rate_value OUT NOCOPY VARCHAR2,
52 x_period_name OUT NOCOPY VARCHAR2,
53 x_gl_date OUT NOCOPY DATE,
54 x_category_set_id OUT NOCOPY NUMBER,
55 x_structure_id OUT NOCOPY NUMBER,
56 x_user_id OUT NOCOPY NUMBER,
57 x_logon_id OUT NOCOPY NUMBER,
58 x_creation_date OUT NOCOPY DATE,
59 x_update_date OUT NOCOPY DATE,
60 x_currency_code OUT NOCOPY VARCHAR2,
61 x_coa_id OUT NOCOPY NUMBER,
62 x_po_encumberance_flag OUT NOCOPY VARCHAR2,
63 x_req_encumberance_flag OUT NOCOPY VARCHAR2,
64 x_ship_to_location_id IN OUT NOCOPY NUMBER,
65 x_bill_to_location_id IN OUT NOCOPY NUMBER,
66 x_fob_lookup_code IN OUT NOCOPY VARCHAR2,
67 x_freight_terms_lookup_code IN OUT NOCOPY VARCHAR2,
68 x_terms_id IN OUT NOCOPY NUMBER,
69 x_default_rate_type IN OUT NOCOPY VARCHAR2,
70 x_taxable_flag OUT NOCOPY VARCHAR2,
71 x_receiving_flag OUT NOCOPY VARCHAR2,
72 x_enforce_buyer_name_flag OUT NOCOPY VARCHAR2,
73 x_enforce_buyer_auth_flag OUT NOCOPY VARCHAR2,
74 x_line_type_id IN OUT NOCOPY NUMBER,
75 x_manual_po_num_type OUT NOCOPY VARCHAR2,
76 x_po_num_code OUT NOCOPY VARCHAR2,
77 x_price_lookup_code OUT NOCOPY VARCHAR2,
78 x_invoice_close_tolerance OUT NOCOPY NUMBER,
79 x_receive_close_tolerance OUT NOCOPY NUMBER,
80 x_security_structure_id OUT NOCOPY NUMBER,
81 x_expense_accrual_code OUT NOCOPY VARCHAR2,
82 x_rev_sort_ordering OUT NOCOPY NUMBER,
83 x_min_rel_amount OUT NOCOPY NUMBER,
84 x_notify_blanket_flag OUT NOCOPY VARCHAR2,
85 x_budgetary_control_flag OUT NOCOPY VARCHAR2,
86 x_user_defined_req_num_code OUT NOCOPY VARCHAR2,
87 x_rfq_required_flag OUT NOCOPY VARCHAR2,
88 x_manual_req_num_type OUT NOCOPY VARCHAR2,
89 x_enforce_full_lot_qty OUT NOCOPY VARCHAR2,
90 x_disposition_warning_flag OUT NOCOPY VARCHAR2,
91 x_reserve_at_completion_flag OUT NOCOPY VARCHAR2,
92 x_user_defined_rcpt_num_code OUT NOCOPY VARCHAR2,
93 x_manual_rcpt_num_type OUT NOCOPY VARCHAR2,
94 x_use_positions_flag OUT NOCOPY VARCHAR2,
95 x_default_quote_warning_delay OUT NOCOPY NUMBER,
96 x_inspection_required_flag OUT NOCOPY VARCHAR2,
97 x_user_defined_quote_num_code OUT NOCOPY VARCHAR2,
98 x_manual_quote_num_type OUT NOCOPY VARCHAR2,
99 x_user_defined_rfq_num_code OUT NOCOPY VARCHAR2,
100 x_manual_rfq_num_type OUT NOCOPY VARCHAR2,
101 x_ship_via_lookup_code IN OUT NOCOPY VARCHAR2,
102 x_qty_rcv_tolerance OUT NOCOPY NUMBER,
103 x_line_type OUT NOCOPY VARCHAR2,
104 x_item_tax_override_popup OUT NOCOPY VARCHAR2,
105 x_item_account_override_popup OUT NOCOPY VARCHAR2,
106 x_curr_tax_override_popup OUT NOCOPY VARCHAR2,
107 x_curr_account_override_popup OUT NOCOPY VARCHAR2,
108 x_use_ap_accrual_account OUT NOCOPY VARCHAR2,
109 x_destination_expense OUT NOCOPY VARCHAR2,
110 x_destination_shop_floor OUT NOCOPY VARCHAR2,
111 x_legal_requisition_type OUT NOCOPY VARCHAR2,
112 x_req_source_internal OUT NOCOPY VARCHAR2,
113 x_req_source_purchase OUT NOCOPY VARCHAR2,
114 x_req_incomplete OUT NOCOPY VARCHAR2,
115 x_fob_disp OUT NOCOPY VARCHAR2,
116 x_freight_terms_disp OUT NOCOPY VARCHAR2,
117 x_internal_access OUT NOCOPY VARCHAR2,
118 x_purchase_access OUT NOCOPY VARCHAR2,
119 x_internal_security OUT NOCOPY VARCHAR2,
120 x_purchase_security OUT NOCOPY VARCHAR2,
121 x_employee_id OUT NOCOPY NUMBER,
122 x_employee_name OUT NOCOPY VARCHAR2,
123 x_employee_is_buyer_flag OUT NOCOPY VARCHAR2,
124 x_requestor_location_id IN OUT NOCOPY NUMBER,
125 x_bill_to_location IN OUT NOCOPY VARCHAR2,
126 x_ship_to_location IN OUT NOCOPY VARCHAR2,
127 x_ship_org_code IN OUT NOCOPY VARCHAR2,
128 x_ship_org_name IN OUT NOCOPY VARCHAR2,
129 x_default_rate_type_disp IN OUT NOCOPY VARCHAR2,
130 x_requestor_location IN OUT NOCOPY VARCHAR2,
131 x_requestor_org_id IN OUT NOCOPY NUMBER,
132 x_requestor_org IN OUT NOCOPY VARCHAR2,
133 x_requestor_org_code IN OUT NOCOPY VARCHAR2,
134 x_destination_inventory OUT NOCOPY VARCHAR2,
135 x_gl_set_of_bks_id OUT NOCOPY VARCHAR2,
136 x_combined_install_statuses OUT NOCOPY VARCHAR2,
137 x_payment_terms IN OUT NOCOPY VARCHAR2,
138 x_acceptance_required_flag OUT NOCOPY VARCHAR2); /* Bug 7518967 : Default Acceptance Required Check ER */
139
140
141
142 END PO_SETUP_S2;