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.PA_FP_CI_MERGE dependencies on PA_DATE_TBL_TYPE

Line 2900: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2896: L_TARG_CBS_ELEM_ID_TBL SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE(); --bug#16200605
2897: L_RA_DML_CODE_TBL SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2898: L_targ_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2899: l_src_ra_id_cnt_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2900: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2901: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2902: l_targ_rbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2903: l_targ_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2904: l_targ_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2901: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

2897: L_RA_DML_CODE_TBL SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
2898: L_targ_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2899: l_src_ra_id_cnt_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2900: l_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2901: l_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2902: l_targ_rbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2903: l_targ_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2904: l_targ_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2905: l_targ_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2937: l_targ_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(); -- Bug 8350296

2933: l_targ_RATE_EXP_FC_CUR_COD_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2934: l_targ_RATE_EXPEND_ORG_ID_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2935: l_targ_INCR_BY_RES_CLS_COD_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2936: l_targ_INCUR_BY_ROLE_ID_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2937: l_targ_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(); -- Bug 8350296
2938:
2939: -- End of tables used to bulk collect and insert into pa_resource_assignments
2940:
2941: --These pl/sql tbls will store the data corresponding to the details such as task_id, rate based flag

Line 3033: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

3029:
3030: l_project_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;
3031:
3032: -- Start of variable to be used in Calculate API Call
3033: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3034: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3035:
3036: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3037: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3034: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

3030: l_project_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;
3031:
3032: -- Start of variable to be used in Calculate API Call
3033: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3034: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3035:
3036: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3037: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3038: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3045: l_prm_bl_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();

3041: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3042: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3043: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3044: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3045: l_prm_bl_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();
3046: l_prm_bl_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();
3047: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3048: l_pc_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3049: l_pc_burd_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3046: l_prm_bl_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();

3042: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3043: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3044: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3045: l_prm_bl_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();
3046: l_prm_bl_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();
3047: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3048: l_pc_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3049: l_pc_burd_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3050: l_pc_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3068: l_upd_bl_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();

3064: l_pji_prm_rbf_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
3065: l_upd_bl_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3066: l_upd_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3067: l_upd_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
3068: l_upd_bl_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();
3069: l_upd_bl_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();
3070: l_upd_cost_rejection_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3071: l_upd_revenue_rejection_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3072: l_upd_burden_rejection_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 3069: l_upd_bl_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();

3065: l_upd_bl_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3066: l_upd_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3067: l_upd_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
3068: l_upd_bl_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();
3069: l_upd_bl_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();
3070: l_upd_cost_rejection_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3071: l_upd_revenue_rejection_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3072: l_upd_burden_rejection_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3073: l_upd_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 3102: l_bl_START_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

3098:
3099: -- Start of tables prepared to insert/update into pa_budget_lines
3100: l_bl_RESOURCE_ASIGNMENT_ID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3101: l_upd_ra_bl_dml_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3102: l_bl_START_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3103: l_bl_END_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3104: l_bl_PERIOD_NAME_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3105: l_bl_QUANTITY_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3106: l_bl_RAW_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3103: l_bl_END_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

3099: -- Start of tables prepared to insert/update into pa_budget_lines
3100: l_bl_RESOURCE_ASIGNMENT_ID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3101: l_upd_ra_bl_dml_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3102: l_bl_START_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3103: l_bl_END_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3104: l_bl_PERIOD_NAME_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3105: l_bl_QUANTITY_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3106: l_bl_RAW_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3107: l_bl_BURDENED_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3155: l_bl_PROJFUNC_COST_RAT_DAT_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

3151: l_bl_HEAD_COUNT_ADJ_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3152: l_bl_PROJFUNC_CUR_CODE_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3153: l_bl_PROJFUNC_COST_RAT_TYP_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3154: l_bl_PJFN_COST_RAT_DAT_TYP_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3155: l_bl_PROJFUNC_COST_RAT_DAT_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3156: l_bl_PROJFUNC_REV_RATE_TYP_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3157: l_bl_PJFN_REV_RAT_DAT_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3158: l_bl_PROJFUNC_REV_RAT_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3159: l_bl_PROJECT_COST_RAT_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 3158: l_bl_PROJFUNC_REV_RAT_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

3154: l_bl_PJFN_COST_RAT_DAT_TYP_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3155: l_bl_PROJFUNC_COST_RAT_DAT_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3156: l_bl_PROJFUNC_REV_RATE_TYP_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3157: l_bl_PJFN_REV_RAT_DAT_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3158: l_bl_PROJFUNC_REV_RAT_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3159: l_bl_PROJECT_COST_RAT_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3160: l_bl_PROJ_COST_RAT_DAT_TYP_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3161: l_bl_PROJ_COST_RATE_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3162: l_bl_PROJECT_RAW_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3161: l_bl_PROJ_COST_RATE_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

3157: l_bl_PJFN_REV_RAT_DAT_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3158: l_bl_PROJFUNC_REV_RAT_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3159: l_bl_PROJECT_COST_RAT_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3160: l_bl_PROJ_COST_RAT_DAT_TYP_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3161: l_bl_PROJ_COST_RATE_DATE_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3162: l_bl_PROJECT_RAW_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3163: l_bl_PROJECT_BURDENED_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3164: l_bl_PROJECT_REV_RATE_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3165: l_bl_PRJ_REV_RAT_DATE_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 3166: l_bl_PROJECT_REV_RATE_DATE SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

3162: l_bl_PROJECT_RAW_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3163: l_bl_PROJECT_BURDENED_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3164: l_bl_PROJECT_REV_RATE_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3165: l_bl_PRJ_REV_RAT_DATE_TYPE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3166: l_bl_PROJECT_REV_RATE_DATE SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
3167: l_bl_PROJECT_REVENUE_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3168: l_bl_TXN_CURRENCY_CODE_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
3169: l_bl_TXN_RAW_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3170: l_bl_TXN_BURDENED_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 11748: l_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

11744: l_plan_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11745: l_ci_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11746: l_ci_plan_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11747: l_record_ver_number_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11748: l_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11749: l_created_by_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11750: l_last_update_login_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11751: l_last_updated_by_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11752: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 11752: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

11748: l_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11749: l_created_by_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11750: l_last_update_login_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11751: l_last_updated_by_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11752: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11753: l_incl_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
11754: l_incl_by_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.PA_NUM_TBL_TYPE();
11755: l_version_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
11756: l_impl_proj_func_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 13645: l_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE;

13641: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13642: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13643: l_burden_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13644: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13645: l_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE;
13646: l_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE;
13647: l_change_reason_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE ;
13648: l_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
13649: -- target ci variables

Line 13646: l_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE;

13642: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13643: l_burden_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13644: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13645: l_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE;
13646: l_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE;
13647: l_change_reason_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE ;
13648: l_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
13649: -- target ci variables
13650: l_dc_line_id_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;

Line 13663: l_effective_from_to_tbl SYSTEM.PA_DATE_TBL_TYPE;

13659: l_burdened_cost_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13660: l_raw_cost_rate_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13661: l_burden_cost_rate_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13662: l_resource_asgn_id_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13663: l_effective_from_to_tbl SYSTEM.PA_DATE_TBL_TYPE;
13664: l_effective_to_to_tbl SYSTEM.PA_DATE_TBL_TYPE;
13665: -- for insert
13666: i_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13667: i_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 13664: l_effective_to_to_tbl SYSTEM.PA_DATE_TBL_TYPE;

13660: l_raw_cost_rate_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13661: l_burden_cost_rate_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13662: l_resource_asgn_id_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13663: l_effective_from_to_tbl SYSTEM.PA_DATE_TBL_TYPE;
13664: l_effective_to_to_tbl SYSTEM.PA_DATE_TBL_TYPE;
13665: -- for insert
13666: i_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13667: i_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
13668: i_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 13676: i_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

13672: i_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13673: i_planning_resource_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13674: i_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13675: i_burden_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13676: i_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
13677: i_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
13678: -- for update
13679: u_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13680: u_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 13677: i_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

13673: i_planning_resource_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13674: i_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13675: i_burden_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13676: i_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
13677: i_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
13678: -- for update
13679: u_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13680: u_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13681: u_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 13692: u_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();

13688: u_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13689: u_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13690: u_burden_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13691: u_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13692: u_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
13693: u_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
13694: u_change_reason_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
13695: u_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
13696: --

Line 13693: u_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

13689: u_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13690: u_burden_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13691: u_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13692: u_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
13693: u_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
13694: u_change_reason_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
13695: u_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
13696: --
13697: l_api_version number := 1;