APPS.JTF_AM_TERR_QUALIFIERS_PKG dependencies on JTF_AM_TERR_QUALIFIERS

Line 1: package body JTF_AM_TERR_QUALIFIERS_PKG as

1: package body JTF_AM_TERR_QUALIFIERS_PKG as
2: /* $Header: jtfamttb.pls 115.1 2003/04/23 23:08:28 sroychou noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_TERR_QUALIFIER_ID in NUMBER,

Line 32: cursor C is select ROWID from JTF_AM_TERR_QUALIFIERS

28: X_LAST_UPDATE_LOGIN in NUMBER,
29: X_SECURITY_GROUP_ID in NUMBER)
30: IS
31:
32: cursor C is select ROWID from JTF_AM_TERR_QUALIFIERS
33: where TERR_QUALIFIER_ID = X_TERR_QUALIFIER_ID
34: ;
35:
36: begin

Line 37: insert into JTF_AM_TERR_QUALIFIERS (

33: where TERR_QUALIFIER_ID = X_TERR_QUALIFIER_ID
34: ;
35:
36: begin
37: insert into JTF_AM_TERR_QUALIFIERS (
38: TERR_QUALIFIER_ID,
39: QUAL_USG_ID ,
40: QUAL_ATTRIBUTE_NAME ,
41: ATTRIBUTE1 ,

Line 110: from JTF_AM_TERR_QUALIFIERS

106: X_OBJECT_VERSION_NUMBER in NUMBER
107: ) is
108: cursor c1 is select
109: OBJECT_VERSION_NUMBER
110: from JTF_AM_TERR_QUALIFIERS
111: where TERR_QUALIFIER_ID = X_TERR_QUALIFIER_ID
112: for update of TERR_QUALIFIER_ID nowait;
113: tlinfo c1%rowtype ;
114: begin

Line 161: update JTF_AM_TERR_QUALIFIERS set

157: X_OBJECT_VERSION_NUMBER in NUMBER,
158: X_SECURITY_GROUP_ID in NUMBER
159: ) is
160: begin
161: update JTF_AM_TERR_QUALIFIERS set
162: ATTRIBUTE9 = X_ATTRIBUTE9,
163: ATTRIBUTE10 = X_ATTRIBUTE10,
164: ATTRIBUTE11 = X_ATTRIBUTE11,
165: ATTRIBUTE12 = X_ATTRIBUTE12,

Line 225: from JTF_AM_TERR_QUALIFIERS

221:
222: CURSOR c_last_updated IS
223: SELECT last_updated_by,
224: object_version_number
225: from JTF_AM_TERR_QUALIFIERS
226: WHERE terr_qualifier_id = x_terr_qualifier_id;
227:
228: begin
229: if (X_OWNER = 'SEED') then

Line 239: jtf_am_terr_qualifiers_pkg.insert_row(

235: OPEN c_last_updated;
236: FETCH c_last_updated into l_last_updated_by, l_object_version_number ;
237: IF c_last_updated%NOTFOUND THEN
238: l_object_version_number := 1;
239: jtf_am_terr_qualifiers_pkg.insert_row(
240: X_ROWID => l_row_id ,
241: X_TERR_QUALIFIER_ID => X_TERR_QUALIFIER_ID,
242: X_ATTRIBUTE1 => X_ATTRIBUTE1 ,
243: X_ATTRIBUTE2 => X_ATTRIBUTE2 ,

Line 274: jtf_am_terr_qualifiers_pkg.update_row(

270:
271: IF l_last_updated_by IN (1,0) THEN
272: l_object_version_number := l_object_version_number + 1;
273:
274: jtf_am_terr_qualifiers_pkg.update_row(
275: X_TERR_QUALIFIER_ID => X_TERR_QUALIFIER_ID,
276: X_ATTRIBUTE1 => X_ATTRIBUTE1 ,
277: X_ATTRIBUTE2 => X_ATTRIBUTE2 ,
278: X_ATTRIBUTE3 => X_ATTRIBUTE3 ,

Line 311: delete from JTF_AM_TERR_QUALIFIERS

307: procedure DELETE_ROW (
308: X_TERR_QUALIFIER_ID in NUMBER
309: ) is
310: begin
311: delete from JTF_AM_TERR_QUALIFIERS
312: where TERR_QUALIFIER_ID = X_TERR_QUALIFIER_ID;
313:
314: if (sql%notfound) then
315: raise no_data_found;

Line 319: end JTF_AM_TERR_QUALIFIERS_PKG;

315: raise no_data_found;
316: end if;
317:
318: end DELETE_ROW;
319: end JTF_AM_TERR_QUALIFIERS_PKG;