DBA Data[Home] [Help]

APPS.AMS_UTILITY_PVT dependencies on AMS_CAMPAIGN_SCHEDULES

Line 664: --x_table_name := 'AMS_CAMPAIGN_SCHEDULES';

660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: IF (p_sys_qual ='CSCH') THEN
663: -- Start of code modified by ptendulk on 30-Jan-2001
664: --x_table_name := 'AMS_CAMPAIGN_SCHEDULES';
665: --x_pk_name := 'CAMPAIGN_SCHEDULE_ID';
666: -- End of code modified by ptendulk on 30-Jan-2001
667: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
668: x_pk_name := 'SCHEDULE_ID';

Line 667: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';

663: -- Start of code modified by ptendulk on 30-Jan-2001
664: --x_table_name := 'AMS_CAMPAIGN_SCHEDULES';
665: --x_pk_name := 'CAMPAIGN_SCHEDULE_ID';
666: -- End of code modified by ptendulk on 30-Jan-2001
667: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
668: x_pk_name := 'SCHEDULE_ID';
669: ELSIF (p_sys_qual ='CAMP') THEN
670: -- Start of code modified by ptendulk on 30-Jan-2001
671: --x_table_name := 'AMS_CAMPAIGNS_VL';

Line 824: ams_campaign_schedules s

820: --added 11/16/99 tdonohoe
821: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS
822: SELECT c.campaign_name
823: FROM ams_campaigns_vl c,
824: ams_campaign_schedules s
825: WHERE s.campaign_schedule_id = p_object_id
826: AND s.campaign_id = c.campaign_id;
827:
828: CURSOR c_deliv(p_object_id IN NUMBER) IS

Line 2657: FROM ams_campaign_schedules_vl

2653:
2654: CURSOR Cur_Csch(p_csch_id IN NUMBER)
2655: IS
2656: SELECT schedule_name
2657: FROM ams_campaign_schedules_vl
2658: WHERE schedule_id = p_csch_id;
2659:
2660: l_api_name CONSTANT VARCHAR2(30) := 'GET_OBJECT_NAME';
2661: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_UTILITY_PVT';