PACKAGE: APPS.GMD_QA_RCV_PUB

Source

1 PACKAGE GMD_QA_RCV_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPRECS.pls 120.2 2011/05/05 18:01:00 rnalla ship $ */
3 
4 FUNCTION get_disposition
5 ( p_po_num IN VARCHAR2,
6   p_po_line_num IN VARCHAR2,
7   p_shipment_num IN VARCHAR2,
8   p_receipt_num IN VARCHAR2,
9   p_shipment_line_id IN NUMBER default null -- 7447810
10 ) RETURN VARCHAR2;
11 
12 FUNCTION get_quantity
13 ( p_po_num IN VARCHAR2,
14   p_po_line_num IN VARCHAR2,
15   p_shipment_num IN VARCHAR2,
16   p_receipt_num IN VARCHAR2,
17   p_shipment_line_id IN NUMBER default null -- 7447810
18 ) RETURN NUMBER;
19 
20 FUNCTION get_inspection_result
21 ( p_po_num IN VARCHAR2,
22   p_po_line_num IN VARCHAR2,
23   p_shipment_num IN VARCHAR2,
24   p_receipt_num IN VARCHAR2,
25   p_shipment_line_id IN NUMBER default null -- 7447810
26 ) RETURN VARCHAR2;
27 
28 
29 -- The procedure has autonomous transaction pragma.
30 -- It inserts data into the gmd_sampling_events table
31 
32 PROCEDURE store_collection_details(
33 						p_po_num IN VARCHAR2,
34   					p_po_line_num IN VARCHAR2,
35   					p_shipment_num IN VARCHAR2,
36   					p_receipt_num IN VARCHAR2,
37   					p_plan_name IN VARCHAR2,
38   					p_collection_id IN NUMBER,
39   					p_occurrence IN NUMBER);
40 
41 
42 
43 END GMD_QA_RCV_PUB;