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 2697: FROM ams_campaign_schedules_b

2693:
2694:
2695: CURSOR c_sch_det IS
2696: SELECT start_date_time, end_date_time, owner_user_id, source_code
2697: FROM ams_campaign_schedules_b
2698: WHERE schedule_id = p_schedule_id;
2699:
2700: CURSOR c_media_item_id IS
2701: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL

Line 2903: FROM ams_campaign_schedules_b

2899: , NVL(trig_repeat_flag,'N') -- soagrawa 26-sep-2003 for trigger and repeating schedule code change
2900: , orig_csch_id -- soagrawa 26-sep-2003 for trigger and repeating schedule code change
2901: , owner_user_id -- vmodur
2902: , campaign_id -- vmodur
2903: FROM ams_campaign_schedules_b
2904: WHERE schedule_id = p_schedule_id;
2905:
2906: l_source_code VARCHAR2(30);
2907: l_new_status_id NUMBER;

Line 2989: UPDATE ams_campaign_schedules_b

2985: , l_old_status_id, l_old_status_code, l_source_code
2986: , l_triggerable_flag, l_trig_repeat_flag, l_orig_csch_id, l_owner_user_id, l_campaign_id;
2987: CLOSE c_sch_det;
2988:
2989: UPDATE ams_campaign_schedules_b
2990: SET user_status_id = p_new_status_id,
2991: status_code = p_new_status_code, -- AMS_Utility_PVT.get_system_status_code(p_new_status_id),
2992: status_date = SYSDATE,
2993: object_version_number = object_version_number + 1,

Line 3131: UPDATE ams_campaign_schedules_b

3127: p_send_date => l_sys_start_time);
3128: END IF; -- repeating parent instance check
3129: END IF; -- not triggerable
3130:
3131: UPDATE ams_campaign_schedules_b
3132: SET workflow_item_key = l_new_item_key
3133: WHERE schedule_id = p_schedule_id ;
3134:
3135: END IF;

Line 3590: from ams_campaign_schedules_b

3586: l_schedule_id NUMBER;
3587:
3588: CURSOR c_schedule_creator_id (p_schedule_id IN NUMBER) IS
3589: select created_by
3590: from ams_campaign_schedules_b
3591: where schedule_id = p_schedule_id;
3592:
3593: CURSOR c_user_resp_dtl(p_user_id IN NUMBER) IS
3594: SELECT responsibility_id

Line 3742: UPDATE ams_campaign_schedules_b

3738: aname => 'SCHEDULE_STATUS' );
3739:
3740:
3741: -- make sure that last activation date is updated
3742: UPDATE ams_campaign_schedules_b
3743: SET last_activation_date = SYSDATE,
3744: object_version_number = object_version_number + 1,
3745: last_update_date = SYSDATE,
3746: last_updated_by = FND_GLOBAL.user_id

Line 3798: FROM ams_campaign_schedules_b

3794:
3795: -- declare cursor as per enh # 3805347
3796: CURSOR c_csch_det(p_schedule_id IN NUMBER) IS
3797: SELECT status_code
3798: FROM ams_campaign_schedules_b
3799: WHERE schedule_id = p_schedule_id;
3800:
3801: l_schedule_id NUMBER;
3802: l_user_status_id NUMBER ;

Line 3832: UPDATE ams_campaign_schedules_b

3828: CLOSE c_csch_det;
3829:
3830: l_user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_CAMPAIGN_SCHEDULE_STATUS','ACTIVE') ;
3831:
3832: UPDATE ams_campaign_schedules_b
3833: SET status_code = 'ACTIVE',
3834: user_status_id = l_user_status_id,
3835: status_date = SYSDATE,
3836: last_activation_date = SYSDATE,

Line 4002: FROM ams_campaign_schedules_b

3998:
3999: -- anchaudh added the following cursor on 01-nov-2004 for getting csch owner, bug# 3799053
4000: CURSOR c_csch_det (l_csch_id IN NUMBER) IS
4001: SELECT owner_user_id
4002: FROM ams_campaign_schedules_b
4003: WHERE schedule_id = l_csch_id ;
4004:
4005: l_csch_owner_user_id NUMBER;
4006: l_schedule_id NUMBER;

Line 4459: from ams_campaign_schedules_b a, ams_source_codes b

4455: and nvl(cat.PURCHASE_INTEREST, 'Y') <> 'N';
4456:
4457: cursor c_schedule_details_csr(p_schedule_id NUMBER) is
4458: select a.source_code, a.sales_methodology_id, b.source_code_id
4459: from ams_campaign_schedules_b a, ams_source_codes b
4460: where a.schedule_id = p_schedule_id
4461: and a.status_code = 'ACTIVE'
4462: and a.source_code = b.source_code;
4463:

Line 4468: FROM ams_campaign_schedules_b

4464: CURSOR c_sch_det(p_schedule_id NUMBER) IS -- anchaudh added this new cursor for the leads bug.
4465: SELECT NVL(triggerable_flag,'N')
4466: ,NVL(trig_repeat_flag,'N')
4467: ,orig_csch_id
4468: FROM ams_campaign_schedules_b
4469: WHERE schedule_id = p_schedule_id;
4470:
4471: CURSOR c_sch_det_offer(p_schedule_id NUMBER) IS -- anchaudh added this for bug#4957178.
4472: select offer_id

Line 5027: ams_campaign_Schedules_b parentCSCH

5023: parentCSCH.status_code
5024: FROM ams_campaign_schedules_vl csch,
5025: ams_scheduler scheduler,
5026: ams_campaigns_all_b camp,
5027: ams_campaign_Schedules_b parentCSCH
5028: WHERE csch.schedule_id = p_schedule_id
5029: AND scheduler.OBJECT_ID = nvl(csch.orig_csch_id, csch.schedule_id)
5030: AND scheduler.OBJECT_TYPE = 'CSCH'
5031: AND camp.campaign_id = csch.campaign_id

Line 5102: UPDATE ams_campaign_schedules_b

5098: itemkey => itemkey,
5099: aname => 'AMS_SCHEDULE_ID',
5100: avalue => l_schedule_id);
5101:
5102: UPDATE ams_campaign_schedules_b
5103: SET REPEAT_WORKFLOW_ITEM_KEY = itemkey
5104: WHERE schedule_id = l_schedule_id;
5105:
5106: WRITE_LOG (l_api_name, 'Wf_Repeat_Init_var: Schedule id is '||l_schedule_id);

Line 5440: FROM ams_campaign_schedules_b

5436:
5437:
5438: SELECT nvl(orig_csch_id, schedule_id)
5439: INTO l_orig_csch_id
5440: FROM ams_campaign_schedules_b
5441: WHERE schedule_id = l_schedule_id;
5442:
5443: IF l_new_last_run_date IS NULL then
5444:

Line 5627: -- FROM ams_campaign_schedules_b

5623: l_child_sched_id NUMBER;
5624:
5625: -- CURSOR c_sch_det (p_schedule_id NUMBER) IS
5626: -- SELECT start_date_time, timezone_id
5627: -- FROM ams_campaign_schedules_b
5628: -- WHERE schedule_id = p_schedule_id;
5629:
5630: BEGIN
5631: l_api_name := 'WF_REPEAT_CREATE_CSCH';

Line 5903: FROM ams_campaign_schedules_b

5899:
5900: CURSOR c_csch_det IS
5901: SELECT related_event_from
5902: , related_event_id
5903: FROM ams_campaign_schedules_b
5904: WHERE schedule_id = p_obj_id;
5905:
5906:
5907: l_api_version CONSTANT NUMBER := 1.0 ;

Line 6111: FROM ams_campaign_schedules_b csch,

6107: frequency,
6108: frequency_type,
6109: end_date_time,
6110: campaign_id
6111: FROM ams_campaign_schedules_b csch,
6112: ams_scheduler scheduler,
6113: AMS_MEDIA_VL Med,
6114: ams_lookups lookup
6115: WHERE csch.schedule_id = p_schedule_id