APPS.PA_PROJECT_CLASSES_PKG dependencies on PA_PROJECT_CLASSES

Line 1: PACKAGE BODY PA_PROJECT_CLASSES_PKG as

1: PACKAGE BODY PA_PROJECT_CLASSES_PKG as
2: /* $Header: PAXCLASB.pls 120.2 2005/08/19 17:11:15 mwasowic ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5: X_object_id NUMBER,

Line 32: CURSOR C IS SELECT rowid FROM PA_PROJECT_CLASSES

28: X_Creation_Date DATE,
29: X_Created_By NUMBER,
30: X_Last_Update_Login NUMBER
31: ) IS
32: CURSOR C IS SELECT rowid FROM PA_PROJECT_CLASSES
33: WHERE object_id = X_object_Id
34: AND object_type = X_object_type
35: AND class_category = X_Class_Category
36: AND class_code = X_Class_Code;

Line 40: INSERT INTO PA_PROJECT_CLASSES(

36: AND class_code = X_Class_Code;
37:
38: BEGIN
39:
40: INSERT INTO PA_PROJECT_CLASSES(
41: project_id,
42: object_id,
43: object_type,
44: class_category,

Line 118: FROM PA_PROJECT_CLASSES

114: X_Class_Code VARCHAR2
115: ) IS
116: CURSOR C IS
117: SELECT *
118: FROM PA_PROJECT_CLASSES
119: WHERE rowid = X_Rowid
120: FOR UPDATE of object_Id NOWAIT;
121: Recinfo C%ROWTYPE;
122:

Line 176: UPDATE PA_PROJECT_CLASSES

172: X_Last_Update_Login NUMBER,
173: X_record_version_number NUMBER
174: ) IS
175: BEGIN
176: UPDATE PA_PROJECT_CLASSES
177: SET
178: project_id = decode(X_object_type, 'PA_PROJECTS', X_object_id, NULL),
179: object_id = X_object_id,
180: object_type = X_object_type,

Line 212: DELETE FROM PA_PROJECT_CLASSES

208: end if;
209: END Update_Row;
210: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
211: BEGIN
212: DELETE FROM PA_PROJECT_CLASSES
213: WHERE rowid = X_Rowid;
214:
215: if (SQL%NOTFOUND) then
216: Raise NO_DATA_FOUND;

Line 221: END PA_PROJECT_CLASSES_PKG;

217: end if;
218: END Delete_Row;
219:
220:
221: END PA_PROJECT_CLASSES_PKG;