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

1124: x_msg_data OUT NOCOPY VARCHAR2
1125: )
1126: IS
1127: l_jtf_note_id NUMBER;
1128: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
1129:
1130: BEGIN
1131: x_return_status := okc_api.g_ret_sts_success;
1132: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 1140: jtf_notes_pub.create_note

1136: 'note = ( ' || p_note || ' )'
1137: );
1138: END IF;
1139:
1140: jtf_notes_pub.create_note
1141: (p_jtf_note_id => NULL,
1142: p_api_version => 1.0,
1143: p_init_msg_list => 'F',
1144: p_commit => 'F',

Line 1261: jtf_notes_pub.writelobtodata (get_notes_details_rec.jtf_note_id,

1257: LOOP
1258: l_notes_tbl (i).source_object_code :=
1259: get_notes_details_rec.source_object_code;
1260: l_notes_tbl (i).notes := get_notes_details_rec.notes;
1261: jtf_notes_pub.writelobtodata (get_notes_details_rec.jtf_note_id,
1262: l_notes_tbl (i).notes_detail
1263: );
1264: l_notes_tbl (i).note_status := get_notes_details_rec.note_status;
1265: l_notes_tbl (i).note_type := get_notes_details_rec.note_type;

Line 4615: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

4611: m Number;
4612:
4613: -- Valiables for notes
4614: l_jtf_note_id NUMBER;
4615: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
4616: l_note_details csi_mass_edit_entries_tl.Description%TYPE;
4617:
4618: l_uom_code Varchar2(240);
4619: BEGIN

Line 5267: jtf_notes_pub.create_note

5263: IF (l_notes_tbl.COUNT > 0)
5264: THEN
5265: FOR m IN l_notes_tbl.FIRST .. l_notes_tbl.LAST
5266: LOOP
5267: jtf_notes_pub.create_note
5268: (p_jtf_note_id => NULL,
5269: p_api_version => 1.0,
5270: p_init_msg_list => 'F',
5271: p_commit => 'F',

Line 6676: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;

6672: l_to_entity_name VARCHAR2 (30);
6673: l_from_version fnd_attached_documents.pk2_value%TYPE;
6674: -- Valiables for notes
6675: l_jtf_note_id NUMBER;
6676: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
6677: l_note_details csi_mass_edit_entries_tl.Description%TYPE;
6678: --Contract Line Table
6679: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6680: l_clev_tbl_out okc_contract_pub.clev_tbl_type;