[Home] [Help]
54: FROM DUAL;
55:
56: CURSOR c_camp_count(camp_id IN NUMBER) IS
57: SELECT COUNT(*)
58: FROM ams_campaigns_vl
59: WHERE campaign_id = camp_id;
60:
61: /**
62: CURSOR c_parent_business_unit (p_parent_campaign_id IN NUMBER, p_org_id IN NUMBER) IS
2486: l_where_clause VARCHAR2(2000);
2487:
2488: CURSOR c_prog_name
2489: IS SELECT 1 from dual
2490: WHERE EXISTS ( SELECT * from ams_campaigns_vl
2491: WHERE rollup_type = 'RCAM'
2492: AND UPPER(campaign_name) = UPPER(p_complete_rec.campaign_name)) ;
2493: CURSOR c_prog_name_updt
2494: IS SELECT 1 from dual
2491: WHERE rollup_type = 'RCAM'
2492: AND UPPER(campaign_name) = UPPER(p_complete_rec.campaign_name)) ;
2493: CURSOR c_prog_name_updt
2494: IS SELECT 1 from dual
2495: WHERE EXISTS ( SELECT * from ams_campaigns_vl
2496: WHERE rollup_type = 'RCAM'
2497: AND UPPER(campaign_name) = UPPER(p_complete_rec.campaign_name)
2498: AND campaign_id <> p_complete_rec.campaign_id );
2499:
2559: -------------------------Program Name ---------------------------------
2560: IF p_complete_rec.rollup_type = 'RCAM' THEN
2561: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2562: -- IF AMS_Utility_PVT.check_uniqueness(
2563: -- 'ams_campaigns_vl',
2564: -- 'campaign_name = ''' || p_camp_rec.campaign_name ||
2565: -- ''' AND rollup_type = ''RCAM'''
2566: -- ) = FND_API.g_false
2567: -- THEN
2570: -- RETURN;
2571: -- END IF;
2572: --ELSE
2573: -- IF AMS_Utility_PVT.check_uniqueness(
2574: -- 'ams_campaigns_vl',
2575: -- 'campaign_name = ''' || p_camp_rec.campaign_name ||
2576: -- ''' AND rollup_type = ''RCAM'''||
2577: -- ' AND campaign_id <> '||p_camp_rec.campaign_id
2578: -- ) = FND_API.g_false
3055: IS
3056:
3057: CURSOR c_camp IS
3058: SELECT *
3059: FROM ams_campaigns_vl
3060: WHERE campaign_id = p_camp_rec.campaign_id;
3061:
3062: l_camp_rec c_camp%ROWTYPE;
3063: