DBA Data[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_TENANCIES_PKG

Line 3837: -- calling pn_tenancies_pkg.update_auto_space_assign.

3833: -- If these is associated area class with tenancy space assignment, Only that
3834: -- tenancy will not be early terminated and message will be logged.
3835: -- 04-DEC-2003 Satish Tripathi o Created for BUG# 3284799.
3836: -- 05-DEC-2003 Satish Tripathi o Pass p_cust_assign_end_dt as p_new_lea_term_dt when
3837: -- calling pn_tenancies_pkg.update_auto_space_assign.
3838: -- Update fin_oblig_end_date of pn_tenancies to p_new_lea_term_dt.
3839: --------------------------------------------------------------------------------------------
3840: PROCEDURE contract_tenancies(
3841: p_lease_id NUMBER

Line 3912: pn_tenancies_pkg.delete_row(

3908: pnp_debug_pkg.put_log_msg(fnd_message.get);
3909: pnp_debug_pkg.put_log_msg('********************************************************************************');
3910: ELSE
3911:
3912: pn_tenancies_pkg.delete_row(
3913: x_tenancy_id => get_delete_tenancies.tenancy_id
3914: );
3915:
3916: pn_tenancies_pkg.delete_auto_space_assign(

Line 3916: pn_tenancies_pkg.delete_auto_space_assign(

3912: pn_tenancies_pkg.delete_row(
3913: x_tenancy_id => get_delete_tenancies.tenancy_id
3914: );
3915:
3916: pn_tenancies_pkg.delete_auto_space_assign(
3917: p_tenancy_id => get_delete_tenancies.tenancy_id
3918: ,p_action => l_action
3919: ,p_location_id => get_delete_tenancies.location_id
3920: ,p_loc_type_code => l_loc_type_code

Line 3955: pn_tenancies_pkg.update_auto_space_assign

3951: l_tenancy_end_date := get_update_tenancies.expiration_date;
3952:
3953: pnp_debug_pkg.log('CON_TEN=>UPD : Early Terminating Tenancy_Id: '||l_tenancy_Id);
3954:
3955: pn_tenancies_pkg.update_auto_space_assign
3956: (
3957: p_location_id => get_update_tenancies.location_id
3958: ,p_lease_id => p_lease_id
3959: ,p_customer_id => get_update_tenancies.customer_id