APPS.CSL_JTF_NOTES_ACC_PKG dependencies on JTF_NOTES_B

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_NOTES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_NOTES_VL');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
9: g_pk_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
10:
11: g_debug_level NUMBER; -- debug level
12:

Line 21: FROM JTF_NOTES_B

17: RETURN BOOLEAN
18: IS
19: CURSOR c_jtf_note (b_jtf_note_id NUMBER) IS
20: SELECT *
21: FROM JTF_NOTES_B
22: WHERE jtf_note_id = b_jtf_note_id;
23: r_jtf_note c_jtf_note%ROWTYPE;
24:
25: BEGIN

Line 73: FROM JTF_NOTES_B

69: RETURN NUMBER
70: IS
71: CURSOR c_jtf_note (b_jtf_note_id NUMBER) IS
72: SELECT entered_by
73: FROM JTF_NOTES_B
74: WHERE jtf_note_id = b_jtf_note_id;
75: r_jtf_note c_jtf_note%ROWTYPE;
76:
77: BEGIN

Line 377: FROM JTF_NOTES_B

373: IS
374: CURSOR c_jtf_note (b_source_obj_id NUMBER,
375: b_source_obj_code VARCHAR2) IS
376: SELECT *
377: FROM JTF_NOTES_B
378: WHERE source_object_id = b_source_obj_id
379: AND source_object_code = b_source_obj_code;
380: r_jtf_note c_jtf_note%ROWTYPE;
381:

Line 496: FROM JTF_NOTES_B

492: IS
493: CURSOR c_jtf_note (b_source_obj_id NUMBER,
494: b_source_obj_code VARCHAR2) IS
495: SELECT *
496: FROM JTF_NOTES_B
497: WHERE source_object_id = b_source_obj_id
498: AND source_object_code = b_source_obj_code;
499: r_jtf_note c_jtf_note%ROWTYPE;
500:

Line 557: FROM JTF_NOTES_B

553:
554: CURSOR c_object( b_note_id NUMBER ) IS
555: SELECT SOURCE_OBJECT_ID
556: , SOURCE_OBJECT_CODE
557: FROM JTF_NOTES_B
558: WHERE JTF_NOTE_ID = b_note_id;
559: r_object c_object%ROWTYPE;
560:
561: CURSOR c_sr( b_id NUMBER ) IS