APPS.JTF_NOTES_PKG dependencies on JTF_NOTES_B

Line 37: cursor C is select ROWID from JTF_NOTES_B

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from JTF_NOTES_B
38: where JTF_NOTE_ID = X_JTF_NOTE_ID
39: ;
40: begin
41: insert into JTF_NOTES_B (

Line 41: insert into JTF_NOTES_B (

37: cursor C is select ROWID from JTF_NOTES_B
38: where JTF_NOTE_ID = X_JTF_NOTE_ID
39: ;
40: begin
41: insert into JTF_NOTES_B (
42: SOURCE_OBJECT_CODE,
43: NOTE_STATUS,
44: ENTERED_BY,
45: ENTERED_DATE,

Line 216: from JTF_NOTES_B

212: ATTRIBUTE15,
213: CONTEXT,
214: PARENT_NOTE_ID,
215: SOURCE_OBJECT_ID
216: from JTF_NOTES_B
217: where JTF_NOTE_ID = X_JTF_NOTE_ID
218: for update of JTF_NOTE_ID nowait;
219: recinfo c%rowtype;
220:

Line 335: update JTF_NOTES_B set

331: X_LAST_UPDATED_BY in NUMBER,
332: X_LAST_UPDATE_LOGIN in NUMBER
333: ) is
334: begin
335: update JTF_NOTES_B set
336: SOURCE_OBJECT_CODE = X_SOURCE_OBJECT_CODE,
337: NOTE_STATUS = X_NOTE_STATUS,
338: ENTERED_BY = X_ENTERED_BY,
339: ENTERED_DATE = X_ENTERED_DATE,

Line 394: delete from JTF_NOTES_B

390: if (sql%notfound) then
391: raise no_data_found;
392: end if;
393:
394: delete from JTF_NOTES_B
395: where JTF_NOTE_ID = X_JTF_NOTE_ID;
396:
397: if (sql%notfound) then
398: raise no_data_found;

Line 410: from JTF_NOTES_B B

406: /** Commented for now for the bug #4229850
407: delete from JTF_NOTES_TL T
408: where not exists
409: (select NULL
410: from JTF_NOTES_B B
411: where B.JTF_NOTE_ID = T.JTF_NOTE_ID
412: );
413:
414: update JTF_NOTES_TL T set (