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_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXPCL_DTL

Line 9: TYPE exp_cls_line_mst_tbl IS TABLE OF pn_rec_expcl_dtlln%ROWTYPE INDEX BY BINARY_INTEGER;

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;

Line 10: TYPE exp_cls_line_dtl_tbl IS TABLE OF pn_rec_expcl_dtlacc%ROWTYPE INDEX BY BINARY_INTEGER;

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;
14:

Line 2234: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,

2230: p_master_data IN OUT NOCOPY exp_cls_line_mst_tbl,
2231: p_ovr_use_data IN OUT NOCOPY exp_cls_line_use_tbl,
2232: p_fee_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2233: p_share_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2234: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2235: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2236: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2237: p_location_id pn_space_assign_cust.location_id%TYPE,
2238: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,

Line 2235: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,

2231: p_ovr_use_data IN OUT NOCOPY exp_cls_line_use_tbl,
2232: p_fee_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2233: p_share_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2234: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2235: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2236: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2237: p_location_id pn_space_assign_cust.location_id%TYPE,
2238: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2239: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,

Line 2236: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,

2232: p_fee_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2233: p_share_use_table IN OUT NOCOPY exp_cls_line_use_tbl,
2234: p_master_data_id OUT NOCOPY pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2235: p_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2236: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2237: p_location_id pn_space_assign_cust.location_id%TYPE,
2238: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2239: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2240: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

Line 2240: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,

2236: p_expense_class_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE,
2237: p_location_id pn_space_assign_cust.location_id%TYPE,
2238: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2239: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2240: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2241: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2242: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,

Line 2241: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

2237: p_location_id pn_space_assign_cust.location_id%TYPE,
2238: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2239: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2240: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2241: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2242: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,

Line 2242: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,

2238: p_cust_space_assign_id pn_space_assign_cust.cust_space_assign_id%TYPE,
2239: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2240: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2241: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2242: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

Line 2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,

2239: p_cust_account_id pn_space_assign_cust.cust_account_id%TYPE,
2240: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2241: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2242: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

Line 2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,

2240: p_lease_id pn_rec_expcl_dtlln.lease_id%TYPE,
2241: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2242: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

Line 2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,

2241: p_recovery_space_std_code pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
2242: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2249: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

Line 2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

2242: p_recovery_type_code pn_rec_expcl_dtlln.recovery_type_code%TYPE,
2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2249: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2250: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,

Line 2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

2243: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2249: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2250: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2251: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

Line 2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

2244: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2249: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2250: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2251: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2252: p_use_prior_ovr BOOLEAN

Line 2249: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

2245: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2246: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2249: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2250: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2251: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2252: p_use_prior_ovr BOOLEAN
2253: )

Line 2251: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

2247: p_cls_line_share_pct pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
2248: p_cls_line_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
2249: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
2250: p_use_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2251: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2252: p_use_prior_ovr BOOLEAN
2253: )
2254: IS
2255: l_info VARCHAR2(300);

Line 2257: temp_rec pn_rec_expcl_dtlln%ROWTYPE;

2253: )
2254: IS
2255: l_info VARCHAR2(300);
2256: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.process_exp_cls_dtl_mst_data' ;
2257: temp_rec pn_rec_expcl_dtlln%ROWTYPE;
2258:
2259: BEGIN
2260:
2261: pnp_debug_pkg.log(l_desc ||' (+)');

Line 2344: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,

2340: ------------------------------------------------------------------------------+
2341:
2342: PROCEDURE process_exp_cls_dtl_dtl_data(
2343: p_detail_data IN OUT NOCOPY exp_cls_line_dtl_tbl,
2344: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2345: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2346: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

Line 2345: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,

2341:
2342: PROCEDURE process_exp_cls_dtl_dtl_data(
2343: p_detail_data IN OUT NOCOPY exp_cls_line_dtl_tbl,
2344: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2345: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2346: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,

Line 2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,

2345: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2346: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,

Line 2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,

2346: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2354: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,

Line 2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,

2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2354: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2355: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

Line 2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2354: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2355: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2356: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE

Line 2355: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2354: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2355: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2356: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE
2357: )
2358: IS
2359:

Line 2356: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE

2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,
2353: p_cls_line_shr_pct pn_rec_expcl_inc.cls_incl_share_pct%TYPE,
2354: p_cls_line_fee_bf_contr pn_rec_expcl_inc.cls_incl_fee_before_contr%TYPE,
2355: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
2356: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE
2357: )
2358: IS
2359:
2360: l_info VARCHAR2(300);

Line 2414: p_default_fee_bf pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE

2410: p_old_master_data exp_cls_line_mst_tbl,
2411: p_detail_data exp_cls_line_dtl_tbl,
2412: p_fee_use_table exp_cls_line_use_tbl,
2413: p_share_use_table exp_cls_line_use_tbl,
2414: p_default_fee_bf pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE
2415: )
2416: IS
2417: l_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
2418: l_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;

Line 2417: l_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;

2413: p_share_use_table exp_cls_line_use_tbl,
2414: p_default_fee_bf pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE
2415: )
2416: IS
2417: l_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
2418: l_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;
2419: l_master_keep_table number_table_type;
2420: l_detail_keep_table number_table_type;
2421: l_master_delete_table number_table_type;

Line 2418: l_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;

2414: p_default_fee_bf pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE
2415: )
2416: IS
2417: l_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
2418: l_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;
2419: l_master_keep_table number_table_type;
2420: l_detail_keep_table number_table_type;
2421: l_master_delete_table number_table_type;
2422: l_detail_delete_table number_table_type;

Line 2460: pn_rec_expcl_dtlln_pkg.insert_row(

2456:
2457: l_info:= ' inserting data into class lines master table';
2458: pnp_debug_pkg.log(l_info);
2459:
2460: pn_rec_expcl_dtlln_pkg.insert_row(
2461: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
2462: x_expense_class_dtl_id => p_master_data(i).expense_class_dtl_id,
2463: x_expense_class_line_id => l_expense_class_line_id,
2464: x_location_id => p_master_data(i).location_id,

Line 2493: pn_rec_expcl_dtlln_pkg.update_row(

2489:
2490: l_info:= ' updating data into class lines table, id: ' || l_expense_class_line_id;
2491: pnp_debug_pkg.log(l_info);
2492:
2493: pn_rec_expcl_dtlln_pkg.update_row(
2494: x_expense_class_line_id => l_expense_class_line_id,
2495: x_location_id => p_master_data(i).location_id,
2496: x_cust_space_assign_id => p_master_data(i).cust_space_assign_id,
2497: x_cust_account_id => p_master_data(i).cust_account_id,

Line 2541: pn_rec_expcl_dtlacc_pkg.insert_row(

2537: l_info := ' inserting detail data for class line header: '||
2538: p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id;
2539: pnp_debug_pkg.log(l_info);
2540:
2541: pn_rec_expcl_dtlacc_pkg.insert_row(
2542: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
2543: x_expense_class_line_id => p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id,
2544: x_expense_class_line_dtl_id => l_expense_class_line_dtl_id,
2545: x_expense_line_dtl_id => p_detail_data(i).expense_line_dtl_id,

Line 2567: pn_rec_expcl_dtlacc_pkg.update_row(

2563: l_info := ' updating detail data for class line header: '||
2564: p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id;
2565: pnp_debug_pkg.log(l_info);
2566:
2567: pn_rec_expcl_dtlacc_pkg.update_row(
2568: x_expense_class_line_dtl_id => l_expense_class_line_dtl_id,
2569: x_expense_line_dtl_id => p_detail_data(i).expense_line_dtl_id,
2570: x_expense_account_id => p_detail_data(i).expense_account_id,
2571: x_expense_type_code => p_detail_data(i).expense_type_code,

Line 2620: DELETE FROM pn_rec_expcl_dtlacc_all

2616: l_info := ' deleting unused data';
2617: pnp_debug_pkg.log(l_info);
2618:
2619: FORALL i IN 0 .. l_detail_delete_table.COUNT - 1
2620: DELETE FROM pn_rec_expcl_dtlacc_all
2621: WHERE expense_class_line_dtl_id = l_detail_delete_table(i);
2622:
2623: FORALL i IN 0 .. l_master_delete_table.COUNT - 1
2624: DELETE FROM pn_rec_expcl_dtlln_all

Line 2624: DELETE FROM pn_rec_expcl_dtlln_all

2620: DELETE FROM pn_rec_expcl_dtlacc_all
2621: WHERE expense_class_line_dtl_id = l_detail_delete_table(i);
2622:
2623: FORALL i IN 0 .. l_master_delete_table.COUNT - 1
2624: DELETE FROM pn_rec_expcl_dtlln_all
2625: WHERE expense_class_line_id = l_master_delete_table(i);
2626:
2627:
2628: pnp_debug_pkg.log(l_desc ||' (-)');

Line 2660: FROM pn_rec_expcl_dtlacc_all

2656: IS
2657: CURSOR get_affected_lines IS
2658: SELECT expense_class_line_dtl_id,
2659: expense_class_line_id
2660: FROM pn_rec_expcl_dtlacc_all
2661: WHERE expense_line_dtl_id = p_expense_line_dtl_id;
2662:
2663: CURSOR get_header_info (p_exp_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE) IS
2664: SELECT sum(nvl(computed_recoverable_amt, 0)) computed_recoverable_amount,

Line 2663: CURSOR get_header_info (p_exp_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE) IS

2659: expense_class_line_id
2660: FROM pn_rec_expcl_dtlacc_all
2661: WHERE expense_line_dtl_id = p_expense_line_dtl_id;
2662:
2663: CURSOR get_header_info (p_exp_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE) IS
2664: SELECT sum(nvl(computed_recoverable_amt, 0)) computed_recoverable_amount,
2665: sum(nvl(recoverable_amt, 0)) recoverable_amount,
2666: sum(nvl(expense_amt, 0)) expense_amount,
2667: sum(nvl(budgeted_amt, 0)) budgeted_amount,

Line 2670: FROM pn_rec_expcl_dtlacc_all

2666: sum(nvl(expense_amt, 0)) expense_amount,
2667: sum(nvl(budgeted_amt, 0)) budgeted_amount,
2668: min(decode(nvl(cls_line_dtl_share_pct_ovr, cls_line_dtl_share_pct), NULL, NULL, 100)) use_cls_line_share,
2669: min(decode(nvl(cls_line_dtl_fee_bf_contr_ovr, cls_line_dtl_fee_bf_contr), NULL, NULL, 0)) use_cls_line_fee
2670: FROM pn_rec_expcl_dtlacc_all
2671: WHERE expense_class_line_id = p_exp_cls_line_id;
2672:
2673: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2674: TYPE use_tbl IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;

Line 2698: DELETE pn_rec_expcl_dtlacc_all

2694: l_info := ' processing affected lines ';
2695: pnp_debug_pkg.log(l_info);
2696:
2697: FOR class_line_dtl_rec IN get_affected_lines LOOP
2698: DELETE pn_rec_expcl_dtlacc_all
2699: WHERE expense_class_line_dtl_id = class_line_dtl_rec.expense_class_line_dtl_id;
2700: hdr_id_list(hdr_id_list.COUNT) := class_line_dtl_rec.expense_class_line_id;
2701: END LOOP;
2702:

Line 2734: UPDATE pn_rec_expcl_dtlln_all

2730: l_info := ' updating header information ';
2731: pnp_debug_pkg.log(l_info);
2732:
2733: FORALL i IN 0 .. update_list.COUNT - 1
2734: UPDATE pn_rec_expcl_dtlln_all
2735: SET budgeted_amt = budgeted_list(i),
2736: expense_amt = expense_list(i),
2737: recoverable_amt = recoverable_list(i),
2738: computed_recoverable_amt = computed_recoverable_list(i) *

Line 2750: DELETE pn_rec_expcl_dtlln_all

2746: l_info := ' deleting unused header lines';
2747: pnp_debug_pkg.log(l_info);
2748:
2749: FORALL i IN 0 .. delete_list.COUNT - 1
2750: DELETE pn_rec_expcl_dtlln_all
2751: WHERE expense_class_line_id = delete_list(i);
2752:
2753: pnp_debug_pkg.log(l_desc ||' (-)');
2754:

Line 2902: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');

2898:
2899: END IF;
2900: END LOOP;
2901:
2902: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
2903: pnp_debug_pkg.put_log_msg('');
2904: pnp_debug_pkg.put_log_msg(fnd_message.get);
2905:
2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

Line 3079: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,

3075:
3076: PROCEDURE find_expense_ovr_values(
3077: p_master_ovr exp_cls_line_mst_tbl,
3078: p_detail_ovr exp_cls_line_dtl_tbl,
3079: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,
3080: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3081: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

Line 3080: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,

3076: PROCEDURE find_expense_ovr_values(
3077: p_master_ovr exp_cls_line_mst_tbl,
3078: p_detail_ovr exp_cls_line_dtl_tbl,
3079: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,
3080: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3081: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,

Line 3081: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,

3077: p_master_ovr exp_cls_line_mst_tbl,
3078: p_detail_ovr exp_cls_line_dtl_tbl,
3079: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,
3080: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3081: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,

Line 3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,

3078: p_detail_ovr exp_cls_line_dtl_tbl,
3079: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,
3080: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3081: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,

Line 3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,

3079: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,
3080: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3081: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

Line 3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,

3080: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,
3081: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

Line 3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,

3081: p_loc_id pn_rec_expcl_dtlln.location_id%TYPE,
3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3089: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

Line 3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,

3082: p_cust_id pn_rec_expcl_dtlln.cust_account_id%TYPE,
3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3089: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3090: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

Line 3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,

3083: p_rec_spc_std pn_rec_expcl_dtlln.recovery_space_std_code%TYPE,
3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3089: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3090: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
3091: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,

Line 3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,

3084: p_rec_type pn_rec_expcl_dtlln.recovery_type_code%TYPE,
3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3089: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3090: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
3091: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
3092: p_found IN OUT NOCOPY BOOLEAN,

Line 3089: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

3085: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3089: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3090: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
3091: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
3092: p_found IN OUT NOCOPY BOOLEAN,
3093: p_keep_override VARCHAR2

Line 3090: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,

3086: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3089: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3090: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
3091: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
3092: p_found IN OUT NOCOPY BOOLEAN,
3093: p_keep_override VARCHAR2
3094: )

Line 3091: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,

3087: p_fee_af_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE,
3088: p_mst_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_share_pct%TYPE,
3089: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,
3090: p_mst_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE,
3091: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE,
3092: p_found IN OUT NOCOPY BOOLEAN,
3093: p_keep_override VARCHAR2
3094: )
3095: IS

Line 3282: FROM pn_rec_expcl_dtl_all summary,

3278: class_line_dtl.expense_type_code exp_type,
3279: class_line_dtl.expense_account_id exp_acct,
3280: class_line_dtl.expense_class_line_dtl_id dtl_id,
3281: class_line_dtl.expense_class_line_id mst_id
3282: FROM pn_rec_expcl_dtl_all summary,
3283: pn_rec_expcl_dtlln_all class_line,
3284: pn_rec_expcl_dtlacc_all class_line_dtl,
3285: pn_rec_expcl_all class,
3286: pn_rec_exp_line_all lines

Line 3283: pn_rec_expcl_dtlln_all class_line,

3279: class_line_dtl.expense_account_id exp_acct,
3280: class_line_dtl.expense_class_line_dtl_id dtl_id,
3281: class_line_dtl.expense_class_line_id mst_id
3282: FROM pn_rec_expcl_dtl_all summary,
3283: pn_rec_expcl_dtlln_all class_line,
3284: pn_rec_expcl_dtlacc_all class_line_dtl,
3285: pn_rec_expcl_all class,
3286: pn_rec_exp_line_all lines
3287: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id

Line 3284: pn_rec_expcl_dtlacc_all class_line_dtl,

3280: class_line_dtl.expense_class_line_dtl_id dtl_id,
3281: class_line_dtl.expense_class_line_id mst_id
3282: FROM pn_rec_expcl_dtl_all summary,
3283: pn_rec_expcl_dtlln_all class_line,
3284: pn_rec_expcl_dtlacc_all class_line_dtl,
3285: pn_rec_expcl_all class,
3286: pn_rec_exp_line_all lines
3287: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3288: AND class_line.expense_class_dtl_id = summary.expense_class_dtl_id

Line 3296: FROM pn_rec_expcl_dtl_all summary,

3292: AND lines.expense_line_id = p_expense_line_id;
3293:
3294: CURSOR get_prior_cls_dtl_id IS
3295: SELECT summary.expense_class_dtl_id
3296: FROM pn_rec_expcl_dtl_all summary,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all line_hdr,
3299: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3300: WHERE expense_line_id = p_expense_line_id) ref_line_hdr

Line 3309: CURSOR get_ovr_from_prior (p_prior_cls_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE) IS

3305: AND line_hdr.to_date <= ref_line_hdr.to_date
3306: AND line_hdr.as_of_date < ref_line_hdr.as_of_date
3307: ORDER BY line_hdr.as_of_date DESC, line_hdr.to_date DESC, line_hdr.from_date DESC;
3308:
3309: CURSOR get_ovr_from_prior (p_prior_cls_dtl_id pn_rec_expcl_dtlln.expense_class_dtl_id%TYPE) IS
3310: SELECT class_line.cls_line_share_pct mst_shr_pc,
3311: class_line.cls_line_fee_after_contr_ovr mst_fee_af,
3312: class_line.cls_line_fee_before_contr_ovr mst_fee_bf,
3313: class_line.location_id location_id,

Line 3321: FROM pn_rec_expcl_dtlln_all class_line,

3317: class_line.recovery_space_std_code rec_space_std,
3318: class_line.recovery_type_code rec_type_code,
3319: class_line_dtl.expense_type_code exp_type,
3320: class_line_dtl.expense_account_id exp_acct
3321: FROM pn_rec_expcl_dtlln_all class_line,
3322: pn_rec_expcl_dtlacc_all class_line_dtl
3323: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3324: AND class_line.expense_class_dtl_id = p_prior_cls_dtl_id;
3325:

Line 3322: pn_rec_expcl_dtlacc_all class_line_dtl

3318: class_line.recovery_type_code rec_type_code,
3319: class_line_dtl.expense_type_code exp_type,
3320: class_line_dtl.expense_account_id exp_acct
3321: FROM pn_rec_expcl_dtlln_all class_line,
3322: pn_rec_expcl_dtlacc_all class_line_dtl
3323: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3324: AND class_line.expense_class_dtl_id = p_prior_cls_dtl_id;
3325:
3326: CURSOR is_reextract IS

Line 3334: FROM pn_rec_expcl_dtl_all dtl,

3330: dtl.default_area_class_id,
3331: dtl.cls_line_portion_pct,
3332: dtl.cls_line_fee_before_contr,
3333: dtl.cls_line_fee_after_contr
3334: FROM pn_rec_expcl_dtl_all dtl,
3335: pn_rec_expcl_all setup
3336: WHERE dtl.expense_line_id = p_expense_line_id
3337: AND setup.expense_class_id = p_expense_class_id
3338: AND setup.expense_class_id = dtl.expense_class_id;

Line 3350: l_dummy_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;

3346: l_master_data_id NUMBER;
3347: l_count NUMBER;
3348: l_found BOOLEAN;
3349: l_updcondition BOOLEAN;
3350: l_dummy_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3351:
3352: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3353: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;

Line 3352: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;

3348: l_found BOOLEAN;
3349: l_updcondition BOOLEAN;
3350: l_dummy_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3351:
3352: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3353: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3355: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;

Line 3353: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;

3349: l_updcondition BOOLEAN;
3350: l_dummy_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3351:
3352: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3353: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3355: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;

Line 3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;

3350: l_dummy_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3351:
3352: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3353: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3355: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;

Line 3355: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;

3351:
3352: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3353: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3355: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3359:

Line 3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;

3352: l_recov_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE;
3353: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3355: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3359:
3360: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;

Line 3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;

3353: l_cpt_recov_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE;
3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3355: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3359:
3360: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3361: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;

Line 3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;

3354: l_mst_share_pct_ovr pn_rec_expcl_dtlln.cls_line_share_pct%TYPE;
3355: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE;
3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3359:
3360: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3361: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;
3362: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;

Line 3360: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;

3356: l_fee_af_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_after_contr_ovr%TYPE;
3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3359:
3360: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3361: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;
3362: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;
3363:
3364: l_expense_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;

Line 3361: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;

3357: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%TYPE;
3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3359:
3360: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3361: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;
3362: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;
3363:
3364: l_expense_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
3365: l_expense_cls_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;

Line 3362: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;

3358: l_mst_fee_bf_contr_ovr pn_rec_expcl_dtlln.cls_line_fee_before_contr_ovr%TYPE;
3359:
3360: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3361: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;
3362: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;
3363:
3364: l_expense_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
3365: l_expense_cls_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;
3366: l_area_class_id pn_rec_expcl.area_class_id%TYPE;

Line 3364: l_expense_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;

3360: l_mst_fee_bf_contr pn_rec_expcl_dtl.cls_line_fee_before_contr%TYPE;
3361: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;
3362: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;
3363:
3364: l_expense_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
3365: l_expense_cls_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;
3366: l_area_class_id pn_rec_expcl.area_class_id%TYPE;
3367: l_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3368:

Line 3365: l_expense_cls_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;

3361: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;
3362: l_portion_pct pn_rec_expcl_dtl.cls_line_portion_pct%TYPE;
3363:
3364: l_expense_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
3365: l_expense_cls_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;
3366: l_area_class_id pn_rec_expcl.area_class_id%TYPE;
3367: l_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3368:
3369: l_fee_use_table exp_cls_line_use_tbl;

Line 3367: l_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;

3363:
3364: l_expense_cls_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE;
3365: l_expense_cls_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;
3366: l_area_class_id pn_rec_expcl.area_class_id%TYPE;
3367: l_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE;
3368:
3369: l_fee_use_table exp_cls_line_use_tbl;
3370: l_share_use_table exp_cls_line_use_tbl;
3371: l_ovr_use_table exp_cls_line_use_tbl;

Line 3383: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');

3379:
3380: BEGIN
3381: pnp_debug_pkg.log(l_desc ||' (+)');
3382:
3383: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3384: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3386: fnd_message.set_token('STR' , p_from_date);
3387: fnd_message.set_token('END' , p_to_date);

Line 3424: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');

3420:
3421: FOR check_exists IN is_reextract LOOP
3422:
3423: IF check_exists.status = 'LOCKED' THEN
3424: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3425: l_token := fnd_message.get;
3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);

Line 3517: pn_rec_expcl_dtl_pkg.update_row(

3513: l_mst_fee_bf_contr := expense_class_rec.class_fee_before_contr;
3514: l_fee_af_contr := expense_class_rec.class_fee_after_contr;
3515: l_portion_pct := expense_class_rec.portion_pct;
3516:
3517: pn_rec_expcl_dtl_pkg.update_row(
3518: x_expense_class_id => p_expense_class_id,
3519: x_expense_line_id => p_expense_line_id,
3520: x_expense_class_dtl_id => l_expense_class_dtl_id,
3521: x_status => 'OPEN',

Line 3542: pn_rec_expcl_dtl_pkg.insert_row(

3538: l_mst_fee_bf_contr := expense_class_rec.class_fee_before_contr;
3539: l_fee_af_contr := expense_class_rec.class_fee_after_contr;
3540: l_portion_pct := expense_class_rec.portion_pct;
3541:
3542: pn_rec_expcl_dtl_pkg.insert_row(
3543: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
3544: x_expense_class_id => p_expense_class_id,
3545: x_expense_line_id => p_expense_line_id,
3546: x_expense_class_dtl_id => l_expense_class_dtl_id,