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_REC_CALC_PKG dependencies on PN_REC_ARCL_DTL_ALL

Line 828: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

824:
825: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE := 0;
826: l_fee_before_contr pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE :=0;
827: l_fee_after_contr pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE :=0;
828: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
829: l_ten_recoverable_area_rec ten_recoverable_area_rec;
830: l_ten_recoverable_area pn_rec_arcl_dtlln_all.occupied_area%TYPE:=0;
831: l_ten_occupancy_pct pn_rec_arcl_dtlln_all.occupancy_pct%TYPE:=0;
832: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE:=0;

Line 2445: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS

2441: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2442: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2443: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2444: )
2445: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2446:
2447: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2448: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2449: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;

Line 2447: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

2443: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2444: )
2445: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2446:
2447: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2448: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2449: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2450: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2451: l_area_type pn_rec_agr_linarea_all.area_type%Type;

Line 2448: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;

2444: )
2445: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2446:
2447: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2448: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2449: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2450: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2451: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2452: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;

Line 2449: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;

2445: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2446:
2447: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2448: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2449: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2450: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2451: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2452: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2453: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

Line 2452: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;

2448: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2449: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2450: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2451: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2452: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2453: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2454: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2455: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2456: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

Line 2459: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

2455: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2456: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2457: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2458: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2459: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2460: l_greater_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2461: l_context VARCHAR2(2000):= null;
2462:
2463: cursor c_area is

Line 2471: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

2467: ,linearea.FLOOR_PCT
2468: ,linearea.area_type
2469: ,area_class_dtl_hdr.area_class_dtl_id
2470: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2471: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2472: ,pn_rec_agr_linarea_all linearea
2473: ,pn_rec_arcl_all aclass
2474: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2475: AND p_as_of_date between linearea.start_date and linearea.end_date

Line 2615: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

2611: SELECT nvl(area_class_dtl_lines.occupied_area_ovr, area_class_dtl_lines.occupied_area)
2612: ,occupancy_pct
2613: INTO l_ten_recoverable_area_rec
2614: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2615: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2616: ,pn_rec_agr_linarea_all linearea
2617: ,pn_rec_arcl_all aclass
2618: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2619: AND p_as_of_date between linearea.start_date and linearea.end_date

Line 2727: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

2723: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2724: WHERE area_class_dtl_id =
2725: (SELECT area_class_dtl_hdr.area_class_dtl_id
2726: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2727: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2728: ,pn_rec_agr_linarea_all linearea
2729: ,pn_rec_arcl_all aclass
2730: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2731: AND p_as_of_date between linearea.start_date

Line 2810: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

2806: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2807: WHERE area_class_dtl_id =
2808: (SELECT area_class_dtl_hdr.area_class_dtl_id
2809: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2810: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2811: ,pn_rec_agr_linarea_all linearea
2812: ,pn_rec_arcl_all aclass
2813: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2814: AND p_as_of_date between linearea.start_date

Line 5130: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

5126: ) is
5127: SELECT
5128: area_class_dtl_hdr.area_class_dtl_id as area_class_dtl_id
5129: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
5130: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
5131: ,pn_rec_agr_linarea_all linearea
5132: ,pn_rec_arcl_all aclass
5133: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
5134: AND p_as_of_date between linearea.start_date and linearea.end_date

Line 5231: update pn_rec_arcl_dtl_all

5227: l_customer_id,
5228: l_lease_id,
5229: l_location_id)
5230: LOOP
5231: update pn_rec_arcl_dtl_all
5232: set status = 'LOCKED' ,
5233: last_update_date = sysdate,
5234: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5235: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)