APPS.PA_ROLE_LISTS_PKG dependencies on PA_ROLE_LISTS

Line 1: package body PA_ROLE_LISTS_PKG as

1: package body PA_ROLE_LISTS_PKG as
2: /*$Header: PAROLSTB.pls 120.2 2005/08/22 02:50:56 raluthra noship $*/
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 33: cursor C is select ROWID from PA_ROLE_LISTS

29: X_LAST_UPDATE_DATE DATE,
30: X_LAST_UPDATED_BY NUMBER,
31: X_LAST_UPDATE_LOGin NUMBER
32: ) is
33: cursor C is select ROWID from PA_ROLE_LISTS
34: where ROLE_LIST_ID = X_ROLE_LIST_ID
35: ;
36:
37: l_rowid ROWID; -- Bug 4565156. Added for Manual NOCOPY Fix.

Line 41: insert into PA_ROLE_LISTS (

37: l_rowid ROWID; -- Bug 4565156. Added for Manual NOCOPY Fix.
38: begin
39: l_rowid := X_ROWID; -- Bug 456156. Storing original value that was passed in.
40:
41: insert into PA_ROLE_LISTS (
42: ROLE_LIST_ID,
43: NAME,
44: START_DATE_ACTIVE,
45: END_DATE_ACTIVE,

Line 116: from PA_ROLE_LISTS

112: X_RECORD_VERSION_NUMBER NUMBER
113: ) is
114: cursor c is
115: select *
116: from PA_ROLE_LISTS
117: where ROWID = X_ROWID
118: for update of ROLE_LIST_ID nowait;
119:
120: tlinfo c%rowtype;

Line 173: update PA_ROLE_LISTS set

169: X_LAST_UPDATED_BY NUMBER,
170: X_LAST_UPDATE_LOGIN NUMBER
171: ) is
172: begin
173: update PA_ROLE_LISTS set
174: ROLE_LIST_ID = X_ROLE_LIST_ID,
175: NAME = X_NAME,
176: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
177: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 213: delete from PA_ROLE_LISTS

209: procedure DELETE_ROW (
210: X_ROWID VARCHAR2
211: ) is
212: begin
213: delete from PA_ROLE_LISTS
214: where ROWID = X_ROWID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 221: end PA_ROLE_LISTS_PKG;

217: raise no_data_found;
218: end if;
219: end DELETE_ROW;
220:
221: end PA_ROLE_LISTS_PKG;