DBA Data[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_TENANCIES_PKG

Line 3072: -- calling pn_tenancies_pkg.update_auto_space_assign.

3068: -- If these is associated area class with tenancy space assignment, Only that
3069: -- tenancy will not be early terminated and message will be logged.
3070: -- 04-DEC-2003 Satish Tripathi o Created for BUG# 3284799.
3071: -- 05-DEC-2003 Satish Tripathi o Pass p_cust_assign_end_dt as p_new_lea_term_dt when
3072: -- calling pn_tenancies_pkg.update_auto_space_assign.
3073: -- Update fin_oblig_end_date of pn_tenancies to p_new_lea_term_dt.
3074: --------------------------------------------------------------------------------------------
3075: PROCEDURE contract_tenancies(
3076: p_lease_id NUMBER

Line 3147: pn_tenancies_pkg.delete_row(

3143: pnp_debug_pkg.put_log_msg(fnd_message.get);
3144: pnp_debug_pkg.put_log_msg('********************************************************************************');
3145: ELSE
3146:
3147: pn_tenancies_pkg.delete_row(
3148: x_tenancy_id => get_delete_tenancies.tenancy_id
3149: );
3150:
3151: pn_tenancies_pkg.delete_auto_space_assign(

Line 3151: pn_tenancies_pkg.delete_auto_space_assign(

3147: pn_tenancies_pkg.delete_row(
3148: x_tenancy_id => get_delete_tenancies.tenancy_id
3149: );
3150:
3151: pn_tenancies_pkg.delete_auto_space_assign(
3152: p_tenancy_id => get_delete_tenancies.tenancy_id
3153: ,p_action => l_action
3154: ,p_location_id => get_delete_tenancies.location_id
3155: ,p_loc_type_code => l_loc_type_code

Line 3190: pn_tenancies_pkg.update_auto_space_assign

3186: l_tenancy_end_date := get_update_tenancies.expiration_date;
3187:
3188: pnp_debug_pkg.log('CON_TEN=>UPD : Early Terminating Tenancy_Id: '||l_tenancy_Id);
3189:
3190: pn_tenancies_pkg.update_auto_space_assign
3191: (
3192: p_location_id => get_update_tenancies.location_id
3193: ,p_lease_id => p_lease_id
3194: ,p_customer_id => get_update_tenancies.customer_id