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_DTL_ALL

Line 853: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

849:
850: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE := 0;
851: l_fee_before_contr pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE :=0;
852: l_fee_after_contr pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE :=0;
853: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
854: l_ten_recoverable_area_rec ten_recoverable_area_rec;
855: l_ten_recoverable_area pn_rec_arcl_dtlln_all.occupied_area%TYPE:=0;
856: l_ten_occupancy_pct pn_rec_arcl_dtlln_all.occupancy_pct%TYPE:=0;
857: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE:=0;

Line 2476: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS

2472: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2473: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2474: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2475: )
2476: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2477:
2478: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2479: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;

Line 2478: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

2474: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2475: )
2476: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2477:
2478: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2479: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;

Line 2479: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;

2475: )
2476: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2477:
2478: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2479: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;

Line 2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;

2476: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2477:
2478: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2479: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

Line 2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;

2479: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;

Line 2490: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;
2487: l_net_asgn_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2488: l_net_occp_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2489: l_net_wgt_avg_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2490: l_floor_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2491: l_greater_area pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2492: l_context VARCHAR2(2000):= null;
2493:
2494: cursor c_area is

Line 2502: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

2498: ,linearea.FLOOR_PCT
2499: ,linearea.area_type
2500: ,area_class_dtl_hdr.area_class_dtl_id
2501: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2502: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2503: ,pn_rec_agr_linarea_all linearea
2504: ,pn_rec_arcl_all aclass
2505: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2506: AND p_as_of_date between linearea.start_date and linearea.end_date

Line 2649: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

2645: SELECT nvl(area_class_dtl_lines.occupied_area_ovr, area_class_dtl_lines.occupied_area)
2646: ,occupancy_pct
2647: INTO l_ten_recoverable_area_rec
2648: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2649: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2650: ,pn_rec_agr_linarea_all linearea
2651: ,pn_rec_arcl_all aclass
2652: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2653: AND p_as_of_date between linearea.start_date and linearea.end_date

Line 2761: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

2757: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2758: WHERE area_class_dtl_id =
2759: (SELECT area_class_dtl_hdr.area_class_dtl_id
2760: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2761: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2762: ,pn_rec_agr_linarea_all linearea
2763: ,pn_rec_arcl_all aclass
2764: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2765: AND p_as_of_date between linearea.start_date

Line 2844: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

2840: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2841: WHERE area_class_dtl_id =
2842: (SELECT area_class_dtl_hdr.area_class_dtl_id
2843: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2844: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2845: ,pn_rec_agr_linarea_all linearea
2846: ,pn_rec_arcl_all aclass
2847: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2848: AND p_as_of_date between linearea.start_date

Line 5215: ,pn_rec_arcl_dtl_all area_class_dtl_hdr

5211: ) is
5212: SELECT
5213: area_class_dtl_hdr.area_class_dtl_id as area_class_dtl_id
5214: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
5215: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
5216: ,pn_rec_agr_linarea_all linearea
5217: ,pn_rec_arcl_all aclass
5218: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
5219: AND p_as_of_date between linearea.start_date and linearea.end_date

Line 5316: update pn_rec_arcl_dtl_all

5312: l_customer_id,
5313: l_lease_id,
5314: l_location_id)
5315: LOOP
5316: update pn_rec_arcl_dtl_all
5317: set status = 'LOCKED' ,
5318: last_update_date = sysdate,
5319: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5320: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)