DBA Data[Home] [Help]

APPS.PN_NORM_RENORM_PKG dependencies on PN_SCHEDULES_ITEMS

Line 373: pn_schedules_items.create_cash_items

369:
370: IF l_cash_item = 0 THEN
371: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
372: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
373: pn_schedules_items.create_cash_items
374: (p_est_amt => 0,
375: p_act_amt => 0,
376: p_sch_dt => g_norm_item_tbl(i).schedule_date,
377: p_sch_id => g_norm_item_tbl(i).schedule_id,

Line 570: PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt)));

566: l_partial_start_fraction := 0;
567: l_partial_end_fraction := 0;
568: l_adjustment_amount := 0;
569: l_norm_months := CEIL(MONTHS_BETWEEN(LAST_DAY(p_norm_end_dt),
570: PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt)));
571: fnd_currency.get_info(p_curr_code, l_precision, l_ext_precision, l_min_acct_unit);
572:
573: FOR get_cash_rec IN get_cash_total LOOP
574: l_cash_total := get_cash_rec.total_cash_amount;

Line 830: pn_schedules_items.create_cash_items

826:
827: IF l_cash_item = 0 THEN
828: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
829: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
830: pn_schedules_items.create_cash_items
831: (p_est_amt => 0,
832: p_act_amt => 0,
833: p_sch_dt => g_norm_item_tbl(i).schedule_date,
834: p_sch_id => g_norm_item_tbl(i).schedule_id,

Line 909: AND pps.schedule_date BETWEEN PN_SCHEDULES_ITEMS.FIRST_DAY(c_norm_str_dt)

905: pps.payment_schedule_id payment_schedule_id
906: FROM pn_payment_schedules_all pps,
907: pn_payment_items_all ppi
908: WHERE pps.lease_id = p_lease_id
909: AND pps.schedule_date BETWEEN PN_SCHEDULES_ITEMS.FIRST_DAY(c_norm_str_dt)
910: AND LAST_DAY(g_new_lea_term_dt) --AND LAST_DAY(p_norm_end_dt) /*Bug4956314*/
911: AND pps.payment_status_lookup_code = 'DRAFT' /* bug 6737971 removed
912: ON_HOLD */
913: AND TO_CHAR(pps.schedule_date,'DD') = p_sch_day