APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_RETRO_ADJUSTMENT_PKG

Line 2475: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;

2471: l_lease_comm_date DATE;
2472: l_lease_term_date DATE;
2473: l_mths NUMBER;
2474: l_appr_sched_exists BOOLEAN := FALSE;
2475: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;
2476: l_lease_id NUMBER;
2477: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;
2478: l_lst_cash_sch_dt DATE;
2479: l_var_rent_id NUMBER;

Line 2669: pn_retro_adjustment_pkg.create_virtual_schedules

2665: AND payment_term_id = l_payment_term_rec.payment_term_id;
2666:
2667: l_sched_tbl.DELETE;
2668:
2669: pn_retro_adjustment_pkg.create_virtual_schedules
2670: (p_start_date => l_payment_term_rec.start_date,
2671: p_end_date => p_new_termination_date,
2672: p_sch_day => l_payment_term_rec.schedule_day,
2673: p_amount => nvl(l_payment_term_rec.actual_amount,l_payment_term_rec.estimated_amount),

Line 2711: pn_retro_adjustment_pkg.find_schedule( l_lease_id

2707: ||'/'||TO_CHAR(l_payment_term_rec.end_date,'MM/YYYY')
2708: ,'DD/MM/YYYY');
2709: l_lease_change_id := pn_schedules_items.Get_Lease_Change_Id(l_lease_id);
2710:
2711: pn_retro_adjustment_pkg.find_schedule( l_lease_id
2712: ,l_lease_change_id
2713: ,l_payment_term_rec.payment_term_id
2714: ,l_lst_cash_sch_dt
2715: ,l_payment_schedule_id);

Line 2782: pn_retro_adjustment_pkg.create_virtual_schedules

2778: AND payment_term_id = l_payment_term_rec.payment_term_id;
2779:
2780: l_sched_tbl.DELETE;
2781:
2782: pn_retro_adjustment_pkg.create_virtual_schedules
2783: (p_start_date => l_payment_term_rec.start_date,
2784: p_end_date => p_new_termination_date,
2785: p_sch_day => l_payment_term_rec.schedule_day,
2786: p_amount => nvl(l_payment_term_rec.actual_amount,l_payment_term_rec.estimated_amount),

Line 2825: pn_retro_adjustment_pkg.find_schedule( l_lease_id

2821: ,'DD/MM/YYYY');
2822:
2823: l_lease_change_id := pn_schedules_items.Get_Lease_Change_Id(l_lease_id);
2824:
2825: pn_retro_adjustment_pkg.find_schedule( l_lease_id
2826: ,l_lease_change_id
2827: ,l_payment_term_rec.payment_term_id
2828: ,l_lst_cash_sch_dt
2829: ,l_payment_schedule_id);

Line 2866: pn_retro_adjustment_pkg.cleanup_schedules(l_lease_id);

2862:
2863: END IF;
2864: END LOOP;
2865:
2866: pn_retro_adjustment_pkg.cleanup_schedules(l_lease_id);
2867:
2868: END IF;
2869:
2870: --Recalculate Natural Breakpoint if any changes in Lease Payment Terms