APPS.OKS_COVERAGES_PVT dependencies on JTF_NOTES_B

Line 6761: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%TYPE;

6757: --AND lines1.lse_id =1
6758: --AND lines2.lse_id = 1;
6759:
6760:
6761: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%TYPE;
6762: l_source_object_id JTF_NOTES_B.SOURCE_OBJECT_ID%TYPE;
6763: l_note_type JTF_NOTES_B.NOTE_TYPE%TYPE;
6764: l_note_status JTF_NOTES_B.NOTE_STATUS%TYPE;
6765: l_notes JTF_NOTES_TL.NOTES%TYPE;

Line 6762: l_source_object_id JTF_NOTES_B.SOURCE_OBJECT_ID%TYPE;

6758: --AND lines2.lse_id = 1;
6759:
6760:
6761: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%TYPE;
6762: l_source_object_id JTF_NOTES_B.SOURCE_OBJECT_ID%TYPE;
6763: l_note_type JTF_NOTES_B.NOTE_TYPE%TYPE;
6764: l_note_status JTF_NOTES_B.NOTE_STATUS%TYPE;
6765: l_notes JTF_NOTES_TL.NOTES%TYPE;
6766: l_Notes_detail VARCHAR2(32767);

Line 6763: l_note_type JTF_NOTES_B.NOTE_TYPE%TYPE;

6759:
6760:
6761: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%TYPE;
6762: l_source_object_id JTF_NOTES_B.SOURCE_OBJECT_ID%TYPE;
6763: l_note_type JTF_NOTES_B.NOTE_TYPE%TYPE;
6764: l_note_status JTF_NOTES_B.NOTE_STATUS%TYPE;
6765: l_notes JTF_NOTES_TL.NOTES%TYPE;
6766: l_Notes_detail VARCHAR2(32767);
6767:

Line 6764: l_note_status JTF_NOTES_B.NOTE_STATUS%TYPE;

6760:
6761: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%TYPE;
6762: l_source_object_id JTF_NOTES_B.SOURCE_OBJECT_ID%TYPE;
6763: l_note_type JTF_NOTES_B.NOTE_TYPE%TYPE;
6764: l_note_status JTF_NOTES_B.NOTE_STATUS%TYPE;
6765: l_notes JTF_NOTES_TL.NOTES%TYPE;
6766: l_Notes_detail VARCHAR2(32767);
6767:
6768: l_Return_Status VARCHAR2(1) := NULL;

Line 10181: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%type;

10177:
10178: -- Added by Jvorugan for Bug: 4610475.
10179: l_pm_sch_exists_yn VARCHAR2(1);
10180: l_pm_conf_req_yn VARCHAR2(1);
10181: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%type;
10182: l_source_line_id NUMBER;
10183:
10184: BEGIN
10185: l_return_status := 'S';