APPS.PN_MTM_ROLLFORWARD_PKG dependencies on FND_PROFILE

Line 286: l_user_id NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);

282: l_leaseChangeId NUMBER := NULL;
283: l_leaseChangeNumber NUMBER := NULL;
284: l_leaseChangeName VARCHAR2(50) ;
285: l_lease_num VARCHAR2(30);
286: l_user_id NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
287: l_last_updated_by NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
288: l_last_update_login NUMBER := NVL(fnd_profile.value ('LOGIN_ID'),0);
289: l_changeCommencementDate DATE;
290: l_changeTerminationdate DATE;

Line 287: l_last_updated_by NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);

283: l_leaseChangeNumber NUMBER := NULL;
284: l_leaseChangeName VARCHAR2(50) ;
285: l_lease_num VARCHAR2(30);
286: l_user_id NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
287: l_last_updated_by NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
288: l_last_update_login NUMBER := NVL(fnd_profile.value ('LOGIN_ID'),0);
289: l_changeCommencementDate DATE;
290: l_changeTerminationdate DATE;
291: l_changeExecutionDate DATE;

Line 288: l_last_update_login NUMBER := NVL(fnd_profile.value ('LOGIN_ID'),0);

284: l_leaseChangeName VARCHAR2(50) ;
285: l_lease_num VARCHAR2(30);
286: l_user_id NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
287: l_last_updated_by NUMBER := NVL(fnd_profile.value ('USER_ID'), 0);
288: l_last_update_login NUMBER := NVL(fnd_profile.value ('LOGIN_ID'),0);
289: l_changeCommencementDate DATE;
290: l_changeTerminationdate DATE;
291: l_changeExecutionDate DATE;
292: l_responsibleUser NUMBER;

Line 470: IF fnd_profile.value('PN_CHG_TEN_WHEN_LEASE_CHG') = 'Y' THEN

466:
467: BEGIN
468: pnp_debug_pkg.log('pn_mtm_rollforward_pkg.rollforward_tenancies +Start+ (+)');
469:
470: IF fnd_profile.value('PN_CHG_TEN_WHEN_LEASE_CHG') = 'Y' THEN
471:
472: <>
473: FOR rec IN get_expandable_tenancies(p_lease_id, p_lease_ext_end_dt) LOOP
474: