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 PNP_UTIL_FUNC

Line 986: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

982: If pn_schedules_items.g_norm_dt_avl is NULL THEN
983:
984: /* If Retro is enabled - we need correct p_norm_start_date to be passed to
985: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE procedure. AMT-RETRO */
986: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
987: OPEN csr_first_draft_sch(g_lease_id, p_norm_str_dt);
988: FETCH csr_first_draft_sch INTO l_first_draft_sch;
989: CLOSE csr_first_draft_sch;
990:

Line 1102: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

1098:
1099: */
1100:
1101: /* AMT-RETRO */
1102: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
1103: OPEN csr_last_app_sch (g_lease_id, l_comm_dt);
1104: FETCH csr_last_app_sch INTO l_last_app_sch;
1105: CLOSE csr_last_app_sch;
1106:

Line 2986: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

2982: FOR i IN (p_counter + 1) .. p_no_sch
2983: LOOP
2984:
2985: /* AMT-RETRO */
2986: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
2987: create_schedule(g_lease_id, p_lease_change_id, l_sch_dt, l_sch_id, l_pymnt_st_lkp_cd,p_payment_term_id);
2988: ELSE
2989: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,
2990: p_lease_change_id,

Line 3243: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

3239: IF p_pay_trm_typ_code = 'PRE' AND l_pre_pay_flag = 'N'
3240: AND (l_sch_dt = l_pro_sch_dt) THEN
3241:
3242: /* AMT-RETRO */
3243: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
3244: pnp_debug_pkg.log('process_term - Calling create schedule for '|| p_trgt_dt);
3245: create_schedule(g_lease_id, p_lease_change_id, p_trgt_dt, l_sch_id, l_pymnt_st_lkp_cd, p_payment_term_id);
3246: ELSE
3247: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,

Line 3352: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

3348:
3349: IF NVL(p_normalize_flag,'N') = 'Y' THEN
3350:
3351: /* AMT-RETRO */
3352: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
3353: create_normalize_items(p_lease_context => p_lease_context,
3354: p_lease_id => g_lease_id,
3355: p_term_id => p_payment_term_id,
3356: p_vendor_id => p_vendor_id,

Line 4186: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

4182:
4183: l_norm_str_dt := NVL(con_cur.norm_start_date, Get_First_Item_Date(con_cur.payment_term_id));
4184: pnp_debug_pkg.log('CON - MAIN - Re-Normalization - l_norm_str_dt : '||l_norm_str_dt);
4185: /* AMT-RETRO */
4186: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
4187: create_normalize_items(p_lease_context => p_lease_context,
4188: p_lease_id => p_lease_id,
4189: p_term_id => con_cur.payment_term_id,
4190: p_vendor_id => con_cur.vendor_id,

Line 4280: l_item_end_dt_tbl pnp_util_func.item_end_dt_tbl_type;

4276: l_old_lea_term_dt DATE;
4277: l_norm_str_dt DATE;
4278: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
4279: l_norm_trm_exsts BOOLEAN := FALSE;
4280: l_item_end_dt_tbl pnp_util_func.item_end_dt_tbl_type;
4281: i NUMBER;
4282: l_max_item_end_dt DATE := TO_DATE('01/01/0001', 'MM/DD/YYYY');
4283: l_ri_end_dt DATE := TO_DATE('01/01/0001', 'MM/DD/YYYY');
4284: l_term_end_dt DATE := NULL;

Line 4324: l_item_end_dt_tbl := pnp_util_func.fetch_item_end_dates(p_lease_id);

4320: OPEN get_old_lea_term_dt;
4321: FETCH get_old_lea_term_dt INTO l_old_lea_term_dt;
4322: CLOSE get_old_lea_term_dt;
4323:
4324: l_item_end_dt_tbl := pnp_util_func.fetch_item_end_dates(p_lease_id);
4325:
4326: /* Call the index rent contraction routine */
4327:
4328: FOR i IN 1 .. l_item_end_dt_tbl.COUNT LOOP

Line 4367: l_norm_trm_exsts := pnp_util_func.norm_trm_exsts(p_lease_id);

4363: ,p_msg => l_msg
4364: ,p_cutoff_date => NULL
4365: ,p_term_end_dt => l_term_end_dt);
4366:
4367: l_norm_trm_exsts := pnp_util_func.norm_trm_exsts(p_lease_id);
4368: IF l_norm_trm_exsts THEN
4369: FOR i IN 1 .. l_item_end_dt_tbl.COUNT LOOP
4370: IF l_item_end_dt_tbl(i).index_period_id IS NULL THEN
4371: l_item_end_dt_tbl(i).item_end_dt := p_new_lea_term_dt;

Line 4915: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

4911: l_sch_dt := TO_DATE(TO_CHAR(l_payment_term_rec.schedule_day)||'/'
4912: ||TO_CHAR(ADD_MONTHS(l_old_lea_term_dt,1),'MM/YYYY'),
4913: 'DD/MM/YYYY');
4914:
4915: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
4916: OPEN csr_first_draft_sch(g_lease_id, l_norm_str_dt);
4917: FETCH csr_first_draft_sch INTO l_first_draft_sch;
4918: CLOSE csr_first_draft_sch;
4919:

Line 4928: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

4924: END IF;
4925: END IF;
4926:
4927: -- AMT-RETRO
4928: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
4929: create_normalize_items(p_lease_context => p_lease_context,
4930: p_lease_id => g_lease_id,
4931: p_term_id => l_payment_term_rec.payment_term_id,
4932: p_vendor_id => l_payment_term_rec.vendor_id,

Line 5620: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

5616: l_norm_str_dt := NVL(pay_term_con_cur.norm_start_date,
5617: Get_First_Item_Date(pay_term_con_cur.payment_term_id));
5618:
5619: /* AMT-RETRO */
5620: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
5621: create_normalize_items(p_lease_context => p_lease_context,
5622: p_lease_id => p_lease_id,
5623: p_term_id => pay_term_con_cur.payment_term_id,
5624: p_vendor_id => pay_term_con_cur.vendor_id,

Line 6154: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

6150: FOR i IN (l_counter + 1) .. l_no_sch
6151: LOOP
6152: pnp_debug_pkg.log('EXTEND_PAYMENT_TERM - Calling create schedule ');
6153: /* AMT-RETRO */
6154: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
6155: create_schedule(p_payment_term_rec.lease_id,
6156: p_payment_term_rec.lease_change_id,
6157: l_sch_dt,
6158: l_sch_id,

Line 6245: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

6241: l_cash_est_amt := NULL;
6242: END IF;
6243:
6244: l_rec_found := FALSE;
6245: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
6246:
6247: pnp_debug_pkg.log('Retro not enabled... ');
6248:
6249: l_exist_amount := 0;

Line 6607: IF PNP_UTIL_FUNC.RETRO_ENABLED THEN

6603: l_rollover_mode := NULL;
6604: l_schd_day := NULL;
6605: l_schd_date := NULL;
6606: l_payment_term_start_date := l_payment_term_rec.end_date + 1;
6607: IF PNP_UTIL_FUNC.RETRO_ENABLED THEN
6608: IF NVL(l_payment_term_rec.normalize,'N')= 'Y' THEN
6609:
6610: pnp_debug_pkg.log('ROLLOVER - Calling create payment term ..');
6611: l_payment_term_rec.lease_change_id := l_lease_change_id;

Line 8346: IF NOT pnp_util_func.mini_retro_enabled THEN

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,
8350: p_new_lea_comm_dt => g_new_lea_comm_dt,

Line 8437: IF NOT pnp_util_func.mini_retro_enabled THEN

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,
8441: p_new_lea_comm_dt => g_new_lea_comm_dt,

Line 8476: IF pnp_util_func.retro_enabled THEN

8472:
8473: -- Retro Start
8474: ELSIF l_lease_context = 'ADJ' AND p_called_from = 'MAIN' THEN
8475:
8476: IF pnp_util_func.retro_enabled THEN
8477:
8478: pnp_debug_pkg.log('schedules_items - Term Adjustment +Start+ (+)');
8479:
8480: term_id_tab.delete;

Line 8522: IF pnp_util_func.retro_enabled = TRUE THEN

8518: /* Generate the rent normalization report */
8519: Norm_Report(l_lease_context);
8520:
8521: -- Retro Start
8522: IF pnp_util_func.retro_enabled = TRUE THEN
8523: retro_rec_impact_report;
8524: retro_vr_impact_report;
8525: END IF;
8526: -- Retro End