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 1578: last_updated_by = fnd_global.user_id,

1574: IF rec_payment_terms.actual_amount IS NOT NULL THEN
1575: UPDATE pn_payment_terms_all
1576: SET actual_amount = v_new_amount,
1577: last_update_date = SYSDATE,
1578: last_updated_by = fnd_global.user_id,
1579: last_update_login = fnd_global.login_id
1580: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1581:
1582: BEGIN

Line 1579: last_update_login = fnd_global.login_id

1575: UPDATE pn_payment_terms_all
1576: SET actual_amount = v_new_amount,
1577: last_update_date = SYSDATE,
1578: last_updated_by = fnd_global.user_id,
1579: last_update_login = fnd_global.login_id
1580: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1581:
1582: BEGIN
1583: UPDATE pn_payment_items_all

Line 1587: last_updated_by = fnd_global.user_id,

1583: UPDATE pn_payment_items_all
1584: SET actual_amount = v_new_amount,
1585: export_currency_amount = v_new_amount,
1586: last_update_date = SYSDATE,
1587: last_updated_by = fnd_global.user_id,
1588: last_update_login = fnd_global.login_id
1589: WHERE payment_term_id = rec_payment_terms.payment_term_id
1590: AND export_currency_amount <> 0
1591: AND payment_item_type_lookup_code = 'CASH';

Line 1588: last_update_login = fnd_global.login_id

1584: SET actual_amount = v_new_amount,
1585: export_currency_amount = v_new_amount,
1586: last_update_date = SYSDATE,
1587: last_updated_by = fnd_global.user_id,
1588: last_update_login = fnd_global.login_id
1589: WHERE payment_term_id = rec_payment_terms.payment_term_id
1590: AND export_currency_amount <> 0
1591: AND payment_item_type_lookup_code = 'CASH';
1592:

Line 1602: last_updated_by = fnd_global.user_id,

1598:
1599: UPDATE pn_payment_terms_all
1600: SET estimated_amount = v_new_amount,
1601: last_update_date = SYSDATE,
1602: last_updated_by = fnd_global.user_id,
1603: last_update_login = fnd_global.login_id
1604: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1605:
1606: BEGIN

Line 1603: last_update_login = fnd_global.login_id

1599: UPDATE pn_payment_terms_all
1600: SET estimated_amount = v_new_amount,
1601: last_update_date = SYSDATE,
1602: last_updated_by = fnd_global.user_id,
1603: last_update_login = fnd_global.login_id
1604: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1605:
1606: BEGIN
1607: UPDATE pn_payment_items_all

Line 1612: last_updated_by = fnd_global.user_id,

1608: SET actual_amount = v_new_amount,
1609: estimated_amount = v_new_amount,
1610: export_currency_amount = v_new_amount,
1611: last_update_date = SYSDATE,
1612: last_updated_by = fnd_global.user_id,
1613: last_update_login = fnd_global.login_id
1614: WHERE payment_term_id = rec_payment_terms.payment_term_id
1615: AND export_currency_amount <> 0
1616: AND payment_item_type_lookup_code = 'CASH';

Line 1613: last_update_login = fnd_global.login_id

1609: estimated_amount = v_new_amount,
1610: export_currency_amount = v_new_amount,
1611: last_update_date = SYSDATE,
1612: last_updated_by = fnd_global.user_id,
1613: last_update_login = fnd_global.login_id
1614: WHERE payment_term_id = rec_payment_terms.payment_term_id
1615: AND export_currency_amount <> 0
1616: AND payment_item_type_lookup_code = 'CASH';
1617:

Line 1852: ,last_updated_by = fnd_global.user_id

1848: --
1849: UPDATE pn_index_leases_all
1850: SET termination_date = GREATEST(p_new_main_lease_term_date,commencement_date)
1851: ,last_update_date = SYSDATE
1852: ,last_updated_by = fnd_global.user_id
1853: ,last_update_login = fnd_global.login_id
1854: WHERE index_lease_id = c_rec.index_lease_id;
1855: END IF; -- c_rec.termination_date > p_new_main_lease_term_date
1856:

Line 1853: ,last_update_login = fnd_global.login_id

1849: UPDATE pn_index_leases_all
1850: SET termination_date = GREATEST(p_new_main_lease_term_date,commencement_date)
1851: ,last_update_date = SYSDATE
1852: ,last_updated_by = fnd_global.user_id
1853: ,last_update_login = fnd_global.login_id
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

Line 1903: last_updated_by = fnd_global.user_id,

1899: THEN
1900: UPDATE pn_payment_terms_all
1901: SET end_date = p_new_main_lease_term_date,
1902: last_update_date = SYSDATE,
1903: last_updated_by = fnd_global.user_id,
1904: last_update_login = fnd_global.login_id
1905: WHERE payment_term_id IN
1906: (SELECT ppt.payment_term_id
1907: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

Line 1904: last_update_login = fnd_global.login_id

1900: UPDATE pn_payment_terms_all
1901: SET end_date = p_new_main_lease_term_date,
1902: last_update_date = SYSDATE,
1903: last_updated_by = fnd_global.user_id,
1904: last_update_login = fnd_global.login_id
1905: WHERE payment_term_id IN
1906: (SELECT ppt.payment_term_id
1907: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1908: WHERE pilp.index_period_id = ppt.index_period_id

Line 1920: last_updated_by = fnd_global.user_id,

1916: ELSIF p_lease_context='CON' THEN
1917: UPDATE pn_payment_terms_all
1918: SET end_date = NVL(p_term_end_dt,p_new_main_lease_term_date),
1919: last_update_date = SYSDATE,
1920: last_updated_by = fnd_global.user_id,
1921: last_update_login = fnd_global.login_id
1922: WHERE payment_term_id IN
1923: (SELECT ppt.payment_term_id
1924: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

Line 1921: last_update_login = fnd_global.login_id

1917: UPDATE pn_payment_terms_all
1918: SET end_date = NVL(p_term_end_dt,p_new_main_lease_term_date),
1919: last_update_date = SYSDATE,
1920: last_updated_by = fnd_global.user_id,
1921: last_update_login = fnd_global.login_id
1922: WHERE payment_term_id IN
1923: (SELECT ppt.payment_term_id
1924: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1925: WHERE pilp.index_period_id = ppt.index_period_id

Line 1945: last_updated_by = fnd_global.user_id,

1941: v_last_period_assess_end_date := add_months(v_max_assessment_date, 12*(c_rec.assessment_interval)) -1;
1942: UPDATE pn_payment_terms_all
1943: SET end_date = least(NVL(p_term_end_dt,p_new_main_lease_term_date), v_last_period_assess_end_date),
1944: last_update_date = SYSDATE,
1945: last_updated_by = fnd_global.user_id,
1946: last_update_login = fnd_global.login_id
1947: WHERE payment_term_id IN
1948: (SELECT ppt.payment_term_id
1949: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

Line 1946: last_update_login = fnd_global.login_id

1942: UPDATE pn_payment_terms_all
1943: SET end_date = least(NVL(p_term_end_dt,p_new_main_lease_term_date), v_last_period_assess_end_date),
1944: last_update_date = SYSDATE,
1945: last_updated_by = fnd_global.user_id,
1946: last_update_login = fnd_global.login_id
1947: WHERE payment_term_id IN
1948: (SELECT ppt.payment_term_id
1949: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1950: WHERE pilp.index_period_id = ppt.index_period_id

Line 2029: last_updated_by = fnd_global.user_id,

2025:
2026: UPDATE pn_payment_terms_all
2027: SET end_date = p_new_main_lease_term_date,
2028: last_update_date = SYSDATE,
2029: last_updated_by = fnd_global.user_id,
2030: last_update_login = fnd_global.login_id
2031: WHERE payment_term_id = terms_rec.payment_term_id;
2032:
2033: pn_schedules_items.Extend_Payment_Term

Line 2030: last_update_login = fnd_global.login_id

2026: UPDATE pn_payment_terms_all
2027: SET end_date = p_new_main_lease_term_date,
2028: last_update_date = SYSDATE,
2029: last_updated_by = fnd_global.user_id,
2030: last_update_login = fnd_global.login_id
2031: WHERE payment_term_id = terms_rec.payment_term_id;
2032:
2033: pn_schedules_items.Extend_Payment_Term
2034: (p_payment_term_rec => l_term_rec,

Line 2091: last_updated_by = fnd_global.user_id,

2087:
2088: UPDATE pn_payment_terms_all
2089: SET end_date = p_new_main_lease_term_date,
2090: last_update_date = SYSDATE,
2091: last_updated_by = fnd_global.user_id,
2092: last_update_login = fnd_global.login_id
2093: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
2094:
2095: pn_schedules_items.Extend_Payment_Term

Line 2092: last_update_login = fnd_global.login_id

2088: UPDATE pn_payment_terms_all
2089: SET end_date = p_new_main_lease_term_date,
2090: last_update_date = SYSDATE,
2091: last_updated_by = fnd_global.user_id,
2092: last_update_login = fnd_global.login_id
2093: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
2094:
2095: pn_schedules_items.Extend_Payment_Term
2096: (p_payment_term_rec => l_ri_term_rec,

Line 2429: last_updated_by = fnd_global.user_id,

2425: UPDATE pn_payment_terms_all
2426: SET end_date = l_lease_term_date,
2427: lease_change_id = l_lease_change_id,
2428: last_update_date = SYSDATE,
2429: last_updated_by = fnd_global.user_id,
2430: last_update_login = fnd_global.login_id
2431: WHERE payment_term_id = l_term_rec.payment_term_id;
2432:
2433: p_extended := TRUE;

Line 2430: last_update_login = fnd_global.login_id

2426: SET end_date = l_lease_term_date,
2427: lease_change_id = l_lease_change_id,
2428: last_update_date = SYSDATE,
2429: last_updated_by = fnd_global.user_id,
2430: last_update_login = fnd_global.login_id
2431: WHERE payment_term_id = l_term_rec.payment_term_id;
2432:
2433: p_extended := TRUE;
2434: