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 2989: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,

2985: /* AMT-RETRO */
2986: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
2987: create_schedule(g_lease_id, p_lease_change_id, l_sch_dt, l_sch_id, l_pymnt_st_lkp_cd,p_payment_term_id);
2988: ELSE
2989: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,
2990: p_lease_change_id,
2991: p_payment_term_id,
2992: l_sch_dt,
2993: l_sch_id);

Line 3247: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,

3243: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN
3244: pnp_debug_pkg.log('process_term - Calling create schedule for '|| p_trgt_dt);
3245: create_schedule(g_lease_id, p_lease_change_id, p_trgt_dt, l_sch_id, l_pymnt_st_lkp_cd, p_payment_term_id);
3246: ELSE
3247: PN_RETRO_ADJUSTMENT_PKG.find_schedule(g_lease_id,
3248: p_lease_change_id,
3249: p_payment_term_id,
3250: p_trgt_dt,
3251: l_sch_id);

Line 4265: -- 17-MAY-10 asahoo Bug#9214283 - Calling the API pn_retro_adjustment_pkg.find_schedule to create adjustment amount

4261: -- option for lease early termination
4262: -- 24-MAR-10 acprakas Bug#9323699. Modified to use condition nvl(l_item_end_dt_tbl(i).item_end_dt,l_max_item_end_dt)
4263: -- so that l_item_end_dt_tbl(i).item_end_dt gets set to new lease termination date
4264: -- when l_item_end_dt_tbl(i).item_end_dt is null.
4265: -- 17-MAY-10 asahoo Bug#9214283 - Calling the API pn_retro_adjustment_pkg.find_schedule to create adjustment amount
4266: -- if there is no draft schedule available
4267: --------------------------------------------------------------------------------------------
4268: PROCEDURE contraction_by_itm_end_dt (p_lease_id NUMBER,
4269: p_lease_context VARCHAR2,

Line 4479: pn_retro_adjustment_pkg.find_schedule(p_lease_id

4475: pnp_debug_pkg.log('CONTRACTION_BY_ITM_END_DT - MAIN - Calling find_schedule lease_change_id : '|| con_cur.lease_change_id);
4476: pnp_debug_pkg.log('CONTRACTION_BY_ITM_END_DT - MAIN - Calling find_schedule payment_term_id : '|| con_cur.payment_term_id);
4477: pnp_debug_pkg.log('CONTRACTION_BY_ITM_END_DT - MAIN - Calling l_sch_dt_1: '|| l_sch_dt_1);
4478: pnp_debug_pkg.log('CONTRACTION_BY_ITM_END_DT - MAIN - Calling l_payment_schedule_id : '|| l_payment_schedule_id);
4479: pn_retro_adjustment_pkg.find_schedule(p_lease_id
4480: ,con_cur.lease_change_id
4481: ,con_cur.payment_term_id
4482: ,l_sch_dt_1
4483: ,l_payment_schedule_id);

Line 5046: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);

5042:
5043: END IF;
5044: END IF;
5045:
5046: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);
5047:
5048: /* Now create the schedules and items for the new terms that have been added along with
5049: the expansion of the main lease */
5050:

Line 6162: PN_RETRO_ADJUSTMENT_PKG.find_schedule(p_payment_term_rec.lease_id,

6158: l_sch_id,
6159: l_pymnt_st_lkp_cd,
6160: p_payment_term_rec.payment_term_id);
6161: ELSE
6162: PN_RETRO_ADJUSTMENT_PKG.find_schedule(p_payment_term_rec.lease_id,
6163: p_payment_term_rec.lease_change_id,
6164: p_payment_term_rec.payment_term_id,
6165: l_sch_dt,
6166: l_sch_id);

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

6819: pnp_debug_pkg.log('adj_term_rec loop : end_date : '||adj_term_rec.end_date);
6820: pnp_debug_pkg.log('adj_term_rec loop : schedule_day : '||adj_term_rec.schedule_day);
6821: pnp_debug_pkg.log('adj_term_rec loop : actual_amount : '||adj_term_rec.actual_amount);
6822: pnp_debug_pkg.log('adj_term_rec loop : frequency : '||adj_term_rec.frequency_code);
6823: pnp_debug_pkg.log('Calling pn_retro_adjustment_pkg.create_retro_adjustments ...');
6824:
6825: pn_retro_adjustment_pkg.create_retro_adjustments
6826: (p_lease_id => p_lease_id,
6827: p_lease_chg_id => adj_term_rec.lease_change_id,

Line 6825: pn_retro_adjustment_pkg.create_retro_adjustments

6821: pnp_debug_pkg.log('adj_term_rec loop : actual_amount : '||adj_term_rec.actual_amount);
6822: pnp_debug_pkg.log('adj_term_rec loop : frequency : '||adj_term_rec.frequency_code);
6823: pnp_debug_pkg.log('Calling pn_retro_adjustment_pkg.create_retro_adjustments ...');
6824:
6825: pn_retro_adjustment_pkg.create_retro_adjustments
6826: (p_lease_id => p_lease_id,
6827: p_lease_chg_id => adj_term_rec.lease_change_id,
6828: p_term_id => adj_term_rec.payment_term_id,
6829: p_term_start_dt => adj_term_rec.start_date,

Line 7356: p_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type)

7352: -- amount as amount due to new term - amount due
7353: -- to old term
7354: --------------------------------------------------------------------------------
7355: FUNCTION calculate_cash_item (p_term_id NUMBER,
7356: p_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type)
7357: RETURN NUMBER
7358: IS
7359:
7360: l_cash_act_amt NUMBER;

Line 7503: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;

7499: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%TYPE;
7500: l_adjustment VARCHAR2(1);
7501: l_adj_amount NUMBER;
7502:
7503: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;
7504: l_last_sched_draft VARCHAR2(1);
7505: l_count NUMBER; -- Added for Bug 6154106.
7506: l_amd_comn_date DATE; /* 7149537 */
7507: l_sch_dt_1 DATE; /* 7149537 */

Line 7652: pn_retro_adjustment_pkg.create_virtual_schedules

7648: AND payment_term_id = pay_term_con_cur.payment_term_id;
7649:
7650: l_sched_tbl.DELETE;
7651:
7652: pn_retro_adjustment_pkg.create_virtual_schedules
7653: (p_start_date => pay_term_con_cur.start_date,
7654: p_end_date => pay_term_con_cur.end_date,
7655: p_sch_day => pay_term_con_cur.schedule_day,
7656: p_amount => nvl(pay_term_con_cur.actual_amount,pay_term_con_cur.estimated_amount), /*5259155*/

Line 7685: pn_retro_adjustment_pkg.find_schedule( p_lease_id

7681: := TO_DATE(TO_CHAR(pay_term_con_cur.schedule_day)
7682: ||'/'||TO_CHAR(pay_term_con_cur.end_date,'MM/YYYY')
7683: ,'DD/MM/YYYY');
7684:
7685: pn_retro_adjustment_pkg.find_schedule( p_lease_id
7686: ,l_active_lease_change_id
7687: ,p_payment_term_id
7688: ,l_lst_cash_sch_dt
7689: ,l_payment_schedule_id);

Line 7708: pn_retro_adjustment_pkg.find_schedule( p_lease_id

7704: := TO_DATE(TO_CHAR(pay_term_con_cur.schedule_day)
7705: ||'/'||TO_CHAR(pay_term_con_cur.end_date,'MM/YYYY')
7706: ,'DD/MM/YYYY'); /* 8608490 */
7707:
7708: pn_retro_adjustment_pkg.find_schedule( p_lease_id
7709: ,l_active_lease_change_id
7710: ,p_payment_term_id
7711: ,l_lst_cash_sch_dt
7712: ,l_payment_schedule_id);

Line 7810: pn_retro_adjustment_pkg.find_schedule( p_lease_id

7806: := TO_DATE(TO_CHAR(pay_term_con_cur.schedule_day)
7807: ||'/'||TO_CHAR(g_new_lea_term_dt,'MM/YYYY')
7808: ,'DD/MM/YYYY');
7809:
7810: pn_retro_adjustment_pkg.find_schedule( p_lease_id
7811: ,l_active_lease_change_id
7812: ,p_payment_term_id
7813: ,l_lst_cash_sch_dt
7814: ,l_payment_schedule_id);

Line 7822: pn_retro_adjustment_pkg.find_schedule( p_lease_id

7818: pnp_debug_pkg.log('NORMALIZE_RENORMALIZE - find draft schedule for '||p_payment_term_id||' with ACD '||l_amd_comn_date);
7819:
7820: FOR rec in get_drf_sch_date(p_payment_term_id) LOOP
7821: l_sch_dt_1 := rec.schedule_date;
7822: pn_retro_adjustment_pkg.find_schedule( p_lease_id
7823: ,l_active_lease_change_id
7824: ,p_payment_term_id
7825: ,l_sch_dt_1
7826: ,l_payment_schedule_id);

Line 7884: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);

7880: END LOOP;
7881:
7882: END LOOP;
7883:
7884: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);
7885:
7886: /* Now create the schedules and items for the new terms that have been added along with
7887: the contraction of the main lease */
7888: IF p_add_main = 'Y' THEN

Line 8134: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);

8130:
8131: /* call clean up schedules to delete schedules which do not have any item or
8132: are draft and are outside the lease */
8133:
8134: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);
8135:
8136: /* For Sub_Lease and Third_Party lease, contract tenancies and associated
8137: space assignments as well. */
8138:

Line 8461: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);

8457:
8458: /* call clean up schedules to delete schedules which do not have any item or
8459: are draft and are outside the lease */
8460:
8461: pn_retro_adjustment_pkg.cleanup_schedules(p_lease_id);
8462: END IF;
8463: ELSE
8464: contract_pay_term(p_lease_id => p_lease_id,
8465: p_lease_context => l_lease_context,