DBA Data[Home] [Help]

APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_SCHEDULES_ITEMS

Line 1984: pn_schedules_items.Create_Payment_Term

1980: l_term_rec.index_norm_flag := 'Y';
1981: l_term_rec.lease_status := 'MTM';
1982: l_term_rec.status := 'DRAFT';
1983:
1984: pn_schedules_items.Create_Payment_Term
1985: (p_payment_term_rec => l_term_rec,
1986: p_lease_end_date => p_new_main_lease_term_date,
1987: p_term_start_date => l_term_rec.start_date,
1988: p_term_end_date => l_term_rec.end_date ,

Line 1998: l_schd_date := pn_schedules_items.Get_Schedule_Date (

1994:
1995:
1996: ELSIF terms_rec.normalize = 'N' THEN
1997:
1998: l_schd_date := pn_schedules_items.Get_Schedule_Date (
1999: p_lease_id => p_lease_id,
2000: p_day => l_term_rec.schedule_day,
2001: p_start_date => p_old_main_lease_term_date + 1,
2002: p_end_date => p_new_main_lease_term_date,

Line 2003: p_freq => pn_schedules_items.get_frequency(l_term_rec.frequency_code)

1999: p_lease_id => p_lease_id,
2000: p_day => l_term_rec.schedule_day,
2001: p_start_date => p_old_main_lease_term_date + 1,
2002: p_end_date => p_new_main_lease_term_date,
2003: p_freq => pn_schedules_items.get_frequency(l_term_rec.frequency_code)
2004: );
2005:
2006: l_schd_day := TO_NUMBER(TO_CHAR(l_schd_date,'DD'));
2007: IF l_schd_day <> l_term_rec.schedule_day THEN

Line 2012: pn_schedules_items.Create_Payment_Term

2008: l_term_rec.start_date := p_old_main_lease_term_date + 1;
2009: l_term_rec.end_date := p_new_main_lease_term_date;
2010: l_term_rec.status := 'DRAFT';
2011:
2012: pn_schedules_items.Create_Payment_Term
2013: (p_payment_term_rec => l_term_rec,
2014: p_lease_end_date => p_new_main_lease_term_date,
2015: p_term_start_date => l_term_rec.start_date,
2016: p_term_end_date => l_term_rec.end_date ,

Line 2033: pn_schedules_items.Extend_Payment_Term

2029: last_updated_by = fnd_global.user_id,
2030: last_update_login = fnd_global.login_id
2031: WHERE payment_term_id = terms_rec.payment_term_id;
2032:
2033: pn_schedules_items.Extend_Payment_Term
2034: (p_payment_term_rec => l_term_rec,
2035: p_new_lea_comm_dt => l_ls_comm_dt,
2036: p_new_lea_term_dt => p_new_main_lease_term_date,
2037: p_mths => l_mths,

Line 2095: pn_schedules_items.Extend_Payment_Term

2091: last_updated_by = fnd_global.user_id,
2092: last_update_login = fnd_global.login_id
2093: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
2094:
2095: pn_schedules_items.Extend_Payment_Term
2096: (p_payment_term_rec => l_ri_term_rec,
2097: p_new_lea_comm_dt => l_ls_comm_dt,
2098: p_new_lea_term_dt => p_new_main_lease_term_date,
2099: p_mths => l_mths,

Line 2369: l_schd_date := pn_schedules_items.get_schedule_date

2365: THEN
2366: EXIT;
2367: END IF;
2368:
2369: l_schd_date := pn_schedules_items.get_schedule_date
2370: ( p_lease_id => p_lease_id,
2371: p_day => l_term_rec.schedule_day,
2372: p_start_date => l_lease_ext_end_date + 1,
2373: p_end_date => l_lease_term_date,

Line 2374: p_freq => pn_schedules_items.get_frequency(l_term_rec.frequency_code)

2370: ( p_lease_id => p_lease_id,
2371: p_day => l_term_rec.schedule_day,
2372: p_start_date => l_lease_ext_end_date + 1,
2373: p_end_date => l_lease_term_date,
2374: p_freq => pn_schedules_items.get_frequency(l_term_rec.frequency_code)
2375: );
2376:
2377: l_schd_day := TO_NUMBER(TO_CHAR(l_schd_date,'DD'));
2378:

Line 2401: pn_schedules_items.Insert_Payment_Term

2397: l_term_rec.index_norm_flag := NULL;
2398: l_term_rec.lease_change_id := l_lease_change_id;
2399: l_term_rec.status := 'DRAFT';
2400:
2401: pn_schedules_items.Insert_Payment_Term
2402: ( p_payment_term_rec => l_term_rec,
2403: x_return_status => x_return_status,
2404: x_return_message => v_msg );
2405:

Line 2416: pn_schedules_items.Insert_Payment_Term

2412: l_term_rec.end_date := l_lease_term_date;
2413: l_term_rec.lease_change_id := l_lease_change_id;
2414: l_term_rec.status := 'DRAFT';
2415:
2416: pn_schedules_items.Insert_Payment_Term
2417: ( p_payment_term_rec => l_term_rec,
2418: x_return_status => x_return_status,
2419: x_return_message => v_msg );
2420:

Line 2610: pn_schedules_items.extend_payment_term(

2606: l_lease_term_date := rec.lease_termination_date;
2607: l_mths := rec.p_mts;
2608: END LOOP;
2609:
2610: pn_schedules_items.extend_payment_term(
2611: p_payment_term_rec => l_payment_term_rec,
2612: p_new_lea_comm_dt => l_lease_comm_date,
2613: p_new_lea_term_dt => l_lease_term_date,
2614: p_mths => l_mths,

Line 2709: l_lease_change_id := pn_schedules_items.Get_Lease_Change_Id(l_lease_id);

2705: l_lst_cash_sch_dt
2706: := TO_DATE(TO_CHAR(l_payment_term_rec.schedule_day)
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

Line 2724: pn_schedules_items.update_cash_item

2720: l_payment_item_id := rec.payment_item_id;
2721: END LOOP;
2722:
2723: IF l_payment_item_id IS NOT NULL THEN
2724: pn_schedules_items.update_cash_item
2725: (p_item_id => l_payment_item_id
2726: ,p_term_id => l_payment_term_rec.payment_term_id
2727: ,p_sched_id => l_payment_schedule_id
2728: ,p_act_amt => l_cash_act_amt);

Line 2731: pn_schedules_items.create_cash_items

2727: ,p_sched_id => l_payment_schedule_id
2728: ,p_act_amt => l_cash_act_amt);
2729:
2730: ELSE
2731: pn_schedules_items.create_cash_items
2732: (p_est_amt => l_cash_act_amt,
2733: p_act_amt => l_cash_act_amt,
2734: p_sch_dt => l_lst_cash_sch_dt,
2735: p_sch_id => l_payment_schedule_id,

Line 2823: l_lease_change_id := pn_schedules_items.Get_Lease_Change_Id(l_lease_id);

2819: := TO_DATE(TO_CHAR(l_payment_term_rec.schedule_day)
2820: ||'/'||TO_CHAR(p_new_termination_date,'MM/YYYY')
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

Line 2838: pn_schedules_items.update_cash_item

2834: l_payment_item_id := rec.payment_item_id;
2835: END LOOP;
2836:
2837: IF l_payment_item_id IS NOT NULL THEN
2838: pn_schedules_items.update_cash_item
2839: ( p_item_id => l_payment_item_id
2840: ,p_term_id => l_payment_term_rec.payment_term_id
2841: ,p_sched_id => l_payment_schedule_id
2842: ,p_act_amt => l_cash_act_amt);

Line 2845: pn_schedules_items.create_cash_items

2841: ,p_sched_id => l_payment_schedule_id
2842: ,p_act_amt => l_cash_act_amt);
2843:
2844: ELSE
2845: pn_schedules_items.create_cash_items
2846: (p_est_amt => l_cash_act_amt,
2847: p_act_amt => l_cash_act_amt,
2848: p_sch_dt => l_lst_cash_sch_dt,
2849: p_sch_id => l_payment_schedule_id,