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_RENT_DATES_ALL

Line 290: FROM pn_var_rent_dates_all

286: 'QTR', 3,
287: 'SA', 6,
288: 'YR', 12,
289: null) group_frequency
290: FROM pn_var_rent_dates_all
291: WHERE var_rent_id = p_var_rent_id;
292:
293:
294: p_creation_date DATE := SYSDATE;

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 2862: FROM PN_VAR_RENT_DATES_ALL cal

2858: 'SA', 6,
2859: 'YR', 12,
2860: null)
2861: INTO p_reptg_freq_code
2862: FROM PN_VAR_RENT_DATES_ALL cal
2863: WHERE cal.var_rent_id = p_var_rent_id;
2864:
2865: -- Get period start date for the last period which has to be
2866: -- updated with the new proration factor after lease contraction

Line 3682: FROM pn_var_rent_dates_ALL dates

3678: SELECT 1
3679: INTO l_vrdates_exists
3680: FROM dual
3681: WHERE EXISTS ( SELECT dates.var_rent_date_id
3682: FROM pn_var_rent_dates_ALL dates
3683: WHERE dates.var_rent_id = p_var_rent_id);
3684:
3685: RETURN l_vrdates_exists;
3686:

Line 6316: FROM pn_var_rent_dates_all

6312: Order by start_date ;
6313:
6314: CURSOR var_rent_dates_cur IS
6315: SELECT *
6316: FROM pn_var_rent_dates_all
6317: WHERE var_rent_id = p_var_rent_id ;
6318:
6319: l_row_found BOOLEAN := FALSE;
6320: l_index NUMBER := 0;

Line 6481: PROCEDURE extend_group_dates (p_pn_var_rent_dates_rec IN PN_VAR_RENT_DATES_ALL%ROWTYPE,

6477: | last partial period are not being prorated. We prorate for the first partial period,
6478: | but use a annual breakpoint in the last period.
6479: |
6480: +===========================================================================*/
6481: PROCEDURE extend_group_dates (p_pn_var_rent_dates_rec IN PN_VAR_RENT_DATES_ALL%ROWTYPE,
6482: p_period_id IN NUMBER,
6483: x_return_status OUT NOCOPY VARCHAR2,
6484: x_return_message OUT NOCOPY VARCHAR2)
6485: IS

Line 6615: FROM pn_var_rent_dates_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
6615: FROM pn_var_rent_dates_all
6616: WHERE var_rent_id = p_pn_var_rent_dates_rec.var_rent_id;
6617:
6618: IF p_pn_var_rent_dates_rec.invg_freq_code = 'MON' THEN
6619: l_invg_freq_code := 1;

Line 7110: PROCEDURE generate_cal_periods_tbl(p_var_rent_dates_rec IN PN_VAR_RENT_DATES_ALL%ROWTYPE,

7106: END LOOP;
7107: RETURN l_proration_rule;
7108: END;
7109:
7110: PROCEDURE generate_cal_periods_tbl(p_var_rent_dates_rec IN PN_VAR_RENT_DATES_ALL%ROWTYPE,
7111: p_start_date IN DATE,
7112: p_end_date IN DATE,
7113: p_extension_end_date IN DATE,
7114: x_cal_periods_tbl OUT NOCOPY cal_periods_tbl)

Line 7170: PROCEDURE generate_group_inv_tbl ( p_pn_var_rent_dates_rec IN pn_var_rent_dates_all%rowtype,

7166: END IF;
7167: -- end if of use_gl_calendar
7168: END generate_cal_periods_tbl;
7169:
7170: PROCEDURE generate_group_inv_tbl ( p_pn_var_rent_dates_rec IN pn_var_rent_dates_all%rowtype,
7171: p_period_start_date IN DATE,
7172: p_period_end_date IN DATE,
7173: x_group_dates_tbl OUT NOCOPY group_dates_tbl,
7174: x_inv_dates_tbl OUT NOCOPY group_dates_tbl)

Line 7768: ) RETURN PN_VAR_RENT_DATES_ALL.REPTG_FREQ_CODE%TYPE

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;
7772: l_freq_code PN_VAR_RENT_DATES_ALL.REPTG_FREQ_CODE%TYPE;

Line 7772: l_freq_code PN_VAR_RENT_DATES_ALL.REPTG_FREQ_CODE%TYPE;

7768: ) RETURN PN_VAR_RENT_DATES_ALL.REPTG_FREQ_CODE%TYPE
7769: is
7770:
7771: l_days NUMBER;
7772: l_freq_code PN_VAR_RENT_DATES_ALL.REPTG_FREQ_CODE%TYPE;
7773:
7774: BEGIN
7775:
7776: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.DETERMINE_FREQUENCY (+)');

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 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;