APPS.JTF_STORE_GRP dependencies on JTF_STORES_B

Line 32: cursor C is select ROWID from JTF_STORES_B

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_STORES_B
33: where STORE_ID = X_STORE_ID
34: ;
35: begin
36: insert into JTF_STORES_B (

Line 36: insert into JTF_STORES_B (

32: cursor C is select ROWID from JTF_STORES_B
33: where STORE_ID = X_STORE_ID
34: ;
35: begin
36: insert into JTF_STORES_B (
37: SECURITY_GROUP_ID,
38: STORE_ID,
39: OBJECT_VERSION_NUMBER,
40: ATTRIBUTE_CATEGORY,

Line 174: from JTF_STORES_B

170: ATTRIBUTE12,
171: ATTRIBUTE13,
172: ATTRIBUTE14,
173: ATTRIBUTE15
174: from JTF_STORES_B
175: where STORE_ID = X_STORE_ID
176: for update of STORE_ID nowait;
177: recinfo c%rowtype;
178:

Line 282: update JTF_STORES_B set

278: X_LAST_UPDATED_BY in NUMBER,
279: X_LAST_UPDATE_LOGIN in NUMBER
280: ) is
281: begin
282: update JTF_STORES_B set
283: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
284: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
285: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
286: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 336: delete from JTF_STORES_B

332: if (sql%notfound) then
333: raise no_data_found;
334: end if;
335:
336: delete from JTF_STORES_B
337: where STORE_ID = X_STORE_ID;
338:
339: if (sql%notfound) then
340: raise no_data_found;

Line 463: from JTF_STORES_B B

459: begin
460: delete from JTF_STORES_TL T
461: where not exists
462: (select NULL
463: from JTF_STORES_B B
464: where B.STORE_ID = T.STORE_ID
465: );
466:
467: update JTF_STORES_TL T set (