5:
6: ------------------------------ DECLARATIONS ----------------------------------+
7:
8: TYPE exp_cls_line_use_tbl IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;
9: TYPE exp_cls_line_mst_tbl IS TABLE OF pn_rec_expcl_dtlln%ROWTYPE INDEX BY BINARY_INTEGER;
10: TYPE exp_cls_line_dtl_tbl IS TABLE OF pn_rec_expcl_dtlacc%ROWTYPE INDEX BY BINARY_INTEGER;
11: TYPE area_cls_line_dtl_tbl IS TABLE OF pn_rec_arcl_dtlln%ROWTYPE INDEX BY BINARY_INTEGER;
12: TYPE area_cls_line_hdr_tbl IS TABLE OF pn_rec_arcl_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
13: TYPE area_cls_exc_tbl IS TABLE OF pn_rec_arcl_exc%ROWTYPE INDEX BY BINARY_INTEGER;
2242: p_master_data IN OUT NOCOPY exp_cls_line_mst_tbl,
2243: p_ovr_use_data IN OUT NOCOPY exp_cls_line_use_tbl,
2244: p_fee_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2245: p_share_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2246: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2247: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2248: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2249: p_location_id pn_space_assign_cust.location_id%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2243: p_ovr_use_data IN OUT NOCOPY exp_cls_line_use_tbl,
2244: p_fee_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2245: p_share_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2246: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2247: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2248: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2249: p_location_id pn_space_assign_cust.location_id%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2244: p_fee_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2245: p_share_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2246: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2247: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2248: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2249: p_location_id pn_space_assign_cust.location_id%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2248: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2249: p_location_id pn_space_assign_cust.location_id%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2249: p_location_id pn_space_assign_cust.location_id%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2250: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2251: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2259: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2252: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2259: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2260: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2253: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2259: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2260: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2261: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2254: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2259: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2260: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2261: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2262: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2255: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2259: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2260: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2261: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2262: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2263: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2256: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2259: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2260: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2261: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2262: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2263: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2264: p_use_prior_ovr BOOLEAN
2257: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2258: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2259: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2260: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2261: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2262: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2263: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2264: p_use_prior_ovr BOOLEAN
2265: )
2265: )
2266: IS
2267: l_info VARCHAR2(300);
2268: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.process_exp_cls_dtl_mst_data' ;
2269: temp_rec pn_rec_expcl_dtlln%ROWTYPE;
2270:
2271: BEGIN
2272:
2273: pnp_debug_pkg.log(l_desc ||' (+)');
2352: ------------------------------------------------------------------------------+
2353:
2354: PROCEDURE process_exp_cls_dtl_dtl_data(
2355: p_detail_data IN OUT NOCOPY exp_cls_line_dtl_tbl,
2356: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2357: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2358: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2359: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2357: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2358: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2359: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2363: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2364: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2365: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2358: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2359: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2363: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2364: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2365: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2366: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2359: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2363: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2364: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2365: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2366: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2367: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2363: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2364: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2365: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2366: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2367: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2368: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE
2425: p_share_use_table exp_cls_line_use_tbl,
2426: p_default_fee_bf pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE
2427: )
2428: IS
2429: l_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
2430: l_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;
2431: l_master_keep_table number_table_type;
2432: l_detail_keep_table number_table_type;
2433: l_master_delete_table number_table_type;
2468:
2469: l_info:= ' inserting data into class lines master table';
2470: pnp_debug_pkg.log(l_info);
2471:
2472: pn_rec_expcl_dtlln_pkg.insert_row(
2473: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
2474: x_expense_class_dtl_id => p_master_data(i).expense_class_dtl_id,
2475: x_expense_class_line_id => l_expense_class_line_id,
2476: x_location_id => p_master_data(i).location_id,
2501:
2502: l_info:= ' updating data into class lines table, id: ' || l_expense_class_line_id;
2503: pnp_debug_pkg.log(l_info);
2504:
2505: pn_rec_expcl_dtlln_pkg.update_row(
2506: x_expense_class_line_id => l_expense_class_line_id,
2507: x_location_id => p_master_data(i).location_id,
2508: x_cust_space_assign_id => p_master_data(i).cust_space_assign_id,
2509: x_cust_account_id => p_master_data(i).cust_account_id,
2632: DELETE FROM pn_rec_expcl_dtlacc_all
2633: WHERE expense_class_line_dtl_id = l_detail_delete_table(i);
2634:
2635: FORALL i IN 0 .. l_master_delete_table.COUNT - 1
2636: DELETE FROM pn_rec_expcl_dtlln_all
2637: WHERE expense_class_line_id = l_master_delete_table(i);
2638:
2639:
2640: pnp_debug_pkg.log(l_desc ||' (-)');
2671: expense_class_line_id
2672: FROM pn_rec_expcl_dtlacc_all
2673: WHERE expense_line_dtl_id = p_expense_line_dtl_id;
2674:
2675: CURSOR get_header_info (p_exp_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE) IS
2676: SELECT sum(nvl(computed_recoverable_amt, 0)) computed_recoverable_amount,
2677: sum(nvl(recoverable_amt, 0)) recoverable_amount,
2678: sum(nvl(expense_amt, 0)) expense_amount,
2679: sum(nvl(budgeted_amt, 0)) budgeted_amount,
2742: l_info := ' updating header information ';
2743: pnp_debug_pkg.log(l_info);
2744:
2745: FORALL i IN 0 .. update_list.COUNT - 1
2746: UPDATE pn_rec_expcl_dtlln_all
2747: SET budgeted_amt = budgeted_list(i),
2748: expense_amt = expense_list(i),
2749: recoverable_amt = recoverable_list(i),
2750: computed_recoverable_amt = computed_recoverable_list(i) *
2758: l_info := ' deleting unused header lines';
2759: pnp_debug_pkg.log(l_info);
2760:
2761: FORALL i IN 0 .. delete_list.COUNT - 1
2762: DELETE pn_rec_expcl_dtlln_all
2763: WHERE expense_class_line_id = delete_list(i);
2764:
2765: pnp_debug_pkg.log(l_desc ||' (-)');
2766:
3089: p_master_ovr exp_cls_line_mst_tbl,
3090: p_detail_ovr exp_cls_line_dtl_tbl,
3091: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,
3092: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3093: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3094: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3095: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3096: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3097: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3090: p_detail_ovr exp_cls_line_dtl_tbl,
3091: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,
3092: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3093: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3094: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3095: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3096: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3097: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3098: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3091: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,
3092: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3093: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3094: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3095: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3096: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3097: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3098: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3099: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3092: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3093: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3094: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3095: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3096: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3097: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3098: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3099: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3100: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3095: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3096: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3097: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3098: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3099: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3100: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3101: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3102: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
3103: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
3096: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3097: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3098: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3099: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3100: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3101: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3102: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
3103: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
3104: p_found IN OUT NOCOPY BOOLEAN,
3098: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3099: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3100: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3101: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3102: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
3103: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
3104: p_found IN OUT NOCOPY BOOLEAN,
3105: p_keep_override VARCHAR2
3106: )
3291: class_line_dtl.expense_account_id exp_acct,
3292: class_line_dtl.expense_class_line_dtl_id dtl_id,
3293: class_line_dtl.expense_class_line_id mst_id
3294: FROM pn_rec_expcl_dtl_all summary,
3295: pn_rec_expcl_dtlln_all class_line,
3296: pn_rec_expcl_dtlacc_all class_line_dtl,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all lines
3299: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3317: AND line_hdr.to_date <= ref_line_hdr.to_date
3318: AND line_hdr.as_of_date < ref_line_hdr.as_of_date
3319: ORDER BY line_hdr.as_of_date DESC, line_hdr.to_date DESC, line_hdr.from_date DESC;
3320:
3321: CURSOR get_ovr_from_prior (p_prior_cls_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE) IS
3322: SELECT class_line.cls_line_share_pct mst_shr_pc,
3323: class_line.cls_line_fee_after_contr_ovr mst_fee_af,
3324: class_line.cls_line_fee_before_contr_ovr mst_fee_bf,
3325: class_line.location_id location_id,
3329: class_line.recovery_space_std_code rec_space_std,
3330: class_line.recovery_type_code rec_type_code,
3331: class_line_dtl.expense_type_code exp_type,
3332: class_line_dtl.expense_account_id exp_acct
3333: FROM pn_rec_expcl_dtlln_all class_line,
3334: pn_rec_expcl_dtlacc_all class_line_dtl
3335: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3336: AND class_line.expense_class_dtl_id = p_prior_cls_dtl_id;
3337:
3360: l_found BOOLEAN;
3361: l_updcondition BOOLEAN;
3362: l_dummy_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3363:
3364: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3365: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3366: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3367: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3368: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3361: l_updcondition BOOLEAN;
3362: l_dummy_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3363:
3364: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3365: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3366: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3367: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3368: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3369: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3362: l_dummy_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3363:
3364: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3365: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3366: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3367: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3368: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3369: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3370: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3364: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3365: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3366: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3367: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3368: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3369: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3370: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3371:
3372: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3366: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3367: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3368: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3369: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3370: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3371:
3372: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3373: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;
3374: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;
3372: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3373: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;
3374: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;
3375:
3376: l_expense_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
3377: l_expense_cls_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;
3378: l_area_class_id pn_rec_expcl.area_class_id%TYPE;
3379: l_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3380: