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_VAR_RENT_PKG dependencies on PN_VAR_RENTS_ALL

Line 74: FROM PN_VAR_RENTS_ALL

70: WHERE PERIOD_ID = X_PERIOD_ID;
71:
72: CURSOR org_id_cur IS
73: SELECT org_id
74: FROM PN_VAR_RENTS_ALL
75: WHERE VAR_RENT_ID = X_VAR_RENT_ID;
76:
77: l_org_id NUMBER;
78:

Line 451: FROM PN_VAR_RENTS_ALL

447: WHERE REPORT_DATE_ID = X_REPORT_DATE_ID;
448:
449: CURSOR org_id_cur IS
450: SELECT org_id
451: FROM PN_VAR_RENTS_ALL
452: WHERE VAR_RENT_ID = X_VAR_RENT_ID;
453:
454: l_org_id NUMBER ;
455:

Line 671: FROM PN_VAR_RENTS_ALL

667: WHERE GRP_DATE_ID = X_GRP_DATE_ID;
668:
669: CURSOR org_id_cur IS
670: SELECT org_id
671: FROM PN_VAR_RENTS_ALL
672: WHERE VAR_RENT_ID = X_VAR_RENT_ID;
673:
674: l_org_id NUMBER ;
675:

Line 1109: FROM PN_VAR_RENTS_ALL vr, PN_VAR_RENT_DATES_ALL cal

1105: p_period_type,
1106: l_use_gl_calendar,
1107: l_year_start_date,
1108: l_org_id
1109: FROM PN_VAR_RENTS_ALL vr, PN_VAR_RENT_DATES_ALL cal
1110: WHERE vr.var_rent_id = p_var_rent_id
1111: AND cal.var_rent_id = vr.var_rent_id;
1112:
1113: ----------------------------------

Line 2252: FROM PN_VAR_RENTS_ALL VR, PN_VAR_RENT_DATES_ALL CAL

2248: l_invg_freq_code,
2249: l_invg_day_of_month,
2250: l_invg_days_after,
2251: l_org_id
2252: FROM PN_VAR_RENTS_ALL VR, PN_VAR_RENT_DATES_ALL CAL
2253: WHERE VR.var_rent_id = p_var_rent_id
2254: AND CAL.var_rent_id = VR.var_rent_id;
2255:
2256: -- generate periods

Line 2880: FROM pn_var_rents_ALL

2876: -- Get proration days info from the main VR record
2877:
2878: SELECT decode(proration_days,999,365,proration_days)
2879: INTO tot_per_proration_days
2880: FROM pn_var_rents_ALL
2881: WHERE var_rent_id = p_var_rent_id;
2882:
2883: -- Get group start date for the last group which has to be
2884: -- updated with the new proration factor after lease contraction

Line 4428: pn_var_rents_ALL var,

4424: INTO l_base_rent
4425: FROM pn_payment_items_ALL item,
4426: pn_payment_terms_ALL term,
4427: pn_var_periods_ALL per,
4428: pn_var_rents_ALL var,
4429: pn_payment_schedules_all sched
4430: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
4431: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
4432: AND term.lease_id = var.lease_id

Line 4452: pn_var_rents_ALL var,

4448: INTO l_base_rent
4449: FROM pn_payment_items_ALL item,
4450: pn_payment_terms_ALL term,
4451: pn_var_periods_ALL per,
4452: pn_var_rents_ALL var,
4453: pn_payment_schedules_all sched
4454: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
4455: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
4456: AND term.lease_id = var.lease_id

Line 5488: FROM pn_var_rents_all

5484: CURSOR var_rent_c(p_vr_id IN NUMBER) IS
5485: SELECT var_rent_id
5486: ,commencement_date
5487: ,termination_date
5488: FROM pn_var_rents_all
5489: WHERE var_rent_id = p_vr_id;
5490:
5491: CURSOR line_defs_c(p_vr_id IN NUMBER) IS
5492: SELECT line_default_id

Line 6083: FROM pn_var_rents_all

6079: CURSOR var_rent_c(p_vr_id IN NUMBER) IS
6080: SELECT var_rent_id
6081: ,commencement_date
6082: ,termination_date
6083: FROM pn_var_rents_all
6084: WHERE var_rent_id = p_vr_id;
6085:
6086: /* cursor for defaults - SETUP */
6087: CURSOR constr_def_c IS

Line 6610: FROM pn_var_rents_all

6606:
6607: BEGIN
6608: SELECT commencement_date, termination_date
6609: INTO l_vr_comm_dt, l_vr_term_dt
6610: FROM pn_var_rents_all
6611: WHERE var_rent_id = p_pn_var_rent_dates_rec.var_rent_id;
6612:
6613: SELECT year_start_date
6614: INTO l_year_st_date

Line 7002: FROM pn_var_rents_all

6998: SELECT var_rent_id,
6999: commencement_date start_date,
7000: termination_date end_date,
7001: cumulative_vol
7002: FROM pn_var_rents_all
7003: WHERE var_rent_id = p_var_rent_id;
7004:
7005: errbuf VARCHAR2(5000);
7006: retcode VARCHAR2(5000);

Line 7013: UPDATE pn_var_rents_all

7009: BEGIN
7010: put_log ('PN_VAR_RENT_PKG.create_new_bkpts (+)');
7011: FOR main_vr_rec in main_vr_cur
7012: LOOP
7013: UPDATE pn_var_rents_all
7014: SET termination_date = p_extension_end_date
7015: WHERE var_rent_id = main_vr_rec.var_rent_id;
7016:
7017: put_log ('Starting Extension of Periods and group Dates');

Line 7067: FROM pn_var_rents_all a,

7063: RETURN VARCHAR2
7064: IS
7065: CURSOR var_rent_cur IS
7066: SELECT a.proration_rule
7067: FROM pn_var_rents_all a,
7068: pn_var_periods_all b
7069: WHERE a.var_rent_id = NVL(p_var_rent_id,a.var_rent_id)
7070: AND a.var_rent_id = b.var_rent_id
7071: AND b.period_id = NVL(p_period_id,b.period_id);

Line 7080: FROM pn_var_rents_all

7076: IF p_var_rent_id IS NOT NULL THEN
7077: BEGIN
7078: SELECT proration_rule
7079: INTO l_proration_rule
7080: FROM pn_var_rents_all
7081: WHERE var_rent_id = p_var_rent_id;
7082: EXCEPTION
7083: WHEN OTHERS THEN
7084: l_proration_rule := NULL;

Line 7091: FROM pn_var_rents_all a,

7087: ELSE
7088: BEGIN
7089: SELECT proration_rule
7090: INTO l_proration_rule
7091: FROM pn_var_rents_all a,
7092: pn_var_periods_all b
7093: WHERE a.var_rent_id = b.var_rent_id
7094: AND b.period_id = NVL(p_period_id,b.period_id);
7095: EXCEPTION

Line 7653: FROM pn_var_rents_all

7649: CURSOR var_rent_cur IS
7650: SELECT 'x'
7651: FROM dual
7652: WHERE EXISTS ( SELECT var_rent_id
7653: FROM pn_var_rents_all
7654: WHERE agreement_template_id = p_template_id);
7655:
7656: l_return BOOLEAN := FALSE;
7657: BEGIN

Line 7766: X_VAR_RENT_START_DATE IN PN_VAR_RENTS_ALL.COMMENCEMENT_DATE%TYPE

7762: |
7763: | 30-JAN-2004 Daniel Thota o Created
7764: +===========================================================================*/
7765: FUNCTION DETERMINE_FREQUENCY (
7766: X_VAR_RENT_START_DATE IN PN_VAR_RENTS_ALL.COMMENCEMENT_DATE%TYPE
7767: ,X_VAR_RENT_END_DATE IN PN_VAR_RENTS_ALL.TERMINATION_DATE%TYPE
7768: ) RETURN PN_VAR_RENT_DATES_ALL.REPTG_FREQ_CODE%TYPE
7769: is
7770:

Line 7767: ,X_VAR_RENT_END_DATE IN PN_VAR_RENTS_ALL.TERMINATION_DATE%TYPE

7763: | 30-JAN-2004 Daniel Thota o Created
7764: +===========================================================================*/
7765: FUNCTION DETERMINE_FREQUENCY (
7766: X_VAR_RENT_START_DATE IN PN_VAR_RENTS_ALL.COMMENCEMENT_DATE%TYPE
7767: ,X_VAR_RENT_END_DATE IN PN_VAR_RENTS_ALL.TERMINATION_DATE%TYPE
7768: ) RETURN PN_VAR_RENT_DATES_ALL.REPTG_FREQ_CODE%TYPE
7769: is
7770:
7771: l_days NUMBER;

Line 8290: FROM pn_var_rents_all vr, pn_var_rent_dates_all cal

8286: 'QTR', 3,
8287: 'SA', 6,
8288: 'YR', 12,
8289: NULL) reptg_freq_code
8290: FROM pn_var_rents_all vr, pn_var_rent_dates_all cal
8291: WHERE vr.var_rent_id = p_var_rent_id
8292: AND cal.var_rent_id = vr.var_rent_id;
8293:
8294: /* Get the details of grp dates for group in which the new termination date falls */

Line 8816: DELETE pn_var_rents_all

8812:
8813: DELETE pn_var_periods_all
8814: WHERE var_rent_id = p_var_rent_id;
8815:
8816: DELETE pn_var_rents_all
8817: WHERE var_rent_id = p_var_rent_id;
8818:
8819: pnp_debug_pkg.debug ('pn_var_rent_pkg.delete_var_agreement (-)');
8820:

Line 8857: FROM pn_var_rents_all

8853: termination date for a given lease or fetches information for a given agreement */
8854:
8855: CURSOR var_rent_cur IS
8856: SELECT var_rent_id, commencement_date
8857: FROM pn_var_rents_all
8858: WHERE lease_id = NVL(p_lease_id, lease_id)
8859: AND var_rent_id = NVL (p_var_rent_id, var_rent_id)
8860: AND (( termination_date = p_old_termn_date) OR
8861: (termination_date < p_old_termn_date AND termination_date > p_new_termn_date))

Line 8874: FROM pn_var_rents_all

8870:
8871: /* Fetch the agreements which start after the new termination date */
8872: CURSOR variable_rent_cur IS
8873: SELECT var_rent_id
8874: FROM pn_var_rents_all
8875: WHERE lease_id = p_lease_id
8876: AND commencement_date > p_new_termn_date
8877: AND commencement_date < p_old_termn_date ;
8878:

Line 8886: pn_var_rents_all pvr

8882: FROM pn_payment_terms_all
8883: WHERE status = 'APPROVED'
8884: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8885: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp,
8886: pn_var_rents_all pvr
8887: WHERE pvi.period_id = pvp.period_id
8888: AND pvr.var_rent_id = pvp.var_rent_id
8889: AND pvr.var_rent_id = p_var_rent_id);
8890:

Line 9021: UPDATE pn_var_rents_all

9017:
9018: pnp_debug_pkg.debug ('after for loop');
9019:
9020: /* update the end date of agreement to new termination date */
9021: UPDATE pn_var_rents_all
9022: SET termination_date = p_new_termn_date
9023: WHERE var_rent_id = var_rent_rec.var_rent_id;
9024:
9025: /* update the bkpt_update_flag to 'Y for VR agreement */

Line 9862: FROM pn_var_rents_all pvr, pn_var_rent_dates_all pvd

9858: , pvr.proration_rule
9859: , pvd.use_gl_calendar
9860: , pvd.year_start_date
9861: , pvr.commencement_date
9862: FROM pn_var_rents_all pvr, pn_var_rent_dates_all pvd
9863: WHERE pvr.lease_id = NVL (p_lease_id, pvr.lease_id)
9864: AND pvr.var_rent_id = NVL (p_var_rent_id, pvr.var_rent_id)
9865: AND pvr.termination_date = p_old_termn_date
9866: AND pvd.var_rent_id = pvr.var_rent_id;

Line 9912: UPDATE pn_var_rents_all

9908:
9909: /* Update the vr agreement with the new termination date */
9910: pnp_debug_pkg.debug ('Update the vr agreement with the new termination date ...');
9911:
9912: UPDATE pn_var_rents_all
9913: SET termination_date = p_new_termn_date
9914: WHERE var_rent_id = main_vr_rec.var_rent_id;
9915:
9916: /* call appropriate procedures to create new periods or activate the inactive one

Line 10298: from pn_var_rents_all var

10294: /* Cursor to get all var_rents for the given property */
10295: CURSOR varent_prop_cur (p_prop_id IN NUMBER)
10296: IS
10297: SELECT DISTINCT var.var_rent_id
10298: from pn_var_rents_all var
10299: where var.lease_id IN( SELECT distinct lease_id
10300: FROM ( SELECT lease_id
10301: FROM pn_tenancies_all
10302: WHERE location_id in (SELECT location_id

Line 10317: FROM pn_var_rents_all var

10313: /* Cursor to get all var_rents for the given location */
10314: CURSOR varent_loc_cur(p_loc_id IN NUMBER)
10315: IS
10316: SELECT DISTINCT var.var_rent_id
10317: FROM pn_var_rents_all var
10318: WHERE var.lease_id IN (SELECT lease_id
10319: FROM (SELECT lease_id
10320: FROM pn_tenancies_all
10321: WHERE location_id = p_loc_id

Line 10332: FROM pn_var_rents_all var

10328: /* Cursor to get all var_rents for the given lease */
10329: CURSOR varent_lease_cur(p_lease_id IN NUMBER)
10330: IS
10331: SELECT DISTINCT var.var_rent_id
10332: FROM pn_var_rents_all var
10333: WHERE var.lease_id = p_lease_id;
10334:
10335:
10336: /* Cursor used to fetch distinct periods */

Line 10341: pn_var_rents_all var

10337: CURSOR periods_cur(p_var_rent_id NUMBER) IS
10338: SELECT DISTINCT per.period_id period_id,
10339: var.rent_num rent_num
10340: FROM pn_var_periods_all per,
10341: pn_var_rents_all var
10342: WHERE per.var_rent_id = p_var_rent_id
10343: AND var.var_rent_id = p_var_rent_id;
10344:
10345:

Line 10546: FROM pn_var_rents_all

10542: IF l_var_rent_id IS NOT NULL THEN
10543:
10544: SELECT rent_num
10545: INTO l_rent_num
10546: FROM pn_var_rents_all
10547: WHERE var_rent_id = l_var_rent_id;
10548:
10549: /* Checking if the var rent agreement has a period with two or more similar lines */
10550:

Line 11054: FROM pn_var_rents_all

11050: CURSOR var_cur(p_vr_id IN NUMBER) IS
11051: SELECT commencement_date
11052: ,termination_date
11053: ,proration_rule
11054: FROM pn_var_rents_all
11055: WHERE var_rent_id = p_vr_id;
11056:
11057: /* Cursor to get var periods */
11058: CURSOR periods_vr_c(p_vr_id IN NUMBER) IS