60: l_interest_use_code VARCHAR2(30);
61: l_interest_out_id NUMBER;
62: l_sales_lead_id NUMBER;
63:
64: l_note_context_rec jtf_notes_pub.jtf_note_contexts_rec_type;
65: l_note_context_rec_tbl jtf_notes_pub.jtf_note_contexts_tbl_type;
66:
67: CURSOR C_get_slaesforce(c_user_id NUMBER)
68: IS
61: l_interest_out_id NUMBER;
62: l_sales_lead_id NUMBER;
63:
64: l_note_context_rec jtf_notes_pub.jtf_note_contexts_rec_type;
65: l_note_context_rec_tbl jtf_notes_pub.jtf_note_contexts_tbl_type;
66:
67: CURSOR C_get_slaesforce(c_user_id NUMBER)
68: IS
69: SELECT JS.RESOURCE_ID
277: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
278:
279: l_note_context_rec_tbl(2) := l_note_context_rec;
280:
281: -- Call Jtf_notes_pub.create_note()
282:
283: JTF_NOTES_PUB.Create_Note (
284: p_parent_note_id => NULL
285: , p_jtf_note_id => NULL
279: l_note_context_rec_tbl(2) := l_note_context_rec;
280:
281: -- Call Jtf_notes_pub.create_note()
282:
283: JTF_NOTES_PUB.Create_Note (
284: p_parent_note_id => NULL
285: , p_jtf_note_id => NULL
286: , p_api_version => 1.0
287: , p_init_msg_list => 'T'