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_DTLACC

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 2263: p_use_share_pct pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%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: )
2266: IS
2267: l_info VARCHAR2(300);

Line 2357: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,

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,
2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,

Line 2367: p_cls_line_shr_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%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
2369: )
2370: IS
2371:

Line 2368: p_cls_line_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%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
2369: )
2370: IS
2371:
2372: l_info VARCHAR2(300);

Line 2430: l_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE;

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;
2434: l_detail_delete_table number_table_type;

Line 2553: pn_rec_expcl_dtlacc_pkg.insert_row(

2549: l_info := ' inserting detail data for class line header: '||
2550: p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id;
2551: pnp_debug_pkg.log(l_info);
2552:
2553: pn_rec_expcl_dtlacc_pkg.insert_row(
2554: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
2555: x_expense_class_line_id => p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id,
2556: x_expense_class_line_dtl_id => l_expense_class_line_dtl_id,
2557: x_expense_line_dtl_id => p_detail_data(i).expense_line_dtl_id,

Line 2579: pn_rec_expcl_dtlacc_pkg.update_row(

2575: l_info := ' updating detail data for class line header: '||
2576: p_master_data(p_detail_data(i).expense_class_line_id).expense_class_line_id;
2577: pnp_debug_pkg.log(l_info);
2578:
2579: pn_rec_expcl_dtlacc_pkg.update_row(
2580: x_expense_class_line_dtl_id => l_expense_class_line_dtl_id,
2581: x_expense_line_dtl_id => p_detail_data(i).expense_line_dtl_id,
2582: x_expense_account_id => p_detail_data(i).expense_account_id,
2583: x_expense_type_code => p_detail_data(i).expense_type_code,

Line 2632: DELETE FROM pn_rec_expcl_dtlacc_all

2628: l_info := ' deleting unused data';
2629: pnp_debug_pkg.log(l_info);
2630:
2631: FORALL i IN 0 .. l_detail_delete_table.COUNT - 1
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

Line 2672: FROM pn_rec_expcl_dtlacc_all

2668: IS
2669: CURSOR get_affected_lines IS
2670: SELECT expense_class_line_dtl_id,
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,

Line 2682: FROM pn_rec_expcl_dtlacc_all

2678: sum(nvl(expense_amt, 0)) expense_amount,
2679: sum(nvl(budgeted_amt, 0)) budgeted_amount,
2680: min(decode(nvl(cls_line_dtl_share_pct_ovr, cls_line_dtl_share_pct), NULL, NULL, 100)) use_cls_line_share,
2681: min(decode(nvl(cls_line_dtl_fee_bf_contr_ovr, cls_line_dtl_fee_bf_contr), NULL, NULL, 0)) use_cls_line_fee
2682: FROM pn_rec_expcl_dtlacc_all
2683: WHERE expense_class_line_id = p_exp_cls_line_id;
2684:
2685: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2686: TYPE use_tbl IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;

Line 2710: DELETE pn_rec_expcl_dtlacc_all

2706: l_info := ' processing affected lines ';
2707: pnp_debug_pkg.log(l_info);
2708:
2709: FOR class_line_dtl_rec IN get_affected_lines LOOP
2710: DELETE pn_rec_expcl_dtlacc_all
2711: WHERE expense_class_line_dtl_id = class_line_dtl_rec.expense_class_line_dtl_id;
2712: hdr_id_list(hdr_id_list.COUNT) := class_line_dtl_rec.expense_class_line_id;
2713: END LOOP;
2714:

Line 3091: p_exp_type pn_rec_expcl_dtlacc.expense_type_code%TYPE,

3087:
3088: PROCEDURE find_expense_ovr_values(
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,

Line 3092: p_exp_acct pn_rec_expcl_dtlacc.expense_account_id%TYPE,

3088: PROCEDURE find_expense_ovr_values(
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,

Line 3097: p_exp_cls_line_dtl_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_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,
3101: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%TYPE,

Line 3098: p_exp_cls_line_id OUT NOCOPY pn_rec_expcl_dtlacc.expense_class_line_dtl_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,
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,

Line 3101: p_dtl_share_pct_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%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,
3105: p_keep_override VARCHAR2

Line 3103: p_dtl_fee_bf_contr_ovr OUT NOCOPY pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%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: )
3107: IS

Line 3296: pn_rec_expcl_dtlacc_all class_line_dtl,

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
3300: AND class_line.expense_class_dtl_id = summary.expense_class_dtl_id

Line 3334: pn_rec_expcl_dtlacc_all class_line_dtl

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:
3338: CURSOR is_reextract IS

Line 3367: l_dtl_share_pct_ovr pn_rec_expcl_dtlacc.cls_line_dtl_share_pct%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;
3371:

Line 3369: l_dtl_fee_bf_contr_ovr pn_rec_expcl_dtlacc.cls_line_dtl_fee_bf_contr%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;
3373: l_fee_af_contr pn_rec_expcl_dtl.cls_line_fee_after_contr%TYPE;

Line 3377: l_expense_cls_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%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:
3381: l_fee_use_table exp_cls_line_use_tbl;