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_CAMPAIGNRULES_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 315: FROM ams_campaigns_all_b

311:
312: CURSOR c_old_info IS
313: SELECT global_flag, source_code, custom_setup_id, status_code, rollup_type,
314: related_event_id
315: FROM ams_campaigns_all_b
316: WHERE campaign_id = p_campaign_id;
317:
318: CURSOR c_csch_exist IS
319: SELECT 1

Line 401: 'ams_campaigns_all_b',

397: RETURN;
398: ELSE
399: --aranka added 07/27/02
400: IF AMS_Utility_PVT.check_uniqueness(
401: 'ams_campaigns_all_b',
402: 'source_code = ''' || p_source_code || ''''
403: || ' AND campaign_id <> '||p_campaign_id
404: -- || ''' AND rollup_type = ''RCAM'' AND campaign_id <> '||p_campaign_id
405: ) = FND_API.g_false

Line 437: -- 'ams_campaigns_all_b',

433: -- x_return_status := FND_API.g_ret_sts_error;
434: -- RETURN;
435: -- END IF;
436: -- IF AMS_Utility_PVT.check_uniqueness(
437: -- 'ams_campaigns_all_b',
438: -- 'source_code = ''' || p_source_code || ''''
439: -- || ' AND campaign_id <> '||p_campaign_id
440: -- ) = FND_API.g_false
441: -- THEN

Line 502: 'ams_campaigns_all_b',

498:
499: -- this code added here by soagrawa on 16-aug-2002 for bug# 2511783
500: IF x_source_code IS NOT NULL THEN
501: IF AMS_Utility_PVT.check_uniqueness(
502: 'ams_campaigns_all_b',
503: 'source_code = ''' || x_source_code || ''''
504: || ' AND campaign_id <> '||p_campaign_id
505: ) = FND_API.g_false
506: THEN

Line 1339: FROM ams_campaigns_all_b

1335:
1336: /* Cursor to get the user status id of program */
1337: CURSOR c_PROGRAM_status IS
1338: SELECT user_status_id
1339: FROM ams_campaigns_all_b
1340: WHERE campaign_id = p_parent_id;
1341:
1342: BEGIN
1343: IF p_parent_id IS NOT NULL then

Line 1651: FROM ams_campaigns_all_b

1647: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1648:
1649: CURSOR c_parent_camp IS
1650: SELECT business_unit_id
1651: FROM ams_campaigns_all_b
1652: WHERE campaign_id = p_program_id;
1653:
1654: l_business_unit_id NUMBER ;
1655: BEGIN

Line 2372: UPDATE ams_campaigns_all_b

2368:
2369: -- soagrawa 29-jan-2003 bug# 2764007
2370: IF l_rollup_type <> 'RCAM'
2371: THEN
2372: UPDATE ams_campaigns_all_b
2373: SET show_campaign_flag = 'N'
2374: WHERE campaign_id IN(
2375: SELECT A.campaign_id
2376: FROM ams_campaigns_vl A, ams_campaigns_vl B

Line 2427: FROM ams_campaigns_all_b

2423:
2424: CURSOR c_old_status IS
2425: SELECT user_status_id, object_version_number,DECODE(rollup_type,'RCAM','RCAM','CAMP') rollup_type,
2426: status_code,custom_setup_id
2427: FROM ams_campaigns_all_b
2428: WHERE campaign_id = p_campaign_id;
2429:
2430: CURSOR c_budget_exist IS
2431: SELECT 1

Line 2441: FROM ams_campaigns_all_b

2437: AND act_budget_used_by_id = p_campaign_id);
2438:
2439: CURSOR c_parent IS
2440: SELECT status_code
2441: FROM ams_campaigns_all_b
2442: WHERE campaign_id = p_parent_id ;
2443: l_status_code VARCHAR2(30);
2444:
2445: CURSOR c_child IS

Line 2447: FROM ams_campaigns_all_b

2443: l_status_code VARCHAR2(30);
2444:
2445: CURSOR c_child IS
2446: SELECT 1
2447: FROM ams_campaigns_all_b
2448: WHERE parent_campaign_id = p_campaign_id
2449: AND status_code = 'ACTIVE' ;
2450: l_act_child_exist NUMBER;
2451:

Line 2778: UPDATE ams_campaigns_all_b

2774:
2775:
2776: /* Following code is commented by ptendulk on 08-Oct-2001
2777: Use the common update api to update the campaign
2778: UPDATE ams_campaigns_all_b
2779: SET user_status_id = l_new_status_id,
2780: status_code = AMS_Utility_PVT.get_system_status_code(l_new_status_id),
2781: status_date = SYSDATE
2782: WHERE campaign_id = p_campaign_id;

Line 2789: UPDATE ams_campaigns_all_b

2785: l_new_status_id = p_user_status_id
2786: THEN
2787: -- Following code is added by ptendulk on 24-Sep-2001
2788: -- Make the campaign Non confidential when it goes live.
2789: UPDATE ams_campaigns_all_b
2790: SET private_flag = 'N'
2791: WHERE campaign_id = p_campaign_id ;
2792:
2793: Activate_Campaign(p_campaign_id => p_campaign_id );

Line 3091: FROM ams_campaigns_all_b

3087: p_owner_id IN NUMBER )
3088: IS
3089: CURSOR c_owner IS
3090: SELECT owner_user_id
3091: FROM ams_campaigns_all_b
3092: WHERE campaign_id = p_campaign_id ;
3093:
3094: CURSOR c_schedules IS
3095: SELECT *

Line 3484: FROM ams_campaigns_all_b

3480: ) IS
3481:
3482: CURSOR c_campaign IS
3483: SELECT campaign_id , object_version_number,rollup_type
3484: FROM ams_campaigns_all_b
3485: WHERE parent_campaign_id = p_program_id
3486: AND (status_code = 'COMPLETED' OR status_code = 'CANCELLED') ;
3487:
3488: l_campaign_id NUMBER ;

Line 3503: UPDATE ams_campaigns_all_b

3499: EXIT WHEN c_campaign%NOTFOUND ;
3500:
3501: IF l_rollup_type = 'RCAM' THEN
3502: Archive_Campaigns(l_campaign_id) ;
3503: UPDATE ams_campaigns_all_b
3504: SET status_code = 'ARCHIVED',
3505: user_status_id = l_program_status_id ,
3506: status_date = SYSDATE ,
3507: object_version_number = l_obj_version + 1

Line 3513: UPDATE ams_campaigns_all_b

3509: AND object_version_number = l_obj_version ;
3510: ELSE
3511: Archive_Schedules(l_campaign_id) ;
3512:
3513: UPDATE ams_campaigns_all_b
3514: SET status_code = 'ARCHIVED',
3515: user_status_id = l_campaign_status_id ,
3516: status_date = SYSDATE ,
3517: object_version_number = l_obj_version + 1

Line 3550: FROM ams_campaigns_all_b

3546: ) IS
3547:
3548: CURSOR c_campaign IS
3549: SELECT campaign_id , object_version_number,rollup_type
3550: FROM ams_campaigns_all_b
3551: WHERE parent_campaign_id = p_program_id
3552: AND status_code = DECODE(rollup_type,'RCAM','NEW','AVAILABLE') ;
3553:
3554: l_campaign_id NUMBER ;

Line 3569: UPDATE ams_campaigns_all_b

3565: EXIT WHEN c_campaign%NOTFOUND ;
3566:
3567: IF l_rollup_type = 'RCAM' THEN
3568: Activate_Campaigns(l_campaign_id) ;
3569: UPDATE ams_campaigns_all_b
3570: SET status_code = 'ACTIVE',
3571: user_status_id = l_program_status_id ,
3572: status_date = SYSDATE ,
3573: object_version_number = l_obj_version + 1

Line 3577: UPDATE ams_campaigns_all_b

3573: object_version_number = l_obj_version + 1
3574: WHERE campaign_id = l_campaign_id
3575: AND object_version_number = l_obj_version ;
3576: ELSE
3577: UPDATE ams_campaigns_all_b
3578: SET status_code = 'ACTIVE',
3579: user_status_id = l_campaign_status_id ,
3580: status_date = SYSDATE ,
3581: object_version_number = l_obj_version + 1

Line 3617: FROM ams_campaigns_all_b

3613: ) IS
3614:
3615: CURSOR c_campaign IS
3616: SELECT campaign_id, object_version_number, rollup_type
3617: FROM ams_campaigns_all_b
3618: WHERE parent_campaign_id = p_program_id
3619: AND status_code = DECODE(p_system_status_code,'ACTIVE','ON_HOLD','ACTIVE') ;
3620:
3621: l_campaign_id NUMBER ;

Line 3636: UPDATE ams_campaigns_all_b

3632: EXIT WHEN c_campaign%NOTFOUND ;
3633:
3634: IF l_rollup_type = 'RCAM' THEN
3635: Hold_Campaigns(l_campaign_id,p_system_status_code) ;
3636: UPDATE ams_campaigns_all_b
3637: SET status_code = p_system_status_code,
3638: user_status_id = l_program_status_id ,
3639: status_date = SYSDATE ,
3640: object_version_number = l_obj_version + 1

Line 3644: UPDATE ams_campaigns_all_b

3640: object_version_number = l_obj_version + 1
3641: WHERE campaign_id = l_campaign_id
3642: AND object_version_number = l_obj_version ;
3643: ELSE
3644: UPDATE ams_campaigns_all_b
3645: SET status_code = p_system_status_code,
3646: user_status_id = l_campaign_status_id ,
3647: status_date = SYSDATE ,
3648: object_version_number = l_obj_version + 1

Line 3766: UPDATE ams_campaigns_all_b

3762: RAISE FND_API.g_exc_error;
3763: /*
3764: ELSE
3765: -- ok cancel
3766: UPDATE ams_campaigns_all_b
3767: SET status_code = 'CANCELLED',
3768: user_status_id = l_program_status_id ,
3769: status_date = SYSDATE ,
3770: -- object_version_number = l_obj_version + 1

Line 3809: FROM ams_campaigns_all_b

3805: ) IS
3806:
3807: CURSOR c_campaign IS
3808: SELECT campaign_id, object_version_number, rollup_type, status_code
3809: FROM ams_campaigns_all_b
3810: WHERE parent_campaign_id = p_program_id
3811: AND status_code <> 'CANCELLED' ;
3812:
3813: l_campaign_id NUMBER ;

Line 3830: UPDATE ams_campaigns_all_b

3826:
3827: IF l_rollup_type = 'RCAM' THEN
3828: Cancel_Program(l_campaign_id) ;
3829: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_PROGRAM_STATUS',l_status_code,'CANCELLED') THEN
3830: UPDATE ams_campaigns_all_b
3831: SET status_code = 'CANCELLED',
3832: user_status_id = l_program_status_id ,
3833: status_date = SYSDATE ,
3834: object_version_number = l_obj_version + 1

Line 3850: UPDATE ams_campaigns_all_b

3846: END IF ;
3847: ELSE
3848: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_CAMPAIGN_STATUS',l_status_code,'CANCELLED') THEN
3849: Cancel_schedule(l_campaign_id);
3850: UPDATE ams_campaigns_all_b
3851: SET status_code = 'CANCELLED',
3852: user_status_id = l_campaign_status_id ,
3853: status_date = SYSDATE ,
3854: object_version_number = l_obj_version + 1

Line 3884: FROM ams_campaigns_all_b

3880:
3881: -- cursor sees if for given program there are any components that are not cancelled / archived
3882: CURSOR c_campaign IS
3883: SELECT count(*)
3884: FROM ams_campaigns_all_b
3885: WHERE parent_campaign_id = p_program_id
3886: AND status_code <> 'CANCELLED'
3887: AND status_code <> 'ARCHIVED';
3888:

Line 3920: UPDATE ams_campaigns_all_b

3916: RAISE FND_API.g_exc_error;
3917: /*
3918: ELSE
3919: -- ok cancel
3920: UPDATE ams_campaigns_all_b
3921: SET status_code = 'CANCELLED',
3922: user_status_id = l_program_status_id ,
3923: status_date = SYSDATE ,
3924: -- object_version_number = l_obj_version + 1

Line 4085: FROM ams_campaigns_all_b

4081: ) IS
4082:
4083: CURSOR c_campaign IS
4084: SELECT campaign_id, object_version_number, rollup_type, status_code
4085: FROM ams_campaigns_all_b
4086: WHERE parent_campaign_id = p_program_id
4087: AND status_code <> 'COMPLETED' ;
4088:
4089: l_campaign_id NUMBER ;

Line 4108: UPDATE ams_campaigns_all_b

4104: -- soagrawa 15-may-2003 modified for bug# 2962702
4105: -- Cancel_Program(l_campaign_id) ;
4106: Complete_Program(l_campaign_id) ;
4107: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_PROGRAM_STATUS',l_status_code,'COMPLETED') THEN
4108: UPDATE ams_campaigns_all_b
4109: SET status_code = 'COMPLETED',
4110: user_status_id = l_program_status_id ,
4111: status_date = SYSDATE ,
4112: object_version_number = l_obj_version + 1

Line 4131: UPDATE ams_campaigns_all_b

4127: -- soagrawa 15-may-2003 modified for bug# 2962702
4128: -- Cancel_schedule(l_campaign_id) ;
4129: Complete_Schedule(l_campaign_id) ;
4130:
4131: UPDATE ams_campaigns_all_b
4132: SET status_code = 'COMPLETED',
4133: user_status_id = l_campaign_status_id ,
4134: status_date = SYSDATE ,
4135: object_version_number = l_obj_version + 1

Line 4239: FROM ams_campaigns_all_b

4235: p_parent_id IN NUMBER )
4236: IS
4237: CURSOR c_parent IS
4238: SELECT parent_campaign_id, DECODE(rollup_type,'RCAM','RCAM','CAMP')
4239: FROM ams_campaigns_all_b
4240: WHERE campaign_id = p_campaign_id ;
4241: l_old_parent NUMBER ;
4242: l_rollup_type VARCHAR2(30) ;
4243:

Line 4309: UPDATE ams_campaigns_all_b

4305: )
4306: IS
4307:
4308: BEGIN
4309: UPDATE ams_campaigns_all_b
4310: SET user_status_id = p_new_status_id,
4311: status_code = p_new_status_code, -- AMS_Utility_PVT.get_system_status_code(p_new_status_id),
4312: status_date = SYSDATE
4313: -- private_flag = DECODE(p_new_status_code,'ACTIVE','N',private_flag)

Line 4343: FROM ams_Campaigns_all_B

4339: )
4340: IS
4341: CURSOR c_child_tree IS
4342: SELECT campaign_id
4343: FROM ams_Campaigns_all_B
4344: WHERE active_flag = 'Y'
4345: START WITH campaign_id = p_campaign_id
4346: CONNECT BY PRIOR campaign_id = parent_campaign_id ;
4347: l_camp_id NUMBER ;