APPS.PN_SCHEDULES_ITEMS dependencies on PN_NORM_RENORM_PKG

Line 985: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE procedure. AMT-RETRO */

981:
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;

Line 3369: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE

3365: p_norm_end_dt => g_new_lea_term_dt,
3366: p_rate => p_rate,
3367: p_lease_change_id => p_lease_change_id);
3368: ELSE
3369: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE
3370: (p_lease_context => p_lease_context,
3371: p_lease_id => g_lease_id,
3372: p_term_id => p_payment_term_id,
3373: p_vendor_id => p_vendor_id,

Line 4203: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE

4199: p_norm_end_dt => g_new_lea_term_dt,
4200: p_rate => con_cur.rate,
4201: p_lease_change_id => con_cur.lease_change_id);
4202: ELSE
4203: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE
4204: (p_lease_context => p_lease_context,
4205: p_lease_id => p_lease_id,
4206: p_term_id => con_cur.payment_term_id,
4207: p_vendor_id => con_cur.vendor_id,

Line 4487: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE

4483: ,l_payment_schedule_id);
4484: END LOOP;
4485:
4486: /* AMT-RETRO */
4487: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE
4488: (p_lease_context => p_lease_context,
4489: p_lease_id => p_lease_id,
4490: p_term_id => con_cur.payment_term_id,
4491: p_vendor_id => con_cur.vendor_id,

Line 4945: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE

4941: p_norm_end_dt => g_new_lea_term_dt,
4942: p_rate => l_payment_term_rec.rate,
4943: p_lease_change_id => l_payment_term_rec.lease_change_id);
4944: ELSE
4945: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE
4946: (p_lease_context => p_lease_context,
4947: p_lease_id => g_lease_id,
4948: p_term_id => l_payment_term_rec.payment_term_id,
4949: p_vendor_id => l_payment_term_rec.vendor_id,

Line 5638: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE

5634: l_lease_termination_date),
5635: p_rate => pay_term_con_cur.rate,
5636: p_lease_change_id => pay_term_con_cur.lease_change_id);
5637: ELSE
5638: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE
5639: (p_lease_context => p_lease_context,
5640: p_lease_id => p_lease_id,
5641: p_term_id => pay_term_con_cur.payment_term_id,
5642: p_vendor_id => pay_term_con_cur.vendor_id,

Line 6865: pnp_debug_pkg.log('Calling pn_norm_renorm_pkg.normalize_renormalize ...');

6861: pnp_debug_pkg.log('adj_term_rec loop : schedule_day : '||adj_term_rec.schedule_day);
6862: pnp_debug_pkg.log('adj_term_rec loop : norm_start_date : '||adj_term_rec.norm_start_date);
6863: pnp_debug_pkg.log('adj_term_rec loop : norm_end_date : '||adj_term_rec.norm_end_date);
6864: pnp_debug_pkg.log('adj_term_rec loop : rate : '||adj_term_rec.rate);
6865: pnp_debug_pkg.log('Calling pn_norm_renorm_pkg.normalize_renormalize ...');
6866:
6867: pn_norm_renorm_pkg.normalize_renormalize
6868: (p_lease_context => p_lease_context,
6869: p_lease_id => p_lease_id,

Line 6867: pn_norm_renorm_pkg.normalize_renormalize

6863: pnp_debug_pkg.log('adj_term_rec loop : norm_end_date : '||adj_term_rec.norm_end_date);
6864: pnp_debug_pkg.log('adj_term_rec loop : rate : '||adj_term_rec.rate);
6865: pnp_debug_pkg.log('Calling pn_norm_renorm_pkg.normalize_renormalize ...');
6866:
6867: pn_norm_renorm_pkg.normalize_renormalize
6868: (p_lease_context => p_lease_context,
6869: p_lease_id => p_lease_id,
6870: p_term_id => adj_term_rec.payment_term_id,
6871: p_vendor_id => adj_term_rec.vendor_id,

Line 7789: -- Copied from PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE

7785: AND schedule_date > l_lst_cash_sch_dt
7786: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))
7787: AND payment_term_id = pay_term_con_cur.payment_term_id;
7788: l_count := 0;
7789: -- Copied from PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE
7790: SELECT count(*) into l_count
7791: FROM pn_payment_schedules_all pps,
7792: pn_payment_items_all ppi
7793: WHERE pps.lease_id = p_lease_id

Line 7828: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE

7824: ,p_payment_term_id
7825: ,l_sch_dt_1
7826: ,l_payment_schedule_id);
7827: END LOOP; /* 7149537 */
7828: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE
7829: (p_lease_context => p_lease_context,
7830: p_lease_id => p_lease_id,
7831: p_term_id => pay_term_con_cur.payment_term_id,
7832: p_vendor_id => pay_term_con_cur.vendor_id,