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:
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
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:
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:
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
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:
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
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:
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
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:
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:
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:
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: --
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 :=
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:
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:
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
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:
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
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;
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;