[Home] [Help]
PACKAGE: APPS.OE_LOT_SERIAL_UTIL
Source
1 PACKAGE OE_Lot_Serial_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUSRLS.pls 120.0.12000000.1 2007/01/16 22:06:09 appldev ship $ */
3
4 -- Attributes global constants
5
6 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
21 G_CONTEXT CONSTANT NUMBER := 16;
22 G_CREATED_BY CONSTANT NUMBER := 17;
23 G_CREATION_DATE CONSTANT NUMBER := 18;
24 G_FROM_SERIAL_NUMBER CONSTANT NUMBER := 19;
25 G_LAST_UPDATED_BY CONSTANT NUMBER := 20;
26 G_LAST_UPDATE_DATE CONSTANT NUMBER := 21;
27 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 22;
28 G_LINE CONSTANT NUMBER := 23;
29 G_LOT_NUMBER CONSTANT NUMBER := 24;
30 G_LOT_SERIAL CONSTANT NUMBER := 25;
31 G_QUANTITY CONSTANT NUMBER := 26;
32 G_TO_SERIAL_NUMBER CONSTANT NUMBER := 27;
33 G_ORIG_SYS_LOTSERIAL_REF CONSTANT NUMBER := 28;
34 G_CHANGE_SEQUENCE_ID CONSTANT NUMBER := 29;
35 G_LINE_SET CONSTANT NUMBER := 30;
36 G_LOCK_CONTROL CONSTANT NUMBER := 31;
37 --G_SUBLOT_NUMBER CONSTANT NUMBER := 32; --OPM 2380194 INVCONV
38 G_QUANTITY2 CONSTANT NUMBER := 32; --OPM 2380194
39 G_MAX_ATTR_ID CONSTANT NUMBER := 33;
40
41 -- Procedure Clear_Dependent_Attr
42
43 PROCEDURE Clear_Dependent_Attr
44 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45 , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
46 , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
47 OE_Order_PUB.G_MISS_LOT_SERIAL_REC
48 );
49
50 -- Procedure Apply_Attribute_Changes
51
52 PROCEDURE Apply_Attribute_Changes
53 ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
54 , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
55 OE_Order_PUB.G_MISS_LOT_SERIAL_REC
56 );
57
58 -- Procedure Complete_Record
59
60 PROCEDURE Complete_Record
61 ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
62 , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
63 );
64
65 -- PROCEDURE Convert_Miss_To_Null
66
67 PROCEDURE Convert_Miss_To_Null
68 ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
69 );
70
71 -- Procedure Set_Line_Set_ID
72 -- When parent line is split, this procedure should be called to update
73 -- the line set id to point to the line set.
74 -- Whenever line_set_id is set, the records should be accessed by line_set_id
75
76 PROCEDURE Set_Line_Set_ID
77 ( p_Line_ID IN NUMBER
78 , p_Line_Set_ID IN NUMBER
79 );
80
81 -- Procedure Update_Row
82
83 PROCEDURE Update_Row
84 ( p_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
85 );
86
87 -- Procedure Insert_Row
88
89 PROCEDURE Insert_Row
90 ( p_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
91 );
92
93 -- Procedure Delete_Row
94
95 PROCEDURE Delete_Row
96 ( p_lot_serial_id IN NUMBER := FND_API.G_MISS_NUM
97 , p_line_id IN NUMBER := FND_API.G_MISS_NUM
98 );
99
100 -- Procedure Query_Row
101
102 PROCEDURE Query_Row
103 ( p_lot_serial_id IN NUMBER
104 , x_lot_serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
105 );
106
107 -- Procedure Query_Rows
108
109 --
110
111 PROCEDURE Query_Rows
112 ( p_lot_serial_id IN NUMBER :=
113 FND_API.G_MISS_NUM
114 , p_line_id IN NUMBER :=
115 FND_API.G_MISS_NUM
116 , p_line_set_id IN NUMBER :=
117 FND_API.G_MISS_NUM
118 , x_lot_serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
119 );
120
121 -- Procedure lock_Row
122 --
123
124
125 PROCEDURE Lock_Row
126 ( x_return_status OUT NOCOPY VARCHAR2
127
128 , p_lot_serial_id IN NUMBER := FND_API.G_MISS_NUM
129 , p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
130 );
131
132 PROCEDURE Lock_Rows
133 ( p_lot_serial_id IN NUMBER :=
134 FND_API.G_MISS_NUM
135 , p_line_id IN NUMBER :=
136 FND_API.G_MISS_NUM
137 , x_lot_serial_tbl OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
138 , x_return_status OUT NOCOPY VARCHAR2
139
140 );
141
142 -- Function Get_Values
143
144 FUNCTION Get_Values
145 ( p_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
146 , p_old_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type :=
147 OE_Order_PUB.G_MISS_LOT_SERIAL_REC
148 ) RETURN OE_Order_PUB.Lot_Serial_Val_Rec_Type;
149
150 -- Function Get_Ids
151
152 PROCEDURE Get_Ids
153 ( p_x_Lot_Serial_rec IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Rec_Type
154 , p_Lot_Serial_val_rec IN OE_Order_PUB.Lot_Serial_Val_Rec_Type
155 );
156
157 END OE_Lot_Serial_Util;