99: /* Procedure Clear_Dependent_Attr */
100: /*
101: PROCEDURE Clear_Dependent_Attr
102: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
103: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
104: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
105: , x_mo_line_rec OUT GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
106: );
107: */
100: /*
101: PROCEDURE Clear_Dependent_Attr
102: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
103: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
104: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
105: , x_mo_line_rec OUT GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
106: );
107: */
108: /* Procedure Apply_Attribute_Changes */
101: PROCEDURE Clear_Dependent_Attr
102: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
103: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
104: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
105: , x_mo_line_rec OUT GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
106: );
107: */
108: /* Procedure Apply_Attribute_Changes */
109: /*
107: */
108: /* Procedure Apply_Attribute_Changes */
109: /*
110: PROCEDURE Apply_Attribute_Changes
111: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
112: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
113: , x_mo_line_rec OUT GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
114: );
115: */
108: /* Procedure Apply_Attribute_Changes */
109: /*
110: PROCEDURE Apply_Attribute_Changes
111: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
112: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
113: , x_mo_line_rec OUT GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
114: );
115: */
116: /* Function Complete_Record */
109: /*
110: PROCEDURE Apply_Attribute_Changes
111: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
112: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
113: , x_mo_line_rec OUT GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
114: );
115: */
116: /* Function Complete_Record */
117: /*
115: */
116: /* Function Complete_Record */
117: /*
118: FUNCTION Complete_Record
119: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
120: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
121: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
122: */
123:
116: /* Function Complete_Record */
117: /*
118: FUNCTION Complete_Record
119: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
120: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
121: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
122: */
123:
124: /* Function Convert_Miss_To_Null */
117: /*
118: FUNCTION Complete_Record
119: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
120: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
121: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
122: */
123:
124: /* Function Convert_Miss_To_Null */
125:
123:
124: /* Function Convert_Miss_To_Null */
125:
126: FUNCTION Convert_Miss_To_Null
127: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
128: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
129: /* Procedure Update_Row */
130:
131: PROCEDURE Update_Row
124: /* Function Convert_Miss_To_Null */
125:
126: FUNCTION Convert_Miss_To_Null
127: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
128: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
129: /* Procedure Update_Row */
130:
131: PROCEDURE Update_Row
132: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
128: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
129: /* Procedure Update_Row */
130:
131: PROCEDURE Update_Row
132: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
133: );
134:
135: /* Procedure Update_Row_Status */
136:
141:
142: /* Procedure Insert_Row */
143:
144: PROCEDURE Insert_Row
145: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
146: );
147:
148: /* Procedure Delete_Row */
149:
154: /* Function Query_Row */
155:
156: FUNCTION Query_Row
157: ( p_line_id IN NUMBER
158: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
159:
160: /* Function Query_Rows */
161:
162: -- HW BUG#:2643440, removed intitalization of G_MISS_XXX
163: -- to p_line_id and p_header_id
164: FUNCTION Query_Rows
165: ( p_line_id IN NUMBER default NULL
166: , p_header_id IN NUMBER default NULL
167: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Tbl ;
168:
169:
170: /* Function Get_Lines */
171:
172: FUNCTION Get_Lines
173: (
174: p_header_id IN NUMBER
175:
176: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Tbl ;
177:
178: /* Procedure lock_Row */
179:
180: PROCEDURE Lock_Row
178: /* Procedure lock_Row */
179:
180: PROCEDURE Lock_Row
181: ( x_return_status OUT NOCOPY VARCHAR2
182: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
183: , x_mo_line_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
184: );
185:
186: /* Function Get_Values */
179:
180: PROCEDURE Lock_Row
181: ( x_return_status OUT NOCOPY VARCHAR2
182: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
183: , x_mo_line_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
184: );
185:
186: /* Function Get_Values */
187: /*
186: /* Function Get_Values */
187: /*
188:
189: FUNCTION Get_Values
190: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
191: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec :=
192: GMI_MOVE_ORDER_GLOBAL.G_MISS_mo_line_REC
193: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec ;
194:
187: /*
188:
189: FUNCTION Get_Values
190: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
191: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec :=
192: GMI_MOVE_ORDER_GLOBAL.G_MISS_mo_line_REC
193: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec ;
194:
195: Function Get_Ids
188:
189: FUNCTION Get_Values
190: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
191: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec :=
192: GMI_MOVE_ORDER_GLOBAL.G_MISS_mo_line_REC
193: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec ;
194:
195: Function Get_Ids
196:
189: FUNCTION Get_Values
190: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
191: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec :=
192: GMI_MOVE_ORDER_GLOBAL.G_MISS_mo_line_REC
193: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec ;
194:
195: Function Get_Ids
196:
197: FUNCTION Get_Ids
194:
195: Function Get_Ids
196:
197: FUNCTION Get_Ids
198: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
199: , p_mo_line_val_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec
200: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
201: */
202:
195: Function Get_Ids
196:
197: FUNCTION Get_Ids
198: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
199: , p_mo_line_val_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec
200: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
201: */
202:
203: PROCEDURE Line_Auto_Detail
196:
197: FUNCTION Get_Ids
198: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec
199: , p_mo_line_val_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_Val_Rec
200: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_Rec ;
201: */
202:
203: PROCEDURE Line_Auto_Detail
204: ( p_mo_line_id IN NUMBER