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 9223: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

9219: l_Return_Status Varchar2(1);
9220: l_msg_count NUMBER;
9221: l_msg_data VARCHAR2(1000);
9222: l_jtf_note_id NUMBER;
9223: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
9224:
9225: CURSOR Get_Orig_System_Id_Cur(l_chr_id IN NUMBER) IS
9226: SELECT ORIG_SYSTEM_ID1, Created_By,LAst_Updated_By,Last_Update_Login
9227: FROM OKC_K_HEADERS_B

Line 9255: JTF_NOTES_PUB.create_note

9251:
9252: IF (l_Notes_TBL.COUNT > 0) THEN
9253: FOR I IN l_Notes_TBL.FIRST .. l_Notes_TBL.LAST LOOP
9254:
9255: JTF_NOTES_PUB.create_note
9256: ( p_jtf_note_id => NULL--:JTF_NOTES.JTF_NOTE_ID
9257: , p_api_version => 1.0
9258: , p_init_msg_list => 'F'
9259: , p_commit => 'F'

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

10216: end LOOP;
10217: -- create notes for actual coverage from the template
10218: -- pass coverage_template_id as (p_source_object_id IN parameter )in the cursor below
10219: IF (G_DEBUG_ENABLED = 'Y') THEN
10220: okc_debug.log('BEFORE CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10221: END IF;
10222:
10223: -- Added l_source_object_code,l_source_line_id as input parameters for CUR_GET_NOTES
10224: FOR notes_rec IN CUR_GET_NOTES (l_source_line_id,l_source_object_code) LOOP

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

10221: END IF;
10222:
10223: -- Added l_source_object_code,l_source_line_id as input parameters for CUR_GET_NOTES
10224: FOR notes_rec IN CUR_GET_NOTES (l_source_line_id,l_source_object_code) LOOP
10225: JTF_NOTES_PUB.writeLobToData(notes_rec.JTF_NOTE_ID,L_Notes_detail);
10226:
10227: JTF_NOTES_PUB.CREATE_NOTE(p_parent_note_id => notes_rec.parent_note_id ,
10228: p_api_version => l_api_version,
10229: p_init_msg_list => l_init_msg_list,

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

10223: -- Added l_source_object_code,l_source_line_id as input parameters for CUR_GET_NOTES
10224: FOR notes_rec IN CUR_GET_NOTES (l_source_line_id,l_source_object_code) LOOP
10225: JTF_NOTES_PUB.writeLobToData(notes_rec.JTF_NOTE_ID,L_Notes_detail);
10226:
10227: JTF_NOTES_PUB.CREATE_NOTE(p_parent_note_id => notes_rec.parent_note_id ,
10228: p_api_version => l_api_version,
10229: p_init_msg_list => l_init_msg_list,
10230: p_commit => 'F',
10231: p_validation_level => 100,

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

10264: p_context => notes_rec.CONTEXT,
10265: p_note_type => notes_rec.NOTE_TYPE);
10266:
10267: IF (G_DEBUG_ENABLED = 'Y') THEN
10268: okc_debug.log('AFTER CALLING JTF_NOTES_PUB.CREATE_NOTE'||l_return_status, 2);
10269: END IF;
10270:
10271:
10272: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN