APPS.JTF_OBJECT_USAGES_PKG dependencies on JTF_OBJECT_USAGES

Line 1: PACKAGE body JTF_OBJECT_USAGES_PKG as

1: PACKAGE body JTF_OBJECT_USAGES_PKG as
2: /* $Header: jtftkusb.pls 115.13 2002/12/04 23:33:40 cjang ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 32: cursor C is select ROWID from JTF_OBJECT_USAGES

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from JTF_OBJECT_USAGES
33: where OBJECT_USAGE_ID = X_OBJECT_USAGE_ID
34: ;
35: begin
36: insert into JTF_OBJECT_USAGES (

Line 36: insert into JTF_OBJECT_USAGES (

32: cursor C is select ROWID from JTF_OBJECT_USAGES
33: where OBJECT_USAGE_ID = X_OBJECT_USAGE_ID
34: ;
35: begin
36: insert into JTF_OBJECT_USAGES (
37: OBJECT_USAGE_ID,
38: CREATED_BY,
39: CREATION_DATE,
40: LAST_UPDATED_BY,

Line 108: from JTF_object_usages

104: X_OBJECT_VERSION_NUMBER in NUMBER
105: ) is
106: cursor c is select
107: OBJECT_VERSION_NUMBER
108: from JTF_object_usages
109:
110: where object_usage_id = X_object_usage_id
111: for update of object_code nowait;
112: recinfo c%rowtype;

Line 166: update JTF_OBJECT_USAGES set

162: X_OBJECT_VERSION_NUMBER NUMBER
163: ) is
164: begin
165:
166: update JTF_OBJECT_USAGES set
167: OBJECT_CODE = X_OBJECT_CODE,
168: SEEDED_FLAG = X_SEEDED_FLAG,
169: ATTRIBUTE1 = X_ATTRIBUTE1,
170: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 202: delete from JTF_OBJECT_USAGES

198: procedure DELETE_ROW (
199: X_OBJECT_USAGE_ID in NUMBER
200: ) is
201: begin
202: delete from JTF_OBJECT_USAGES
203: where OBJECT_USAGE_ID = X_OBJECT_USAGE_ID;
204:
205: if (sql%notfound) then
206: raise no_data_found;

Line 213: end JTF_OBJECT_USAGES_PKG;

209:
210: end DELETE_ROW;
211:
212:
213: end JTF_OBJECT_USAGES_PKG;