DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MRP_FLOW_SCHEDULE_PVT

Line 179: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)

175: /*
176: Enhancement : 2665434
177: Description : Changed the usage of the record type from old record type
178: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
179: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
180: */
181:
182: PROCEDURE Clear_Dependent_Attr
183: ( p_attr_id IN NUMBER DEFAULT NULL

Line 184: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

180: */
181:
182: PROCEDURE Clear_Dependent_Attr
183: ( p_attr_id IN NUMBER DEFAULT NULL
184: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
185: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
186: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
187: );
188:

Line 185: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

181:
182: PROCEDURE Clear_Dependent_Attr
183: ( p_attr_id IN NUMBER DEFAULT NULL
184: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
185: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
186: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
187: );
188:
189: -- Procedure Apply_Attribute_Changes

Line 186: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

182: PROCEDURE Clear_Dependent_Attr
183: ( p_attr_id IN NUMBER DEFAULT NULL
184: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
185: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
186: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
187: );
188:
189: -- Procedure Apply_Attribute_Changes
190: /*

Line 194: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)

190: /*
191: Enhancement : 2665434
192: Description : Changed the usage of the record type from old record type
193: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
194: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
195: */
196:
197: PROCEDURE Apply_Attribute_Changes
198: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

Line 198: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

194: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
195: */
196:
197: PROCEDURE Apply_Attribute_Changes
198: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
199: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
200: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
201: );
202:

Line 199: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

195: */
196:
197: PROCEDURE Apply_Attribute_Changes
198: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
199: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
200: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
201: );
202:
203: -- Function Complete_Record

Line 200: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

196:
197: PROCEDURE Apply_Attribute_Changes
198: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
199: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
200: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
201: );
202:
203: -- Function Complete_Record
204: /*

Line 208: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) and also reversed the logic.

204: /*
205: Enhancement : 2665434
206: Description : Changed the usage of the record type from old record type
207: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
208: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) and also reversed the logic.
209: */
210: FUNCTION Complete_Record
211: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
212: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

Line 211: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

207: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
208: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) and also reversed the logic.
209: */
210: FUNCTION Complete_Record
211: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
212: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
213: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
214:
215: -- Function Convert_Miss_To_Null

Line 212: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

208: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) and also reversed the logic.
209: */
210: FUNCTION Complete_Record
211: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
212: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
213: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
214:
215: -- Function Convert_Miss_To_Null
216: /*

Line 213: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;

209: */
210: FUNCTION Complete_Record
211: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
212: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
213: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
214:
215: -- Function Convert_Miss_To_Null
216: /*
217: Enhancement : 2665434

Line 220: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)

216: /*
217: Enhancement : 2665434
218: Description : Changed the usage of the record type from old record type
219: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
220: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
221: */
222:
223: FUNCTION Convert_Miss_To_Null
224: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

Line 224: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

220: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
221: */
222:
223: FUNCTION Convert_Miss_To_Null
224: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
225: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
226:
227: -- Procedure Update_Row
228: /*

Line 225: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;

221: */
222:
223: FUNCTION Convert_Miss_To_Null
224: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
225: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
226:
227: -- Procedure Update_Row
228: /*
229: Enhancement : 2665434

Line 232: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)

228: /*
229: Enhancement : 2665434
230: Description : Changed the usage of the record type from old record type
231: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
232: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
233: */
234: PROCEDURE Update_Row
235: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
236: );

Line 235: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

231: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
232: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
233: */
234: PROCEDURE Update_Row
235: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
236: );
237:
238: -- Procedure Insert_Row
239: /*

Line 243: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)

239: /*
240: Enhancement : 2665434
241: Description : Changed the usage of the record type from old record type
242: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
243: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
244: */
245: PROCEDURE Insert_Row
246: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
247: );

Line 246: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

242: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
243: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
244: */
245: PROCEDURE Insert_Row
246: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
247: );
248:
249: -- Procedure Delete_Row
250:

Line 259: new record type (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)

255: -- Function Query_Row
256: /*
257: Enhancement : 2665434
258: Description : Changed the return type from old record type (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to
259: new record type (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
260: */
261: FUNCTION Query_Row
262: ( p_wip_entity_id IN NUMBER
263: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;

Line 263: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;

259: new record type (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
260: */
261: FUNCTION Query_Row
262: ( p_wip_entity_id IN NUMBER
263: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
264:
265: -- Procedure lock_Row
266: --
267: /*

Line 271: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)

267: /*
268: Enhancement : 2665434
269: Description : Changed the usage of the record type from old record type
270: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
271: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
272: */
273: PROCEDURE Lock_Row
274: ( x_return_status OUT NOCOPY VARCHAR2
275: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

Line 275: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

271: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
272: */
273: PROCEDURE Lock_Row
274: ( x_return_status OUT NOCOPY VARCHAR2
275: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
276: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
277: );
278:
279: -- Function Get_Values

Line 276: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

272: */
273: PROCEDURE Lock_Row
274: ( x_return_status OUT NOCOPY VARCHAR2
275: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
276: , x_flow_schedule_rec IN OUT NOCOPY MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
277: );
278:
279: -- Function Get_Values
280: /*

Line 284: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) .

280: /*
281: Enhancement : 2665434
282: Description : Changed the usage of the record type from old record type
283: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
284: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) .
285: */
286: FUNCTION Get_Values
287: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
288: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

Line 287: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

283: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
284: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) .
285: */
286: FUNCTION Get_Values
287: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
288: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
289: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type;
290:
291: -- Function Get_Ids

Line 288: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

284: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type) .
285: */
286: FUNCTION Get_Values
287: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
288: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
289: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type;
290:
291: -- Function Get_Ids
292: /*

Line 289: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type;

285: */
286: FUNCTION Get_Values
287: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
288: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
289: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type;
290:
291: -- Function Get_Ids
292: /*
293: Enhancement : 2665434

Line 296: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)

292: /*
293: Enhancement : 2665434
294: Description : Changed the usage of the record type from old record type
295: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
296: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
297: */
298:
299: FUNCTION Get_Ids
300: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

Line 300: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type

296: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
297: */
298:
299: FUNCTION Get_Ids
300: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
301: , p_flow_schedule_val_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type
302: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
303:
304: -- Procedure populates mrp_form_query with the values necessary

Line 301: , p_flow_schedule_val_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type

297: */
298:
299: FUNCTION Get_Ids
300: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
301: , p_flow_schedule_val_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type
302: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
303:
304: -- Procedure populates mrp_form_query with the values necessary
305: -- for the flow schedule summary buckets.

Line 302: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;

298:
299: FUNCTION Get_Ids
300: ( p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
301: , p_flow_schedule_val_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type
302: ) RETURN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
303:
304: -- Procedure populates mrp_form_query with the values necessary
305: -- for the flow schedule summary buckets.
306:

Line 362: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it

358: /*
359: Enhancement : 2665434
360: Description : Changed the usage of the record type from old record type
361: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
362: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
363: compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
364: */
365: PROCEDURE Roll_Flow_Schedules( ERRBUF OUT NOCOPY VARCHAR2,
366: RETCODE OUT NOCOPY VARCHAR2,

Line 363: compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)

359: Enhancement : 2665434
360: Description : Changed the usage of the record type from old record type
361: (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
362: (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
363: compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
364: */
365: PROCEDURE Roll_Flow_Schedules( ERRBUF OUT NOCOPY VARCHAR2,
366: RETCODE OUT NOCOPY VARCHAR2,
367: p_organization_id IN NUMBER,