[Home] [Help]
925: -- is true, return_status should be W (warn) else
926: -- return_status is E (error) in Overlap exception
927: -- for Multi-Tenancy-Lease changes.
928: -- 30 OCT-02 graghuna o added group by to location code select.
929: -- 08-JUL-03 AKumar o Replaced calls to fnd_profile.get_value with
930: -- pn_mo_cache_utils.get_profile_value
931: -- 28-nov-05 pikhar o passed org_id in pn_mo_cache_utils.get_profile_value
932: -------------------------------------------------------------------------------
933: PROCEDURE CHECK_FOR_OVELAP_OF_TENANCY
1701: x_attribute13 => NULL,
1702: x_attribute14 => NULL,
1703: x_attribute15 => NULL,
1704: x_creation_date => SYSDATE,
1705: x_created_by => NVL(fnd_profile.value('USER_ID'),-1),
1706: x_last_update_date => SYSDATE,
1707: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),-1),
1708: x_last_update_login => NVL(fnd_profile.value('USER_ID'),-1),
1709: x_org_id => p_org_id,
1703: x_attribute15 => NULL,
1704: x_creation_date => SYSDATE,
1705: x_created_by => NVL(fnd_profile.value('USER_ID'),-1),
1706: x_last_update_date => SYSDATE,
1707: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),-1),
1708: x_last_update_login => NVL(fnd_profile.value('USER_ID'),-1),
1709: x_org_id => p_org_id,
1710: x_lease_id => p_lease_id,
1711: x_recovery_space_std_code => p_recovery_space_std_code,
1704: x_creation_date => SYSDATE,
1705: x_created_by => NVL(fnd_profile.value('USER_ID'),-1),
1706: x_last_update_date => SYSDATE,
1707: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),-1),
1708: x_last_update_login => NVL(fnd_profile.value('USER_ID'),-1),
1709: x_org_id => p_org_id,
1710: x_lease_id => p_lease_id,
1711: x_recovery_space_std_code => p_recovery_space_std_code,
1712: x_recovery_type_code => p_recovery_type_code,
2505:
2506: UPDATE pn_space_assign_cust_all
2507: SET cust_assign_start_date = p_cust_assign_start_dt
2508: ,last_update_date = SYSDATE
2509: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2510: WHERE tenancy_id = p_tenancy_id
2511: AND cust_assign_start_date < p_cust_assign_start_dt
2512: AND cust_assign_end_date >= p_cust_assign_start_dt;
2513: l_count := 0;
2555: UPDATE pn_space_assign_cust_all
2556: SET cust_assign_end_date = p_cust_assign_end_dt
2557: ,fin_oblig_end_date = p_fin_oblig_end_date
2558: ,last_update_date = SYSDATE
2559: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2560: WHERE tenancy_id = p_tenancy_id
2561: AND cust_assign_start_date <= p_cust_assign_end_dt
2562: AND cust_assign_end_date > p_cust_assign_end_dt;
2563: l_count := 0;
2825: IF p_fin_oblig_end_date_old IS NOT NULL THEN
2826: UPDATE pn_space_assign_cust_all
2827: SET fin_oblig_end_date = p_fin_oblig_end_date
2828: ,last_update_date = SYSDATE
2829: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2830: WHERE tenancy_id = p_tenancy_id
2831: AND fin_oblig_end_date = p_fin_oblig_end_date_old;
2832: ELSE
2833: UPDATE pn_space_assign_cust_all
2832: ELSE
2833: UPDATE pn_space_assign_cust_all
2834: SET fin_oblig_end_date = p_fin_oblig_end_date
2835: ,last_update_date = SYSDATE
2836: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2837: WHERE tenancy_id = p_tenancy_id
2838: AND cust_assign_end_date = p_cust_assign_end_dt;
2839: END IF;
2840:
2880: ,site_use_id = p_cust_site_use_id
2881: ,recovery_space_std_code = p_recovery_space_std_code
2882: ,recovery_type_code = p_recovery_type_code
2883: ,last_update_date = SYSDATE
2884: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
2885: WHERE tenancy_id = p_tenancy_id;
2886:
2887: END IF;
2888:
3030: ,recovery_space_std_code = p_recovery_space_std_code
3031: ,recovery_type_code = p_recovery_type_code
3032: ,fin_oblig_end_date = NVL(cust_assign_end_date, pnt_locations_pkg.g_end_of_time)
3033: ,last_update_date = SYSDATE
3034: ,last_updated_by = NVL(FND_PROFILE.VALUE('USER_ID'),-1)
3035: WHERE cust_space_assign_id = l_cust_space_assign_id;
3036:
3037:
3038: pn_tenancies_pkg.update_auto_space_assign