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_PAYMENT_SCHEDULES_S

Line 1726: SELECT pn_payment_schedules_s.NEXTVAL

1722: FETCH check_sch INTO l_sch_id, l_pymnt_st_lkp_cd;
1723:
1724: IF check_sch%NOTFOUND THEN
1725:
1726: SELECT pn_payment_schedules_s.NEXTVAL
1727: INTO l_sch_id
1728: FROM DUAL;
1729:
1730: l_pymnt_st_lkp_cd := 'DRAFT';

Line 1807: SELECT pn_payment_schedules_s.NEXTVAL INTO l_sch_id

1803:
1804: pnp_debug_pkg.log('create_schedule: select executed' );
1805:
1806: EXCEPTION WHEN NO_DATA_FOUND THEN
1807: SELECT pn_payment_schedules_s.NEXTVAL INTO l_sch_id
1808: FROM DUAL;
1809: pnp_debug_pkg.log('create_schedule: l_sch_id ' || l_sch_id);
1810: INSERT INTO pn_payment_schedules_all(
1811: payment_schedule_id,

Line 2882: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

2878: l_cash_est_amt pn_payment_items.estimated_amount%TYPE := 0;
2879: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;
2880: l_sch_str_dt DATE := NULL;
2881: l_sch_end_dt DATE := NULL;
2882: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
2883: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
2884: l_app_sch NUMBER;
2885: l_norm_mths NUMBER;
2886: l_sch_day VARCHAR2(240);

Line 2883: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

2879: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;
2880: l_sch_str_dt DATE := NULL;
2881: l_sch_end_dt DATE := NULL;
2882: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
2883: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
2884: l_app_sch NUMBER;
2885: l_norm_mths NUMBER;
2886: l_sch_day VARCHAR2(240);
2887: l_pymnt_st_lkp_cd pn_payment_schedules.payment_status_lookup_code%TYPE;

Line 3669: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

3665: p_new_lea_comm_dt DATE,
3666: p_mths NUMBER)
3667: IS
3668:
3669: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
3670: l_no_sch NUMBER;
3671: l_freq NUMBER;
3672: l_counter NUMBER;
3673: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 3673: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

3669: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
3670: l_no_sch NUMBER;
3671: l_freq NUMBER;
3672: l_counter NUMBER;
3673: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
3674: l_msg VARCHAR2(2000);
3675: l_norm_str_dt DATE;
3676: l_sch_str_dt DATE;
3677: l_lease_context VARCHAR2(100);

Line 4576: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

4572: p_ten_trm_context VARCHAR2 DEFAULT 'N')
4573: IS
4574:
4575: l_old_lea_term_dt pn_lease_details.lease_termination_date%TYPE;
4576: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
4577: l_no_sch NUMBER;
4578: l_freq NUMBER;
4579: l_counter NUMBER;
4580: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 4580: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

4576: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
4577: l_no_sch NUMBER;
4578: l_freq NUMBER;
4579: l_counter NUMBER;
4580: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
4581: l_msg VARCHAR2(2000);
4582: l_norm_str_dt DATE := NULL;
4583: l_sch_str_dt DATE;
4584: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

Line 5113: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

5109: p_new_lea_comm_dt DATE,
5110: p_mths NUMBER)
5111: IS
5112:
5113: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5114: l_no_sch NUMBER;
5115: l_freq NUMBER;
5116: l_counter NUMBER;
5117: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 5117: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

5113: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5114: l_no_sch NUMBER;
5115: l_freq NUMBER;
5116: l_counter NUMBER;
5117: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
5118: l_norm_str_dt DATE;
5119: l_sch_str_dt DATE;
5120:
5121: CURSOR get_lease_status(p_lease_id NUMBER) IS

Line 5329: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

5325: p_new_lea_comm_dt DATE,
5326: p_mths NUMBER)
5327: IS
5328:
5329: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5330: l_no_sch NUMBER;
5331: l_freq NUMBER;
5332: l_counter NUMBER;
5333: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 5333: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

5329: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5330: l_no_sch NUMBER;
5331: l_freq NUMBER;
5332: l_counter NUMBER;
5333: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
5334: l_norm_str_dt DATE;
5335: l_sch_str_dt DATE;
5336:
5337: BEGIN

Line 6052: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

6048: x_return_message OUT NOCOPY VARCHAR2
6049: )
6050:
6051: IS
6052: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
6053: l_no_sch NUMBER;
6054: l_freq NUMBER;
6055: l_counter NUMBER;
6056: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 6056: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

6052: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
6053: l_no_sch NUMBER;
6054: l_freq NUMBER;
6055: l_counter NUMBER;
6056: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
6057: l_sch_str_dt DATE;
6058: l_sch_end_dt DATE;
6059: l_norm_st_dt DATE;
6060: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;

Line 6401: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

6397: l_schedule_date DATE := NULL;
6398: l_sch_id NUMBER := NULL;
6399: l_curr_payment_term_id NUMBER := NULL;
6400: l_payment_term_rec pn_payment_terms_all%ROWTYPE;
6401: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
6402: l_no_sch NUMBER;
6403: l_freq NUMBER;
6404: l_counter NUMBER;
6405: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 6405: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

6401: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
6402: l_no_sch NUMBER;
6403: l_freq NUMBER;
6404: l_counter NUMBER;
6405: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
6406: l_sch_str_dt DATE;
6407: l_norm_st_dt DATE;
6408:
6409: BEGIN