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_SCHEDULES_ITEMS dependencies on PN_RETRO_ADJUSTMENT_PKG

Line 2331: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,

2327: /* AMT-RETRO */
2328: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
2329: create_schedule(g_lease_id, p_lease_change_id, l_sch_dt, l_sch_id, l_pymnt_st_lkp_cd,p_payment_term_id);
2330: ELSE
2331: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,
2332: p_lease_change_id,
2333: p_payment_term_id,
2334: l_sch_dt,
2335: l_sch_id);

Line 2553: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,

2549: /* AMT-RETRO */
2550: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
2551: create_schedule(g_lease_id, p_lease_change_id, p_trgt_dt, l_sch_id, l_pymnt_st_lkp_cd);
2552: ELSE
2553: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,
2554: p_lease_change_id,
2555: p_payment_term_id,
2556: p_trgt_dt,
2557: l_sch_id);

Line 5229: PN_RETRO_ADJUSTMENT_PKG.find_schedule(p_payment_term_rec.lease_id,

5225: l_sch_id,
5226: l_pymnt_st_lkp_cd,
5227: p_payment_term_rec.payment_term_id);
5228: ELSE
5229: PN_RETRO_ADJUSTMENT_PKG.find_schedule(p_payment_term_rec.lease_id,
5230: p_payment_term_rec.lease_change_id,
5231: p_payment_term_rec.payment_term_id,
5232: l_sch_dt,
5233: l_sch_id);

Line 5844: pnp_debug_pkg.log('Calling pn_retro_adjustment_pkg.create_retro_adjustments ...');

5840: pnp_debug_pkg.log('adj_term_rec loop : end_date : '||adj_term_rec.end_date);
5841: pnp_debug_pkg.log('adj_term_rec loop : schedule_day : '||adj_term_rec.schedule_day);
5842: pnp_debug_pkg.log('adj_term_rec loop : actual_amount : '||adj_term_rec.actual_amount);
5843: pnp_debug_pkg.log('adj_term_rec loop : frequency : '||adj_term_rec.frequency_code);
5844: pnp_debug_pkg.log('Calling pn_retro_adjustment_pkg.create_retro_adjustments ...');
5845:
5846: pn_retro_adjustment_pkg.create_retro_adjustments
5847: (p_lease_id => p_lease_id,
5848: p_lease_chg_id => adj_term_rec.lease_change_id,

Line 5846: pn_retro_adjustment_pkg.create_retro_adjustments

5842: pnp_debug_pkg.log('adj_term_rec loop : actual_amount : '||adj_term_rec.actual_amount);
5843: pnp_debug_pkg.log('adj_term_rec loop : frequency : '||adj_term_rec.frequency_code);
5844: pnp_debug_pkg.log('Calling pn_retro_adjustment_pkg.create_retro_adjustments ...');
5845:
5846: pn_retro_adjustment_pkg.create_retro_adjustments
5847: (p_lease_id => p_lease_id,
5848: p_lease_chg_id => adj_term_rec.lease_change_id,
5849: p_term_id => adj_term_rec.payment_term_id,
5850: p_term_start_dt => adj_term_rec.start_date,

Line 6370: p_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type)

6366: -- amount as amount due to new term - amount due
6367: -- to old term
6368: --------------------------------------------------------------------------------
6369: FUNCTION calculate_cash_item (p_term_id NUMBER,
6370: p_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type)
6371: RETURN NUMBER
6372: IS
6373:
6374: l_cash_act_amt NUMBER;

Line 6508: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;

6504: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%TYPE;
6505: l_adjustment VARCHAR2(1);
6506: l_adj_amount NUMBER;
6507:
6508: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;
6509: l_last_sched_draft VARCHAR2(1);
6510: l_count NUMBER; -- Added for Bug 6154106.
6511:
6512: /* find id CASH item exists for a schedule */

Line 6566: pn_retro_adjustment_pkg.create_virtual_schedules

6562: AND payment_term_id = pay_term_con_cur.payment_term_id;
6563:
6564: l_sched_tbl.DELETE;
6565:
6566: pn_retro_adjustment_pkg.create_virtual_schedules
6567: (p_start_date => pay_term_con_cur.start_date,
6568: p_end_date => pay_term_con_cur.end_date,
6569: p_sch_day => pay_term_con_cur.schedule_day,
6570: p_amount => nvl(pay_term_con_cur.actual_amount,pay_term_con_cur.estimated_amount), /*5259155*/

Line 6598: pn_retro_adjustment_pkg.find_schedule( p_lease_id

6594: := TO_DATE(TO_CHAR(pay_term_con_cur.schedule_day)
6595: ||'/'||TO_CHAR(pay_term_con_cur.end_date,'MM/YYYY')
6596: ,'DD/MM/YYYY');
6597:
6598: pn_retro_adjustment_pkg.find_schedule( p_lease_id
6599: ,l_active_lease_change_id
6600: ,p_payment_term_id
6601: ,l_lst_cash_sch_dt
6602: ,l_payment_schedule_id);

Line 6618: pn_retro_adjustment_pkg.find_schedule( p_lease_id

6614: IF l_last_sched_draft = 'N' THEN
6615:
6616: l_lst_cash_sch_dt := l_sched_tbl(l_sched_tbl.LAST).schedule_date;
6617:
6618: pn_retro_adjustment_pkg.find_schedule( p_lease_id
6619: ,l_active_lease_change_id
6620: ,p_payment_term_id
6621: ,l_lst_cash_sch_dt
6622: ,l_payment_schedule_id);

Line 6697: pn_retro_adjustment_pkg.find_schedule( p_lease_id

6693: := TO_DATE(TO_CHAR(pay_term_con_cur.schedule_day)
6694: ||'/'||TO_CHAR(g_new_lea_term_dt,'MM/YYYY')
6695: ,'DD/MM/YYYY');
6696:
6697: pn_retro_adjustment_pkg.find_schedule( p_lease_id
6698: ,l_active_lease_change_id
6699: ,p_payment_term_id
6700: ,l_lst_cash_sch_dt
6701: ,l_payment_schedule_id);

Line 6945: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);

6941:
6942: /* call clean up schedules to delete schedules which do not have any item or
6943: are draft and are outside the lease */
6944:
6945: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);
6946:
6947: /* For Sub_Lease and Third_Party lease, contract tenancies and associated
6948: space assignments as well. */
6949:

Line 7259: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);

7255:
7256: /* call clean up schedules to delete schedules which do not have any item or
7257: are draft and are outside the lease */
7258:
7259: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);
7260: END IF;
7261: ELSE
7262: contract_pay_term(p_lease_id => p_lease_id,
7263: p_lease_context => l_lease_context,