12: X_shipment_num NUMBER;
13:
14: BEGIN
15:
16: dbms_output.put_line('before call');
17:
18: po_shipments_sv1.get_shipment_num(X_po_release_id,
19: X_po_line_id,
20: X_shipment_num);
18: po_shipments_sv1.get_shipment_num(X_po_release_id,
19: X_po_line_id,
20: X_shipment_num);
21:
22: dbms_output.put_line('after call');
23: dbms_output.put_line(X_shipment_num);
24:
25: END test_get_shipment_num;
26:
19: X_po_line_id,
20: X_shipment_num);
21:
22: dbms_output.put_line('after call');
23: dbms_output.put_line(X_shipment_num);
24:
25: END test_get_shipment_num;
26:
27: /*===========================================================================
62: X_inspection_required_flag VARCHAR2(1) := '';
63:
64: BEGIN
65:
66: dbms_output.put_line('before call');
67:
68: po_shipments_sv1.get_planned_ship_info(
69: X_source_shipment_id,
70: X_set_of_books_id ,
92: X_accrue_on_receipt_flag,
93: X_receipt_required_flag,
94: X_inspection_required_flag);
95:
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
93: X_receipt_required_flag,
94: X_inspection_required_flag);
95:
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
94: X_inspection_required_flag);
95:
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
102:
95:
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
102:
103: END test_get_planned_ship_info;
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
102:
103: END test_get_planned_ship_info;
104:
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
102:
103: END test_get_planned_ship_info;
104:
105:
115: X_quantity_released NUMBER := '';
116:
117: BEGIN
118:
119: dbms_output.put_line('before call');
120:
121: X_quantity_released := po_shipments_sv1.get_sched_released_qty(X_source_id,
122: X_entity_level, X_shipment_type);
123:
120:
121: X_quantity_released := po_shipments_sv1.get_sched_released_qty(X_source_id,
122: X_entity_level, X_shipment_type);
123:
124: dbms_output.put_line('Return Value is = '||X_quantity_released);
125:
126: END test_get_sched_released_qty;
127:
128:
137: X_number_shipments NUMBER := '';
138:
139: BEGIN
140:
141: dbms_output.put_line('before call');
142:
143: X_number_shipments := po_shipments_sv2.get_number_shipments(X_po_line_id,
144: X_shipment_type);
145:
142:
143: X_number_shipments := po_shipments_sv2.get_number_shipments(X_po_line_id,
144: X_shipment_type);
145:
146: dbms_output.put_line('Return Value is = '||X_number_shipments);
147:
148: END test_get_number_shipments;
149:
150: /*===========================================================================
156: X_shipment_type IN VARCHAR2) IS
157:
158: BEGIN
159:
160: dbms_output.put_line('before call');
161:
162: IF po_shipments_sv2.val_release_shipments(X_po_line_id, X_shipment_type) THEN
163: dbms_output.put_line('Return TRUE');
164: ELSE
159:
160: dbms_output.put_line('before call');
161:
162: IF po_shipments_sv2.val_release_shipments(X_po_line_id, X_shipment_type) THEN
163: dbms_output.put_line('Return TRUE');
164: ELSE
165: dbms_output.put_line('Return FALSE');
166:
167: END IF;
161:
162: IF po_shipments_sv2.val_release_shipments(X_po_line_id, X_shipment_type) THEN
163: dbms_output.put_line('Return TRUE');
164: ELSE
165: dbms_output.put_line('Return FALSE');
166:
167: END IF;
168: END test_val_release_shipments;
169:
178: X_line_location_id NUMBER := '';
179:
180: BEGIN
181:
182: dbms_output.put_line('before call');
183:
184: X_line_location_id := po_shipments_sv3.get_line_location_id(X_po_line_id,
185: X_shipment_type);
186:
183:
184: X_line_location_id := po_shipments_sv3.get_line_location_id(X_po_line_id,
185: X_shipment_type);
186:
187: dbms_output.put_line('Return Value is = '||X_line_location_id);
188:
189: END test_get_line_location_id;
190:
191:
205: X_cancelled_flag VARCHAR2(1) := '';
206:
207: BEGIN
208:
209: dbms_output.put_line('before call');
210:
211: po_shipments_sv2.get_shipment_status(X_po_line_id,
212: X_shipment_type,
213: X_line_location_id,
215: X_encumbered_flag,
216: X_closed_code,
217: X_cancelled_flag);
218:
219: dbms_output.put_line('Approved Value is = '||X_approved_flag);
220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);
221: dbms_output.put_line('Closed Code is = '||X_closed_code);
222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);
223:
216: X_closed_code,
217: X_cancelled_flag);
218:
219: dbms_output.put_line('Approved Value is = '||X_approved_flag);
220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);
221: dbms_output.put_line('Closed Code is = '||X_closed_code);
222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);
223:
224: END test_get_shipment_status;
217: X_cancelled_flag);
218:
219: dbms_output.put_line('Approved Value is = '||X_approved_flag);
220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);
221: dbms_output.put_line('Closed Code is = '||X_closed_code);
222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);
223:
224: END test_get_shipment_status;
225:
218:
219: dbms_output.put_line('Approved Value is = '||X_approved_flag);
220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);
221: dbms_output.put_line('Closed Code is = '||X_closed_code);
222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);
223:
224: END test_get_shipment_status;
225:
226: /*===========================================================================
235: X_Ship_Val_For_Update BOOLEAN;
236:
237: BEGIN
238:
239: dbms_output.put_line('before call');
240:
241: IF po_shipments_sv2.val_ship_qty(X_po_line_id,
242: X_shipment_type,
243: X_line_quantity) THEN
240:
241: IF po_shipments_sv2.val_ship_qty(X_po_line_id,
242: X_shipment_type,
243: X_line_quantity) THEN
244: dbms_output.put_line('TRUE');
245: ELSE
246: dbms_output.put_line('FALSE');
247: END IF;
248:
242: X_shipment_type,
243: X_line_quantity) THEN
244: dbms_output.put_line('TRUE');
245: ELSE
246: dbms_output.put_line('FALSE');
247: END IF;
248:
249: END test_val_ship_qty;
250:
261: X_Ship_Val_For_Update BOOLEAN;
262:
263: BEGIN
264:
265: dbms_output.put_line('before call');
266:
267: IF po_shipments_sv2.val_ship_price(X_po_line_id,
268: X_shipment_type,
269: X_unit_price) THEN
266:
267: IF po_shipments_sv2.val_ship_price(X_po_line_id,
268: X_shipment_type,
269: X_unit_price) THEN
270: dbms_output.put_line('TRUE');
271: ELSE
272: dbms_output.put_line('FALSE');
273: END IF;
274:
268: X_shipment_type,
269: X_unit_price) THEN
270: dbms_output.put_line('TRUE');
271: ELSE
272: dbms_output.put_line('FALSE');
273: END IF;
274:
275: END test_val_ship_price;
276:
299: X_need_to_approve number;
300:
301: BEGIN
302:
303: dbms_output.put_line('before call');
304:
305: X_need_to_approve := po_shipments_sv10.val_approval_status(
306: X_shipment_id ,
307: X_shipment_type ,
322: NULL); --
323:
324: IF ((X_need_to_approve = 1) or
325: (X_need_to_approve = 2) ) THEN
326: dbms_output.put_line('TRUE');
327: ELSE
328: dbms_output.put_line('FALSE');
329: END IF;
330:
324: IF ((X_need_to_approve = 1) or
325: (X_need_to_approve = 2) ) THEN
326: dbms_output.put_line('TRUE');
327: ELSE
328: dbms_output.put_line('FALSE');
329: END IF;
330:
331: END test_val_approval_status;
332:
375: X_total_line_quantity NUMBER;
376:
377: BEGIN
378:
379: dbms_output.put_line('before call');
380:
381: po_shipments_sv5.val_source_line_num
382: (X_entity_level ,
383: X_po_line_id ,
397: X_receipt_required_flag ,
398: X_stock_enabled_flag ,
399: X_total_line_quantity );
400:
401: dbms_output.put_line('X_val_sched_released_qty = '||X_val_sched_released_qty);
402: dbms_output.put_line('X_item_id = '||X_item_id);
403: dbms_output.put_line('X_category_id = '||X_category_id);
404:
405:
398: X_stock_enabled_flag ,
399: X_total_line_quantity );
400:
401: dbms_output.put_line('X_val_sched_released_qty = '||X_val_sched_released_qty);
402: dbms_output.put_line('X_item_id = '||X_item_id);
403: dbms_output.put_line('X_category_id = '||X_category_id);
404:
405:
406: END test_source_line_server_cover;
399: X_total_line_quantity );
400:
401: dbms_output.put_line('X_val_sched_released_qty = '||X_val_sched_released_qty);
402: dbms_output.put_line('X_item_id = '||X_item_id);
403: dbms_output.put_line('X_category_id = '||X_category_id);
404:
405:
406: END test_source_line_server_cover;
407:
416: X_po_header_id IN NUMBER) IS
417:
418: BEGIN
419:
420: dbms_output.put_line('Before_call');
421:
422: /* IF po_rfqqt_s.val_start_dates(X_start_date, X_po_header_id) THEN
423: dbms_output.put_line('Return TRUE');
424: ELSE
419:
420: dbms_output.put_line('Before_call');
421:
422: /* IF po_rfqqt_s.val_start_dates(X_start_date, X_po_header_id) THEN
423: dbms_output.put_line('Return TRUE');
424: ELSE
425: dbms_output.put_line('Return FALSE');
426: END IF;*/
427:
421:
422: /* IF po_rfqqt_s.val_start_dates(X_start_date, X_po_header_id) THEN
423: dbms_output.put_line('Return TRUE');
424: ELSE
425: dbms_output.put_line('Return FALSE');
426: END IF;*/
427:
428: /* There is no server pkg by the name po_rfqqt_s. */
429: null;
443: X_po_header_id IN NUMBER) IS
444:
445: BEGIN
446:
447: dbms_output.put_line('Before_call');
448:
449: /* IF po_rfqqt_s.val_end_dates(X_end_date, X_po_header_id) THEN
450: dbms_output.put_line('Return TRUE');
451: ELSE
446:
447: dbms_output.put_line('Before_call');
448:
449: /* IF po_rfqqt_s.val_end_dates(X_end_date, X_po_header_id) THEN
450: dbms_output.put_line('Return TRUE');
451: ELSE
452: dbms_output.put_line('Return FALSE');
453: END IF;*/
454:
448:
449: /* IF po_rfqqt_s.val_end_dates(X_end_date, X_po_header_id) THEN
450: dbms_output.put_line('Return TRUE');
451: ELSE
452: dbms_output.put_line('Return FALSE');
453: END IF;*/
454:
455: /* There is no server pkg by the name po_rfqqt_s. */
456: null;