1 PACKAGE WSH_SC_PLD_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHSCPDS.pls 115.0 99/07/16 08:20:51 porting ship $ */
3 --
4 -- Package
5 -- WSH_SC_PLD_PKG
6 --
7 -- Purpose
8 -- This package is used by the confirm delivery form to update
9 -- serial number information (details) entered on a delivery line
10 -- and do the explosion of the serial numbers if necessary.
11 -- History
12 -- Version 1.0 03/01/97 RMANJUNA
13 --
14
15 --
16 -- Name
17 -- Close_Details
18 -- Purpose
19 -- To update picking line details with information entered in the
20 -- serial number window.
21 --
22 PROCEDURE Close_Details(X_Delivery_Id IN NUMBER);
23
24 --
25 -- Name
26 -- Update_Details
27 -- Purpose
28 -- To update picking line details with information entered into the
29 -- transaction block.
30
31 PROCEDURE Update_Details( X_Trx_Src_Line_Id IN NUMBER,
32 X_Requested_Qty IN NUMBER,
33 X_Shipped_Qty IN NUMBER,
34 X_Serial IN VARCHAR2);
35 --
36 -- Name
37 -- Insert_Details
38 -- Purpose
39 -- To insert new picking line details for details split on transaction
40 -- block or entered in the serial number window.
41
42 PROCEDURE Insert_Details( X_New_Detail_Id IN NUMBER,
43 X_Parent_Detail_Id IN NUMBER,
44 X_Trx_Qty IN NUMBER,
45 X_Req_Qty IN NUMBER,
46 X_Serial IN VARCHAR2,
47 X_Mode IN VARCHAR2,
48 X_detail_type_code IN VARCHAR2 DEFAULT 'NA');
49
50 --
51 -- Purpose
52 -- This the used for split delivery line function to create a new
53 -- picking line details
54 --
55 FUNCTION Insert_Splitted_Details( X_Parent_Detail_Id IN NUMBER,
56 X_Req_Qty IN NUMBER,
57 X_detail_type_code IN VARCHAR2)
58 RETURN NUMBER;
59
60 --
61 -- Name
62 -- Create_Remainders
63 -- Purpose
64 -- To create a new detail for the remaining quantity when a partial quantity
65 -- has been shipped for a reserved picking line.
66 --
67
68 PROCEDURE Create_Remainders(X_Picking_Line_Detail_Id NUMBER,
69 X_New_Requested NUMBER );
70 --
71 -- Name
72 -- Explode_Lines
73 -- Purpose
74 -- Takes individual lines from MTL_SERIAL_NUMBERS_TEMP that
75 -- are under serial number control and explodes them into multiple
76 -- lines based on the serial numbers entered.
77
78 PROCEDURE Explode_Lines( X_Picking_Line_Detail_Id IN NUMBER);
79
80 --
81 -- Name
82 -- Next_Serial
83 -- Purpose
84 -- Takes a serial prefix, the length of the numeric portion of a serial
85 -- number and the current value of the numeric portion and returns the
86 -- next serial number.
87
88 FUNCTION Next_Serial (s_prefix IN VARCHAR2,
89 s_num_length IN NUMBER,
90 s_num_current IN NUMBER
91 ) RETURN VARCHAR2 ;
92 --
93 -- Name
94 -- Delete_From_Msnt
95 -- Purpose
96 -- To Delete the temporary records created in MSNT by the Serial Number Entry Form
97 --
98
99 PROCEDURE Delete_From_Msnt(X_Delivery_Id NUMBER );
100
101 END WSH_SC_PLD_PKG;