[Home] [Help]
48: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
54: );
55:
56: PROCEDURE get_vendor_values(
49: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
50: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
51: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
52: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
53: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
54: );
55:
56: PROCEDURE get_vendor_values(
57: x_vendor_id IN po_headers.vendor_id%TYPE,
60: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
66: );
67:
68: PROCEDURE get_vendor_site_values(
61: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
62: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
63: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
64: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
65: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
66: );
67:
68: PROCEDURE get_vendor_site_values(
69: x_vendor_id IN po_headers.vendor_id%TYPE,
73: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
79: );
80:
81: PROCEDURE validate_buyer_id(
74: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
75: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
76: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
77: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
78: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
79: );
80:
81: PROCEDURE validate_buyer_id(
82: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
79: );
80:
81: PROCEDURE validate_buyer_id(
82: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
83: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
84: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
85: );
86:
87:
80:
81: PROCEDURE validate_buyer_id(
82: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
83: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
84: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
85: );
86:
87:
88: PROCEDURE validate_vendor(
96: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
102: );
103:
104: PROCEDURE validate_location_terms(
97: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
98: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
99: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
100: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
101: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
102: );
103:
104: PROCEDURE validate_location_terms(
105: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
107: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
111: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
112: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
113: );
114:
115: PROCEDURE validate_item(
108: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
109: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
110: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
111: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
112: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
113: );
114:
115: PROCEDURE validate_item(
116: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
118: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
120: x_line_type_id IN po_lines.line_type_id%TYPE,
121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
122: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
123: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
124: x_line_num IN po_online_report_text.line_num%TYPE,
125: x_return_code OUT NOCOPY NUMBER
126: );
119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
120: x_line_type_id IN po_lines.line_type_id%TYPE,
121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
122: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
123: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
124: x_line_num IN po_online_report_text.line_num%TYPE,
125: x_return_code OUT NOCOPY NUMBER
126: );
127:
120: x_line_type_id IN po_lines.line_type_id%TYPE,
121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
122: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
123: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
124: x_line_num IN po_online_report_text.line_num%TYPE,
125: x_return_code OUT NOCOPY NUMBER
126: );
127:
128: PROCEDURE validate_project_id(
131: -- Removed the x_destination_type_code and x_ship_to_organization_id arguments.
132: -- Added NOCOPY to x_project_id and x_sequence.
133: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
134: -- x_ship_to_organization_id IN NUMBER,
135: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
136: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
137: x_line_num IN po_online_report_text.line_num%TYPE,
138: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
139: x_distribution_num IN po_online_report_text.distribution_num%TYPE
132: -- Added NOCOPY to x_project_id and x_sequence.
133: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
134: -- x_ship_to_organization_id IN NUMBER,
135: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
136: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
137: x_line_num IN po_online_report_text.line_num%TYPE,
138: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
139: x_distribution_num IN po_online_report_text.distribution_num%TYPE
140: );
133: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
134: -- x_ship_to_organization_id IN NUMBER,
135: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
136: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
137: x_line_num IN po_online_report_text.line_num%TYPE,
138: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
139: x_distribution_num IN po_online_report_text.distribution_num%TYPE
140: );
141:
134: -- x_ship_to_organization_id IN NUMBER,
135: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
136: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
137: x_line_num IN po_online_report_text.line_num%TYPE,
138: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
139: x_distribution_num IN po_online_report_text.distribution_num%TYPE
140: );
141:
142: PROCEDURE validate_task_id(
135: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
136: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
137: x_line_num IN po_online_report_text.line_num%TYPE,
138: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
139: x_distribution_num IN po_online_report_text.distribution_num%TYPE
140: );
141:
142: PROCEDURE validate_task_id(
143: x_task_id IN OUT NOCOPY NUMBER,
141:
142: PROCEDURE validate_task_id(
143: x_task_id IN OUT NOCOPY NUMBER,
144: x_project_id IN NUMBER,
145: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
146: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
147: x_line_num IN po_online_report_text.line_num%TYPE,
148: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
149: x_distribution_num IN po_online_report_text.distribution_num%TYPE
142: PROCEDURE validate_task_id(
143: x_task_id IN OUT NOCOPY NUMBER,
144: x_project_id IN NUMBER,
145: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
146: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
147: x_line_num IN po_online_report_text.line_num%TYPE,
148: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
149: x_distribution_num IN po_online_report_text.distribution_num%TYPE
150: );
143: x_task_id IN OUT NOCOPY NUMBER,
144: x_project_id IN NUMBER,
145: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
146: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
147: x_line_num IN po_online_report_text.line_num%TYPE,
148: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
149: x_distribution_num IN po_online_report_text.distribution_num%TYPE
150: );
151:
144: x_project_id IN NUMBER,
145: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
146: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
147: x_line_num IN po_online_report_text.line_num%TYPE,
148: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
149: x_distribution_num IN po_online_report_text.distribution_num%TYPE
150: );
151:
152: PROCEDURE validate_account_id(
145: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
146: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
147: x_line_num IN po_online_report_text.line_num%TYPE,
148: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
149: x_distribution_num IN po_online_report_text.distribution_num%TYPE
150: );
151:
152: PROCEDURE validate_account_id(
153: x_account_id IN OUT NOCOPY NUMBER,
153: x_account_id IN OUT NOCOPY NUMBER,
154: x_account_type IN VARCHAR2,
155: x_gl_date IN DATE,
156: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
157: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
158: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
159: x_line_num IN po_online_report_text.line_num%TYPE,
160: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
161: x_distribution_num IN po_online_report_text.distribution_num%TYPE
154: x_account_type IN VARCHAR2,
155: x_gl_date IN DATE,
156: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
157: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
158: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
159: x_line_num IN po_online_report_text.line_num%TYPE,
160: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
161: x_distribution_num IN po_online_report_text.distribution_num%TYPE
162: );
155: x_gl_date IN DATE,
156: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
157: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
158: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
159: x_line_num IN po_online_report_text.line_num%TYPE,
160: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
161: x_distribution_num IN po_online_report_text.distribution_num%TYPE
162: );
163:
156: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
157: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
158: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
159: x_line_num IN po_online_report_text.line_num%TYPE,
160: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
161: x_distribution_num IN po_online_report_text.distribution_num%TYPE
162: );
163:
164: PROCEDURE validate_destination_type_code(
157: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
158: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
159: x_line_num IN po_online_report_text.line_num%TYPE,
160: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
161: x_distribution_num IN po_online_report_text.distribution_num%TYPE
162: );
163:
164: PROCEDURE validate_destination_type_code(
165: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
165: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
166: x_item_id IN po_lines.item_id%TYPE,
167: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
168: x_accrue_on_receipt_flag IN varchar2,
169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
171: x_line_num IN po_online_report_text.line_num%TYPE,
172: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
173: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
166: x_item_id IN po_lines.item_id%TYPE,
167: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
168: x_accrue_on_receipt_flag IN varchar2,
169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
171: x_line_num IN po_online_report_text.line_num%TYPE,
172: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
173: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
174: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
167: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
168: x_accrue_on_receipt_flag IN varchar2,
169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
171: x_line_num IN po_online_report_text.line_num%TYPE,
172: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
173: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
174: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
175: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID
168: x_accrue_on_receipt_flag IN varchar2,
169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
171: x_line_num IN po_online_report_text.line_num%TYPE,
172: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
173: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
174: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
175: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID
176: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
171: x_line_num IN po_online_report_text.line_num%TYPE,
172: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
173: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
174: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
175: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID
176: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
177: );
177: );
178:
179: PROCEDURE validate_deliver_to_person_id(
180: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
181: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
182: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
183: x_line_num IN po_online_report_text.line_num%TYPE,
184: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
185: x_distribution_num IN po_online_report_text.distribution_num%TYPE
178:
179: PROCEDURE validate_deliver_to_person_id(
180: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
181: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
182: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
183: x_line_num IN po_online_report_text.line_num%TYPE,
184: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
185: x_distribution_num IN po_online_report_text.distribution_num%TYPE
186: );
179: PROCEDURE validate_deliver_to_person_id(
180: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
181: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
182: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
183: x_line_num IN po_online_report_text.line_num%TYPE,
184: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
185: x_distribution_num IN po_online_report_text.distribution_num%TYPE
186: );
187:
180: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
181: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
182: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
183: x_line_num IN po_online_report_text.line_num%TYPE,
184: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
185: x_distribution_num IN po_online_report_text.distribution_num%TYPE
186: );
187:
188: PROCEDURE validate_osp_data( x_wip_entity_id IN NUMBER,
181: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
182: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
183: x_line_num IN po_online_report_text.line_num%TYPE,
184: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
185: x_distribution_num IN po_online_report_text.distribution_num%TYPE
186: );
187:
188: PROCEDURE validate_osp_data( x_wip_entity_id IN NUMBER,
189: x_wip_operation_seq_num IN NUMBER,
190: x_wip_resource_seq_num IN NUMBER,
191: x_wip_repetitive_schedule_id IN NUMBER,
192: x_wip_line_id IN NUMBER,
193: x_destination_organization_id IN NUMBER,
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_line_num IN po_online_report_text.line_num%TYPE,
197: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
198: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
191: x_wip_repetitive_schedule_id IN NUMBER,
192: x_wip_line_id IN NUMBER,
193: x_destination_organization_id IN NUMBER,
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_line_num IN po_online_report_text.line_num%TYPE,
197: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
198: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
199:
192: x_wip_line_id IN NUMBER,
193: x_destination_organization_id IN NUMBER,
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_line_num IN po_online_report_text.line_num%TYPE,
197: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
198: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
199:
200: PROCEDURE validate_deliver_to_loc_id(
193: x_destination_organization_id IN NUMBER,
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_line_num IN po_online_report_text.line_num%TYPE,
197: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
198: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
199:
200: PROCEDURE validate_deliver_to_loc_id(
201: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_line_num IN po_online_report_text.line_num%TYPE,
197: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
198: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
199:
200: PROCEDURE validate_deliver_to_loc_id(
201: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
202: x_ship_to_organization_id IN NUMBER,
199:
200: PROCEDURE validate_deliver_to_loc_id(
201: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
202: x_ship_to_organization_id IN NUMBER,
203: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
204: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
205: x_line_num IN po_online_report_text.line_num%TYPE,
206: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
207: x_distribution_num IN po_online_report_text.distribution_num%TYPE
200: PROCEDURE validate_deliver_to_loc_id(
201: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
202: x_ship_to_organization_id IN NUMBER,
203: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
204: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
205: x_line_num IN po_online_report_text.line_num%TYPE,
206: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
207: x_distribution_num IN po_online_report_text.distribution_num%TYPE
208: );
201: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
202: x_ship_to_organization_id IN NUMBER,
203: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
204: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
205: x_line_num IN po_online_report_text.line_num%TYPE,
206: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
207: x_distribution_num IN po_online_report_text.distribution_num%TYPE
208: );
209:
202: x_ship_to_organization_id IN NUMBER,
203: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
204: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
205: x_line_num IN po_online_report_text.line_num%TYPE,
206: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
207: x_distribution_num IN po_online_report_text.distribution_num%TYPE
208: );
209:
210: PROCEDURE validate_dest_subinventory(
203: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
204: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
205: x_line_num IN po_online_report_text.line_num%TYPE,
206: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
207: x_distribution_num IN po_online_report_text.distribution_num%TYPE
208: );
209:
210: PROCEDURE validate_dest_subinventory(
211: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
210: PROCEDURE validate_dest_subinventory(
211: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
212: x_ship_to_organization_id IN NUMBER,
213: x_item_id IN po_lines.item_id%TYPE,
214: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
215: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
216: x_line_num IN po_online_report_text.line_num%TYPE,
217: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
218: x_distribution_num IN po_online_report_text.distribution_num%TYPE
211: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
212: x_ship_to_organization_id IN NUMBER,
213: x_item_id IN po_lines.item_id%TYPE,
214: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
215: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
216: x_line_num IN po_online_report_text.line_num%TYPE,
217: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
218: x_distribution_num IN po_online_report_text.distribution_num%TYPE
219: );
212: x_ship_to_organization_id IN NUMBER,
213: x_item_id IN po_lines.item_id%TYPE,
214: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
215: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
216: x_line_num IN po_online_report_text.line_num%TYPE,
217: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
218: x_distribution_num IN po_online_report_text.distribution_num%TYPE
219: );
220:
213: x_item_id IN po_lines.item_id%TYPE,
214: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
215: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
216: x_line_num IN po_online_report_text.line_num%TYPE,
217: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
218: x_distribution_num IN po_online_report_text.distribution_num%TYPE
219: );
220:
221: --
214: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
215: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
216: x_line_num IN po_online_report_text.line_num%TYPE,
217: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
218: x_distribution_num IN po_online_report_text.distribution_num%TYPE
219: );
220:
221: --
222: -- this is now added to regular submission check (POXVDCKB.pls 115.30)
222: -- this is now added to regular submission check (POXVDCKB.pls 115.30)
223:
224: PROCEDURE validate_contract_num(
225: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
226: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
227: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
228: x_line_num IN po_online_report_text.line_num%TYPE
229: );
230:
223:
224: PROCEDURE validate_contract_num(
225: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
226: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
227: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
228: x_line_num IN po_online_report_text.line_num%TYPE
229: );
230:
231: --
224: PROCEDURE validate_contract_num(
225: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
226: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
227: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
228: x_line_num IN po_online_report_text.line_num%TYPE
229: );
230:
231: --
232: --Procedure that validate that the referenced global agreement is not cancelled or
233: --finally closed
234: PROCEDURE validate_global_ref(
235: p_from_header_id IN po_headers_all.po_header_id%TYPE,
236: p_from_line_id IN po_lines_all.po_line_id%TYPE,
237: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
238: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
239: p_line_num IN po_online_report_text.line_num%TYPE
240: );
241: --
234: PROCEDURE validate_global_ref(
235: p_from_header_id IN po_headers_all.po_header_id%TYPE,
236: p_from_line_id IN po_lines_all.po_line_id%TYPE,
237: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
238: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
239: p_line_num IN po_online_report_text.line_num%TYPE
240: );
241: --
242:
235: p_from_header_id IN po_headers_all.po_header_id%TYPE,
236: p_from_line_id IN po_lines_all.po_line_id%TYPE,
237: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
238: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
239: p_line_num IN po_online_report_text.line_num%TYPE
240: );
241: --
242:
243: -- SERVICES FPJ Start
244: -- Procedure to validate the temp labor Job on PO lines
245:
246: PROCEDURE validate_job(
247: p_job_id IN po_lines.job_id%TYPE,
248: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
249: p_line_num IN po_online_report_text.line_num%TYPE,
250: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
251: );
252:
245:
246: PROCEDURE validate_job(
247: p_job_id IN po_lines.job_id%TYPE,
248: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
249: p_line_num IN po_online_report_text.line_num%TYPE,
250: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
251: );
252:
253: -- SERVICES FPJ End
246: PROCEDURE validate_job(
247: p_job_id IN po_lines.job_id%TYPE,
248: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
249: p_line_num IN po_online_report_text.line_num%TYPE,
250: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
251: );
252:
253: -- SERVICES FPJ End
254:
289: PROCEDURE validate_exp_item_date(
290: x_project_id IN NUMBER,
291: x_task_id IN NUMBER,
292: x_exp_item_date IN OUT NOCOPY DATE,
293: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
294: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
295: x_line_num IN po_online_report_text.line_num%TYPE,
296: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
297: x_distribution_num IN po_online_report_text.distribution_num%TYPE
290: x_project_id IN NUMBER,
291: x_task_id IN NUMBER,
292: x_exp_item_date IN OUT NOCOPY DATE,
293: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
294: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
295: x_line_num IN po_online_report_text.line_num%TYPE,
296: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
297: x_distribution_num IN po_online_report_text.distribution_num%TYPE
298: );
291: x_task_id IN NUMBER,
292: x_exp_item_date IN OUT NOCOPY DATE,
293: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
294: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
295: x_line_num IN po_online_report_text.line_num%TYPE,
296: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
297: x_distribution_num IN po_online_report_text.distribution_num%TYPE
298: );
299:
292: x_exp_item_date IN OUT NOCOPY DATE,
293: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
294: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
295: x_line_num IN po_online_report_text.line_num%TYPE,
296: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
297: x_distribution_num IN po_online_report_text.distribution_num%TYPE
298: );
299:
300: PROCEDURE validate_exp_type(
293: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
294: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
295: x_line_num IN po_online_report_text.line_num%TYPE,
296: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
297: x_distribution_num IN po_online_report_text.distribution_num%TYPE
298: );
299:
300: PROCEDURE validate_exp_type(
301: x_project_id IN NUMBER,
299:
300: PROCEDURE validate_exp_type(
301: x_project_id IN NUMBER,
302: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
303: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
304: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
305: x_line_num IN po_online_report_text.line_num%TYPE,
306: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
307: x_distribution_num IN po_online_report_text.distribution_num%TYPE
300: PROCEDURE validate_exp_type(
301: x_project_id IN NUMBER,
302: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
303: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
304: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
305: x_line_num IN po_online_report_text.line_num%TYPE,
306: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
307: x_distribution_num IN po_online_report_text.distribution_num%TYPE
308: );
301: x_project_id IN NUMBER,
302: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
303: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
304: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
305: x_line_num IN po_online_report_text.line_num%TYPE,
306: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
307: x_distribution_num IN po_online_report_text.distribution_num%TYPE
308: );
309:
302: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
303: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
304: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
305: x_line_num IN po_online_report_text.line_num%TYPE,
306: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
307: x_distribution_num IN po_online_report_text.distribution_num%TYPE
308: );
309:
310: PROCEDURE validate_exp_org(
303: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
304: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
305: x_line_num IN po_online_report_text.line_num%TYPE,
306: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
307: x_distribution_num IN po_online_report_text.distribution_num%TYPE
308: );
309:
310: PROCEDURE validate_exp_org(
311: x_org_id IN OUT NOCOPY NUMBER,
308: );
309:
310: PROCEDURE validate_exp_org(
311: x_org_id IN OUT NOCOPY NUMBER,
312: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
313: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
314: x_line_num IN po_online_report_text.line_num%TYPE,
315: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
316: x_distribution_num IN po_online_report_text.distribution_num%TYPE
309:
310: PROCEDURE validate_exp_org(
311: x_org_id IN OUT NOCOPY NUMBER,
312: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
313: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
314: x_line_num IN po_online_report_text.line_num%TYPE,
315: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
316: x_distribution_num IN po_online_report_text.distribution_num%TYPE
317: );
310: PROCEDURE validate_exp_org(
311: x_org_id IN OUT NOCOPY NUMBER,
312: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
313: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
314: x_line_num IN po_online_report_text.line_num%TYPE,
315: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
316: x_distribution_num IN po_online_report_text.distribution_num%TYPE
317: );
318:
311: x_org_id IN OUT NOCOPY NUMBER,
312: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
313: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
314: x_line_num IN po_online_report_text.line_num%TYPE,
315: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
316: x_distribution_num IN po_online_report_text.distribution_num%TYPE
317: );
318:
319: -- End Bug 3488117
312: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
313: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
314: x_line_num IN po_online_report_text.line_num%TYPE,
315: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
316: x_distribution_num IN po_online_report_text.distribution_num%TYPE
317: );
318:
319: -- End Bug 3488117
320:
327: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
330: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
331: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
332: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
333: ) IS
334:
335: x_progress VARCHAR2(4) := NULL;
328: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
329: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
330: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
331: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
332: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
333: ) IS
334:
335: x_progress VARCHAR2(4) := NULL;
336:
386: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
389: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
392: ) IS
393:
394: x_progress VARCHAR2(4) := NULL;
387: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
388: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
389: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
392: ) IS
393:
394: x_progress VARCHAR2(4) := NULL;
395:
449: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
452: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
453: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
454: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
455: ) IS
456:
457: x_progress VARCHAR2(4) := NULL;
450: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
451: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
452: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
453: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
454: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
455: ) IS
456:
457: x_progress VARCHAR2(4) := NULL;
458:
506:
507:
508: PROCEDURE validate_buyer_id(
509: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
510: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
511: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
512: ) IS
513: x_valid_flag VARCHAR2(2) := NULL;
514: x_progress VARCHAR2(4) := NULL;
507:
508: PROCEDURE validate_buyer_id(
509: x_buyer_id IN OUT NOCOPY po_headers.agent_id%TYPE,
510: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
511: x_sequence IN OUT NOCOPY po_online_report_text.line_num%TYPE
512: ) IS
513: x_valid_flag VARCHAR2(2) := NULL;
514: x_progress VARCHAR2(4) := NULL;
515:
566: x_ship_via_lookup_code IN OUT NOCOPY po_headers.ship_via_lookup_code%TYPE,
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
569: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
570: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
571: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
572: ) IS
573:
574: x_progress VARCHAR2(4) := NULL;
567: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
568: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
569: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
570: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
571: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
572: ) IS
573:
574: x_progress VARCHAR2(4) := NULL;
575: x_valid_flag VARCHAR2(2) := NULL;
722: x_bill_to_location_id IN OUT NOCOPY po_headers.bill_to_location_id%TYPE,
723: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
724: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
725: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
726: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
727: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
728: ) IS
729:
730: x_progress VARCHAR2(4) := NULL;
723: x_fob_lookup_code IN OUT NOCOPY po_headers.fob_lookup_code%TYPE,
724: x_freight_terms_lu_code IN OUT NOCOPY po_headers.freight_terms_lookup_code%TYPE,
725: x_terms_id IN OUT NOCOPY po_headers.terms_id%TYPE,
726: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
727: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
728: ) IS
729:
730: x_progress VARCHAR2(4) := NULL;
731: x_valid_flag VARCHAR2(2) := NULL;
870: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
872: x_line_type_id IN po_lines.line_type_id%TYPE,
873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
874: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
875: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
876: x_line_num IN po_online_report_text.line_num%TYPE,
877: x_return_code OUT NOCOPY NUMBER
878: ) IS
871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
872: x_line_type_id IN po_lines.line_type_id%TYPE,
873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
874: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
875: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
876: x_line_num IN po_online_report_text.line_num%TYPE,
877: x_return_code OUT NOCOPY NUMBER
878: ) IS
879:
872: x_line_type_id IN po_lines.line_type_id%TYPE,
873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
874: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
875: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
876: x_line_num IN po_online_report_text.line_num%TYPE,
877: x_return_code OUT NOCOPY NUMBER
878: ) IS
879:
880: x_progress VARCHAR2(4);
1193: x_account_id IN OUT NOCOPY NUMBER,
1194: x_account_type IN VARCHAR2,
1195: x_gl_date IN DATE,
1196: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1197: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1198: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1199: x_line_num IN po_online_report_text.line_num%TYPE,
1200: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1201: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1194: x_account_type IN VARCHAR2,
1195: x_gl_date IN DATE,
1196: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1197: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1198: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1199: x_line_num IN po_online_report_text.line_num%TYPE,
1200: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1201: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1202: )IS
1195: x_gl_date IN DATE,
1196: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1197: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1198: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1199: x_line_num IN po_online_report_text.line_num%TYPE,
1200: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1201: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1202: )IS
1203: x_valid_flag VARCHAR2(2);
1196: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
1197: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1198: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1199: x_line_num IN po_online_report_text.line_num%TYPE,
1200: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1201: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1202: )IS
1203: x_valid_flag VARCHAR2(2);
1204: x_progress VARCHAR2(4) := NULL;
1197: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1198: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1199: x_line_num IN po_online_report_text.line_num%TYPE,
1200: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1201: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1202: )IS
1203: x_valid_flag VARCHAR2(2);
1204: x_progress VARCHAR2(4) := NULL;
1205:
1256:
1257: /**
1258: * Private Procedure: validate_project_id
1259: * Requires: Destination type is EXPENSE.
1260: * Modifies: PO_ONLINE_REPORT_TEXT
1261: * Effects: Validates that the given project_id exists as a
1262: * chargeable PA project. If not, writes an error message to
1263: * PO_ONLINE_REPORT_TEXT.
1264: * Returns: none
1259: * Requires: Destination type is EXPENSE.
1260: * Modifies: PO_ONLINE_REPORT_TEXT
1261: * Effects: Validates that the given project_id exists as a
1262: * chargeable PA project. If not, writes an error message to
1263: * PO_ONLINE_REPORT_TEXT.
1264: * Returns: none
1265: */
1266: PROCEDURE validate_project_id(
1267: x_project_id IN OUT NOCOPY po_distributions.project_id%TYPE,
1269: -- Removed the x_destination_type_code and x_ship_to_organization_id arguments.
1270: -- Added NOCOPY to x_project_id and x_sequence.
1271: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
1272: -- x_ship_to_organization_id IN NUMBER,
1273: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1274: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1275: x_line_num IN po_online_report_text.line_num%TYPE,
1276: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1277: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1270: -- Added NOCOPY to x_project_id and x_sequence.
1271: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
1272: -- x_ship_to_organization_id IN NUMBER,
1273: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1274: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1275: x_line_num IN po_online_report_text.line_num%TYPE,
1276: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1277: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1278: )IS
1271: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
1272: -- x_ship_to_organization_id IN NUMBER,
1273: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1274: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1275: x_line_num IN po_online_report_text.line_num%TYPE,
1276: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1277: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1278: )IS
1279: x_valid_flag VARCHAR2(2);
1272: -- x_ship_to_organization_id IN NUMBER,
1273: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1274: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1275: x_line_num IN po_online_report_text.line_num%TYPE,
1276: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1277: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1278: )IS
1279: x_valid_flag VARCHAR2(2);
1280: x_progress VARCHAR2(4) := NULL;
1273: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1274: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1275: x_line_num IN po_online_report_text.line_num%TYPE,
1276: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1277: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1278: )IS
1279: x_valid_flag VARCHAR2(2);
1280: x_progress VARCHAR2(4) := NULL;
1281:
1336:
1337: PROCEDURE validate_task_id(
1338: x_task_id IN OUT NOCOPY NUMBER,
1339: x_project_id IN NUMBER,
1340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1342: x_line_num IN po_online_report_text.line_num%TYPE,
1343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1337: PROCEDURE validate_task_id(
1338: x_task_id IN OUT NOCOPY NUMBER,
1339: x_project_id IN NUMBER,
1340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1342: x_line_num IN po_online_report_text.line_num%TYPE,
1343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1345: )IS
1338: x_task_id IN OUT NOCOPY NUMBER,
1339: x_project_id IN NUMBER,
1340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1342: x_line_num IN po_online_report_text.line_num%TYPE,
1343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1345: )IS
1346: x_valid_flag VARCHAR2(2);
1339: x_project_id IN NUMBER,
1340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1342: x_line_num IN po_online_report_text.line_num%TYPE,
1343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1345: )IS
1346: x_valid_flag VARCHAR2(2);
1347: x_progress VARCHAR2(4) := NULL;
1340: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1341: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1342: x_line_num IN po_online_report_text.line_num%TYPE,
1343: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1344: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1345: )IS
1346: x_valid_flag VARCHAR2(2);
1347: x_progress VARCHAR2(4) := NULL;
1348:
1386: PROCEDURE validate_exp_item_date(
1387: x_project_id IN NUMBER,
1388: x_task_id IN NUMBER,
1389: x_exp_item_date IN OUT NOCOPY DATE,
1390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1392: x_line_num IN po_online_report_text.line_num%TYPE,
1393: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1394: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1387: x_project_id IN NUMBER,
1388: x_task_id IN NUMBER,
1389: x_exp_item_date IN OUT NOCOPY DATE,
1390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1392: x_line_num IN po_online_report_text.line_num%TYPE,
1393: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1394: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1395: )IS
1388: x_task_id IN NUMBER,
1389: x_exp_item_date IN OUT NOCOPY DATE,
1390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1392: x_line_num IN po_online_report_text.line_num%TYPE,
1393: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1394: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1395: )IS
1396: x_valid_flag VARCHAR2(2) := 'N';
1389: x_exp_item_date IN OUT NOCOPY DATE,
1390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1392: x_line_num IN po_online_report_text.line_num%TYPE,
1393: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1394: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1395: )IS
1396: x_valid_flag VARCHAR2(2) := 'N';
1397: x_progress VARCHAR2(4) := NULL;
1390: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1391: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1392: x_line_num IN po_online_report_text.line_num%TYPE,
1393: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1394: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1395: )IS
1396: x_valid_flag VARCHAR2(2) := 'N';
1397: x_progress VARCHAR2(4) := NULL;
1398: BEGIN
1435:
1436: PROCEDURE validate_exp_type(
1437: x_project_id IN NUMBER,
1438: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1439: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1440: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1441: x_line_num IN po_online_report_text.line_num%TYPE,
1442: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1443: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1436: PROCEDURE validate_exp_type(
1437: x_project_id IN NUMBER,
1438: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1439: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1440: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1441: x_line_num IN po_online_report_text.line_num%TYPE,
1442: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1443: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1444: )IS
1437: x_project_id IN NUMBER,
1438: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1439: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1440: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1441: x_line_num IN po_online_report_text.line_num%TYPE,
1442: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1443: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1444: )IS
1445: x_valid_flag VARCHAR2(2) := 'N';
1438: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1439: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1440: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1441: x_line_num IN po_online_report_text.line_num%TYPE,
1442: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1443: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1444: )IS
1445: x_valid_flag VARCHAR2(2) := 'N';
1446: x_progress VARCHAR2(4) := NULL;
1439: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1440: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1441: x_line_num IN po_online_report_text.line_num%TYPE,
1442: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1443: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1444: )IS
1445: x_valid_flag VARCHAR2(2) := 'N';
1446: x_progress VARCHAR2(4) := NULL;
1447: BEGIN
1479: END validate_exp_type;
1480:
1481: PROCEDURE validate_exp_org(
1482: x_org_id IN OUT NOCOPY NUMBER,
1483: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1484: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1485: x_line_num IN po_online_report_text.line_num%TYPE,
1486: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1487: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1480:
1481: PROCEDURE validate_exp_org(
1482: x_org_id IN OUT NOCOPY NUMBER,
1483: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1484: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1485: x_line_num IN po_online_report_text.line_num%TYPE,
1486: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1487: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1488: )IS
1481: PROCEDURE validate_exp_org(
1482: x_org_id IN OUT NOCOPY NUMBER,
1483: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1484: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1485: x_line_num IN po_online_report_text.line_num%TYPE,
1486: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1487: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1488: )IS
1489: x_valid_flag VARCHAR2(2) := 'N';
1482: x_org_id IN OUT NOCOPY NUMBER,
1483: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1484: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1485: x_line_num IN po_online_report_text.line_num%TYPE,
1486: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1487: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1488: )IS
1489: x_valid_flag VARCHAR2(2) := 'N';
1490: x_progress VARCHAR2(4) := NULL;
1483: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1484: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1485: x_line_num IN po_online_report_text.line_num%TYPE,
1486: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1487: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1488: )IS
1489: x_valid_flag VARCHAR2(2) := 'N';
1490: x_progress VARCHAR2(4) := NULL;
1491: BEGIN
1524: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
1525: x_item_id IN po_lines.item_id%TYPE,
1526: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1527: x_accrue_on_receipt_flag IN varchar2,
1528: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1529: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1530: x_line_num IN po_online_report_text.line_num%TYPE,
1531: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1532: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1525: x_item_id IN po_lines.item_id%TYPE,
1526: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1527: x_accrue_on_receipt_flag IN varchar2,
1528: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1529: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1530: x_line_num IN po_online_report_text.line_num%TYPE,
1531: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1532: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1533: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1526: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1527: x_accrue_on_receipt_flag IN varchar2,
1528: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1529: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1530: x_line_num IN po_online_report_text.line_num%TYPE,
1531: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1532: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1533: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1534: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1527: x_accrue_on_receipt_flag IN varchar2,
1528: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1529: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1530: x_line_num IN po_online_report_text.line_num%TYPE,
1531: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1532: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1533: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1534: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1535: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
1528: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1529: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1530: x_line_num IN po_online_report_text.line_num%TYPE,
1531: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1532: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1533: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1534: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1535: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
1536: ) IS
1687:
1688: /* deliver_to_person = Requestor */
1689: PROCEDURE validate_deliver_to_person_id(
1690: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1691: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1692: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1693: x_line_num IN po_online_report_text.line_num%TYPE,
1694: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1695: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1688: /* deliver_to_person = Requestor */
1689: PROCEDURE validate_deliver_to_person_id(
1690: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1691: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1692: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1693: x_line_num IN po_online_report_text.line_num%TYPE,
1694: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1695: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1696: )IS
1689: PROCEDURE validate_deliver_to_person_id(
1690: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1691: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1692: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1693: x_line_num IN po_online_report_text.line_num%TYPE,
1694: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1695: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1696: )IS
1697: x_valid_flag VARCHAR2(2);
1690: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1691: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1692: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1693: x_line_num IN po_online_report_text.line_num%TYPE,
1694: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1695: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1696: )IS
1697: x_valid_flag VARCHAR2(2);
1698: x_progress VARCHAR2(4) := NULL;
1691: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1692: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1693: x_line_num IN po_online_report_text.line_num%TYPE,
1694: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1695: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1696: )IS
1697: x_valid_flag VARCHAR2(2);
1698: x_progress VARCHAR2(4) := NULL;
1699:
1740: x_wip_resource_seq_num IN NUMBER,
1741: x_wip_repetitive_schedule_id IN NUMBER,
1742: x_wip_line_id IN NUMBER,
1743: x_destination_organization_id IN NUMBER,
1744: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1745: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1746: x_line_num IN po_online_report_text.line_num%TYPE,
1747: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1748: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1741: x_wip_repetitive_schedule_id IN NUMBER,
1742: x_wip_line_id IN NUMBER,
1743: x_destination_organization_id IN NUMBER,
1744: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1745: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1746: x_line_num IN po_online_report_text.line_num%TYPE,
1747: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1748: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1749: IS
1742: x_wip_line_id IN NUMBER,
1743: x_destination_organization_id IN NUMBER,
1744: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1745: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1746: x_line_num IN po_online_report_text.line_num%TYPE,
1747: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1748: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1749: IS
1750: x_count number;
1743: x_destination_organization_id IN NUMBER,
1744: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1745: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1746: x_line_num IN po_online_report_text.line_num%TYPE,
1747: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1748: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1749: IS
1750: x_count number;
1751: x_progress VARCHAR2(4) := '10';
1744: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1745: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1746: x_line_num IN po_online_report_text.line_num%TYPE,
1747: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1748: x_distribution_num IN po_online_report_text.distribution_num%TYPE)
1749: IS
1750: x_count number;
1751: x_progress VARCHAR2(4) := '10';
1752: --Bug# 2090549 togeorge 11/05/2001
1896: /* Deliver To Location */
1897: PROCEDURE validate_deliver_to_loc_id(
1898: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
1899: x_ship_to_organization_id IN NUMBER,
1900: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1901: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1902: x_line_num IN po_online_report_text.line_num%TYPE,
1903: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1904: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1897: PROCEDURE validate_deliver_to_loc_id(
1898: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
1899: x_ship_to_organization_id IN NUMBER,
1900: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1901: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1902: x_line_num IN po_online_report_text.line_num%TYPE,
1903: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1904: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1905: )IS
1898: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
1899: x_ship_to_organization_id IN NUMBER,
1900: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1901: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1902: x_line_num IN po_online_report_text.line_num%TYPE,
1903: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1904: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1905: )IS
1906: x_valid_flag VARCHAR2(2);
1899: x_ship_to_organization_id IN NUMBER,
1900: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1901: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1902: x_line_num IN po_online_report_text.line_num%TYPE,
1903: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1904: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1905: )IS
1906: x_valid_flag VARCHAR2(2);
1907: x_progress VARCHAR2(4) := NULL;
1900: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1901: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1902: x_line_num IN po_online_report_text.line_num%TYPE,
1903: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1904: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1905: )IS
1906: x_valid_flag VARCHAR2(2);
1907: x_progress VARCHAR2(4) := NULL;
1908:
1957: PROCEDURE validate_dest_subinventory(
1958: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
1959: x_ship_to_organization_id IN NUMBER,
1960: x_item_id IN po_lines.item_id%TYPE,
1961: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1962: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1963: x_line_num IN po_online_report_text.line_num%TYPE,
1964: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1965: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1958: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
1959: x_ship_to_organization_id IN NUMBER,
1960: x_item_id IN po_lines.item_id%TYPE,
1961: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1962: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1963: x_line_num IN po_online_report_text.line_num%TYPE,
1964: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1965: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1966: )IS
1959: x_ship_to_organization_id IN NUMBER,
1960: x_item_id IN po_lines.item_id%TYPE,
1961: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1962: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1963: x_line_num IN po_online_report_text.line_num%TYPE,
1964: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1965: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1966: )IS
1967: x_valid_flag VARCHAR2(2);
1960: x_item_id IN po_lines.item_id%TYPE,
1961: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1962: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1963: x_line_num IN po_online_report_text.line_num%TYPE,
1964: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1965: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1966: )IS
1967: x_valid_flag VARCHAR2(2);
1968: x_progress VARCHAR2(4) := NULL;
1961: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1962: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1963: x_line_num IN po_online_report_text.line_num%TYPE,
1964: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1965: x_distribution_num IN po_online_report_text.distribution_num%TYPE
1966: )IS
1967: x_valid_flag VARCHAR2(2);
1968: x_progress VARCHAR2(4) := NULL;
1969:
2020:
2021:
2022: PROCEDURE validate_contract_num(
2023: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
2024: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2025: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2026: x_line_num IN po_online_report_text.line_num%TYPE
2027: ) IS
2028: x_valid_flag VARCHAR2(2);
2021:
2022: PROCEDURE validate_contract_num(
2023: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
2024: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2025: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2026: x_line_num IN po_online_report_text.line_num%TYPE
2027: ) IS
2028: x_valid_flag VARCHAR2(2);
2029: x_progress VARCHAR2(4) := NULL;
2022: PROCEDURE validate_contract_num(
2023: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
2024: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2025: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2026: x_line_num IN po_online_report_text.line_num%TYPE
2027: ) IS
2028: x_valid_flag VARCHAR2(2);
2029: x_progress VARCHAR2(4) := NULL;
2030:
2089: --finally closed
2090: PROCEDURE validate_global_ref(
2091: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2092: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2093: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2094: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2095: p_line_num IN po_online_report_text.line_num%TYPE
2096: ) IS
2097: l_valid_flag VARCHAR2(2);
2090: PROCEDURE validate_global_ref(
2091: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2092: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2093: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2094: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2095: p_line_num IN po_online_report_text.line_num%TYPE
2096: ) IS
2097: l_valid_flag VARCHAR2(2);
2098: l_progress VARCHAR2(4) := NULL;
2091: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2092: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2093: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2094: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2095: p_line_num IN po_online_report_text.line_num%TYPE
2096: ) IS
2097: l_valid_flag VARCHAR2(2);
2098: l_progress VARCHAR2(4) := NULL;
2099:
2158: --End of Comments
2159: -------------------------------------------------------------------------------------------------
2160: PROCEDURE validate_job(
2161: p_job_id IN po_lines.job_id%TYPE,
2162: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2163: p_line_num IN po_online_report_text.line_num%TYPE,
2164: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
2165: ) IS
2166:
2159: -------------------------------------------------------------------------------------------------
2160: PROCEDURE validate_job(
2161: p_job_id IN po_lines.job_id%TYPE,
2162: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2163: p_line_num IN po_online_report_text.line_num%TYPE,
2164: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
2165: ) IS
2166:
2167: l_valid_flag VARCHAR2(2);
2160: PROCEDURE validate_job(
2161: p_job_id IN po_lines.job_id%TYPE,
2162: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2163: p_line_num IN po_online_report_text.line_num%TYPE,
2164: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
2165: ) IS
2166:
2167: l_valid_flag VARCHAR2(2);
2168: l_progress VARCHAR2(4) := NULL;
2277: x_po_line_record po_lines%ROWTYPE;
2278: x_po_shipment_record po_line_locations%ROWTYPE;
2279: x_po_distribution_record po_distributions%ROWTYPE;
2280:
2281: x_line_num po_online_report_text.line_num%TYPE := NULL;
2282: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2283: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
2284:
2285: x_progress VARCHAR2(4);
2278: x_po_shipment_record po_line_locations%ROWTYPE;
2279: x_po_distribution_record po_distributions%ROWTYPE;
2280:
2281: x_line_num po_online_report_text.line_num%TYPE := NULL;
2282: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2283: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
2284:
2285: x_progress VARCHAR2(4);
2286: x_sequence po_online_report_text.sequence%TYPE := 1;
2279: x_po_distribution_record po_distributions%ROWTYPE;
2280:
2281: x_line_num po_online_report_text.line_num%TYPE := NULL;
2282: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2283: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
2284:
2285: x_progress VARCHAR2(4);
2286: x_sequence po_online_report_text.sequence%TYPE := 1;
2287: x_return_code NUMBER := NULL;
2282: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2283: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
2284:
2285: x_progress VARCHAR2(4);
2286: x_sequence po_online_report_text.sequence%TYPE := 1;
2287: x_return_code NUMBER := NULL;
2288:
2289: --
2290: l_encumbrance_on BOOLEAN;
2689: , X_msg_data => X_msg_data
2690: , X_billable_flag => X_billable_flag);
2691:
2692: IF x_msg_type = 'E' and x_msg_data is not NULL THEN
2693: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2694: po_copydoc_s1.online_report(x_online_report_id,
2695: x_sequence, x_msg_data,
2696: x_line_num, x_shipment_num, x_distribution_num,
2697: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2695: x_sequence, x_msg_data,
2696: x_line_num, x_shipment_num, x_distribution_num,
2697: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2698: ELSIF x_msg_type = 'W' and x_msg_data is not NULL THEN
2699: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2700: po_copydoc_s1.online_report(x_online_report_id,
2701: x_sequence, x_msg_data,
2702: x_line_num, x_shipment_num, x_distribution_num,
2703: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);
2719: x_error_code => l_val_proj_error_code,
2720: x_return_code => l_val_proj_result);
2721:
2722: IF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_failure) THEN
2723: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2724: po_copydoc_s1.online_report(x_online_report_id,
2725: x_sequence, FND_MESSAGE.get,
2726: x_line_num, x_shipment_num, x_distribution_num,
2727: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2725: x_sequence, FND_MESSAGE.get,
2726: x_line_num, x_shipment_num, x_distribution_num,
2727: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2728: ELSIF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_warning) THEN
2729: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2730: po_copydoc_s1.online_report(x_online_report_id,
2731: x_sequence, FND_MESSAGE.get,
2732: x_line_num, x_shipment_num, x_distribution_num,
2733: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);
2818: --Name: validate_transaction_flow
2819: --Pre-reqs:
2820: -- None.
2821: --Modifies:
2822: -- PO_ONLINE_REPORT_TEXT
2823: --Locks:
2824: -- None.
2825: --Function:
2826: -- Validates the transaction flow if it is not NULL. If it is a valid
2836: --p_shipment_num
2837: --p_item_id
2838: --IN OUT:
2839: --x_sequence
2840: -- PO_ONLINE_REPORT_TEXT.sequence.
2841: --End of Comments
2842: --------------------------------------------------------------------------------
2843: PROCEDURE validate_transaction_flow
2844: (
2926: --Name: validate_org_assignments
2927: --Pre-reqs:
2928: -- None.
2929: --Modifies:
2930: -- PO_ONLINE_REPORT_TEXT
2931: -- PO_SESSION_GT
2932: -- PO_SESSION_GT_S
2933: --Locks:
2934: -- None.
2935: --Function:
2936: -- Validates all the enabled org assignments of the Global Agreement
2937: -- p_po_header_id. Checks if the Requesting Org, Purchasing Org, and
2938: -- Purchasing Site are still valid for all the enabled records. Inserts an
2939: -- error message to PO_ONLINE_REPORT_TEXT table under ID p_online_report_id
2940: -- for each check that fails.
2941: --Parameters:
2942: --IN:
2943: --p_po_header_id
2948: -- The online report ID to write to if an error occurs.
2949: --IN OUT:
2950: --x_sequence
2951: -- The online report sequence, which gets incremented when an error is
2952: -- written to PO_ONLINE_REPORT_TEXT.
2953: --End of Comments
2954: --------------------------------------------------------------------------------
2955: PROCEDURE validate_org_assignments
2956: (
2968: l_err_prefix VARCHAR2(256);
2969: l_populate_failed_exc EXCEPTION;
2970:
2971: l_key PO_SESSION_GT.key%TYPE;
2972: l_text_line PO_ONLINE_REPORT_TEXT.text_line%TYPE;
2973: l_message_type PO_ONLINE_REPORT_TEXT.message_type%TYPE;
2974:
2975: BEGIN
2976:
2969: l_populate_failed_exc EXCEPTION;
2970:
2971: l_key PO_SESSION_GT.key%TYPE;
2972: l_text_line PO_ONLINE_REPORT_TEXT.text_line%TYPE;
2973: l_message_type PO_ONLINE_REPORT_TEXT.message_type%TYPE;
2974:
2975: BEGIN
2976:
2977: l_progress := '000';
3002: -- Validate the Requesting Orgs for all enabled org assignments
3003: l_text_line := FND_MESSAGE.get_string
3004: (appin => 'PO',
3005: namein => 'PO_GA_INVALID_REQUESTING_ORG');
3006: INSERT INTO po_online_report_text
3007: (
3008: online_report_id,
3009: last_update_login,
3010: last_updated_by,
3050: -- Validate the Purchasing Orgs for all enabled org assignments
3051: l_text_line := FND_MESSAGE.get_string
3052: (appin => 'PO',
3053: namein => 'PO_GA_INVALID_PURCHASING_ORG');
3054: INSERT INTO po_online_report_text
3055: (
3056: online_report_id,
3057: last_update_login,
3058: last_updated_by,
3126: -- Validate the Purchasing Sites for all enabled org assignments
3127: l_text_line := FND_MESSAGE.get_string
3128: (appin => 'PO',
3129: namein => 'PO_GA_INVALID_PURCHASING_SITE');
3130: INSERT INTO po_online_report_text
3131: (
3132: online_report_id,
3133: last_update_login,
3134: last_updated_by,
3209: -- The online report ID to write to if an error occurs.
3210: --IN OUT:
3211: --x_sequence
3212: -- The online report sequence, which gets incremented when an error is
3213: -- written to PO_ONLINE_REPORT_TEXT.
3214: --OUT:
3215: --x_return_status
3216: -- FND_API.g_ret_sts_success - success
3217: -- FND_API.g_ret_sts_unexp_error - unexpected error occurs