APPS.JTF_RS_GROUPS_DENORM_PKG dependencies on JTF_RS_GROUPS_DENORM

Line 1: package body JTF_RS_GROUPS_DENORM_PKG as

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

Line 35: cursor C is select ROWID from JTF_RS_GROUPS_DENORM

31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER,
33: X_DENORM_LEVEL in NUMBER
34: ) is
35: cursor C is select ROWID from JTF_RS_GROUPS_DENORM
36: where DENORM_GRP_ID = X_DENORM_GRP_ID
37: ;
38: begin
39: insert into JTF_RS_GROUPS_DENORM (

Line 39: insert into JTF_RS_GROUPS_DENORM (

35: cursor C is select ROWID from JTF_RS_GROUPS_DENORM
36: where DENORM_GRP_ID = X_DENORM_GRP_ID
37: ;
38: begin
39: insert into JTF_RS_GROUPS_DENORM (
40: GROUP_ID,
41: PARENT_GROUP_ID,
42: CREATED_BY,
43: CREATION_DATE,

Line 118: from JTF_RS_GROUPS_DENORM

114: X_OBJECT_VERSION_NUMBER in NUMBER
115: ) is
116: cursor c1 is select
117: OBJECT_VERSION_NUMBER
118: from JTF_RS_GROUPS_DENORM
119: where DENORM_GRP_ID = X_DENORM_GRP_ID
120: for update of DENORM_GRP_ID nowait;
121: tlinfo c1%rowtype ;
122: begin

Line 173: update JTF_RS_GROUPS_DENORM set

169: X_LAST_UPDATE_LOGIN in NUMBER,
170: X_DENORM_LEVEL in NUMBER
171: ) is
172: begin
173: update JTF_RS_GROUPS_DENORM set
174: GROUP_ID = X_GROUP_ID,
175: PARENT_GROUP_ID = X_PARENT_GROUP_ID,
176: IMMEDIATE_PARENT_FLAG = X_IMMEDIATE_PARENT_FLAG,
177: ACTUAL_PARENT_ID = X_ACTUAL_PARENT_ID,

Line 212: delete from JTF_RS_GROUPS_DENORM

208: procedure DELETE_ROW (
209: X_DENORM_GRP_ID in NUMBER
210: ) is
211: begin
212: delete from JTF_RS_GROUPS_DENORM
213: where DENORM_GRP_ID = X_DENORM_GRP_ID;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 221: end JTF_RS_GROUPS_DENORM_PKG;

217: end if;
218:
219: end DELETE_ROW;
220:
221: end JTF_RS_GROUPS_DENORM_PKG;