APPS.PA_OBJ_STATUS_CHANGES_PKG dependencies on PA_OBJ_STATUS_CHANGES

Line 1: package body PA_OBJ_STATUS_CHANGES_PKG as

1: package body PA_OBJ_STATUS_CHANGES_PKG as
2: /* $Header: PAOBSCTB.pls 120.1 2005/08/19 16:36:46 mwasowic noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 21: cursor C is select ROWID from PA_OBJ_STATUS_CHANGES

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from PA_OBJ_STATUS_CHANGES
22: where OBJ_STATUS_CHANGE_ID = X_OBJ_STATUS_CHANGE_ID ;
23: begin
24: insert into PA_OBJ_STATUS_CHANGES (
25: OBJ_STATUS_CHANGE_ID,

Line 24: insert into PA_OBJ_STATUS_CHANGES (

20: ) is
21: cursor C is select ROWID from PA_OBJ_STATUS_CHANGES
22: where OBJ_STATUS_CHANGE_ID = X_OBJ_STATUS_CHANGE_ID ;
23: begin
24: insert into PA_OBJ_STATUS_CHANGES (
25: OBJ_STATUS_CHANGE_ID,
26: OBJECT_TYPE,
27: OBJECT_ID,
28: STATUS_TYPE,

Line 86: from PA_OBJ_STATUS_CHANGES

82: OLD_PROJECT_STATUS_CODE,
83: OLD_PROJECT_SYSTEM_STATUS_CODE,
84: CHANGE_COMMENT,
85: OBJ_STATUS_CHANGE_ID
86: from PA_OBJ_STATUS_CHANGES
87: where OBJ_STATUS_CHANGE_ID = X_OBJ_STATUS_CHANGE_ID
88: for update of OBJ_STATUS_CHANGE_ID nowait;
89: begin
90: for tlinfo in c1 loop

Line 126: update PA_OBJ_STATUS_CHANGES set

122: X_LAST_UPDATED_BY in NUMBER,
123: X_LAST_UPDATE_LOGIN in NUMBER
124: ) is
125: begin
126: update PA_OBJ_STATUS_CHANGES set
127: OBJECT_TYPE = X_OBJECT_TYPE,
128: OBJECT_ID = X_OBJECT_ID,
129: STATUS_TYPE = X_STATUS_TYPE,
130: NEW_PROJECT_STATUS_CODE = X_NEW_PROJECT_STATUS_CODE,

Line 149: delete from PA_OBJ_STATUS_CHANGES

145: procedure DELETE_ROW (
146: X_OBJ_STATUS_CHANGE_ID in NUMBER
147: ) is
148: begin
149: delete from PA_OBJ_STATUS_CHANGES
150: where OBJ_STATUS_CHANGE_ID = X_OBJ_STATUS_CHANGE_ID;
151:
152: if (sql%notfound) then
153: raise no_data_found;

Line 158: end PA_OBJ_STATUS_CHANGES_PKG;

154: end if;
155:
156: end DELETE_ROW;
157:
158: end PA_OBJ_STATUS_CHANGES_PKG;