APPS.JTF_RS_TABLE_ATTRIBUTES_PKG dependencies on JTF_RS_TABLE_ATTRIBUTES_B

Line 32: cursor C is select ROWID from JTF_RS_TABLE_ATTRIBUTES_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_RS_TABLE_ATTRIBUTES_B
33: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
34: ;
35: begin
36: insert into JTF_RS_TABLE_ATTRIBUTES_B (

Line 36: insert into JTF_RS_TABLE_ATTRIBUTES_B (

32: cursor C is select ROWID from JTF_RS_TABLE_ATTRIBUTES_B
33: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
34: ;
35: begin
36: insert into JTF_RS_TABLE_ATTRIBUTES_B (
37: ATTRIBUTE_ID,
38: ATTRIBUTE_NAME,
39: ATTRIBUTE_ACCESS_LEVEL,
40: ATTRIBUTE1,

Line 186: update JTF_RS_TABLE_ATTRIBUTES_B set

182: X_LAST_UPDATED_BY in NUMBER,
183: X_LAST_UPDATE_LOGIN in NUMBER
184: ) is
185: begin
186: update JTF_RS_TABLE_ATTRIBUTES_B set
187: ATTRIBUTE_NAME = X_ATTRIBUTE_NAME,
188: ATTRIBUTE_ACCESS_LEVEL = X_ATTRIBUTE_ACCESS_LEVEL,
189: ATTRIBUTE1 = X_ATTRIBUTE1,
190: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 240: delete from JTF_RS_TABLE_ATTRIBUTES_B

236: if (sql%notfound) then
237: raise no_data_found;
238: end if;
239:
240: delete from JTF_RS_TABLE_ATTRIBUTES_B
241: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
242:
243: if (sql%notfound) then
244: raise no_data_found;

Line 254: from JTF_RS_TABLE_ATTRIBUTES_B B

250: begin
251: delete from JTF_RS_TABLE_ATTRIBUTES_TL T
252: where not exists
253: (select NULL
254: from JTF_RS_TABLE_ATTRIBUTES_B B
255: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
256: );
257:
258: update JTF_RS_TABLE_ATTRIBUTES_TL T set (