APPS.PN_REC_CALC_PKG dependencies on PN_REC_EXPCL_DTLLN_ALL

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

821: ,p_error IN OUT NOCOPY VARCHAR2
822: ,p_error_code IN OUT NOCOPY NUMBER
823: ) IS
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;

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

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

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

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

Line 855: l_BUDGET_EXPENSE PN_REC_EXPCL_DTLLN_ALL.budgeted_amt%TYPE;

851: l_STATUS VARCHAR2(30):=NULL;
852: l_BUDGET_PRORATA_SHARE NUMBER:=0;
853: l_BUDGET_COST_PER_AREA NUMBER:=0;
854: l_BUDGET_RECOVERY NUMBER:=0;
855: l_BUDGET_EXPENSE PN_REC_EXPCL_DTLLN_ALL.budgeted_amt%TYPE;
856: l_count NUMBER := 0;
857: i NUMBER := 0;
858: l_prior_period_amount pn_rec_period_lines_all.actual_recovery%TYPE:=0;
859: l_prior_period_cap pn_rec_period_lines_all.constrained_actual%TYPE:=0;

Line 2901: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;

2897: ,p_error IN OUT NOCOPY VARCHAR2
2898: ,p_error_code IN OUT NOCOPY NUMBER
2899: ) IS
2900:
2901: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;
2902: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;
2903: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;
2904:
2905: BEGIN

Line 2902: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;

2898: ,p_error_code IN OUT NOCOPY NUMBER
2899: ) IS
2900:
2901: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;
2902: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;
2903: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;
2904:
2905: BEGIN
2906:

Line 2903: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;

2899: ) IS
2900:
2901: l_line_expenses pn_rec_expcl_dtlln_all.computed_recoverable_amt%TYPE;
2902: l_fee_before pn_rec_expcl_dtlln_all.cls_line_fee_before_contr_ovr%TYPE;
2903: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;
2904:
2905: BEGIN
2906:
2907: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (+) ');

Line 2917: ,pn_rec_expcl_dtlln_all exp_detail_line

2913: FROM pn_rec_expcl_all rec_exp_class
2914: ,pn_rec_agr_linexp_all lineexp
2915: ,pn_rec_expcl_dtl_all exp_detail_hdr
2916: ,pn_rec_exp_line_all exp_extract_hdr
2917: ,pn_rec_expcl_dtlln_all exp_detail_line
2918: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
2919: AND exp_detail_line.cust_account_id = p_customer_id
2920: AND exp_detail_line.lease_id = p_lease_id
2921: AND exp_detail_line.location_id = p_location_id

Line 2996: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS

2992: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2993: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2994: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2995: )
2996: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS
2997:
2998: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
2999:
3000: BEGIN

Line 2998: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;

2994: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2995: )
2996: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS
2997:
2998: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
2999:
3000: BEGIN
3001:
3002: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_budget_expenses (+) ');

Line 3029: ,pn_rec_expcl_dtlln_all exp_detail_line

3025: FROM pn_rec_expcl_all rec_exp_class
3026: ,pn_rec_agr_linexp_all lineexp
3027: ,pn_rec_expcl_dtl_all exp_detail_hdr
3028: ,pn_rec_exp_line_all exp_extract_hdr
3029: ,pn_rec_expcl_dtlln_all exp_detail_line
3030: ,pn_rec_expcl_dtlacc_all expcl_lndtl_alloc
3031: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
3032: AND exp_detail_line.cust_account_id = p_customer_id
3033: AND exp_detail_line.lease_id = p_lease_id

Line 5103: ,pn_rec_expcl_dtlln_all exp_detail_line

5099: FROM pn_rec_expcl_all rec_exp_class
5100: ,pn_rec_agr_linexp_all lineexp
5101: ,pn_rec_expcl_dtl_all exp_detail_hdr
5102: ,pn_rec_exp_line_all exp_extract_hdr
5103: ,pn_rec_expcl_dtlln_all exp_detail_line
5104: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
5105: AND exp_detail_line.cust_account_id = p_customer_id
5106: AND exp_detail_line.lease_id = p_lease_id
5107: AND exp_detail_line.location_id = p_location_id