eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on FND_PROFILE

Line 39: -- | o Changed instances of updation using nvl(fnd_profile(),0)

35: -- |
36: -- | 24-AUG-04 ftanudja o Added logic to check profile option value before
37: -- | extending index rent term in process_main_lease_term_date().
38: -- | #3756208.
39: -- | o Changed instances of updation using nvl(fnd_profile(),0)
40: -- | to use fnd_global.user_id|login_id.
41: -- | 14-JUL-05 SatyaDeep o Replaced base views with their respective _ALL tables.
42: -- | 19-JAN-06 piagrawa o Bug#4931780 - Modified signature of
43: -- | process_main_lease_term_date, recalc_ot_payment_terms

Line 611: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

607: ,x_assessment_date => v_curr_asmt_dt
608: ,x_basis_start_date => v_basis_start_date
609: ,x_basis_end_date => v_basis_end_date
610: ,x_last_update_date => SYSDATE
611: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
612: ,x_creation_date => SYSDATE
613: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
614: ,x_index_finder_date => v_x_index_finder_date
615: ,x_current_index_line_id => NULL

Line 613: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

609: ,x_basis_end_date => v_basis_end_date
610: ,x_last_update_date => SYSDATE
611: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
612: ,x_creation_date => SYSDATE
613: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
614: ,x_index_finder_date => v_x_index_finder_date
615: ,x_current_index_line_id => NULL
616: ,x_current_index_line_value => NULL
617: ,x_previous_index_line_id => NULL

Line 1890: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'

1886: WHERE index_lease_id = c_rec.index_lease_id;
1887: END IF; -- c_rec.termination_date > p_new_main_lease_term_date
1888:
1889: IF p_lease_context IN ('EXP') AND
1890: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'
1891: THEN
1892: handle_MTM_ACT ( p_lease_id => p_lease_id,
1893: p_extended => l_extended,
1894: x_return_status => l_return_status);

Line 1926: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR

1922: --
1923: -- updating the end date of any non-approved index rent
1924: -- payment terms..
1925: --
1926: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
1927: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR') THEN
1928:
1929: IF p_lease_context='EXP' AND NOT(l_extended) AND
1930: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'

Line 1930: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'

1926: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
1927: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR') THEN
1928:
1929: IF p_lease_context='EXP' AND NOT(l_extended) AND
1930: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'
1931: THEN
1932:
1933: /*--Bug16243330 */
1934: For appr_terms_rec in get_ri_terms_to_extend(c_rec.index_lease_id)

Line 1984: ELSIF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND

1980: AND ppt.frequency_code <>
1981: pn_index_amount_pkg.c_spread_frequency_one_time);
1982: END IF;
1983:
1984: ELSIF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
1985: (c_rec.basis_type = 'FIXED' AND c_rec.reference_period = 'BASE_YEAR') AND
1986: p_lease_context='CON' THEN
1987:
1988: FOR get_last_index_period_rec IN get_last_index_period_cur(c_rec.index_lease_id) LOOP

Line 2013: (nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR

2009: END IF;
2010: END IF;
2011:
2012: IF (p_lease_context IN ('ROLLOVER','ROLLOVER_RI') AND
2013: (nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
2014: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR')) AND
2015: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE' ) OR
2016: ( p_lease_context IN ('ROLLOVER_RI') AND
2017: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT')

Line 2015: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE' ) OR

2011:
2012: IF (p_lease_context IN ('ROLLOVER','ROLLOVER_RI') AND
2013: (nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
2014: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR')) AND
2015: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE' ) OR
2016: ( p_lease_context IN ('ROLLOVER_RI') AND
2017: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT')
2018: THEN
2019: FOR terms_rec IN get_term_4_mtm_update(c_rec.index_lease_id) LOOP

Line 2017: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT')

2013: (nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
2014: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR')) AND
2015: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE' ) OR
2016: ( p_lease_context IN ('ROLLOVER_RI') AND
2017: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT')
2018: THEN
2019: FOR terms_rec IN get_term_4_mtm_update(c_rec.index_lease_id) LOOP
2020:
2021: FOR term_details_rec IN get_term_details(terms_rec.payment_term_id) LOOP

Line 2077: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND

2073: ELSE
2074:
2075: l_term_rec.end_date := p_new_main_lease_term_date;
2076: /* added below if condition for bug #11671285 */
2077: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
2078: (c_rec.basis_type = 'FIXED' AND c_rec.reference_period = 'BASE_YEAR') THEN
2079:
2080: l_term(l_term_index).index_id := c_rec.index_lease_id;
2081: l_term(l_term_index).term_id := l_term_rec.payment_term_id;

Line 2131: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),

2127: LOOP
2128: UPDATE pn_index_leases_all
2129: SET termination_date = p_new_main_lease_term_date,
2130: last_update_date = SYSDATE,
2131: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2132: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
2133: WHERE index_lease_id = index_leases_rec.index_lease_id;
2134:
2135:

Line 2132: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

2128: UPDATE pn_index_leases_all
2129: SET termination_date = p_new_main_lease_term_date,
2130: last_update_date = SYSDATE,
2131: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2132: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
2133: WHERE index_lease_id = index_leases_rec.index_lease_id;
2134:
2135:
2136: -- This will create new period for index rent for extended period

Line 2185: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT'

2181: END IF;
2182: END LOOP; /* end of the added loop for bug #11671285 */
2183:
2184: IF p_lease_context = 'EXP_RI' AND
2185: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT'
2186: THEN
2187: v_end_date := p_new_main_lease_term_date; -- bug #11671285
2188:
2189: FOR appr_terms_rec IN get_appr_terms_to_extend( index_leases_rec.index_lease_id) LOOP

Line 2201: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND

2197: and pp.LEASE_ID = pi.LEASE_ID
2198: and rownum=1;
2199:
2200:
2201: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
2202: (l_basis_type = 'FIXED' AND l_ref_period = 'BASE_YEAR') THEN
2203: pn_index_amount_pkg.derive_term_end_date(
2204: ip_index_lease_id => index_leases_rec.index_lease_id
2205: ,ip_index_period_id => l_period_id

Line 2237: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT'

2233:
2234: END LOOP;
2235:
2236: IF p_lease_context = 'EXP_RI' AND
2237: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT'
2238: THEN
2239:
2240: handle_MTM_ACT ( p_lease_id => p_lease_id,
2241: p_extended => l_extended,

Line 2371: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

2367:
2368: UPDATE pn_index_leases_all
2369: SET initial_basis = v_initial_basis_amt
2370: ,last_update_date = SYSDATE
2371: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2372: WHERE index_lease_id = rec1.index_lease_id;
2373: END IF;
2374:
2375: pn_index_amount_pkg.calculate (

Line 2489: IF NVL(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND

2485: l_basis_type := ilease_details.basis_type;
2486: l_reference_period := ilease_details.reference_period;
2487: END LOOP;
2488:
2489: IF NVL(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
2490: l_basis_type = 'FIXED' AND l_reference_period = 'BASE_YEAR'
2491: THEN
2492: EXIT;
2493: END IF;

Line 2723: IF NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') = 'END_AGRMNT' AND

2719: BEGIN
2720:
2721: put_log('handle_term_date_change (+) ');
2722:
2723: IF NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') = 'END_AGRMNT' AND
2724: p_old_termination_date <> p_new_termination_date
2725: THEN
2726:
2727: /* RI agreement expansion */

Line 2736: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' THEN

2732:
2733: IF p_old_termination_date < p_new_termination_date THEN
2734: p_msg := 'RI agreement expansion';
2735:
2736: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' THEN
2737: FOR ri_terms_rec IN get_ri_terms_to_exp LOOP
2738: l_payment_term_rec := ri_terms_rec;
2739:
2740: UPDATE pn_payment_terms_all