APPS.JTF_TASK_REFERENCES_PKG dependencies on JTF_TASK_REFERENCES_B

Line 36: cursor C is select ROWID from JTF_TASK_REFERENCES_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from JTF_TASK_REFERENCES_B
37: where TASK_REFERENCE_ID = X_TASK_REFERENCE_ID
38: ;
39: begin
40: insert into JTF_TASK_REFERENCES_B (

Line 40: insert into JTF_TASK_REFERENCES_B (

36: cursor C is select ROWID from JTF_TASK_REFERENCES_B
37: where TASK_REFERENCE_ID = X_TASK_REFERENCE_ID
38: ;
39: begin
40: insert into JTF_TASK_REFERENCES_B (
41: TASK_REFERENCE_ID,
42: TASK_ID,
43: OBJECT_TYPE_CODE,
44: OBJECT_NAME,

Line 203: update JTF_TASK_REFERENCES_B set

199: X_LAST_UPDATED_BY in NUMBER,
200: X_LAST_UPDATE_LOGIN in NUMBER
201: ) is
202: begin
203: update JTF_TASK_REFERENCES_B set
204: TASK_ID = X_TASK_ID,
205: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
206: OBJECT_TYPE_CODE = X_OBJECT_TYPE_CODE,
207: OBJECT_NAME = X_OBJECT_NAME,

Line 261: delete from JTF_TASK_REFERENCES_B

257: if (sql%notfound) then
258: raise no_data_found;
259: end if;
260:
261: delete from JTF_TASK_REFERENCES_B
262: where TASK_REFERENCE_ID = X_TASK_REFERENCE_ID ;
263:
264: if (sql%notfound) then
265: raise no_data_found;

Line 281: from JTF_TASK_REFERENCES_B B

277:
278: delete from JTF_TASK_REFERENCES_TL T
279: where not exists
280: (select NULL
281: from JTF_TASK_REFERENCES_B B
282: where B.TASK_REFERENCE_ID = T.TASK_REFERENCE_ID
283: );
284:
285: update JTF_TASK_REFERENCES_TL T set (