APPS.PA_ROLE_LIST_MEMBERS_PKG dependencies on PA_ROLE_LIST_MEMBERS

Line 1: package body PA_ROLE_LIST_MEMBERS_PKG as

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

Line 14: cursor C is select ROWID from PA_ROLE_LIST_MEMBERS

10: X_LAST_UPDATE_DATE DATE,
11: X_LAST_UPDATED_BY NUMBER,
12: X_LAST_UPDATE_LOGIN NUMBER
13: ) is
14: cursor C is select ROWID from PA_ROLE_LIST_MEMBERS
15: where ROLE_LIST_ID = X_ROLE_LIST_ID
16: AND PROJECT_ROLE_ID = X_PROJECT_ROLE_ID
17: ;
18: l_rowid ROWID; -- Bug 4565156. Added for Manual NOCOPY Fix.

Line 22: insert into PA_ROLE_LIST_MEMBERS (

18: l_rowid ROWID; -- Bug 4565156. Added for Manual NOCOPY Fix.
19: begin
20: l_rowid := X_ROWID; -- Bug 4565156. Storing original value. Added for Manual NOCOPY Fix.
21:
22: insert into PA_ROLE_LIST_MEMBERS (
23: ROLE_LIST_ID,
24: PROJECT_ROLE_ID,
25: CREATION_DATE,
26: CREATED_BY,

Line 59: from PA_ROLE_LIST_MEMBERS

55: X_RECORD_VERSION_NUMBER NUMBER
56: ) is
57: cursor c is
58: select *
59: from PA_ROLE_LIST_MEMBERS
60: where ROWID = X_ROWID
61: for update of ROLE_LIST_ID nowait;
62:
63: tlinfo c%rowtype;

Line 97: update PA_ROLE_LIST_MEMBERS set

93: X_LAST_UPDATED_BY NUMBER,
94: X_LAST_UPDATE_LOGIN NUMBER
95: ) is
96: begin
97: update PA_ROLE_LIST_MEMBERS set
98: ROLE_LIST_ID = X_ROLE_LIST_ID,
99: PROJECT_ROLE_ID = X_PROJECT_ROLE_ID,
100: CREATION_DATE = X_CREATION_DATE,
101: CREATED_BY = X_CREATED_BY,

Line 118: delete from PA_ROLE_LIST_MEMBERS

114: procedure DELETE_ROW (
115: X_ROWID VARCHAR2
116: ) is
117: begin
118: delete from PA_ROLE_LIST_MEMBERS
119: where ROWID = X_ROWID;
120:
121: if (sql%notfound) then
122: raise no_data_found;

Line 126: end PA_ROLE_LIST_MEMBERS_PKG;

122: raise no_data_found;
123: end if;
124: end DELETE_ROW;
125:
126: end PA_ROLE_LIST_MEMBERS_PKG;