[Home] [Help]
PACKAGE: APPS.PO_SETUP_S
Source
1 PACKAGE PO_SETUP_S as
2 /* $Header: POXSES1S.pls 120.0.12010000.2 2008/11/11 11:18:02 bisdas ship $*/
3 /*===========================================================================
4 PACKAGE NAME: PO_SETUP_S
5
6 DESCRIPTION:
7
8 CLIENT/SERVER: Server
9
10 LIBRARY NAME
11
12 OWNER:
13
14 PROCEDURE NAMES: get_startup_values
15 get_install_status
16 get_defaults
17 ===========================================================================*/
18
19 /*===========================================================================
20 PROCEDURE NAME: get_startup_values()
21
22 DESCRIPTION:
23 o DEF - Get Purchasing and External defaults including:
24 - Get ussgl_option to determine if the descriptive flex is
25 ussgl based. If any of the descriptive flex fields are
26 used and the ussgl_option is set to 'Y' then open the ussgl
27 PO_REQEXPRESS_LINES/PO_USSGL_TRANSACTION then dynamically
28 enable the display for private sector related information.
29 - Get flex builder value
30 - Get display_inverse_rate value
31 - Get period name
32
33 PARAMETERS : x_ussgl_value - Stores the ussgl_value
34 x_flex_value - Stores whether PA allows flex builder to be
35 overridden
36 x_inverse_rate_value - Stores the value of 'DISPLAY_INVERSE_RATE'
37 x_period_name - Name of the GL period depending on sysdate
38 x_category_set_id - Stores the default category set
39 x_structure_id - Stores the default structure_id
40 x_user_id - Id of the user
41 x_logonid - Logon Id of the user
42 x_creation_date - Creation date
43 x_update_date - Updation date
44 x_currency_code
45 x_coa_id
46 x_po_encumberance_flag
47 x_req_encumberance_flag
48 x_sob_id
49 x_ship_to_location_id
50 x_bill_to_location_id
51 x_fob_lookup_code
52 x_freight_terms_lookup_code
53 x_terms_id
54 x_default_rate_type
55 x_taxable_flag
56 x_receiving_flag
57 x_enforce_buyer_name_flag
58 x_enforce_buyer_auth_flag
59 x_line_type_id
60 x_manual_po_num_type
61 x_po_num_code
62 x_price_lookup_code
63 x_invoice_close_tolerance
64 x_receive_close_tolerance
65 x_security_structure_id
66 x_expense_accrual_code
67 x_inv_org_id
68 x_rev_sort_ordering
69 x_min_rel_amount
70 x_notify_blanket_flag
71 x_budgetary_control_flag
72 x_user_defined_req_num_code
73 x_rfq_required_flag
74 x_manual_req_num_type
75 x_enforce_full_lot_qty
76 x_disposition_warning_flag
77 x_reserve_at_completion_flag
78 x_user_defined_rcpt_num_code
79 x_manual_rcpt_num_type
80 x_use_positions_flag
81 x_default_quote_warning_delay
82 x_inspection_required_flag
83 x_user_defined_quote_num_code
84 x_manual_quote_num_type
85 x_user_defined_rfq_num_code
86 x_manual_rfq_num_type
87 x_ship_via_lookup_code
88 x_qty_rcv_tolerance
89 x_line_type
90 x_item_tax_override_popup
91 x_item_account_override_popup
92 x_curr_tax_override_popup
93 x_curr_account_override_popup
94 x_use_ap_accrual_account
95 x_destination_expense
96 x_destination_shop_floor
97 x_legal_requisition_type
98 x_req_source_internal
99 x_req_source_purchase
100 x_req_incomplete
101 x_fob_disp
102 x_freight_terms_disp
103 x_internal_access
104 x_purchase_access
105 x_internal_security
106 x_purchase_security
107 x_employee_id
108 x_employee_name
109 x_employee_is_buyer_flag
110 x_requestor_location_id
111 x_bill_to_location
112 x_ship_to_location
113 x_ship_org_code
114 x_ship_org_name
115 x_default_rate_type_disp
116 x_requestor_location
117 x_requestor_org_id
118 x_requestor_org
119 x_requestor_org_code
120 x_destination_inventory
121 x_gl_set_of_bks_id
122 x_acceptance_required_flag
123
124 DESIGN REFERENCES: POXPOMPO.dd
125
126 ALGORITHM:
127
128 NOTES:
129
130 OPEN ISSUES:
131
132 CLOSED ISSUES:
133
134 CHANGE HISTORY:
135 ===========================================================================*/
136
137 PROCEDURE get_startup_values(x_sob_id IN OUT NOCOPY NUMBER,
138 x_inv_org_id IN OUT NOCOPY NUMBER,
139 x_ussgl_value OUT NOCOPY VARCHAR2 ,
140 x_flex_value OUT NOCOPY VARCHAR2,
141 x_inverse_rate_value OUT NOCOPY VARCHAR2,
142 x_period_name OUT NOCOPY VARCHAR2,
143 x_gl_date OUT NOCOPY DATE,
144 x_category_set_id OUT NOCOPY NUMBER,
145 x_structure_id OUT NOCOPY NUMBER,
146 x_user_id OUT NOCOPY NUMBER,
147 x_logonid OUT NOCOPY NUMBER,
148 x_creation_date OUT NOCOPY DATE,
149 x_update_date OUT NOCOPY DATE,
150 x_currency_code OUT NOCOPY VARCHAR2,
151 x_coa_id OUT NOCOPY NUMBER,
152 x_po_encumberance_flag OUT NOCOPY VARCHAR2,
153 x_req_encumberance_flag OUT NOCOPY VARCHAR2,
154 x_ship_to_location_id IN OUT NOCOPY NUMBER,
155 x_bill_to_location_id IN OUT NOCOPY NUMBER,
156 x_fob_lookup_code IN OUT NOCOPY VARCHAR2,
157 x_freight_terms_lookup_code IN OUT NOCOPY VARCHAR2,
158 x_terms_id IN OUT NOCOPY NUMBER,
159 x_default_rate_type IN OUT NOCOPY VARCHAR2,
160 x_taxable_flag OUT NOCOPY VARCHAR2,
161 x_receiving_flag OUT NOCOPY VARCHAR2,
162 x_enforce_buyer_name_flag OUT NOCOPY VARCHAR2,
163 x_enforce_buyer_auth_flag OUT NOCOPY VARCHAR2,
164 x_line_type_id IN OUT NOCOPY NUMBER,
165 x_manual_po_num_type OUT NOCOPY VARCHAR2,
166 x_po_num_code OUT NOCOPY VARCHAR2,
167 x_price_lookup_code OUT NOCOPY VARCHAR2,
168 x_invoice_close_tolerance OUT NOCOPY NUMBER,
169 x_receive_close_tolerance OUT NOCOPY NUMBER,
170 x_security_structure_id OUT NOCOPY NUMBER,
171 x_expense_accrual_code OUT NOCOPY VARCHAR2,
172 x_rev_sort_ordering OUT NOCOPY NUMBER,
173 x_min_rel_amount OUT NOCOPY NUMBER,
174 x_notify_blanket_flag OUT NOCOPY VARCHAR2,
175 x_budgetary_control_flag OUT NOCOPY VARCHAR2,
176 x_user_defined_req_num_code OUT NOCOPY VARCHAR2,
177 x_rfq_required_flag OUT NOCOPY VARCHAR2,
178 x_manual_req_num_type OUT NOCOPY VARCHAR2,
179 x_enforce_full_lot_qty OUT NOCOPY VARCHAR2,
180 x_disposition_warning_flag OUT NOCOPY VARCHAR2,
181 x_reserve_at_completion_flag OUT NOCOPY VARCHAR2,
182 x_user_defined_rcpt_num_code OUT NOCOPY VARCHAR2,
183 x_manual_rcpt_num_type OUT NOCOPY VARCHAR2,
184 x_use_positions_flag OUT NOCOPY VARCHAR2,
185 x_default_quote_warning_delay OUT NOCOPY NUMBER,
186 x_inspection_required_flag OUT NOCOPY VARCHAR2,
187 x_user_defined_quote_num_code OUT NOCOPY VARCHAR2,
188 x_manual_quote_num_type OUT NOCOPY VARCHAR2,
189 x_user_defined_rfq_num_code OUT NOCOPY VARCHAR2,
190 x_manual_rfq_num_type OUT NOCOPY VARCHAR2,
191 x_ship_via_lookup_code IN OUT NOCOPY VARCHAR2,
192 x_qty_rcv_tolerance OUT NOCOPY NUMBER,
193 x_line_type OUT NOCOPY VARCHAR2,
194 x_item_tax_override_popup OUT NOCOPY VARCHAR2,
195 x_item_account_override_popup OUT NOCOPY VARCHAR2,
196 x_curr_tax_override_popup OUT NOCOPY VARCHAR2,
197 x_curr_account_override_popup OUT NOCOPY VARCHAR2,
198 x_use_ap_accrual_account OUT NOCOPY VARCHAR2,
199 x_destination_expense OUT NOCOPY VARCHAR2,
200 x_destination_shop_floor OUT NOCOPY VARCHAR2,
201 x_legal_requisition_type OUT NOCOPY VARCHAR2,
202 x_req_source_internal OUT NOCOPY VARCHAR2,
203 x_req_source_purchase OUT NOCOPY VARCHAR2,
204 x_req_incomplete OUT NOCOPY VARCHAR2,
205 x_fob_disp OUT NOCOPY VARCHAR2,
206 x_freight_terms_disp OUT NOCOPY VARCHAR2,
207 x_internal_access OUT NOCOPY VARCHAR2,
208 x_purchase_access OUT NOCOPY VARCHAR2,
209 x_internal_security OUT NOCOPY VARCHAR2,
210 x_purchase_security OUT NOCOPY VARCHAR2,
211 x_employee_id OUT NOCOPY NUMBER,
212 x_employee_name OUT NOCOPY VARCHAR2,
213 x_employee_is_buyer_flag OUT NOCOPY VARCHAR2,
214 x_requestor_location_id IN OUT NOCOPY NUMBER,
215 x_bill_to_location IN OUT NOCOPY VARCHAR2,
216 x_ship_to_location IN OUT NOCOPY VARCHAR2,
217 x_ship_org_code IN OUT NOCOPY VARCHAR2,
218 x_ship_org_name IN OUT NOCOPY VARCHAR2,
219 x_default_rate_type_disp IN OUT NOCOPY VARCHAR2,
220 x_requestor_location IN OUT NOCOPY VARCHAR2,
221 x_requestor_org_id IN OUT NOCOPY NUMBER,
222 x_requestor_org IN OUT NOCOPY VARCHAR2,
223 x_requestor_org_code IN OUT NOCOPY VARCHAR2,
224 x_destination_inventory OUT NOCOPY VARCHAR2,
225 x_gl_set_of_bks_id OUT NOCOPY VARCHAR2,
226 x_acceptance_required_flag OUT NOCOPY VARCHAR2); /* Bug 7518967 : Default Acceptance Required Check ER */
227
228 END PO_SETUP_S;