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 1418: NVL(fnd_profile.value('USER_ID'),0),

1414: VALUES
1415:
1416: (l_sch_id,
1417: SYSDATE,
1418: NVL(fnd_profile.value('USER_ID'),0),
1419: SYSDATE,
1420: NVL(fnd_profile.value('USER_ID'),0),
1421: NVL(fnd_profile.value('LOGIN_ID'),0),
1422: p_sch_dt,

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

1416: (l_sch_id,
1417: SYSDATE,
1418: NVL(fnd_profile.value('USER_ID'),0),
1419: SYSDATE,
1420: NVL(fnd_profile.value('USER_ID'),0),
1421: NVL(fnd_profile.value('LOGIN_ID'),0),
1422: p_sch_dt,
1423: p_lease_id,
1424: p_lc_id,

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

1417: SYSDATE,
1418: NVL(fnd_profile.value('USER_ID'),0),
1419: SYSDATE,
1420: NVL(fnd_profile.value('USER_ID'),0),
1421: NVL(fnd_profile.value('LOGIN_ID'),0),
1422: p_sch_dt,
1423: p_lease_id,
1424: p_lc_id,
1425: l_pymnt_st_lkp_cd,

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

1473: payment_status_lookup_code,
1474: org_id)
1475: VALUES (l_sch_id,
1476: SYSDATE,
1477: NVL(fnd_profile.value('USER_ID'),0),
1478: SYSDATE,
1479: NVL(fnd_profile.value('USER_ID'),0),
1480: NVL(fnd_profile.value('LOGIN_ID'),0),
1481: l_schd_date,

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

1475: VALUES (l_sch_id,
1476: SYSDATE,
1477: NVL(fnd_profile.value('USER_ID'),0),
1478: SYSDATE,
1479: NVL(fnd_profile.value('USER_ID'),0),
1480: NVL(fnd_profile.value('LOGIN_ID'),0),
1481: l_schd_date,
1482: p_lease_id,
1483: p_lc_id,

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

1476: SYSDATE,
1477: NVL(fnd_profile.value('USER_ID'),0),
1478: SYSDATE,
1479: NVL(fnd_profile.value('USER_ID'),0),
1480: NVL(fnd_profile.value('LOGIN_ID'),0),
1481: l_schd_date,
1482: p_lease_id,
1483: p_lc_id,
1484: l_pymnt_st_lkp_cd,

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

1560: FOR rec IN org_cur LOOP
1561: l_org_id := rec.org_id;
1562: END LOOP;
1563:
1564: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN
1565:
1566: FOR rec IN get_calc_date_recur_bb(p_term_id) LOOP
1567: l_sch_dt := rec.recur_bb_calc_date;
1568: END LOOP;

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

1602:
1603: VALUES
1604: (PN_PAYMENT_ITEMS_S.NEXTVAL,
1605: SYSDATE,
1606: NVL(fnd_profile.value('USER_ID'),0),
1607: SYSDATE,
1608: NVL(fnd_profile.value('USER_ID'),0),
1609: NVL(fnd_profile.value('LOGIN_ID'),0),
1610: ROUND(p_act_amt,l_precision),

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

1604: (PN_PAYMENT_ITEMS_S.NEXTVAL,
1605: SYSDATE,
1606: NVL(fnd_profile.value('USER_ID'),0),
1607: SYSDATE,
1608: NVL(fnd_profile.value('USER_ID'),0),
1609: NVL(fnd_profile.value('LOGIN_ID'),0),
1610: ROUND(p_act_amt,l_precision),
1611: ROUND(p_est_amt,l_precision),
1612: l_sch_dt,

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

1605: SYSDATE,
1606: NVL(fnd_profile.value('USER_ID'),0),
1607: SYSDATE,
1608: NVL(fnd_profile.value('USER_ID'),0),
1609: NVL(fnd_profile.value('LOGIN_ID'),0),
1610: ROUND(p_act_amt,l_precision),
1611: ROUND(p_est_amt,l_precision),
1612: l_sch_dt,
1613: 'CASH',

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

1996: l_org_id := rec.org_id;
1997: END LOOP;
1998:
1999: l_due_date := l_norm_sch_dt;
2000: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN
2001:
2002: FOR rec IN get_calc_date_recur_bb(p_term_id) LOOP
2003: l_due_date := rec.recur_bb_calc_date;
2004: END LOOP;

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

2039: VALUES
2040:
2041: (PN_PAYMENT_ITEMS_S.NEXTVAL,
2042: SYSDATE,
2043: NVL(fnd_profile.value('USER_ID'),0),
2044: SYSDATE,
2045: NVL(fnd_profile.value('USER_ID'),0),
2046: NVL(fnd_profile.value('LOGIN_ID'),0),
2047: l_prec_norm_amt,

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

2041: (PN_PAYMENT_ITEMS_S.NEXTVAL,
2042: SYSDATE,
2043: NVL(fnd_profile.value('USER_ID'),0),
2044: SYSDATE,
2045: NVL(fnd_profile.value('USER_ID'),0),
2046: NVL(fnd_profile.value('LOGIN_ID'),0),
2047: l_prec_norm_amt,
2048: NULL,
2049: l_norm_sch_dt,

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

2042: SYSDATE,
2043: NVL(fnd_profile.value('USER_ID'),0),
2044: SYSDATE,
2045: NVL(fnd_profile.value('USER_ID'),0),
2046: NVL(fnd_profile.value('LOGIN_ID'),0),
2047: l_prec_norm_amt,
2048: NULL,
2049: l_norm_sch_dt,
2050: 'NORMALIZED',

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

2080: UPDATE pn_payment_items_all ppi
2081: SET ppi.actual_amount = l_prec_norm_amt,
2082: ppi.export_currency_amount = l_prec_norm_amt,
2083: ppi.last_update_date = SYSDATE,
2084: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2085: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2086: WHERE ppi.payment_schedule_id IN (SELECT pps.payment_schedule_id
2087: FROM pn_payment_schedules_all pps,
2088: pn_payment_items_all ppi1

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

2081: SET ppi.actual_amount = l_prec_norm_amt,
2082: ppi.export_currency_amount = l_prec_norm_amt,
2083: ppi.last_update_date = SYSDATE,
2084: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2085: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2086: WHERE ppi.payment_schedule_id IN (SELECT pps.payment_schedule_id
2087: FROM pn_payment_schedules_all pps,
2088: pn_payment_items_all ppi1
2089: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id

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

2111: UPDATE pn_payment_items_all ppi
2112: SET ppi.actual_amount = l_prec_norm_amt,
2113: ppi.export_currency_amount = l_prec_norm_amt,
2114: ppi.last_update_date = SYSDATE,
2115: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2116: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2117: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2118: FROM pn_payment_schedules_all pps,
2119: pn_payment_items_all ppi1

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

2112: SET ppi.actual_amount = l_prec_norm_amt,
2113: ppi.export_currency_amount = l_prec_norm_amt,
2114: ppi.last_update_date = SYSDATE,
2115: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2116: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2117: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2118: FROM pn_payment_schedules_all pps,
2119: pn_payment_items_all ppi1
2120: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id

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

2145: UPDATE pn_payment_items_all ppi
2146: SET ppi.actual_amount = l_prec_norm_amt,
2147: ppi.export_currency_amount = l_prec_norm_amt,
2148: ppi.last_update_date = SYSDATE,
2149: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2150: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2151: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2152: FROM pn_payment_schedules_all pps,
2153: pn_payment_items_all ppi1

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

2146: SET ppi.actual_amount = l_prec_norm_amt,
2147: ppi.export_currency_amount = l_prec_norm_amt,
2148: ppi.last_update_date = SYSDATE,
2149: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2150: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2151: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2152: FROM pn_payment_schedules_all pps,
2153: pn_payment_items_all ppi1
2154: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id

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

2746: SET estimated_amount = l_cash_est_amt,
2747: actual_amount = l_cash_act_amt,
2748: export_currency_amount = l_cash_act_amt,
2749: last_update_date = SYSDATE,
2750: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2751: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2752: WHERE payment_item_id = (SELECT ppi1.payment_item_id
2753: FROM pn_payment_items_all ppi1,
2754: pn_payment_schedules_all pps

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

2747: actual_amount = l_cash_act_amt,
2748: export_currency_amount = l_cash_act_amt,
2749: last_update_date = SYSDATE,
2750: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2751: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2752: WHERE payment_item_id = (SELECT ppi1.payment_item_id
2753: FROM pn_payment_items_all ppi1,
2754: pn_payment_schedules_all pps
2755: WHERE ppi1.payment_term_id = p_term_id

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

3233: UPDATE pn_tenancies_all
3234: SET expiration_date = p_new_lea_term_dt,
3235: fin_oblig_end_date = p_new_lea_term_dt,
3236: last_update_date = SYSDATE,
3237: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3238: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3239: WHERE tenancy_id = l_tenancy_Id;
3240:
3241: pnp_debug_pkg.log('CON_TEN=>UPD : Tenancy Early Terminated...');

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

3234: SET expiration_date = p_new_lea_term_dt,
3235: fin_oblig_end_date = p_new_lea_term_dt,
3236: last_update_date = SYSDATE,
3237: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3238: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3239: WHERE tenancy_id = l_tenancy_Id;
3240:
3241: pnp_debug_pkg.log('CON_TEN=>UPD : Tenancy Early Terminated...');
3242:

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

3377:
3378: UPDATE pn_payment_terms_all
3379: SET end_date = p_new_lea_term_dt,
3380: last_update_date = SYSDATE,
3381: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3382: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3383: WHERE lease_id = p_lease_id
3384: AND end_date > p_new_lea_term_dt
3385: AND frequency_code <> 'OT';

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

3378: UPDATE pn_payment_terms_all
3379: SET end_date = p_new_lea_term_dt,
3380: last_update_date = SYSDATE,
3381: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3382: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3383: WHERE lease_id = p_lease_id
3384: AND end_date > p_new_lea_term_dt
3385: AND frequency_code <> 'OT';
3386:

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

3552: IF l_ri_end_dt < p_new_lea_term_dt THEN
3553: l_ri_end_dt := p_new_lea_term_dt;
3554: END IF;
3555: pnp_debug_pkg.log('+++++++++++++Now l_ri_end_dt:'||l_ri_end_dt);
3556: IF(NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE') THEN
3557: FOR i IN 1 .. l_item_end_dt_tbl.COUNT LOOP
3558: IF l_item_end_dt_tbl(i).index_period_id IS NOT NULL THEN
3559: IF l_item_end_dt_tbl(i).item_end_dt < p_new_lea_term_dt THEN
3560: l_item_end_dt_tbl(i).item_end_dt := p_new_lea_term_dt;

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

3651: FOR i IN 1 .. l_item_end_dt_tbl.COUNT LOOP
3652: UPDATE pn_payment_terms_all
3653: SET end_date = l_item_end_dt_tbl(i).item_end_dt,
3654: last_update_date = SYSDATE,
3655: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3656: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3657: WHERE payment_term_id = l_item_end_dt_tbl(i).term_id
3658: AND end_date > l_item_end_dt_tbl(i).item_end_dt
3659: AND frequency_code <> 'OT';

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

3652: UPDATE pn_payment_terms_all
3653: SET end_date = l_item_end_dt_tbl(i).item_end_dt,
3654: last_update_date = SYSDATE,
3655: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3656: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3657: WHERE payment_term_id = l_item_end_dt_tbl(i).term_id
3658: AND end_date > l_item_end_dt_tbl(i).item_end_dt
3659: AND frequency_code <> 'OT';
3660: END LOOP;

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

4657: SET estimated_amount = 0,
4658: actual_amount = 0,
4659: export_currency_amount = 0,
4660: last_update_date = SYSDATE,
4661: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4662: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4663: WHERE payment_item_id IN (SELECT ppi1.payment_item_id
4664: FROM pn_payment_items_all ppi1,
4665: pn_payment_schedules_all pps

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

4658: actual_amount = 0,
4659: export_currency_amount = 0,
4660: last_update_date = SYSDATE,
4661: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4662: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4663: WHERE payment_item_id IN (SELECT ppi1.payment_item_id
4664: FROM pn_payment_items_all ppi1,
4665: pn_payment_schedules_all pps
4666: WHERE ppi1.payment_term_id = pay_term_con_cur.payment_term_id

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

5064: ,x_account_class => rec_distributions.account_class
5065: ,x_percentage => rec_distributions.percentage
5066: ,x_line_number => rec_distributions.line_number
5067: ,x_last_update_date => sysdate
5068: ,x_last_updated_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5069: ,x_creation_date => sysdate
5070: ,x_created_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5071: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
5072: ,x_attribute_category => rec_distributions.attribute_category

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

5066: ,x_line_number => rec_distributions.line_number
5067: ,x_last_update_date => sysdate
5068: ,x_last_updated_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5069: ,x_creation_date => sysdate
5070: ,x_created_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5071: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
5072: ,x_attribute_category => rec_distributions.attribute_category
5073: ,x_attribute1 => rec_distributions.attribute1
5074: ,x_attribute2 => rec_distributions.attribute2

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

5067: ,x_last_update_date => sysdate
5068: ,x_last_updated_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5069: ,x_creation_date => sysdate
5070: ,x_created_by => NVL(fnd_profile.VALUE ('USER_ID'), 0)
5071: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
5072: ,x_attribute_category => rec_distributions.attribute_category
5073: ,x_attribute1 => rec_distributions.attribute1
5074: ,x_attribute2 => rec_distributions.attribute2
5075: ,x_attribute3 => rec_distributions.attribute3

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

6266: SET start_date = NVL(p_new_lea_term_start_dt, start_date),
6267: end_date = p_new_lea_term_end_dt,
6268: actual_amount = NVL(l_act_amount, actual_amount),
6269: last_update_date = SYSDATE,
6270: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
6271: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
6272: WHERE payment_term_id = p_payment_term_id;
6273:
6274: pnp_debug_pkg.log('UPDATE TERMS +Start+ (-)');

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

6267: end_date = p_new_lea_term_end_dt,
6268: actual_amount = NVL(l_act_amount, actual_amount),
6269: last_update_date = SYSDATE,
6270: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
6271: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
6272: WHERE payment_term_id = p_payment_term_id;
6273:
6274: pnp_debug_pkg.log('UPDATE TERMS +Start+ (-)');
6275: END update_term_dates;

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

6322: UPDATE pn_payment_items_all
6323: SET actual_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
6324: export_currency_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
6325: last_update_date = SYSDATE,
6326: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
6327: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
6328: WHERE payment_item_id = p_item_id;
6329:
6330: ELSE

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

6323: SET actual_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
6324: export_currency_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
6325: last_update_date = SYSDATE,
6326: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
6327: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
6328: WHERE payment_item_id = p_item_id;
6329:
6330: ELSE
6331:

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

6332: UPDATE pn_payment_items_all
6333: SET actual_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
6334: export_currency_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
6335: last_update_date = SYSDATE,
6336: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
6337: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
6338: WHERE payment_item_id = (SELECT ppi.payment_item_id
6339: FROM pn_payment_items_all ppi,
6340: pn_payment_schedules_all pps

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

6333: SET actual_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
6334: export_currency_amount = ROUND(actual_amount + NVL(p_act_amt,0), l_precision),
6335: last_update_date = SYSDATE,
6336: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
6337: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
6338: WHERE payment_item_id = (SELECT ppi.payment_item_id
6339: FROM pn_payment_items_all ppi,
6340: pn_payment_schedules_all pps
6341: WHERE ppi.payment_term_id = p_term_id

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

7146:
7147: IF l_lease_context = 'CON' AND p_called_from = 'MAIN' THEN
7148:
7149: pnp_debug_pkg.log('schedules_items - Contraction +Start+ (+)');
7150: IF NVL(fnd_profile.value('PN_ERLY_TMNT_B4_LST_APP_SCHD'),'N') = 'Y' THEN
7151: IF NOT pnp_util_func.mini_retro_enabled THEN
7152: contraction(p_lease_id => p_lease_id,
7153: p_lease_context => l_lease_context,
7154: p_new_lea_term_dt => g_new_lea_term_dt,

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

7230:
7231: ELSIF l_lease_context = 'CONTERM' AND p_called_from = 'MAIN' THEN
7232:
7233: pnp_debug_pkg.log('schedules_items - Payment Term Contraction +Start+ (+)');
7234: IF NVL(fnd_profile.value('PN_ERLY_TMNT_B4_LST_APP_SCHD'),'N') = 'Y' THEN
7235: IF NOT pnp_util_func.mini_retro_enabled THEN
7236: contract_pay_term(p_lease_id => p_lease_id,
7237: p_lease_context => l_lease_context,
7238: p_new_lea_term_dt => g_new_lea_term_dt,