eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_SCHEDULES_ITEMS

Line 1952: pn_schedules_items.Extend_Payment_Term

1948: where payment_term_id = l_ri_term_rec.payment_term_id;
1949:
1950: IF l_status <> 'DRAFT' then
1951:
1952: pn_schedules_items.Extend_Payment_Term
1953: (p_payment_term_rec => l_ri_term_rec,
1954: p_new_lea_comm_dt => l_ls_comm_dt,
1955: p_new_lea_term_dt => p_new_main_lease_term_date, /* bug # 11671285*/
1956: p_mths => l_mths,

Line 2035: pn_schedules_items.Create_Payment_Term

2031: l_term_rec.index_norm_flag := 'Y';
2032: l_term_rec.lease_status := 'MTM';
2033: l_term_rec.status := 'DRAFT';
2034:
2035: pn_schedules_items.Create_Payment_Term
2036: (p_payment_term_rec => l_term_rec,
2037: p_lease_end_date => p_new_main_lease_term_date,
2038: p_term_start_date => l_term_rec.start_date,
2039: p_term_end_date => l_term_rec.end_date ,

Line 2049: l_schd_date := pn_schedules_items.Get_Schedule_Date (

2045:
2046:
2047: ELSIF terms_rec.normalize = 'N' THEN
2048:
2049: l_schd_date := pn_schedules_items.Get_Schedule_Date (
2050: p_lease_id => p_lease_id,
2051: p_day => l_term_rec.schedule_day,
2052: p_start_date => p_old_main_lease_term_date + 1,
2053: p_end_date => p_new_main_lease_term_date,

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

2050: p_lease_id => p_lease_id,
2051: p_day => l_term_rec.schedule_day,
2052: p_start_date => p_old_main_lease_term_date + 1,
2053: p_end_date => p_new_main_lease_term_date,
2054: p_freq => pn_schedules_items.get_frequency(l_term_rec.frequency_code)
2055: );
2056:
2057: l_schd_day := TO_NUMBER(TO_CHAR(l_schd_date,'DD'));
2058: IF l_schd_day <> l_term_rec.schedule_day THEN

Line 2063: pn_schedules_items.Create_Payment_Term

2059: l_term_rec.start_date := p_old_main_lease_term_date + 1;
2060: l_term_rec.end_date := p_new_main_lease_term_date;
2061: l_term_rec.status := 'DRAFT';
2062:
2063: pn_schedules_items.Create_Payment_Term
2064: (p_payment_term_rec => l_term_rec,
2065: p_lease_end_date => p_new_main_lease_term_date,
2066: p_term_start_date => l_term_rec.start_date,
2067: p_term_end_date => l_term_rec.end_date ,

Line 2094: pn_schedules_items.Extend_Payment_Term

2090: WHERE payment_term_id = terms_rec.payment_term_id;
2091: select status into l_status from pn_payment_terms_all where payment_term_id = terms_rec.payment_term_id;
2092: if l_status <> 'DRAFT' then
2093:
2094: pn_schedules_items.Extend_Payment_Term
2095: (p_payment_term_rec => l_term_rec,
2096: p_new_lea_comm_dt => l_ls_comm_dt,
2097: p_new_lea_term_dt => p_new_main_lease_term_date,
2098: p_mths => l_mths,

Line 2171: pn_schedules_items.Extend_Payment_Term

2167:
2168: select status into l_status from pn_payment_terms_all where payment_term_id = l_term(i).term_id;
2169: if l_status <> 'DRAFT' then
2170:
2171: pn_schedules_items.Extend_Payment_Term
2172: (p_payment_term_rec => l_ri_term_rec,
2173: p_new_lea_comm_dt => l_ls_comm_dt,
2174: p_new_lea_term_dt => v_end_date, --p_new_main_lease_term_date,
2175: p_mths => l_mths,

Line 2220: pn_schedules_items.Extend_Payment_Term

2216:
2217: select status into l_status from pn_payment_terms_all where payment_term_id = l_ri_term_rec.payment_term_id;
2218: if l_status <> 'DRAFT' then
2219:
2220: pn_schedules_items.Extend_Payment_Term
2221: (p_payment_term_rec => l_ri_term_rec,
2222: p_new_lea_comm_dt => l_ls_comm_dt,
2223: p_new_lea_term_dt => v_end_date, --p_new_main_lease_term_date, /* bug # 11671285*/
2224: p_mths => l_mths,

Line 2495: l_schd_date := pn_schedules_items.get_schedule_date

2491: THEN
2492: EXIT;
2493: END IF;
2494:
2495: l_schd_date := pn_schedules_items.get_schedule_date
2496: ( p_lease_id => p_lease_id,
2497: p_day => l_term_rec.schedule_day,
2498: p_start_date => l_lease_ext_end_date + 1,
2499: p_end_date => l_lease_term_date,

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

2496: ( p_lease_id => p_lease_id,
2497: p_day => l_term_rec.schedule_day,
2498: p_start_date => l_lease_ext_end_date + 1,
2499: p_end_date => l_lease_term_date,
2500: p_freq => pn_schedules_items.get_frequency(l_term_rec.frequency_code)
2501: );
2502:
2503: l_schd_day := TO_NUMBER(TO_CHAR(l_schd_date,'DD'));
2504:

Line 2527: pn_schedules_items.Insert_Payment_Term

2523: l_term_rec.index_norm_flag := NULL;
2524: l_term_rec.lease_change_id := l_lease_change_id;
2525: l_term_rec.status := 'DRAFT';
2526:
2527: pn_schedules_items.Insert_Payment_Term
2528: ( p_payment_term_rec => l_term_rec,
2529: x_return_status => x_return_status,
2530: x_return_message => v_msg );
2531:

Line 2542: pn_schedules_items.Insert_Payment_Term

2538: l_term_rec.end_date := l_lease_term_date;
2539: l_term_rec.lease_change_id := l_lease_change_id;
2540: l_term_rec.status := 'DRAFT';
2541:
2542: pn_schedules_items.Insert_Payment_Term
2543: ( p_payment_term_rec => l_term_rec,
2544: x_return_status => x_return_status,
2545: x_return_message => v_msg );
2546:

Line 2755: pn_schedules_items.extend_payment_term(

2751: l_lease_term_date := rec.lease_termination_date;
2752: l_mths := rec.p_mts;
2753: END LOOP;
2754:
2755: pn_schedules_items.extend_payment_term(
2756: p_payment_term_rec => l_payment_term_rec,
2757: p_new_lea_comm_dt => l_lease_comm_date,
2758: p_new_lea_term_dt => l_lease_term_date,
2759: p_mths => l_mths,

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

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

Line 2870: pn_schedules_items.update_cash_item

2866: l_payment_item_id := rec.payment_item_id;
2867: END LOOP;
2868:
2869: IF l_payment_item_id IS NOT NULL THEN
2870: pn_schedules_items.update_cash_item
2871: (p_item_id => l_payment_item_id
2872: ,p_term_id => l_payment_term_rec.payment_term_id
2873: ,p_sched_id => l_payment_schedule_id
2874: ,p_act_amt => l_cash_act_amt);

Line 2877: pn_schedules_items.create_cash_items

2873: ,p_sched_id => l_payment_schedule_id
2874: ,p_act_amt => l_cash_act_amt);
2875:
2876: ELSE
2877: pn_schedules_items.create_cash_items
2878: (p_est_amt => l_cash_act_amt,
2879: p_act_amt => l_cash_act_amt,
2880: p_sch_dt => l_lst_cash_sch_dt,
2881: p_sch_id => l_payment_schedule_id,

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

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

Line 2985: pn_schedules_items.update_cash_item

2981: l_payment_item_id := rec.payment_item_id;
2982: END LOOP;
2983:
2984: IF l_payment_item_id IS NOT NULL THEN
2985: pn_schedules_items.update_cash_item
2986: ( p_item_id => l_payment_item_id
2987: ,p_term_id => l_payment_term_rec.payment_term_id
2988: ,p_sched_id => l_payment_schedule_id
2989: ,p_act_amt => l_cash_act_amt);

Line 2992: pn_schedules_items.create_cash_items

2988: ,p_sched_id => l_payment_schedule_id
2989: ,p_act_amt => l_cash_act_amt);
2990:
2991: ELSE
2992: pn_schedules_items.create_cash_items
2993: (p_est_amt => l_cash_act_amt,
2994: p_act_amt => l_cash_act_amt,
2995: p_sch_dt => l_lst_cash_sch_dt,
2996: p_sch_id => l_payment_schedule_id,