299: l_leaseChangeId NUMBER := NULL;
300: l_leaseChangeNumber NUMBER := NULL;
301: l_leaseChangeName VARCHAR2(50) ;
302: l_lease_num VARCHAR2(30);
303: l_user_id NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
304: l_last_updated_by NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
305: l_last_update_login NUMBER := NVL(fnd_profile.value ('LOGIN_ID'),0);
306: l_changeCommencementDate DATE;
307: l_changeTerminationdate DATE;
300: l_leaseChangeNumber NUMBER := NULL;
301: l_leaseChangeName VARCHAR2(50) ;
302: l_lease_num VARCHAR2(30);
303: l_user_id NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
304: l_last_updated_by NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
305: l_last_update_login NUMBER := NVL(fnd_profile.value ('LOGIN_ID'),0);
306: l_changeCommencementDate DATE;
307: l_changeTerminationdate DATE;
308: l_changeExecutionDate DATE;
301: l_leaseChangeName VARCHAR2(50) ;
302: l_lease_num VARCHAR2(30);
303: l_user_id NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
304: l_last_updated_by NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
305: l_last_update_login NUMBER := NVL(fnd_profile.value ('LOGIN_ID'),0);
306: l_changeCommencementDate DATE;
307: l_changeTerminationdate DATE;
308: l_changeExecutionDate DATE;
309: l_responsibleUser NUMBER;
517:
518: BEGIN
519: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_tenancies +Start+ (+)');
520:
521: IF fnd_profile.value('PN_CHG_TEN_WHEN_LEASE_CHG') = 'Y' THEN
522:
523: <
524: FOR rec IN get_expandable_tenancies(p_lease_id, p_lease_ext_end_dt) LOOP
525: