APPS.JTF_RS_JOB_ROLES_PKG dependencies on JTF_RS_JOB_ROLES

Line 1: package body JTF_RS_JOB_ROLES_PKG as

1: package body JTF_RS_JOB_ROLES_PKG as
2: /* $Header: jtfrstjb.pls 120.0 2005/05/11 08:22:18 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_JOB_ROLE_ID in NUMBER,

Line 30: cursor C is select ROWID from JTF_RS_JOB_ROLES

26: X_LAST_UPDATE_DATE in DATE,
27: X_LAST_UPDATED_BY in NUMBER,
28: X_LAST_UPDATE_LOGIN in NUMBER
29: ) is
30: cursor C is select ROWID from JTF_RS_JOB_ROLES
31: where JOB_ROLE_ID = X_JOB_ROLE_ID
32: ;
33: begin
34: insert into JTF_RS_JOB_ROLES (

Line 34: insert into JTF_RS_JOB_ROLES (

30: cursor C is select ROWID from JTF_RS_JOB_ROLES
31: where JOB_ROLE_ID = X_JOB_ROLE_ID
32: ;
33: begin
34: insert into JTF_RS_JOB_ROLES (
35: JOB_ROLE_ID,
36: JOB_ID,
37: ROLE_ID,
38: OBJECT_VERSION_NUMBER,

Line 103: from JTF_RS_JOB_ROLES

99: X_OBJECT_VERSION_NUMBER in NUMBER
100: ) is
101: cursor c1 is select
102: OBJECT_VERSION_NUMBER
103: from JTF_RS_JOB_ROLES
104: where JOB_ROLE_ID = X_JOB_ROLE_ID
105: for update of JOB_ROLE_ID nowait;
106: tlinfo c1%rowtype ;
107: begin

Line 153: update JTF_RS_JOB_ROLES set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update JTF_RS_JOB_ROLES set
154: JOB_ID = X_JOB_ID,
155: ROLE_ID = X_ROLE_ID,
156: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
157: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 187: delete from JTF_RS_JOB_ROLES

183: procedure DELETE_ROW (
184: X_JOB_ROLE_ID in NUMBER
185: ) is
186: begin
187: delete from JTF_RS_JOB_ROLES
188: where JOB_ROLE_ID = X_JOB_ROLE_ID;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 196: end JTF_RS_JOB_ROLES_PKG;

192: end if;
193:
194: end DELETE_ROW;
195:
196: end JTF_RS_JOB_ROLES_PKG;