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_SCHEDULES_ITEMS dependencies on FND_PROFILE

Line 1750: NVL(fnd_profile.value('USER_ID'),0),

1746: VALUES
1747:
1748: (l_sch_id,
1749: SYSDATE,
1750: NVL(fnd_profile.value('USER_ID'),0),
1751: SYSDATE,
1752: NVL(fnd_profile.value('USER_ID'),0),
1753: NVL(fnd_profile.value('LOGIN_ID'),0),
1754: p_sch_dt,

Line 1752: NVL(fnd_profile.value('USER_ID'),0),

1748: (l_sch_id,
1749: SYSDATE,
1750: NVL(fnd_profile.value('USER_ID'),0),
1751: SYSDATE,
1752: NVL(fnd_profile.value('USER_ID'),0),
1753: NVL(fnd_profile.value('LOGIN_ID'),0),
1754: p_sch_dt,
1755: p_lease_id,
1756: p_lc_id,

Line 1753: NVL(fnd_profile.value('LOGIN_ID'),0),

1749: SYSDATE,
1750: NVL(fnd_profile.value('USER_ID'),0),
1751: SYSDATE,
1752: NVL(fnd_profile.value('USER_ID'),0),
1753: NVL(fnd_profile.value('LOGIN_ID'),0),
1754: p_sch_dt,
1755: p_lease_id,
1756: p_lc_id,
1757: l_pymnt_st_lkp_cd,

Line 1824: NVL(fnd_profile.value('USER_ID'),0),

1820: payment_status_lookup_code,
1821: org_id)
1822: VALUES (l_sch_id,
1823: SYSDATE,
1824: NVL(fnd_profile.value('USER_ID'),0),
1825: SYSDATE,
1826: NVL(fnd_profile.value('USER_ID'),0),
1827: NVL(fnd_profile.value('LOGIN_ID'),0),
1828: l_schd_date,

Line 1826: NVL(fnd_profile.value('USER_ID'),0),

1822: VALUES (l_sch_id,
1823: SYSDATE,
1824: NVL(fnd_profile.value('USER_ID'),0),
1825: SYSDATE,
1826: NVL(fnd_profile.value('USER_ID'),0),
1827: NVL(fnd_profile.value('LOGIN_ID'),0),
1828: l_schd_date,
1829: p_lease_id,
1830: p_lc_id,

Line 1827: NVL(fnd_profile.value('LOGIN_ID'),0),

1823: SYSDATE,
1824: NVL(fnd_profile.value('USER_ID'),0),
1825: SYSDATE,
1826: NVL(fnd_profile.value('USER_ID'),0),
1827: NVL(fnd_profile.value('LOGIN_ID'),0),
1828: l_schd_date,
1829: p_lease_id,
1830: p_lc_id,
1831: l_pymnt_st_lkp_cd,

Line 1913: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN

1909: FOR rec IN org_cur LOOP
1910: l_org_id := rec.org_id;
1911: END LOOP;
1912:
1913: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN
1914:
1915: FOR rec IN get_calc_date_recur_bb(p_term_id) LOOP
1916: l_sch_dt := rec.recur_bb_calc_date;
1917: END LOOP;

Line 1955: NVL(fnd_profile.value('USER_ID'),0),

1951:
1952: VALUES
1953: (PN_PAYMENT_ITEMS_S.NEXTVAL,
1954: SYSDATE,
1955: NVL(fnd_profile.value('USER_ID'),0),
1956: SYSDATE,
1957: NVL(fnd_profile.value('USER_ID'),0),
1958: NVL(fnd_profile.value('LOGIN_ID'),0),
1959: ROUND(p_act_amt,l_precision),

Line 1957: NVL(fnd_profile.value('USER_ID'),0),

1953: (PN_PAYMENT_ITEMS_S.NEXTVAL,
1954: SYSDATE,
1955: NVL(fnd_profile.value('USER_ID'),0),
1956: SYSDATE,
1957: NVL(fnd_profile.value('USER_ID'),0),
1958: NVL(fnd_profile.value('LOGIN_ID'),0),
1959: ROUND(p_act_amt,l_precision),
1960: ROUND(p_est_amt,l_precision),
1961: l_sch_dt,

Line 1958: NVL(fnd_profile.value('LOGIN_ID'),0),

1954: SYSDATE,
1955: NVL(fnd_profile.value('USER_ID'),0),
1956: SYSDATE,
1957: NVL(fnd_profile.value('USER_ID'),0),
1958: NVL(fnd_profile.value('LOGIN_ID'),0),
1959: ROUND(p_act_amt,l_precision),
1960: ROUND(p_est_amt,l_precision),
1961: l_sch_dt,
1962: 'CASH',

Line 2522: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN

2518: l_org_id := rec.org_id;
2519: END LOOP;
2520:
2521: l_due_date := l_norm_sch_dt;
2522: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN
2523:
2524: FOR rec IN get_calc_date_recur_bb(p_term_id) LOOP
2525: l_due_date := rec.recur_bb_calc_date;
2526: END LOOP;

Line 2628: NVL(fnd_profile.value('USER_ID'),0),

2624: VALUES
2625:
2626: (PN_PAYMENT_ITEMS_S.NEXTVAL,
2627: SYSDATE,
2628: NVL(fnd_profile.value('USER_ID'),0),
2629: SYSDATE,
2630: NVL(fnd_profile.value('USER_ID'),0),
2631: NVL(fnd_profile.value('LOGIN_ID'),0),
2632: l_prec_norm_amt,

Line 2630: NVL(fnd_profile.value('USER_ID'),0),

2626: (PN_PAYMENT_ITEMS_S.NEXTVAL,
2627: SYSDATE,
2628: NVL(fnd_profile.value('USER_ID'),0),
2629: SYSDATE,
2630: NVL(fnd_profile.value('USER_ID'),0),
2631: NVL(fnd_profile.value('LOGIN_ID'),0),
2632: l_prec_norm_amt,
2633: NULL,
2634: l_norm_sch_dt,

Line 2631: NVL(fnd_profile.value('LOGIN_ID'),0),

2627: SYSDATE,
2628: NVL(fnd_profile.value('USER_ID'),0),
2629: SYSDATE,
2630: NVL(fnd_profile.value('USER_ID'),0),
2631: NVL(fnd_profile.value('LOGIN_ID'),0),
2632: l_prec_norm_amt,
2633: NULL,
2634: l_norm_sch_dt,
2635: 'NORMALIZED',

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

2671: UPDATE pn_payment_items_all ppi
2672: SET ppi.actual_amount = l_prec_norm_amt,
2673: ppi.export_currency_amount = l_prec_norm_amt,
2674: ppi.last_update_date = SYSDATE,
2675: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2676: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2677: WHERE ppi.payment_schedule_id = l_sch_id_1
2678: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
2679: AND ppi.payment_term_id = p_term_id;

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

2672: SET ppi.actual_amount = l_prec_norm_amt,
2673: ppi.export_currency_amount = l_prec_norm_amt,
2674: ppi.last_update_date = SYSDATE,
2675: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2676: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2677: WHERE ppi.payment_schedule_id = l_sch_id_1
2678: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
2679: AND ppi.payment_term_id = p_term_id;
2680:

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

2698: UPDATE pn_payment_items_all ppi
2699: SET ppi.actual_amount = l_prec_norm_amt,
2700: ppi.export_currency_amount = l_prec_norm_amt,
2701: ppi.last_update_date = SYSDATE,
2702: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2703: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2704: WHERE ppi.payment_schedule_id IN (SELECT pps.payment_schedule_id
2705: FROM pn_payment_schedules_all pps,
2706: pn_payment_items_all ppi1

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

2699: SET ppi.actual_amount = l_prec_norm_amt,
2700: ppi.export_currency_amount = l_prec_norm_amt,
2701: ppi.last_update_date = SYSDATE,
2702: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2703: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2704: WHERE ppi.payment_schedule_id IN (SELECT pps.payment_schedule_id
2705: FROM pn_payment_schedules_all pps,
2706: pn_payment_items_all ppi1
2707: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id

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

2729: UPDATE pn_payment_items_all ppi
2730: SET ppi.actual_amount = l_prec_norm_amt,
2731: ppi.export_currency_amount = l_prec_norm_amt,
2732: ppi.last_update_date = SYSDATE,
2733: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2734: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2735: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2736: FROM pn_payment_schedules_all pps,
2737: pn_payment_items_all ppi1

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

2730: SET ppi.actual_amount = l_prec_norm_amt,
2731: ppi.export_currency_amount = l_prec_norm_amt,
2732: ppi.last_update_date = SYSDATE,
2733: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2734: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2735: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2736: FROM pn_payment_schedules_all pps,
2737: pn_payment_items_all ppi1
2738: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id

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

2763: UPDATE pn_payment_items_all ppi
2764: SET ppi.actual_amount = l_prec_norm_amt,
2765: ppi.export_currency_amount = l_prec_norm_amt,
2766: ppi.last_update_date = SYSDATE,
2767: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2768: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2769: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2770: FROM pn_payment_schedules_all pps,
2771: pn_payment_items_all ppi1

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

2764: SET ppi.actual_amount = l_prec_norm_amt,
2765: ppi.export_currency_amount = l_prec_norm_amt,
2766: ppi.last_update_date = SYSDATE,
2767: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2768: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2769: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2770: FROM pn_payment_schedules_all pps,
2771: pn_payment_items_all ppi1
2772: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id

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

3484: SET estimated_amount = l_cash_est_amt - l_cash_est_amt_appr, --Bug 9150650
3485: actual_amount = l_cash_act_amt - l_cash_act_amt_appr,
3486: export_currency_amount = l_cash_act_amt - l_cash_exp_amt_appr,
3487: last_update_date = SYSDATE,
3488: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3489: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3490: WHERE payment_item_id = (SELECT ppi1.payment_item_id
3491: FROM pn_payment_items_all ppi1,
3492: pn_payment_schedules_all pps

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

3485: actual_amount = l_cash_act_amt - l_cash_act_amt_appr,
3486: export_currency_amount = l_cash_act_amt - l_cash_exp_amt_appr,
3487: last_update_date = SYSDATE,
3488: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3489: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3490: WHERE payment_item_id = (SELECT ppi1.payment_item_id
3491: FROM pn_payment_items_all ppi1,
3492: pn_payment_schedules_all pps
3493: WHERE ppi1.payment_term_id = p_term_id

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

3998: UPDATE pn_tenancies_all
3999: SET expiration_date = p_new_lea_term_dt,
4000: fin_oblig_end_date = p_new_lea_term_dt,
4001: last_update_date = SYSDATE,
4002: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4003: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4004: WHERE tenancy_id = l_tenancy_Id;
4005:
4006: pnp_debug_pkg.log('CON_TEN=>UPD : Tenancy Early Terminated...');

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

3999: SET expiration_date = p_new_lea_term_dt,
4000: fin_oblig_end_date = p_new_lea_term_dt,
4001: last_update_date = SYSDATE,
4002: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4003: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4004: WHERE tenancy_id = l_tenancy_Id;
4005:
4006: pnp_debug_pkg.log('CON_TEN=>UPD : Tenancy Early Terminated...');
4007:

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

4142:
4143: UPDATE pn_payment_terms_all
4144: SET end_date = p_new_lea_term_dt,
4145: last_update_date = SYSDATE,
4146: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4147: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4148: WHERE lease_id = p_lease_id
4149: AND end_date > p_new_lea_term_dt
4150: AND frequency_code <> 'OT';

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

4143: UPDATE pn_payment_terms_all
4144: SET end_date = p_new_lea_term_dt,
4145: last_update_date = SYSDATE,
4146: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4147: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4148: WHERE lease_id = p_lease_id
4149: AND end_date > p_new_lea_term_dt
4150: AND frequency_code <> 'OT';
4151:

Line 4342: IF(NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE') THEN

4338: IF l_ri_end_dt < p_new_lea_term_dt THEN
4339: l_ri_end_dt := p_new_lea_term_dt;
4340: END IF;
4341: pnp_debug_pkg.log('+++++++++++++Now l_ri_end_dt:'||l_ri_end_dt);
4342: IF(NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE') THEN
4343: FOR i IN 1 .. l_item_end_dt_tbl.COUNT LOOP
4344: IF l_item_end_dt_tbl(i).index_period_id IS NOT NULL THEN
4345: IF nvl(l_item_end_dt_tbl(i).item_end_dt,l_max_item_end_dt) < p_new_lea_term_dt THEN
4346: l_item_end_dt_tbl(i).item_end_dt := p_new_lea_term_dt;

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

4437: FOR i IN 1 .. l_item_end_dt_tbl.COUNT LOOP
4438: UPDATE pn_payment_terms_all
4439: SET end_date = l_item_end_dt_tbl(i).item_end_dt,
4440: last_update_date = SYSDATE,
4441: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4442: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4443: WHERE payment_term_id = l_item_end_dt_tbl(i).term_id
4444: AND end_date > l_item_end_dt_tbl(i).item_end_dt
4445: AND frequency_code <> 'OT';

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

4438: UPDATE pn_payment_terms_all
4439: SET end_date = l_item_end_dt_tbl(i).item_end_dt,
4440: last_update_date = SYSDATE,
4441: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4442: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4443: WHERE payment_term_id = l_item_end_dt_tbl(i).term_id
4444: AND end_date > l_item_end_dt_tbl(i).item_end_dt
4445: AND frequency_code <> 'OT';
4446: END LOOP;

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

5561: SET estimated_amount = 0,
5562: actual_amount = 0,
5563: export_currency_amount = 0,
5564: last_update_date = SYSDATE,
5565: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5566: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
5567: WHERE payment_item_id IN (SELECT ppi1.payment_item_id
5568: FROM pn_payment_items_all ppi1,
5569: pn_payment_schedules_all pps

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

5562: actual_amount = 0,
5563: export_currency_amount = 0,
5564: last_update_date = SYSDATE,
5565: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5566: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
5567: WHERE payment_item_id IN (SELECT ppi1.payment_item_id
5568: FROM pn_payment_items_all ppi1,
5569: pn_payment_schedules_all pps
5570: WHERE ppi1.payment_term_id = pay_term_con_cur.payment_term_id

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

5981: ,x_account_class => rec_distributions.account_class
5982: ,x_percentage => rec_distributions.percentage
5983: ,x_line_number => rec_distributions.line_number
5984: ,x_last_update_date => sysdate
5985: ,x_last_updated_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5986: ,x_creation_date => sysdate
5987: ,x_created_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5988: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
5989: ,x_attribute_category => rec_distributions.attribute_category

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

5983: ,x_line_number => rec_distributions.line_number
5984: ,x_last_update_date => sysdate
5985: ,x_last_updated_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5986: ,x_creation_date => sysdate
5987: ,x_created_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5988: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
5989: ,x_attribute_category => rec_distributions.attribute_category
5990: ,x_attribute1 => rec_distributions.attribute1
5991: ,x_attribute2 => rec_distributions.attribute2

Line 5988: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)

5984: ,x_last_update_date => sysdate
5985: ,x_last_updated_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5986: ,x_creation_date => sysdate
5987: ,x_created_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5988: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
5989: ,x_attribute_category => rec_distributions.attribute_category
5990: ,x_attribute1 => rec_distributions.attribute1
5991: ,x_attribute2 => rec_distributions.attribute2
5992: ,x_attribute3 => rec_distributions.attribute3

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

7252: SET start_date = NVL(p_new_lea_term_start_dt, start_date),
7253: end_date = p_new_lea_term_end_dt,
7254: actual_amount = NVL(l_act_amount, actual_amount),
7255: last_update_date = SYSDATE,
7256: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
7257: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
7258: WHERE payment_term_id = p_payment_term_id;
7259:
7260: pnp_debug_pkg.log('UPDATE TERMS +Start+ (-)');

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

7253: end_date = p_new_lea_term_end_dt,
7254: actual_amount = NVL(l_act_amount, actual_amount),
7255: last_update_date = SYSDATE,
7256: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
7257: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
7258: WHERE payment_term_id = p_payment_term_id;
7259:
7260: pnp_debug_pkg.log('UPDATE TERMS +Start+ (-)');
7261: END update_term_dates;

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

7308: UPDATE pn_payment_items_all
7309: SET actual_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
7310: export_currency_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
7311: last_update_date = SYSDATE,
7312: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
7313: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
7314: WHERE payment_item_id = p_item_id;
7315:
7316: ELSE

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

7309: SET actual_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
7310: export_currency_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
7311: last_update_date = SYSDATE,
7312: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
7313: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
7314: WHERE payment_item_id = p_item_id;
7315:
7316: ELSE
7317:

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

7318: UPDATE pn_payment_items_all
7319: SET actual_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
7320: export_currency_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
7321: last_update_date = SYSDATE,
7322: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
7323: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
7324: WHERE payment_item_id = (SELECT ppi.payment_item_id
7325: FROM pn_payment_items_all ppi,
7326: pn_payment_schedules_all pps

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

7319: SET actual_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
7320: export_currency_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
7321: last_update_date = SYSDATE,
7322: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
7323: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
7324: WHERE payment_item_id = (SELECT ppi.payment_item_id
7325: FROM pn_payment_items_all ppi,
7326: pn_payment_schedules_all pps
7327: WHERE ppi.payment_term_id = p_term_id

Line 8345: IF NVL(fnd_profile.value('PN_ERLY_TMNT_B4_LST_APP_SCHD'),'N') = 'Y' THEN

8341:
8342: IF l_lease_context = 'CON' AND p_called_from = 'MAIN' THEN
8343:
8344: pnp_debug_pkg.log('schedules_items - Contraction +Start+ (+)');
8345: IF NVL(fnd_profile.value('PN_ERLY_TMNT_B4_LST_APP_SCHD'),'N') = 'Y' THEN
8346: IF NOT pnp_util_func.mini_retro_enabled THEN
8347: contraction(p_lease_id => p_lease_id,
8348: p_lease_context => l_lease_context,
8349: p_new_lea_term_dt => g_new_lea_term_dt,

Line 8436: IF NVL(fnd_profile.value('PN_ERLY_TMNT_B4_LST_APP_SCHD'),'N') = 'Y' THEN

8432:
8433: ELSIF l_lease_context = 'CONTERM' AND p_called_from = 'MAIN' THEN
8434:
8435: pnp_debug_pkg.log('schedules_items - Payment Term Contraction +Start+ (+)');
8436: IF NVL(fnd_profile.value('PN_ERLY_TMNT_B4_LST_APP_SCHD'),'N') = 'Y' THEN
8437: IF NOT pnp_util_func.mini_retro_enabled THEN
8438: contract_pay_term(p_lease_id => p_lease_id,
8439: p_lease_context => l_lease_context,
8440: p_new_lea_term_dt => g_new_lea_term_dt,