[Home] [Help]
PACKAGE: APPS.RCV_SHIPMENT_LINES_PKG
Source
1 PACKAGE RCV_SHIPMENT_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: RCVTISLS.pls 120.2.12010000.3 2010/04/09 12:17:43 yjian ship $ */
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
67 /* Bug 9534775 WC -ve correction */
68 PROCEDURE correct_wc_line(
69 p_shipment_line_id IN NUMBER,
70 p_interface_transaction_id IN NUMBER
71 );
72
73 /* Bug 9534775 WC -ve correction, get available quantity for correction
74 against WC and at Pay Item level receipt */
75 PROCEDURE get_wc_correct_quantity(p_correction_type IN VARCHAR2,
76 p_parent_transaction_type IN VARCHAR2,
77 p_receipt_source_code IN VARCHAR2,
78 p_po_line_location_id IN NUMBER,
79 p_shipment_header_id IN NUMBER,
80 p_available_quantity IN OUT NOCOPY NUMBER);
81
82 /* Bug 9534775 WC -ve correction, get available amount for correction
83 against WC and at Pay Item level receipt */
84 PROCEDURE get_wc_correct_amount(p_correction_type IN VARCHAR2,
85 p_parent_transaction_type IN VARCHAR2,
86 p_receipt_source_code IN VARCHAR2,
87 p_po_line_location_id IN NUMBER,
88 p_shipment_header_id IN NUMBER,
89 p_available_amount IN OUT NOCOPY NUMBER);
90
91 END RCV_SHIPMENT_LINES_PKG;