DBA Data[Home] [Help]

APPS.JTF_OBJECTS_PKG dependencies on JTF_OBJECTS_B

Line 55: cursor C is select ROWID from JTF_OBJECTS_B

51: X_INACTIVE_CLAUSE in VARCHAR2,
52: X_OA_WEB_FUNCTION_NAME in VARCHAR2,
53: X_OA_WEB_FUNCTION_PARAMETERS in VARCHAR2
54: ) is
55: cursor C is select ROWID from JTF_OBJECTS_B
56: where OBJECT_CODE = X_OBJECT_CODE
57: ;
58: begin
59: insert into JTF_OBJECTS_B (

Line 59: insert into JTF_OBJECTS_B (

55: cursor C is select ROWID from JTF_OBJECTS_B
56: where OBJECT_CODE = X_OBJECT_CODE
57: ;
58: begin
59: insert into JTF_OBJECTS_B (
60: SEEDED_FLAG,
61: ATTRIBUTE1,
62: ATTRIBUTE2,
63: ATTRIBUTE3,

Line 283: update JTF_OBJECTS_B set

279: X_OA_WEB_FUNCTION_NAME in VARCHAR2,
280: X_OA_WEB_FUNCTION_PARAMETERS in VARCHAR2
281: ) is
282: begin
283: update JTF_OBJECTS_B set
284: SEEDED_FLAG = X_SEEDED_FLAG,
285: ATTRIBUTE1 = X_ATTRIBUTE1,
286: ATTRIBUTE2 = X_ATTRIBUTE2,
287: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 362: delete from JTF_OBJECTS_B

358: if (sql%notfound) then
359: raise no_data_found;
360: end if;
361:
362: delete from JTF_OBJECTS_B
363: where OBJECT_CODE = X_OBJECT_CODE;
364:
365: if (sql%notfound) then
366: raise no_data_found;

Line 390: from JTF_OBJECTS_B B

386:
387: delete from JTF_OBJECTS_TL T
388: where not exists
389: (select NULL
390: from JTF_OBJECTS_B B
391: where B.OBJECT_CODE = T.OBJECT_CODE
392: );
393:
394: update JTF_OBJECTS_TL T set (