APPS.WIP_REPETITIVE_SCHEDULES_PKG dependencies on WIP_REPETITIVE_SCHEDULES

Line 1: PACKAGE BODY WIP_REPETITIVE_SCHEDULES_PKG as

1: PACKAGE BODY WIP_REPETITIVE_SCHEDULES_PKG as
2: /* $Header: wiprsvhb.pls 115.7 2002/11/29 15:32:54 rmahidha ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Repetitive_Schedule_Id NUMBER,

Line 62: CURSOR C IS SELECT rowid FROM WIP_REPETITIVE_SCHEDULES

58: X_Attribute14 VARCHAR2,
59: X_Attribute15 VARCHAR2,
60: X_PO_Creation_Time NUMBER
61: ) IS
62: CURSOR C IS SELECT rowid FROM WIP_REPETITIVE_SCHEDULES
63: WHERE repetitive_schedule_id = X_Repetitive_Schedule_Id;
64:
65: BEGIN
66:

Line 68: INSERT INTO WIP_REPETITIVE_SCHEDULES(

64:
65: BEGIN
66:
67:
68: INSERT INTO WIP_REPETITIVE_SCHEDULES(
69: repetitive_schedule_id,
70: organization_id,
71: last_update_date,
72: last_updated_by,

Line 235: FROM WIP_REPETITIVE_SCHEDULES

231: X_Attribute15 VARCHAR2
232: ) IS
233: CURSOR C IS
234: SELECT *
235: FROM WIP_REPETITIVE_SCHEDULES
236: WHERE rowid = X_Rowid
237: FOR UPDATE of Repetitive_Schedule_Id NOWAIT;
238: Recinfo C%ROWTYPE;
239:

Line 404: UPDATE WIP_REPETITIVE_SCHEDULES

400: X_Attribute15 VARCHAR2
401:
402: ) IS
403: BEGIN
404: UPDATE WIP_REPETITIVE_SCHEDULES
405: SET
406: repetitive_schedule_id = X_Repetitive_Schedule_Id,
407: organization_id = X_Organization_Id,
408: last_update_date = X_Last_Update_Date,

Line 466: DELETE FROM WIP_REPETITIVE_SCHEDULES

462: end if;
463: END Update_Row;
464: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
465: BEGIN
466: DELETE FROM WIP_REPETITIVE_SCHEDULES
467: WHERE rowid = X_Rowid;
468:
469: if (SQL%NOTFOUND) then
470: Raise NO_DATA_FOUND;

Line 475: END WIP_REPETITIVE_SCHEDULES_PKG;

471: end if;
472: END Delete_Row;
473:
474:
475: END WIP_REPETITIVE_SCHEDULES_PKG;