eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 207: FROM ams_campaign_schedules_b

203:
204:
205: CURSOR c_sched_details IS
206: SELECT activity_id,activity_type_code
207: FROM ams_campaign_schedules_b
208: WHERE schedule_id = p_scheduleid;
209:
210: CURSOR C_Content_CL( l_obj_id IN NUMBER) IS
211: SELECT ibcassn.content_item_id,citm.name

Line 674: FROM ams_campaign_schedules_b

670: AND active_flag = 'Y';
671:
672: CURSOR c_schedule IS
673: SELECT campaign_id, source_code, use_parent_code_flag
674: FROM ams_campaign_schedules_b
675: WHERE schedule_id = p_schedule_rec.schedule_id;
676:
677: CURSOR c_list_header IS
678: SELECT 1

Line 834: FROM ams_campaign_schedules_b

830: AND active_flag = 'Y';
831:
832: CURSOR c_schedule IS
833: SELECT campaign_id, source_code, use_parent_code_flag
834: FROM ams_campaign_schedules_b
835: WHERE schedule_id = p_schedule_rec.schedule_id;
836:
837: CURSOR c_list_header IS
838: SELECT 1

Line 1719: FROM ams_campaign_schedules_b

1715: x_msg_data OUT NOCOPY VARCHAR2 )
1716: IS
1717: CURSOR c_completed_schedule IS
1718: SELECT schedule_id, object_version_number
1719: FROM ams_campaign_schedules_b
1720: WHERE status_code = 'ACTIVE'
1721: AND end_date_time <= SYSDATE ;
1722:
1723: CURSOR c_status(l_status_code VARCHAR2) IS

Line 1791: UPDATE ams_campaign_schedules_b

1787: FETCH c_completed_schedule INTO l_schedule_id, l_obj_version ;
1788: EXIT WHEN c_completed_schedule%NOTFOUND ;
1789:
1790: -- Update the status of the schedule to Active.
1791: UPDATE ams_campaign_schedules_b
1792: SET status_code = 'COMPLETED',
1793: status_date = SYSDATE ,
1794: user_status_id = l_status_id,
1795: object_version_number = l_obj_version + 1

Line 1970: FROM ams_campaign_schedules_b

1966: SELECT user_status_id, object_version_number,
1967: start_date_time, timezone_id,activity_type_code,
1968: activity_id,marketing_medium_id,custom_setup_id,
1969: cover_letter_id, printer_address
1970: FROM ams_campaign_schedules_b
1971: WHERE schedule_id = p_schedule_id;
1972:
1973: CURSOR c_budget_exist IS
1974: SELECT 1

Line 2709: FROM ams_campaign_schedules_b

2705:
2706:
2707: CURSOR c_sch_det IS
2708: SELECT start_date_time, end_date_time, owner_user_id, source_code
2709: FROM ams_campaign_schedules_b
2710: WHERE schedule_id = p_schedule_id;
2711:
2712: CURSOR c_media_item_id IS
2713: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL

Line 2915: FROM ams_campaign_schedules_b

2911: , NVL(trig_repeat_flag,'N') -- soagrawa 26-sep-2003 for trigger and repeating schedule code change
2912: , orig_csch_id -- soagrawa 26-sep-2003 for trigger and repeating schedule code change
2913: , owner_user_id -- vmodur
2914: , campaign_id -- vmodur
2915: FROM ams_campaign_schedules_b
2916: WHERE schedule_id = p_schedule_id;
2917:
2918: l_source_code VARCHAR2(30);
2919: l_new_status_id NUMBER;

Line 3001: UPDATE ams_campaign_schedules_b

2997: , l_old_status_id, l_old_status_code, l_source_code
2998: , l_triggerable_flag, l_trig_repeat_flag, l_orig_csch_id, l_owner_user_id, l_campaign_id;
2999: CLOSE c_sch_det;
3000:
3001: UPDATE ams_campaign_schedules_b
3002: SET user_status_id = p_new_status_id,
3003: status_code = p_new_status_code, -- AMS_Utility_PVT.get_system_status_code(p_new_status_id),
3004: status_date = SYSDATE,
3005: object_version_number = object_version_number + 1,

Line 3143: UPDATE ams_campaign_schedules_b

3139: p_send_date => l_sys_start_time);
3140: END IF; -- repeating parent instance check
3141: END IF; -- not triggerable
3142:
3143: UPDATE ams_campaign_schedules_b
3144: SET workflow_item_key = l_new_item_key
3145: WHERE schedule_id = p_schedule_id ;
3146:
3147: END IF;

Line 3602: from ams_campaign_schedules_b

3598: l_schedule_id NUMBER;
3599:
3600: CURSOR c_schedule_creator_id (p_schedule_id IN NUMBER) IS
3601: select created_by
3602: from ams_campaign_schedules_b
3603: where schedule_id = p_schedule_id;
3604:
3605: CURSOR c_user_resp_dtl(p_user_id IN NUMBER) IS
3606: SELECT responsibility_id

Line 3754: UPDATE ams_campaign_schedules_b

3750: aname => 'SCHEDULE_STATUS' );
3751:
3752:
3753: -- make sure that last activation date is updated
3754: UPDATE ams_campaign_schedules_b
3755: SET last_activation_date = SYSDATE,
3756: object_version_number = object_version_number + 1,
3757: last_update_date = SYSDATE,
3758: last_updated_by = FND_GLOBAL.user_id

Line 3811: FROM ams_campaign_schedules_b

3807: -- declare cursor as per enh # 3805347
3808: -- dkailash related_event_id added for bug #11830352
3809: CURSOR c_csch_det(p_schedule_id IN NUMBER) IS
3810: SELECT status_code,related_event_id,activity_type_code
3811: FROM ams_campaign_schedules_b
3812: WHERE schedule_id = p_schedule_id;
3813:
3814: l_schedule_id NUMBER;
3815: l_user_status_id NUMBER ;

Line 3848: UPDATE ams_campaign_schedules_b

3844: CLOSE c_csch_det;
3845:
3846: l_user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','ACTIVE') ;
3847:
3848: UPDATE ams_campaign_schedules_b
3849: SET status_code = 'ACTIVE',
3850: user_status_id = l_user_status_id,
3851: status_date = SYSDATE,
3852: last_activation_date = SYSDATE,

Line 4032: FROM ams_campaign_schedules_b

4028:
4029: -- anchaudh added the following cursor on 01-nov-2004 for getting csch owner, bug# 3799053
4030: CURSOR c_csch_det (l_csch_id IN NUMBER) IS
4031: SELECT owner_user_id
4032: FROM ams_campaign_schedules_b
4033: WHERE schedule_id = l_csch_id ;
4034:
4035: l_csch_owner_user_id NUMBER;
4036: l_schedule_id NUMBER;

Line 4489: from ams_campaign_schedules_b a, ams_source_codes b

4485: and nvl(cat.PURCHASE_INTEREST, 'Y') <> 'N';
4486:
4487: cursor c_schedule_details_csr(p_schedule_id NUMBER) is
4488: select a.source_code, a.sales_methodology_id, b.source_code_id
4489: from ams_campaign_schedules_b a, ams_source_codes b
4490: where a.schedule_id = p_schedule_id
4491: and a.status_code = 'ACTIVE'
4492: and a.source_code = b.source_code;
4493:

Line 4498: FROM ams_campaign_schedules_b

4494: CURSOR c_sch_det(p_schedule_id NUMBER) IS -- anchaudh added this new cursor for the leads bug.
4495: SELECT NVL(triggerable_flag,'N')
4496: ,NVL(trig_repeat_flag,'N')
4497: ,orig_csch_id
4498: FROM ams_campaign_schedules_b
4499: WHERE schedule_id = p_schedule_id;
4500:
4501: CURSOR c_sch_det_offer(p_schedule_id NUMBER) IS -- anchaudh added this for bug#4957178.
4502: select offer_id

Line 5057: ams_campaign_Schedules_b parentCSCH

5053: parentCSCH.status_code
5054: FROM ams_campaign_schedules_vl csch,
5055: ams_scheduler scheduler,
5056: ams_campaigns_all_b camp,
5057: ams_campaign_Schedules_b parentCSCH
5058: WHERE csch.schedule_id = p_schedule_id
5059: AND scheduler.OBJECT_ID = nvl(csch.orig_csch_id, csch.schedule_id)
5060: AND scheduler.OBJECT_TYPE = 'CSCH'
5061: AND camp.campaign_id = csch.campaign_id

Line 5132: UPDATE ams_campaign_schedules_b

5128: itemkey => itemkey,
5129: aname => 'AMS_SCHEDULE_ID',
5130: avalue => l_schedule_id);
5131:
5132: UPDATE ams_campaign_schedules_b
5133: SET REPEAT_WORKFLOW_ITEM_KEY = itemkey
5134: WHERE schedule_id = l_schedule_id;
5135:
5136: WRITE_LOG (l_api_name, 'Wf_Repeat_Init_var: Schedule id is '||l_schedule_id);

Line 5470: FROM ams_campaign_schedules_b

5466:
5467:
5468: SELECT nvl(orig_csch_id, schedule_id)
5469: INTO l_orig_csch_id
5470: FROM ams_campaign_schedules_b
5471: WHERE schedule_id = l_schedule_id;
5472:
5473: IF l_new_last_run_date IS NULL then
5474:

Line 5657: -- FROM ams_campaign_schedules_b

5653: l_child_sched_id NUMBER;
5654:
5655: -- CURSOR c_sch_det (p_schedule_id NUMBER) IS
5656: -- SELECT start_date_time, timezone_id
5657: -- FROM ams_campaign_schedules_b
5658: -- WHERE schedule_id = p_schedule_id;
5659:
5660: BEGIN
5661: l_api_name := 'WF_REPEAT_CREATE_CSCH';

Line 5933: FROM ams_campaign_schedules_b

5929:
5930: CURSOR c_csch_det IS
5931: SELECT related_event_from
5932: , related_event_id
5933: FROM ams_campaign_schedules_b
5934: WHERE schedule_id = p_obj_id;
5935:
5936:
5937: l_api_version CONSTANT NUMBER := 1.0 ;

Line 6141: FROM ams_campaign_schedules_b csch,

6137: frequency,
6138: frequency_type,
6139: end_date_time,
6140: campaign_id
6141: FROM ams_campaign_schedules_b csch,
6142: ams_scheduler scheduler,
6143: AMS_MEDIA_VL Med,
6144: ams_lookups lookup
6145: WHERE csch.schedule_id = p_schedule_id