2708: CURSOR c_activities_id IS
2709: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
2710: FROM dual;
2711:
2712: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
2713: l_activities JTF_IH_PUB.activity_tbl_type;
2714: l_activity_rec JTF_IH_PUB.activity_rec_type;
2715: l_media_rec JTF_IH_PUB.media_rec_type;
2716: l_interaction_id NUMBER;
2709: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
2710: FROM dual;
2711:
2712: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
2713: l_activities JTF_IH_PUB.activity_tbl_type;
2714: l_activity_rec JTF_IH_PUB.activity_rec_type;
2715: l_media_rec JTF_IH_PUB.media_rec_type;
2716: l_interaction_id NUMBER;
2717: l_media_id NUMBER;
2710: FROM dual;
2711:
2712: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
2713: l_activities JTF_IH_PUB.activity_tbl_type;
2714: l_activity_rec JTF_IH_PUB.activity_rec_type;
2715: l_media_rec JTF_IH_PUB.media_rec_type;
2716: l_interaction_id NUMBER;
2717: l_media_id NUMBER;
2718: l_party_id NUMBER;
2711:
2712: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
2713: l_activities JTF_IH_PUB.activity_tbl_type;
2714: l_activity_rec JTF_IH_PUB.activity_rec_type;
2715: l_media_rec JTF_IH_PUB.media_rec_type;
2716: l_interaction_id NUMBER;
2717: l_media_id NUMBER;
2718: l_party_id NUMBER;
2719: l_schedule_start_time DATE;
2743: l_media_rec.start_date_time := l_schedule_start_time ;
2744: l_media_rec.media_item_type := 'MAIL' ;
2745:
2746: -- create media_rec
2747: JTF_IH_PUB.Create_MediaItem
2748: (
2749: p_api_version => 1.0,
2750: p_init_msg_list => FND_API.g_false,
2751: p_commit => FND_API.g_false,
2818: -- populate activity table with the activity record
2819: l_activities(1) := l_activity_rec;
2820:
2821: -- create interaction
2822: JTF_IH_PUB.Create_Interaction
2823: (
2824: p_api_version => 1.0,
2825: p_init_msg_list => FND_API.g_false,
2826: p_commit => FND_API.g_false,