APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_RETRO_ADJUSTMENT_PKG

Line 2604: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;

2600: l_lease_comm_date DATE;
2601: l_lease_term_date DATE;
2602: l_mths NUMBER;
2603: l_appr_sched_exists BOOLEAN := FALSE;
2604: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;
2605: l_lease_id NUMBER;
2606: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;
2607: l_lst_cash_sch_dt DATE;
2608: l_var_rent_id NUMBER;

Line 2814: pn_retro_adjustment_pkg.create_virtual_schedules

2810: AND payment_term_id = l_payment_term_rec.payment_term_id;
2811:
2812: l_sched_tbl.DELETE;
2813:
2814: pn_retro_adjustment_pkg.create_virtual_schedules
2815: (p_start_date => l_payment_term_rec.start_date,
2816: p_end_date => p_new_termination_date,
2817: p_sch_day => l_payment_term_rec.schedule_day,
2818: p_amount => nvl(l_payment_term_rec.actual_amount,l_payment_term_rec.estimated_amount),

Line 2857: pn_retro_adjustment_pkg.find_schedule( l_lease_id

2853: ||'/'||TO_CHAR(l_payment_term_rec.end_date,'MM/YYYY')
2854: ,'DD/MM/YYYY');
2855: l_lease_change_id := pn_schedules_items.Get_Lease_Change_Id(l_lease_id);
2856:
2857: pn_retro_adjustment_pkg.find_schedule( l_lease_id
2858: ,l_lease_change_id
2859: ,l_payment_term_rec.payment_term_id
2860: ,l_lst_cash_sch_dt
2861: ,l_payment_schedule_id);

Line 2928: pn_retro_adjustment_pkg.create_virtual_schedules

2924: AND payment_term_id = l_payment_term_rec.payment_term_id;
2925:
2926: l_sched_tbl.DELETE;
2927:
2928: pn_retro_adjustment_pkg.create_virtual_schedules
2929: (p_start_date => l_payment_term_rec.start_date,
2930: p_end_date => p_new_termination_date,
2931: p_sch_day => l_payment_term_rec.schedule_day,
2932: p_amount => nvl(l_payment_term_rec.actual_amount,l_payment_term_rec.estimated_amount),

Line 2972: pn_retro_adjustment_pkg.find_schedule( l_lease_id

2968: ,'DD/MM/YYYY');
2969:
2970: l_lease_change_id := pn_schedules_items.Get_Lease_Change_Id(l_lease_id);
2971:
2972: pn_retro_adjustment_pkg.find_schedule( l_lease_id
2973: ,l_lease_change_id
2974: ,l_payment_term_rec.payment_term_id
2975: ,l_lst_cash_sch_dt
2976: ,l_payment_schedule_id);

Line 3013: pn_retro_adjustment_pkg.cleanup_schedules(l_lease_id);

3009:
3010: END IF;
3011: END LOOP;
3012:
3013: pn_retro_adjustment_pkg.cleanup_schedules(l_lease_id);
3014:
3015: END IF;
3016:
3017: --Recalculate Natural Breakpoint if any changes in Lease Payment Terms