DBA Data[Home] [Help]

APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_NUM_TBL_TYPE

Line 17: (P_PROJECT_ID_TAB IN SYSTEM.PA_NUM_TBL_TYPE,

13: * FULL -- DEFAULT, indicates full update of existing period *
14: * INCREMENTAL -- indicates increment the passed value of existing period *
15: **/
16: PROCEDURE MAINTAIN_ACTUAL_AMT_WRP
17: (P_PROJECT_ID_TAB IN SYSTEM.PA_NUM_TBL_TYPE,
18: P_WP_STR_VERSION_ID_TAB IN SYSTEM.PA_NUM_TBL_TYPE,
19: P_ACTUALS_THRU_DATE IN SYSTEM.PA_DATE_TBL_TYPE,
20: P_CALLING_CONTEXT IN VARCHAR2,
21: P_COMMIT_FLAG IN VARCHAR2,

Line 18: P_WP_STR_VERSION_ID_TAB IN SYSTEM.PA_NUM_TBL_TYPE,

14: * INCREMENTAL -- indicates increment the passed value of existing period *
15: **/
16: PROCEDURE MAINTAIN_ACTUAL_AMT_WRP
17: (P_PROJECT_ID_TAB IN SYSTEM.PA_NUM_TBL_TYPE,
18: P_WP_STR_VERSION_ID_TAB IN SYSTEM.PA_NUM_TBL_TYPE,
19: P_ACTUALS_THRU_DATE IN SYSTEM.PA_DATE_TBL_TYPE,
20: P_CALLING_CONTEXT IN VARCHAR2,
21: P_COMMIT_FLAG IN VARCHAR2,
22: P_INIT_MSG_FLAG IN VARCHAR2,

Line 124: l_bv_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

120: l_proj_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
121: l_pou_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
122:
123: l_bv_id pa_budget_versions.budget_version_id%type;
124: l_bv_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
125: l_ra_id_upd_reprt_tab pa_plsql_datatypes.IdTabTyp;
126:
127: /* Additional parameters for MAINTAIN_ACTUAL_AMT_RA */
128: l_open_pd_plan_amt_flag VARCHAR2(1);

Line 137: l_display_qty_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

133: l_last_update_login NUMBER := FND_GLOBAL.login_id;
134: l_sysdate DATE := SYSDATE;
135:
136: -- IPM: Added table to store Distinct ra_ids for workplan resources
137: l_display_qty_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
138:
139: BEGIN
140: IF p_init_msg_flag = 'Y' THEN
141: FND_MSG_PUB.initialize;

Line 3142: l_rep_budget_line_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3138: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
3139:
3140: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.blk_upd_reporting_lines_wrp';
3141:
3142: l_rep_budget_line_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3143: l_rep_res_assignment_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3144: l_rep_start_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
3145: l_rep_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
3146: l_rep_period_name_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 3143: l_rep_res_assignment_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3139:
3140: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.blk_upd_reporting_lines_wrp';
3141:
3142: l_rep_budget_line_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3143: l_rep_res_assignment_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3144: l_rep_start_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
3145: l_rep_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
3146: l_rep_period_name_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3147: l_rep_txn_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 3148: l_rep_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3144: l_rep_start_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
3145: l_rep_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
3146: l_rep_period_name_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3147: l_rep_txn_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3148: l_rep_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3149: l_rep_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3150: l_rep_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3151: l_rep_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3152: l_rep_project_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 3149: l_rep_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3145: l_rep_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
3146: l_rep_period_name_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3147: l_rep_txn_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3148: l_rep_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3149: l_rep_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3150: l_rep_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3151: l_rep_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3152: l_rep_project_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3153: l_rep_project_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3150: l_rep_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3146: l_rep_period_name_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
3147: l_rep_txn_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3148: l_rep_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3149: l_rep_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3150: l_rep_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3151: l_rep_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3152: l_rep_project_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3153: l_rep_project_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3154: l_rep_project_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3151: l_rep_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3147: l_rep_txn_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3148: l_rep_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3149: l_rep_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3150: l_rep_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3151: l_rep_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3152: l_rep_project_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3153: l_rep_project_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3154: l_rep_project_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3155: l_rep_project_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3153: l_rep_project_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3149: l_rep_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3150: l_rep_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3151: l_rep_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3152: l_rep_project_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3153: l_rep_project_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3154: l_rep_project_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3155: l_rep_project_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3156: l_rep_projfunc_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3157: l_rep_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3154: l_rep_project_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3150: l_rep_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3151: l_rep_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3152: l_rep_project_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3153: l_rep_project_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3154: l_rep_project_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3155: l_rep_project_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3156: l_rep_projfunc_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3157: l_rep_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3158: l_rep_projfunc_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3155: l_rep_project_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3151: l_rep_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3152: l_rep_project_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3153: l_rep_project_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3154: l_rep_project_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3155: l_rep_project_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3156: l_rep_projfunc_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3157: l_rep_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3158: l_rep_projfunc_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3159: l_rep_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3157: l_rep_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3153: l_rep_project_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3154: l_rep_project_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3155: l_rep_project_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3156: l_rep_projfunc_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3157: l_rep_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3158: l_rep_projfunc_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3159: l_rep_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3160: /*
3161: * Following _act_ variables to hold Actual amounts.

Line 3158: l_rep_projfunc_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3154: l_rep_project_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3155: l_rep_project_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3156: l_rep_projfunc_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3157: l_rep_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3158: l_rep_projfunc_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3159: l_rep_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3160: /*
3161: * Following _act_ variables to hold Actual amounts.
3162: */

Line 3159: l_rep_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3155: l_rep_project_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3156: l_rep_projfunc_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3157: l_rep_projfunc_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3158: l_rep_projfunc_burden_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3159: l_rep_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3160: /*
3161: * Following _act_ variables to hold Actual amounts.
3162: */
3163: l_rep_act_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3163: l_rep_act_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3159: l_rep_projfunc_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3160: /*
3161: * Following _act_ variables to hold Actual amounts.
3162: */
3163: l_rep_act_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3164: l_rep_txn_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3165: l_rep_txn_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3164: l_rep_txn_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3160: /*
3161: * Following _act_ variables to hold Actual amounts.
3162: */
3163: l_rep_act_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3164: l_rep_txn_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3165: l_rep_txn_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3165: l_rep_txn_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3161: * Following _act_ variables to hold Actual amounts.
3162: */
3163: l_rep_act_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3164: l_rep_txn_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3165: l_rep_txn_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3162: */
3163: l_rep_act_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3164: l_rep_txn_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3165: l_rep_txn_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3170: l_rep_pf_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3163: l_rep_act_quantity_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3164: l_rep_txn_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3165: l_rep_txn_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3170: l_rep_pf_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3171: l_rep_pf_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3164: l_rep_txn_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3165: l_rep_txn_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3170: l_rep_pf_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3171: l_rep_pf_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3172: l_rep_pf_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3165: l_rep_txn_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3170: l_rep_pf_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3171: l_rep_pf_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3172: l_rep_pf_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3173:

Line 3170: l_rep_pf_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3166: l_rep_txn_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3170: l_rep_pf_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3171: l_rep_pf_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3172: l_rep_pf_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3173:
3174: l_msg_count NUMBER;

Line 3171: l_rep_pf_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3167: l_rep_prj_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3170: l_rep_pf_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3171: l_rep_pf_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3172: l_rep_pf_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3173:
3174: l_msg_count NUMBER;
3175: l_data VARCHAR2(2000);

Line 3172: l_rep_pf_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

3168: l_rep_prj_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3169: l_rep_prj_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3170: l_rep_pf_act_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3171: l_rep_pf_act_burd_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3172: l_rep_pf_act_rev_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3173:
3174: l_msg_count NUMBER;
3175: l_data VARCHAR2(2000);
3176: l_msg_data VARCHAR2(2000);