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_EXPCL_DTLLN_ALL

Line 850: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE := 0;

846: ,p_error IN OUT NOCOPY VARCHAR2
847: ,p_error_code IN OUT NOCOPY NUMBER
848: ) IS
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;

Line 851: l_fee_before_contr pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE :=0;

847: ,p_error_code IN OUT NOCOPY NUMBER
848: ) IS
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;

Line 852: l_fee_after_contr pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE :=0;

848: ) IS
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;

Line 880: l_BUDGET_EXPENSE PN_REC_EXPCL_DTLLN_ALL.budgeted_amt%TYPE;

876: l_STATUS VARCHAR2(30):=NULL;
877: l_BUDGET_PRORATA_SHARE NUMBER:=0;
878: l_BUDGET_COST_PER_AREA NUMBER:=0;
879: l_BUDGET_RECOVERY NUMBER:=0;
880: l_BUDGET_EXPENSE PN_REC_EXPCL_DTLLN_ALL.budgeted_amt%TYPE;
881: l_count NUMBER := 0;
882: i NUMBER := 0;
883: l_prior_period_amount pn_rec_period_lines_all.actual_recovery%TYPE:=0;
884: l_prior_period_cap pn_rec_period_lines_all.constrained_actual%TYPE:=0;

Line 2937: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;

2933: ,p_error IN OUT NOCOPY VARCHAR2
2934: ,p_error_code IN OUT NOCOPY NUMBER
2935: ) IS
2936:
2937: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;
2938: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;
2939: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;
2940: l_expense_class_id pn_rec_expcl_all.expense_class_id%TYPE;
2941: l_expense_type_count Number := 0;

Line 2938: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;

2934: ,p_error_code IN OUT NOCOPY NUMBER
2935: ) IS
2936:
2937: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;
2938: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;
2939: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;
2940: l_expense_class_id pn_rec_expcl_all.expense_class_id%TYPE;
2941: l_expense_type_count Number := 0;
2942:

Line 2939: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;

2935: ) IS
2936:
2937: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;
2938: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;
2939: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;
2940: l_expense_class_id pn_rec_expcl_all.expense_class_id%TYPE;
2941: l_expense_type_count Number := 0;
2942:
2943: BEGIN

Line 2957: ,pn_rec_expcl_dtlln_all exp_detail_line

2953: FROM pn_rec_expcl_all rec_exp_class
2954: ,pn_rec_agr_linexp_all lineexp
2955: ,pn_rec_expcl_dtl_all exp_detail_hdr
2956: ,pn_rec_exp_line_all exp_extract_hdr
2957: ,pn_rec_expcl_dtlln_all exp_detail_line
2958: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
2959: AND exp_detail_line.cust_account_id = p_customer_id
2960: AND exp_detail_line.lease_id = p_lease_id
2961: AND exp_detail_line.location_id = p_location_id

Line 2990: ,pn_rec_expcl_dtlln_all exp_detail_line

2986: FROM pn_rec_expcl_all rec_exp_class
2987: ,pn_rec_agr_linexp_all lineexp
2988: ,pn_rec_expcl_dtl_all exp_detail_hdr
2989: ,pn_rec_exp_line_all exp_extract_hdr
2990: ,pn_rec_expcl_dtlln_all exp_detail_line
2991: ,pn_rec_expcl_dtlacc_all exp_detail_acc
2992: ,pn_rec_agr_lines_all agrline
2993: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
2994: AND exp_detail_line.cust_account_id = p_customer_id

Line 3081: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS

3077: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3078: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3079: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3080: )
3081: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS
3082:
3083: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
3084:
3085: BEGIN

Line 3083: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;

3079: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3080: )
3081: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS
3082:
3083: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
3084:
3085: BEGIN
3086:
3087: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_budget_expenses (+) ');

Line 3114: ,pn_rec_expcl_dtlln_all exp_detail_line

3110: FROM pn_rec_expcl_all rec_exp_class
3111: ,pn_rec_agr_linexp_all lineexp
3112: ,pn_rec_expcl_dtl_all exp_detail_hdr
3113: ,pn_rec_exp_line_all exp_extract_hdr
3114: ,pn_rec_expcl_dtlln_all exp_detail_line
3115: ,pn_rec_expcl_dtlacc_all expcl_lndtl_alloc
3116: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
3117: AND exp_detail_line.cust_account_id = p_customer_id
3118: AND exp_detail_line.lease_id = p_lease_id

Line 5188: ,pn_rec_expcl_dtlln_all exp_detail_line

5184: FROM pn_rec_expcl_all rec_exp_class
5185: ,pn_rec_agr_linexp_all lineexp
5186: ,pn_rec_expcl_dtl_all exp_detail_hdr
5187: ,pn_rec_exp_line_all exp_extract_hdr
5188: ,pn_rec_expcl_dtlln_all exp_detail_line
5189: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
5190: AND exp_detail_line.cust_account_id = p_customer_id
5191: AND exp_detail_line.lease_id = p_lease_id
5192: AND exp_detail_line.location_id = p_location_id