DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on JTF_NOTES_PUB

Line 31: --| JTF_NOTES_PUB | | | | | |X |

27: --| FND_ATTACHED_DOCUMENTS | | | | | |X |
28: --+---------------------------------+---+---+---+---+---+----------------------+
29: --| okc_k_headers_all_b | X | | X | | | |
30: --+---------------------------------+---+---+---+---+---+----------------------+
31: --| JTF_NOTES_PUB | | | | | |X |
32: --+---------------------------------+---+---+---+---+---+----------------------+
33: --| JTF_NOTES_VL | X | | | | | |
34: --+---------------------------------+---+---+---+---+---+----------------------+
35: --| HZ_PARTIES | X | | | | | |

Line 1132: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

1128: x_msg_data OUT NOCOPY VARCHAR2
1129: )
1130: IS
1131: l_jtf_note_id NUMBER;
1132: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
1133:
1134: BEGIN
1135: x_return_status := okc_api.g_ret_sts_success;
1136: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 1144: jtf_notes_pub.create_note

1140: 'note = ( ' || p_note || ' )'
1141: );
1142: END IF;
1143:
1144: jtf_notes_pub.create_note
1145: (p_jtf_note_id => NULL,
1146: p_api_version => 1.0,
1147: p_init_msg_list => 'F',
1148: p_commit => 'F',

Line 1265: jtf_notes_pub.writelobtodata (get_notes_details_rec.jtf_note_id,

1261: LOOP
1262: l_notes_tbl (i).source_object_code :=
1263: get_notes_details_rec.source_object_code;
1264: l_notes_tbl (i).notes := get_notes_details_rec.notes;
1265: jtf_notes_pub.writelobtodata (get_notes_details_rec.jtf_note_id,
1266: l_notes_tbl (i).notes_detail
1267: );
1268: l_notes_tbl (i).note_status := get_notes_details_rec.note_status;
1269: l_notes_tbl (i).note_type := get_notes_details_rec.note_type;

Line 4620: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

4616: m Number;
4617:
4618: -- Valiables for notes
4619: l_jtf_note_id NUMBER;
4620: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
4621: l_note_details csi_mass_edit_entries_tl.Description%TYPE;
4622:
4623: l_uom_code Varchar2(240);
4624: BEGIN

Line 5282: jtf_notes_pub.create_note

5278: IF (l_notes_tbl.COUNT > 0)
5279: THEN
5280: FOR m IN l_notes_tbl.FIRST .. l_notes_tbl.LAST
5281: LOOP
5282: jtf_notes_pub.create_note
5283: (p_jtf_note_id => NULL,
5284: p_api_version => 1.0,
5285: p_init_msg_list => 'F',
5286: p_commit => 'F',

Line 6693: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

6689: l_to_entity_name VARCHAR2 (30);
6690: l_from_version fnd_attached_documents.pk2_value%TYPE;
6691: -- Valiables for notes
6692: l_jtf_note_id NUMBER;
6693: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
6694: l_note_details csi_mass_edit_entries_tl.Description%TYPE;
6695: --Contract Line Table
6696: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6697: l_clev_tbl_out okc_contract_pub.clev_tbl_type;