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 603: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

599: ,x_assessment_date => v_curr_asmt_dt
600: ,x_basis_start_date => v_basis_start_date
601: ,x_basis_end_date => v_basis_end_date
602: ,x_last_update_date => SYSDATE
603: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
604: ,x_creation_date => SYSDATE
605: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
606: ,x_index_finder_date => v_x_index_finder_date
607: ,x_current_index_line_id => NULL

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

601: ,x_basis_end_date => v_basis_end_date
602: ,x_last_update_date => SYSDATE
603: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
604: ,x_creation_date => SYSDATE
605: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
606: ,x_index_finder_date => v_x_index_finder_date
607: ,x_current_index_line_id => NULL
608: ,x_current_index_line_value => NULL
609: ,x_previous_index_line_id => NULL

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

1854: WHERE index_lease_id = c_rec.index_lease_id;
1855: END IF; -- c_rec.termination_date > p_new_main_lease_term_date
1856:
1857: IF p_lease_context IN ('EXP') AND
1858: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'
1859: THEN
1860: handle_MTM_ACT ( p_lease_id => p_lease_id,
1861: p_extended => l_extended,
1862: x_return_status => l_return_status);

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

1890: --
1891: -- updating the end date of any non-approved index rent
1892: -- payment terms..
1893: --
1894: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
1895: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR') THEN
1896:
1897: IF p_lease_context='EXP' AND NOT(l_extended) AND
1898: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'

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

1894: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
1895: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR') THEN
1896:
1897: IF p_lease_context='EXP' AND NOT(l_extended) AND
1898: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'
1899: THEN
1900: UPDATE pn_payment_terms_all
1901: SET end_date = p_new_main_lease_term_date,
1902: last_update_date = SYSDATE,

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

1929: AND ppt.frequency_code <>
1930: pn_index_amount_pkg.c_spread_frequency_one_time);
1931: END IF;
1932:
1933: ELSIF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
1934: (c_rec.basis_type = 'FIXED' AND c_rec.reference_period = 'BASE_YEAR') AND
1935: p_lease_context='CON' THEN
1936:
1937: FOR get_last_index_period_rec IN get_last_index_period_cur(c_rec.index_lease_id) LOOP

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

1958: END IF;
1959: END IF;
1960:
1961: IF (p_lease_context IN ('ROLLOVER','ROLLOVER_RI') AND
1962: (nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
1963: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR')) AND
1964: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE' ) OR
1965: ( p_lease_context IN ('ROLLOVER_RI') AND
1966: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT')

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

1960:
1961: IF (p_lease_context IN ('ROLLOVER','ROLLOVER_RI') AND
1962: (nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
1963: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR')) AND
1964: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE' ) OR
1965: ( p_lease_context IN ('ROLLOVER_RI') AND
1966: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT')
1967: THEN
1968: FOR terms_rec IN get_term_4_mtm_update(c_rec.index_lease_id) LOOP

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

1962: (nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' OR
1963: (c_rec.basis_type <> 'FIXED' AND c_rec.reference_period <> 'BASE_YEAR')) AND
1964: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE' ) OR
1965: ( p_lease_context IN ('ROLLOVER_RI') AND
1966: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT')
1967: THEN
1968: FOR terms_rec IN get_term_4_mtm_update(c_rec.index_lease_id) LOOP
1969:
1970: FOR term_details_rec IN get_term_details(terms_rec.payment_term_id) LOOP

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

2064: LOOP
2065: UPDATE pn_index_leases_all
2066: SET termination_date = p_new_main_lease_term_date,
2067: last_update_date = SYSDATE,
2068: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2069: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
2070: WHERE index_lease_id = index_leases_rec.index_lease_id;
2071:
2072:

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

2065: UPDATE pn_index_leases_all
2066: SET termination_date = p_new_main_lease_term_date,
2067: last_update_date = SYSDATE,
2068: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2069: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
2070: WHERE index_lease_id = index_leases_rec.index_lease_id;
2071:
2072:
2073: -- This will create new period for index rent for extended period

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

2077: ,p_ignore_approved_terms => 'N'
2078: ,p_msg => v_msg);
2079:
2080: IF p_lease_context = 'EXP_RI' AND
2081: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT'
2082: THEN
2083:
2084: FOR appr_terms_rec IN get_appr_terms_to_extend( index_leases_rec.index_lease_id) LOOP
2085:

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

2107:
2108: END LOOP;
2109:
2110: IF p_lease_context = 'EXP_RI' AND
2111: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_AGRMNT'
2112: THEN
2113:
2114: handle_MTM_ACT ( p_lease_id => p_lease_id,
2115: p_extended => l_extended,

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

2241:
2242: UPDATE pn_index_leases_all
2243: SET initial_basis = v_initial_basis_amt
2244: ,last_update_date = SYSDATE
2245: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2246: WHERE index_lease_id = rec1.index_lease_id;
2247: END IF;
2248:
2249: pn_index_amount_pkg.calculate (

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

2359: l_basis_type := ilease_details.basis_type;
2360: l_reference_period := ilease_details.reference_period;
2361: END LOOP;
2362:
2363: IF NVL(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
2364: l_basis_type = 'FIXED' AND l_reference_period = 'BASE_YEAR'
2365: THEN
2366: EXIT;
2367: END IF;

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

2575: BEGIN
2576:
2577: put_log('handle_term_date_change (+) ');
2578:
2579: IF NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') = 'END_AGRMNT' AND
2580: p_old_termination_date <> p_new_termination_date
2581: THEN
2582:
2583: /* RI agreement expansion */