APPS.JTF_RS_REP_MANAGERS_PKG dependencies on JTF_RS_REP_MANAGERS

Line 1: package body JTF_RS_REP_MANAGERS_PKG as

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

Line 41: cursor C is select ROWID from JTF_RS_REP_MANAGERS

37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER,
39: X_DENORM_LEVEL in NUMBER
40: ) is
41: cursor C is select ROWID from JTF_RS_REP_MANAGERS
42: where DENORM_MGR_ID = X_DENORM_MGR_ID
43: ;
44: begin
45: insert into JTF_RS_REP_MANAGERS (

Line 45: insert into JTF_RS_REP_MANAGERS (

41: cursor C is select ROWID from JTF_RS_REP_MANAGERS
42: where DENORM_MGR_ID = X_DENORM_MGR_ID
43: ;
44: begin
45: insert into JTF_RS_REP_MANAGERS (
46: DENORM_MGR_ID,
47: RESOURCE_ID,
48: PERSON_ID,
49: CATEGORY,

Line 136: from JTF_RS_REP_MANAGERS

132: X_OBJECT_VERSION_NUMBER in NUMBER
133: ) is
134: cursor c1 is select
135: OBJECT_VERSION_NUMBER
136: from JTF_RS_REP_MANAGERS
137: where DENORM_MGR_ID = X_DENORM_MGR_ID
138: for update of DENORM_MGR_ID nowait;
139: tlinfo c1%rowtype ;
140: begin

Line 197: update JTF_RS_REP_MANAGERS set

193: X_LAST_UPDATE_LOGIN in NUMBER,
194: X_DENORM_LEVEL in NUMBER
195: ) is
196: begin
197: update JTF_RS_REP_MANAGERS set
198: RESOURCE_ID = X_RESOURCE_ID,
199: PERSON_ID = X_PERSON_ID,
200: CATEGORY = X_CATEGORY,
201: MANAGER_PERSON_ID = X_MANAGER_PERSON_ID,

Line 242: delete from JTF_RS_REP_MANAGERS

238: procedure DELETE_ROW (
239: X_DENORM_MGR_ID in NUMBER
240: ) is
241: begin
242: delete from JTF_RS_REP_MANAGERS
243: where DENORM_MGR_ID = X_DENORM_MGR_ID;
244:
245: if (sql%notfound) then
246: raise no_data_found;

Line 251: end JTF_RS_REP_MANAGERS_PKG;

247: end if;
248:
249: end DELETE_ROW;
250:
251: end JTF_RS_REP_MANAGERS_PKG;