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

Line 830: l_ten_recoverable_area pn_rec_arcl_dtlln_all.occupied_area%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;
833: l_line_constraints pn_rec_agr_linconst_all.value%TYPE:=0;
834: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE:=0;

Line 831: l_ten_occupancy_pct pn_rec_arcl_dtlln_all.occupancy_pct%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;
833: l_line_constraints pn_rec_agr_linconst_all.value%TYPE:=0;
834: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE:=0;
835: l_ten_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;

Line 2453: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_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;
2457: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

Line 2454: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%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;
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;

Line 2455: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%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;
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;

Line 2456: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%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;
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;

Line 2457: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%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;
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;

Line 2458: l_net_wgt_avg_area 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;
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:

Line 2460: l_greater_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%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
2464: SELECT area_class_dtl_hdr.TOTAL_assignable_area

Line 2470: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2466: ,nvl(area_class_dtl_hdr.TOTAL_WEIGHTED_AVG_ovr, area_class_dtl_hdr.TOTAL_WEIGHTED_AVG)
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

Line 2516: FROM pn_rec_arcl_dtlln_all area_class_dtl

2512: INTO
2513: l_asgn_area_contr,
2514: l_occp_area_contr,
2515: l_wgt_avg_area_contr
2516: FROM pn_rec_arcl_dtlln_all area_class_dtl
2517: WHERE area_class_dtl_line_id = l_area_class_dtl_id
2518: AND exclude_area_ovr_flag = 'Y'
2519: AND include_flag ='Y';
2520:

Line 2614: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2610:
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

Line 2723: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2719: (
2720: SELECT area_class_dtl_lines.location_id,
2721: area_class_dtl_lines.cust_account_id,
2722: area_class_dtl_lines.lease_id
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

Line 2726: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2722: area_class_dtl_lines.lease_id
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

Line 2806: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2802: (
2803: SELECT area_class_dtl_lines.location_id,
2804: area_class_dtl_lines.cust_account_id,
2805: area_class_dtl_lines.lease_id
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

Line 2809: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

2805: area_class_dtl_lines.lease_id
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

Line 5129: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines

5125: p_location_id number
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