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_GLOBAL

Line 40: -- | to use fnd_global.user_id|login_id.

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
44: -- | 24-NOV-06 Prabhakar o Added parameter index_multiplier to create_periods.

Line 1586: last_updated_by = fnd_global.user_id,

1582: IF rec_payment_terms.actual_amount IS NOT NULL THEN
1583: UPDATE pn_payment_terms_all
1584: SET actual_amount = v_new_amount,
1585: last_update_date = SYSDATE,
1586: last_updated_by = fnd_global.user_id,
1587: last_update_login = fnd_global.login_id
1588: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1589:
1590: BEGIN

Line 1587: last_update_login = fnd_global.login_id

1583: UPDATE pn_payment_terms_all
1584: SET actual_amount = v_new_amount,
1585: last_update_date = SYSDATE,
1586: last_updated_by = fnd_global.user_id,
1587: last_update_login = fnd_global.login_id
1588: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1589:
1590: BEGIN
1591: UPDATE pn_payment_items_all

Line 1595: last_updated_by = fnd_global.user_id,

1591: UPDATE pn_payment_items_all
1592: SET actual_amount = v_new_amount,
1593: export_currency_amount = v_new_amount,
1594: last_update_date = SYSDATE,
1595: last_updated_by = fnd_global.user_id,
1596: last_update_login = fnd_global.login_id
1597: WHERE payment_term_id = rec_payment_terms.payment_term_id
1598: AND export_currency_amount <> 0
1599: AND payment_item_type_lookup_code = 'CASH';

Line 1596: last_update_login = fnd_global.login_id

1592: SET actual_amount = v_new_amount,
1593: export_currency_amount = v_new_amount,
1594: last_update_date = SYSDATE,
1595: last_updated_by = fnd_global.user_id,
1596: last_update_login = fnd_global.login_id
1597: WHERE payment_term_id = rec_payment_terms.payment_term_id
1598: AND export_currency_amount <> 0
1599: AND payment_item_type_lookup_code = 'CASH';
1600:

Line 1610: last_updated_by = fnd_global.user_id,

1606:
1607: UPDATE pn_payment_terms_all
1608: SET estimated_amount = v_new_amount,
1609: last_update_date = SYSDATE,
1610: last_updated_by = fnd_global.user_id,
1611: last_update_login = fnd_global.login_id
1612: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1613:
1614: BEGIN

Line 1611: last_update_login = fnd_global.login_id

1607: UPDATE pn_payment_terms_all
1608: SET estimated_amount = v_new_amount,
1609: last_update_date = SYSDATE,
1610: last_updated_by = fnd_global.user_id,
1611: last_update_login = fnd_global.login_id
1612: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1613:
1614: BEGIN
1615: UPDATE pn_payment_items_all

Line 1620: last_updated_by = fnd_global.user_id,

1616: SET actual_amount = v_new_amount,
1617: estimated_amount = v_new_amount,
1618: export_currency_amount = v_new_amount,
1619: last_update_date = SYSDATE,
1620: last_updated_by = fnd_global.user_id,
1621: last_update_login = fnd_global.login_id
1622: WHERE payment_term_id = rec_payment_terms.payment_term_id
1623: AND export_currency_amount <> 0
1624: AND payment_item_type_lookup_code = 'CASH';

Line 1621: last_update_login = fnd_global.login_id

1617: estimated_amount = v_new_amount,
1618: export_currency_amount = v_new_amount,
1619: last_update_date = SYSDATE,
1620: last_updated_by = fnd_global.user_id,
1621: last_update_login = fnd_global.login_id
1622: WHERE payment_term_id = rec_payment_terms.payment_term_id
1623: AND export_currency_amount <> 0
1624: AND payment_item_type_lookup_code = 'CASH';
1625:

Line 1884: ,last_updated_by = fnd_global.user_id

1880: --
1881: UPDATE pn_index_leases_all
1882: SET termination_date = GREATEST(p_new_main_lease_term_date,commencement_date)
1883: ,last_update_date = SYSDATE
1884: ,last_updated_by = fnd_global.user_id
1885: ,last_update_login = fnd_global.login_id
1886: WHERE index_lease_id = c_rec.index_lease_id;
1887: END IF; -- c_rec.termination_date > p_new_main_lease_term_date
1888:

Line 1885: ,last_update_login = fnd_global.login_id

1881: UPDATE pn_index_leases_all
1882: SET termination_date = GREATEST(p_new_main_lease_term_date,commencement_date)
1883: ,last_update_date = SYSDATE
1884: ,last_updated_by = fnd_global.user_id
1885: ,last_update_login = fnd_global.login_id
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

Line 1941: last_updated_by = fnd_global.user_id,

1937:
1938: UPDATE pn_payment_terms_all
1939: SET end_date = p_new_main_lease_term_date,
1940: last_update_date = SYSDATE,
1941: last_updated_by = fnd_global.user_id,
1942: last_update_login = fnd_global.login_id
1943: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
1944:
1945:

Line 1942: last_update_login = fnd_global.login_id

1938: UPDATE pn_payment_terms_all
1939: SET end_date = p_new_main_lease_term_date,
1940: last_update_date = SYSDATE,
1941: last_updated_by = fnd_global.user_id,
1942: last_update_login = fnd_global.login_id
1943: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
1944:
1945:
1946: select status into l_status

Line 1971: last_updated_by = fnd_global.user_id,

1967: ELSIF p_lease_context='CON' THEN
1968: UPDATE pn_payment_terms_all
1969: SET end_date = NVL(p_term_end_dt,p_new_main_lease_term_date),
1970: last_update_date = SYSDATE,
1971: last_updated_by = fnd_global.user_id,
1972: last_update_login = fnd_global.login_id
1973: WHERE payment_term_id IN
1974: (SELECT ppt.payment_term_id
1975: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

Line 1972: last_update_login = fnd_global.login_id

1968: UPDATE pn_payment_terms_all
1969: SET end_date = NVL(p_term_end_dt,p_new_main_lease_term_date),
1970: last_update_date = SYSDATE,
1971: last_updated_by = fnd_global.user_id,
1972: last_update_login = fnd_global.login_id
1973: WHERE payment_term_id IN
1974: (SELECT ppt.payment_term_id
1975: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1976: WHERE pilp.index_period_id = ppt.index_period_id

Line 1996: last_updated_by = fnd_global.user_id,

1992: v_last_period_assess_end_date := add_months(v_max_assessment_date, 12*(c_rec.assessment_interval)) -1;
1993: UPDATE pn_payment_terms_all
1994: SET end_date = least(NVL(p_term_end_dt,p_new_main_lease_term_date), v_last_period_assess_end_date),
1995: last_update_date = SYSDATE,
1996: last_updated_by = fnd_global.user_id,
1997: last_update_login = fnd_global.login_id
1998: WHERE payment_term_id IN
1999: (SELECT ppt.payment_term_id
2000: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

Line 1997: last_update_login = fnd_global.login_id

1993: UPDATE pn_payment_terms_all
1994: SET end_date = least(NVL(p_term_end_dt,p_new_main_lease_term_date), v_last_period_assess_end_date),
1995: last_update_date = SYSDATE,
1996: last_updated_by = fnd_global.user_id,
1997: last_update_login = fnd_global.login_id
1998: WHERE payment_term_id IN
1999: (SELECT ppt.payment_term_id
2000: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
2001: WHERE pilp.index_period_id = ppt.index_period_id

Line 2088: last_updated_by = fnd_global.user_id,

2084: ELSE
2085: UPDATE pn_payment_terms_all
2086: SET end_date = p_new_main_lease_term_date,
2087: last_update_date = SYSDATE,
2088: last_updated_by = fnd_global.user_id,
2089: last_update_login = fnd_global.login_id
2090: WHERE payment_term_id = terms_rec.payment_term_id;
2091: select status into l_status from pn_payment_terms_all where payment_term_id = terms_rec.payment_term_id;
2092: if l_status <> 'DRAFT' then

Line 2089: last_update_login = fnd_global.login_id

2085: UPDATE pn_payment_terms_all
2086: SET end_date = p_new_main_lease_term_date,
2087: last_update_date = SYSDATE,
2088: last_updated_by = fnd_global.user_id,
2089: last_update_login = fnd_global.login_id
2090: WHERE payment_term_id = terms_rec.payment_term_id;
2091: select status into l_status from pn_payment_terms_all where payment_term_id = terms_rec.payment_term_id;
2092: if l_status <> 'DRAFT' then
2093:

Line 2159: last_updated_by = fnd_global.user_id,

2155:
2156: UPDATE pn_payment_terms_all
2157: SET end_date = v_end_date, --p_new_main_lease_term_date,
2158: last_update_date = SYSDATE,
2159: last_updated_by = fnd_global.user_id,
2160: last_update_login = fnd_global.login_id
2161: WHERE payment_term_id = l_term(i).term_id;
2162:
2163: select *

Line 2160: last_update_login = fnd_global.login_id

2156: UPDATE pn_payment_terms_all
2157: SET end_date = v_end_date, --p_new_main_lease_term_date,
2158: last_update_date = SYSDATE,
2159: last_updated_by = fnd_global.user_id,
2160: last_update_login = fnd_global.login_id
2161: WHERE payment_term_id = l_term(i).term_id;
2162:
2163: select *
2164: into l_ri_term_rec

Line 2213: last_updated_by = fnd_global.user_id,

2209: END IF; /* added for bug #11671285*/
2210: UPDATE pn_payment_terms_all
2211: SET end_date = v_end_date, --p_new_main_lease_term_date, /* bug # 11671285*/
2212: last_update_date = SYSDATE,
2213: last_updated_by = fnd_global.user_id,
2214: last_update_login = fnd_global.login_id
2215: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
2216:
2217: select status into l_status from pn_payment_terms_all where payment_term_id = l_ri_term_rec.payment_term_id;

Line 2214: last_update_login = fnd_global.login_id

2210: UPDATE pn_payment_terms_all
2211: SET end_date = v_end_date, --p_new_main_lease_term_date, /* bug # 11671285*/
2212: last_update_date = SYSDATE,
2213: last_updated_by = fnd_global.user_id,
2214: last_update_login = fnd_global.login_id
2215: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
2216:
2217: select status into l_status from pn_payment_terms_all where payment_term_id = l_ri_term_rec.payment_term_id;
2218: if l_status <> 'DRAFT' then

Line 2555: last_updated_by = fnd_global.user_id,

2551: UPDATE pn_payment_terms_all
2552: SET end_date = l_lease_term_date,
2553: lease_change_id = l_lease_change_id,
2554: last_update_date = SYSDATE,
2555: last_updated_by = fnd_global.user_id,
2556: last_update_login = fnd_global.login_id
2557: WHERE payment_term_id = l_term_rec.payment_term_id;
2558:
2559: p_extended := TRUE;

Line 2556: last_update_login = fnd_global.login_id

2552: SET end_date = l_lease_term_date,
2553: lease_change_id = l_lease_change_id,
2554: last_update_date = SYSDATE,
2555: last_updated_by = fnd_global.user_id,
2556: last_update_login = fnd_global.login_id
2557: WHERE payment_term_id = l_term_rec.payment_term_id;
2558:
2559: p_extended := TRUE;
2560: