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.

[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_PAYMENT_SCHEDULES_S

Line 1394: SELECT pn_payment_schedules_s.NEXTVAL

1390: FETCH check_sch INTO l_sch_id, l_pymnt_st_lkp_cd;
1391:
1392: IF check_sch%NOTFOUND THEN
1393:
1394: SELECT pn_payment_schedules_s.NEXTVAL
1395: INTO l_sch_id
1396: FROM DUAL;
1397:
1398: l_pymnt_st_lkp_cd := 'DRAFT';

Line 1460: SELECT pn_payment_schedules_s.NEXTVAL INTO l_sch_id

1456: AND payment_status_lookup_code = l_pymnt_st_lkp_cd
1457: AND ROWNUM = 1;
1458:
1459: EXCEPTION WHEN NO_DATA_FOUND THEN
1460: SELECT pn_payment_schedules_s.NEXTVAL INTO l_sch_id
1461: FROM DUAL;
1462:
1463: INSERT INTO pn_payment_schedules_all(
1464: payment_schedule_id,

Line 2249: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

2245: l_cash_est_amt pn_payment_items.estimated_amount%TYPE := 0;
2246: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;
2247: l_sch_str_dt DATE := NULL;
2248: l_sch_end_dt DATE := NULL;
2249: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
2250: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
2251: l_app_sch NUMBER;
2252: l_norm_mths NUMBER;
2253: l_sch_day VARCHAR2(240);

Line 2250: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

2246: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;
2247: l_sch_str_dt DATE := NULL;
2248: l_sch_end_dt DATE := NULL;
2249: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
2250: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
2251: l_app_sch NUMBER;
2252: l_norm_mths NUMBER;
2253: l_sch_day VARCHAR2(240);
2254: l_pymnt_st_lkp_cd pn_payment_schedules.payment_status_lookup_code%TYPE;

Line 2904: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

2900: p_new_lea_comm_dt DATE,
2901: p_mths NUMBER)
2902: IS
2903:
2904: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
2905: l_no_sch NUMBER;
2906: l_freq NUMBER;
2907: l_counter NUMBER;
2908: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 2908: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

2904: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
2905: l_no_sch NUMBER;
2906: l_freq NUMBER;
2907: l_counter NUMBER;
2908: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
2909: l_msg VARCHAR2(2000);
2910: l_norm_str_dt DATE;
2911: l_sch_str_dt DATE;
2912: l_lease_context VARCHAR2(100);

Line 3775: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

3771: p_ten_trm_context VARCHAR2 DEFAULT 'N')
3772: IS
3773:
3774: l_old_lea_term_dt pn_lease_details.lease_termination_date%TYPE;
3775: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
3776: l_no_sch NUMBER;
3777: l_freq NUMBER;
3778: l_counter NUMBER;
3779: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 3779: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

3775: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
3776: l_no_sch NUMBER;
3777: l_freq NUMBER;
3778: l_counter NUMBER;
3779: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
3780: l_msg VARCHAR2(2000);
3781: l_norm_str_dt DATE := NULL;
3782: l_sch_str_dt DATE;
3783: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

Line 4220: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

4216: p_new_lea_comm_dt DATE,
4217: p_mths NUMBER)
4218: IS
4219:
4220: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
4221: l_no_sch NUMBER;
4222: l_freq NUMBER;
4223: l_counter NUMBER;
4224: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 4224: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

4220: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
4221: l_no_sch NUMBER;
4222: l_freq NUMBER;
4223: l_counter NUMBER;
4224: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
4225: l_norm_str_dt DATE;
4226: l_sch_str_dt DATE;
4227:
4228: CURSOR get_lease_status(p_lease_id NUMBER) IS

Line 4436: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

4432: p_new_lea_comm_dt DATE,
4433: p_mths NUMBER)
4434: IS
4435:
4436: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
4437: l_no_sch NUMBER;
4438: l_freq NUMBER;
4439: l_counter NUMBER;
4440: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 4440: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

4436: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
4437: l_no_sch NUMBER;
4438: l_freq NUMBER;
4439: l_counter NUMBER;
4440: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
4441: l_norm_str_dt DATE;
4442: l_sch_str_dt DATE;
4443:
4444: BEGIN

Line 5130: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

5126: x_return_message OUT NOCOPY VARCHAR2
5127: )
5128:
5129: IS
5130: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5131: l_no_sch NUMBER;
5132: l_freq NUMBER;
5133: l_counter NUMBER;
5134: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 5134: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

5130: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5131: l_no_sch NUMBER;
5132: l_freq NUMBER;
5133: l_counter NUMBER;
5134: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
5135: l_sch_str_dt DATE;
5136: l_sch_end_dt DATE;
5137: l_norm_st_dt DATE;
5138: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;

Line 5422: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;

5418: l_schedule_date DATE := NULL;
5419: l_sch_id NUMBER := NULL;
5420: l_curr_payment_term_id NUMBER := NULL;
5421: l_payment_term_rec pn_payment_terms_all%ROWTYPE;
5422: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5423: l_no_sch NUMBER;
5424: l_freq NUMBER;
5425: l_counter NUMBER;
5426: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

Line 5426: l_sch_dt pn_payment_schedules.schedule_date%TYPE;

5422: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5423: l_no_sch NUMBER;
5424: l_freq NUMBER;
5425: l_counter NUMBER;
5426: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
5427: l_sch_str_dt DATE;
5428: l_norm_st_dt DATE;
5429:
5430: BEGIN