APPS.JTF_RS_GROUP_USAGES_PKG dependencies on JTF_RS_GROUP_USAGES

Line 1: package body JTF_RS_GROUP_USAGES_PKG as

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

Line 30: cursor C is select ROWID from JTF_RS_GROUP_USAGES

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_GROUP_USAGES
31: where GROUP_USAGE_ID = X_GROUP_USAGE_ID
32: ;
33: begin
34: insert into JTF_RS_GROUP_USAGES (

Line 34: insert into JTF_RS_GROUP_USAGES (

30: cursor C is select ROWID from JTF_RS_GROUP_USAGES
31: where GROUP_USAGE_ID = X_GROUP_USAGE_ID
32: ;
33: begin
34: insert into JTF_RS_GROUP_USAGES (
35: GROUP_USAGE_ID,
36: GROUP_ID,
37: USAGE,
38: OBJECT_VERSION_NUMBER,

Line 103: from JTF_RS_GROUP_USAGES

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

Line 153: update JTF_RS_GROUP_USAGES set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update JTF_RS_GROUP_USAGES set
154: GROUP_ID = X_GROUP_ID,
155: USAGE = X_USAGE,
156: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
157: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 187: delete from JTF_RS_GROUP_USAGES

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

Line 196: end JTF_RS_GROUP_USAGES_PKG;

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