DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on JTF_NOTES_PUB

Line 1107: JTF_NOTES_PUB.writeLobToData(notes_rec.JTF_NOTE_ID,L_Notes_detail);

1103: IF l_cov_templ_yn = 'N' then
1104: -- create notes for actual coverage from the template
1105: FOR notes_rec IN CUR_GET_NOTES(l_Template_Line_Id) LOOP
1106:
1107: JTF_NOTES_PUB.writeLobToData(notes_rec.JTF_NOTE_ID,L_Notes_detail);
1108:
1109: JTF_NOTES_PUB.CREATE_NOTE(p_parent_note_id => notes_rec.parent_note_id ,
1110: p_api_version => l_api_version,
1111: p_init_msg_list => l_init_msg_list,

Line 1109: JTF_NOTES_PUB.CREATE_NOTE(p_parent_note_id => notes_rec.parent_note_id ,

1105: FOR notes_rec IN CUR_GET_NOTES(l_Template_Line_Id) LOOP
1106:
1107: JTF_NOTES_PUB.writeLobToData(notes_rec.JTF_NOTE_ID,L_Notes_detail);
1108:
1109: JTF_NOTES_PUB.CREATE_NOTE(p_parent_note_id => notes_rec.parent_note_id ,
1110: p_api_version => l_api_version,
1111: p_init_msg_list => l_init_msg_list,
1112: p_commit => 'F',
1113: p_validation_level => 100,

Line 2498: JTF_NOTES_PUB.Secure_Delete_note

2494: CLOSE Cur_Service_line;
2495:
2496: FOR note_rec IN Cur_Get_notes(l_service_line_id)
2497: LOOP
2498: JTF_NOTES_PUB.Secure_Delete_note
2499: ( p_api_version => l_api_version,
2500: p_init_msg_list => l_init_msg_list, -- VARCHAR2 DEFAULT 'F'
2501: p_commit => 'F', --IN VARCHAR2 DEFAULT 'F'
2502: p_validation_level => 100, --IN NUMBER DEFAULT 100

Line 6701: JTF_NOTES_PUB.writeLobToData(GET_NOTES_DETAILS_REC.JTF_NOTE_ID,L_Notes_TBL(i).Notes_detail);

6697:
6698:
6699: L_Notes_TBL(i).source_object_code := GET_NOTES_DETAILS_REC.SOURCE_OBJECT_CODE;
6700: L_Notes_TBL(i).Notes := GET_NOTES_DETAILS_REC.NOTES;
6701: JTF_NOTES_PUB.writeLobToData(GET_NOTES_DETAILS_REC.JTF_NOTE_ID,L_Notes_TBL(i).Notes_detail);
6702: --GET_NOTES_DETAILS_REC.NOTES_DETAIL;
6703: L_Notes_TBL(i).note_status := GET_NOTES_DETAILS_REC.NOTE_STATUS;
6704: L_Notes_TBL(i).note_type := GET_NOTES_DETAILS_REC.NOTE_TYPE;
6705: -- Modified by Jvorugan for Bug:4489214 who columns not to be populated from old contract

Line 6772: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

6768: l_Return_Status VARCHAR2(1) := NULL;
6769: l_msg_count NUMBER;
6770: l_msg_data VARCHAR2(1000);
6771: l_jtf_note_id NUMBER;
6772: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
6773:
6774:
6775: BEGIN
6776:

Line 6797: JTF_NOTES_PUB.create_note

6793: IF l_Return_Status = 'S' THEN
6794: IF (l_Notes_TBL.COUNT > 0) THEN
6795: FOR I IN l_Notes_TBL.FIRST .. l_Notes_TBL.LAST LOOP
6796:
6797: JTF_NOTES_PUB.create_note
6798: ( p_jtf_note_id => NULL--:JTF_NOTES.JTF_NOTE_ID
6799: , p_api_version => 1.0
6800: , p_init_msg_list => 'F'
6801: , p_commit => 'F'

Line 9213: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

9209: l_Return_Status Varchar2(1);
9210: l_msg_count NUMBER;
9211: l_msg_data VARCHAR2(1000);
9212: l_jtf_note_id NUMBER;
9213: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
9214:
9215: CURSOR Get_Orig_System_Id_Cur(l_chr_id IN NUMBER) IS
9216: SELECT ORIG_SYSTEM_ID1, Created_By,LAst_Updated_By,Last_Update_Login
9217: FROM OKC_K_HEADERS_B

Line 9245: JTF_NOTES_PUB.create_note

9241:
9242: IF (l_Notes_TBL.COUNT > 0) THEN
9243: FOR I IN l_Notes_TBL.FIRST .. l_Notes_TBL.LAST LOOP
9244:
9245: JTF_NOTES_PUB.create_note
9246: ( p_jtf_note_id => NULL--:JTF_NOTES.JTF_NOTE_ID
9247: , p_api_version => 1.0
9248: , p_init_msg_list => 'F'
9249: , p_commit => 'F'

Line 10210: okc_debug.log('BEFORE CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);

10206: end LOOP;
10207: -- create notes for actual coverage from the template
10208: -- pass coverage_template_id as (p_source_object_id IN parameter )in the cursor below
10209: IF (G_DEBUG_ENABLED = 'Y') THEN
10210: okc_debug.log('BEFORE CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10211: END IF;
10212:
10213: -- Added l_source_object_code,l_source_line_id as input parameters for CUR_GET_NOTES
10214: FOR notes_rec IN CUR_GET_NOTES (l_source_line_id,l_source_object_code) LOOP

Line 10215: JTF_NOTES_PUB.writeLobToData(notes_rec.JTF_NOTE_ID,L_Notes_detail);

10211: END IF;
10212:
10213: -- Added l_source_object_code,l_source_line_id as input parameters for CUR_GET_NOTES
10214: FOR notes_rec IN CUR_GET_NOTES (l_source_line_id,l_source_object_code) LOOP
10215: JTF_NOTES_PUB.writeLobToData(notes_rec.JTF_NOTE_ID,L_Notes_detail);
10216:
10217: JTF_NOTES_PUB.CREATE_NOTE(p_parent_note_id => notes_rec.parent_note_id ,
10218: p_api_version => l_api_version,
10219: p_init_msg_list => l_init_msg_list,

Line 10217: JTF_NOTES_PUB.CREATE_NOTE(p_parent_note_id => notes_rec.parent_note_id ,

10213: -- Added l_source_object_code,l_source_line_id as input parameters for CUR_GET_NOTES
10214: FOR notes_rec IN CUR_GET_NOTES (l_source_line_id,l_source_object_code) LOOP
10215: JTF_NOTES_PUB.writeLobToData(notes_rec.JTF_NOTE_ID,L_Notes_detail);
10216:
10217: JTF_NOTES_PUB.CREATE_NOTE(p_parent_note_id => notes_rec.parent_note_id ,
10218: p_api_version => l_api_version,
10219: p_init_msg_list => l_init_msg_list,
10220: p_commit => 'F',
10221: p_validation_level => 100,

Line 10258: okc_debug.log('AFTER CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);

10254: p_context => notes_rec.CONTEXT,
10255: p_note_type => notes_rec.NOTE_TYPE);
10256:
10257: IF (G_DEBUG_ENABLED = 'Y') THEN
10258: okc_debug.log('AFTER CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10259: END IF;
10260:
10261:
10262: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN