DBA Data[Home] [Help]

APPS.AMS_FULFILL_PVT dependencies on AMS_LISTHEADER_PVT

Line 780: l_list_rec AMS_LISTHEADER_PVT.list_header_rec_type;

776: FROM ams_list_headers_all
777: WHERE list_header_id = p_list_header_id ;
778:
779:
780: l_list_rec AMS_LISTHEADER_PVT.list_header_rec_type;
781: l_api_name CONSTANT VARCHAR2(30) := 'AMS_EXEC_SCHEDULE';
782: l_api_version CONSTANT NUMBER := 1.0;
783: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
784:

Line 826: AMS_LISTHEADER_PVT.Init_ListHeader_rec(x_listheader_rec => l_list_rec);

822: --
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: -- Update the list header with the Schedule details.
826: AMS_LISTHEADER_PVT.Init_ListHeader_rec(x_listheader_rec => l_list_rec);
827: l_list_rec.list_header_id := p_list_header_id ;
828:
829: OPEN c_list_details ;
830: FETCH c_list_details INTO l_list_rec.object_version_number ;

Line 835: AMS_LISTHEADER_PVT.Update_ListHeader

831: CLOSE c_list_details ;
832: l_list_rec.arc_list_used_by := 'CSCH' ; -- Campaign Schedule
833: l_list_rec.list_used_by_id := p_schedule_id ; -- Campaign Schedule
834:
835: AMS_LISTHEADER_PVT.Update_ListHeader
836: ( p_api_version => p_api_version,
837: p_init_msg_list => FND_API.G_FALSE,
838: p_commit => FND_API.G_FALSE,
839: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 883: AMS_LISTHEADER_PVT.Init_ListHeader_rec(x_listheader_rec => l_list_rec);

879:
880: --
881: -- Update the list sent out date with sysdate if success
882: --
883: AMS_LISTHEADER_PVT.Init_ListHeader_rec(x_listheader_rec => l_list_rec);
884: l_list_rec.list_header_id := p_list_header_id ;
885:
886: OPEN c_list_details ;
887: FETCH c_list_details INTO l_list_rec.object_version_number ;

Line 891: AMS_LISTHEADER_PVT.Update_ListHeader

887: FETCH c_list_details INTO l_list_rec.object_version_number ;
888: CLOSE c_list_details ;
889: l_list_rec.sent_out_date := sysdate ;
890:
891: AMS_LISTHEADER_PVT.Update_ListHeader
892: ( p_api_version => p_api_version,
893: p_init_msg_list => FND_API.G_FALSE,
894: p_commit => FND_API.G_FALSE,
895: p_validation_level => FND_API.G_VALID_LEVEL_FULL,