DBA Data[Home] [Help]

PACKAGE: APPS.RCV_SHIPMENT_LINES_PKG

Source


1 PACKAGE RCV_SHIPMENT_LINES_PKG as
2 /* $Header: RCVTISLS.pls 120.2 2005/09/02 13:38:03 pparthas noship $ */
3 
4   PROCEDURE Lock_Line_s( X_Rowid                          VARCHAR2,
5                        X_Shipment_Line_Id	        NUMBER,
6                        X_item_revision              	VARCHAR2,
7                        X_stock_locator_id               NUMBER,
8                        X_packing_slip                   VARCHAR2,
9                        X_comments                  	VARCHAR2,
10                        X_routing_header_id              NUMBER,
11                        X_Reason_id                      NUMBER,
12                        X_Attribute_Category             VARCHAR2,
13                        X_Attribute1                     VARCHAR2,
14                        X_Attribute2                     VARCHAR2,
15                        X_Attribute3                     VARCHAR2,
16                        X_Attribute4                     VARCHAR2,
17                        X_Attribute5                     VARCHAR2,
18                        X_Attribute6                     VARCHAR2,
19                        X_Attribute7                     VARCHAR2,
20                        X_Attribute8                     VARCHAR2,
21                        X_Attribute9                     VARCHAR2,
22                        X_Attribute10                    VARCHAR2,
23                        X_Attribute11                    VARCHAR2,
24                        X_Attribute12                    VARCHAR2,
25                        X_Attribute13                    VARCHAR2,
26                        X_Attribute14                    VARCHAR2,
27                        X_Attribute15                    VARCHAR2,
28 		       X_Request_Id			NUMBER,
29 		       X_Program_Application_Id		NUMBER,
30 		       X_Program_Id			NUMBER,
31 		       X_Program_Update_Date		DATE
32                       );
33 
34 
35   PROCEDURE Update_Line_s(
36 		       X_Shipment_Line_Id	        NUMBER,
37                        X_item_revision              	VARCHAR2,
38                        X_stock_locator_id               NUMBER,
39                        X_packing_slip                   VARCHAR2,
40                        X_comments                  	VARCHAR2,
41                        X_routing_header_id              NUMBER,
42                        X_Reason_id                      NUMBER
43 		       );
44 
45   PROCEDURE update_wc_line(
46 			p_shipment_line_id IN NUMBER,
47 			p_requested_amount       IN      NUMBER DEFAULT NULL,
48 			p_material_stored_amount IN      NUMBER DEFAULT NULL,
49 			p_amount_shipped         IN      NUMBER DEFAULT NULL,
50 			p_quantity_shipped       IN      NUMBER DEFAULT NULL
51 		       );
52 
53 
54   PROCEDURE update_quantity_amount(
55                         p_Shipment_Line_Id       IN      NUMBER,
56                         p_quantity_shipped      IN      NUMBER,
57                         p_amount_shipped        IN      NUMBER);
58 
59   PROCEDURE delete_line_s(
60                        p_Shipment_Line_Id       IN      NUMBER) ;
61 
62 PROCEDURE update_approval_status(p_level IN VARCHAR2,
63                                 p_approval_status IN VARCHAR2,
64                                 p_comments IN VARCHAR2,
65                                 p_document_id IN NUMBER);
66 END RCV_SHIPMENT_LINES_PKG;