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 10171: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%type;

10167:
10168: -- Added by Jvorugan for Bug: 4610475.
10169: l_pm_sch_exists_yn VARCHAR2(1);
10170: l_pm_conf_req_yn VARCHAR2(1);
10171: l_source_object_code JTF_NOTES_B.SOURCE_OBJECT_CODE%type;
10172: l_source_line_id NUMBER;
10173:
10174: BEGIN
10175: l_return_status := 'S';