APPS.JTF_RS_TEAM_USAGES_PKG dependencies on JTF_RS_TEAM_USAGES

Line 1: package body JTF_RS_TEAM_USAGES_PKG as

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

Line 30: cursor C is select ROWID from JTF_RS_TEAM_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_TEAM_USAGES
31: where TEAM_USAGE_ID = X_TEAM_USAGE_ID
32: ;
33: begin
34: insert into JTF_RS_TEAM_USAGES (

Line 34: insert into JTF_RS_TEAM_USAGES (

30: cursor C is select ROWID from JTF_RS_TEAM_USAGES
31: where TEAM_USAGE_ID = X_TEAM_USAGE_ID
32: ;
33: begin
34: insert into JTF_RS_TEAM_USAGES (
35: LAST_UPDATED_BY,
36: LAST_UPDATE_DATE,
37: LAST_UPDATE_LOGIN,
38: ATTRIBUTE1,

Line 103: from JTF_RS_TEAM_USAGES

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

Line 153: update JTF_RS_TEAM_USAGES set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update JTF_RS_TEAM_USAGES set
154: ATTRIBUTE2 = X_ATTRIBUTE2,
155: ATTRIBUTE3 = X_ATTRIBUTE3,
156: ATTRIBUTE4 = X_ATTRIBUTE4,
157: ATTRIBUTE5 = X_ATTRIBUTE5,

Line 187: delete from JTF_RS_TEAM_USAGES

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

Line 196: end JTF_RS_TEAM_USAGES_PKG;

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