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_VARCHAR2_1_TBL_TYPE

Line 926: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

922: l_ci_cost_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
923: l_ci_rev_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
924: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
925: l_target_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
926: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
927: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
928: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type:=SYSTEM.pa_varchar2_2000_tbl_type();
929: l_translated_err_msg_count NUMBER;
930: l_translated_err_msg_level_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 927: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

923: l_ci_rev_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
924: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
925: l_target_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
926: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
927: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
928: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type:=SYSTEM.pa_varchar2_2000_tbl_type();
929: l_translated_err_msg_count NUMBER;
930: l_translated_err_msg_level_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
931:

Line 2845: l_impl_qty_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2841: l_fp_version_ids_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2842:
2843: l_src_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2844: l_impl_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2845: l_impl_qty_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2846:
2847: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
2848:
2849: l_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 2921: l_targ_INCURED_BY_RES_FLAG_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2917: l_targ_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE:= SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
2918: l_targ_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2919: l_targ_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2920: l_targ_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2921: l_targ_INCURED_BY_RES_FLAG_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2922: l_targ_RATE_BASED_FLAG_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2923: l_targ_RES_RATE_BASED_FLAG_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); --IPM Architecture Enhancement
2924: l_targ_RESOURCE_CLASS_FLAG_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2925: l_targ_NAMED_ROLE_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE:= SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 2947: l_upd_ra_rbf_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2943: l_upd_ra_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2944: l_upd_ra_rbs_elem_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2945: l_upd_ra_cbs_elem_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE(); --bug#16911079
2946: l_upd_ra_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2947: l_upd_ra_rbf_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2948: l_upd_ra_res_asmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2949:
2950:
2951: l_index NUMBER;

Line 2955: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2951: l_index NUMBER;
2952: l_matching_index NUMBER;
2953: -- Start of local Variables for calling get_resource_defaults API
2954: l_da_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
2955: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2956: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2957: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2958: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2959: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();

Line 2978: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2974: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2975: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2976: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2977: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2978: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2979: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2980: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2981: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2982: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();

Line 2983: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2979: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2980: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2981: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2982: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2983: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2984: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2985: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2986: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2987:

Line 2990: lresource_class_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

2986: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2987:
2988: --for Start bug 5291484
2989: lresource_list_members_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2990: lresource_class_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2991: lresource_class_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2992: lresource_class_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
2993: lres_type_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2994: lperson_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();

Line 3013: lincurred_by_res_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

3009: l_da_supplier_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3010: l_da_spread_curve_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3011: l_da_etc_method_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3012: l_da_mfc_cost_type_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3013: lincurred_by_res_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3014: lincur_by_res_cls_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3015: l_da_incur_by_role_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3016: l_da_unit_of_measure_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3017: l_da_org_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();

Line 3018: l_da_rate_based_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

3014: lincur_by_res_cls_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3015: l_da_incur_by_role_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3016: l_da_unit_of_measure_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3017: l_da_org_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3018: l_da_rate_based_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3019: lrate_expenditure_type_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3020: l_da_rate_func_curr_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3021: l_da_incur_by_res_type_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3022: ltxnsrctyp_code_rbs_prm_tbl_1 SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();

Line 3064: l_pji_prm_rbf_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

3060: l_pji_prm_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3061: l_pji_prm_rbs_elem_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3062: l_pji_prm_cbs_elem_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); --bug#16911079
3063: l_pji_prm_res_cls_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_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();

Line 3078: l_delete_budget_lines_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

3074: l_upd_pc_cur_conv_rej_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3075: l_upd_pfc_cur_conv_rej_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3076:
3077: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3078: l_delete_budget_lines_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3079: L_SPREAD_AMOUNT_FLAGS_TBL SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3080:
3081:
3082: -- End of variable to be used in Calculate API Call

Line 3079: L_SPREAD_AMOUNT_FLAGS_TBL SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

3075: l_upd_pfc_cur_conv_rej_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3076:
3077: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3078: l_delete_budget_lines_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3079: L_SPREAD_AMOUNT_FLAGS_TBL SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3080:
3081:
3082: -- End of variable to be used in Calculate API Call
3083:

Line 3134: l_bl_CCID_GEN_STATUS_CODE_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

3130: l_bl_REVENUE_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3131: l_bl_BURDEN_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3132: l_bl_OTHER_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3133: l_bl_CODE_COMBINATION_ID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3134: l_bl_CCID_GEN_STATUS_CODE_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3135: l_bl_CCID_GEN_REJ_MESSAGE_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3136: l_bl_REQUEST_ID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3137: l_bl_BORROWED_REVENUE_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3138: l_bl_TP_REVENUE_IN_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 3188: l_bl_rbf_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

3184: l_bl_BURDEN_COST_RATE_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3185: l_bl_BURDEN_COST_RAT_OVRID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3186: l_bl_PC_CUR_CONV_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3187: l_bl_PFC_CUR_CONV_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3188: l_bl_rbf_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3189:
3190: -- End of tables prepared to insert/update into pa_budget_lines
3191:
3192: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;

Line 8778: l_bl_rbf_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

8774: --for the resource assignment to which the budget line corresponds. This will help in populating
8775: --correct values in quantity and rate columns of budget lines.Bug 3621847
8776: IF l_upd_ra_bl_dml_code_tbl.COUNT>0 THEN
8777:
8778: l_bl_rbf_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
8779: l_bl_rbf_flag_tbl.EXTEND(l_bl_RESOURCE_ASIGNMENT_ID_tbl.COUNT);
8780: --dbms_output.put_line('I42');
8781: FOR KK IN l_bl_RESOURCE_ASIGNMENT_ID_tbl.FIRST..l_bl_RESOURCE_ASIGNMENT_ID_tbl.LAST LOOP
8782:

Line 10369: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

10365: ,p_ci_all_version_id_tbl IN SYSTEM.pa_num_tbl_type
10366: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
10367: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
10368: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
10369: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10370: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10371: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10372: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10373: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE

Line 10370: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

10366: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
10367: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
10368: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
10369: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10370: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10371: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10372: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10373: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
10374: ,p_update_agreement_amt_flag IN VARCHAR2

Line 10371: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

10367: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
10368: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
10369: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10370: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10371: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10372: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10373: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
10374: ,p_update_agreement_amt_flag IN VARCHAR2
10375: ,p_funding_category IN VARCHAR2

Line 10383: ,x_submit_version_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type --File.Sql.39 bug 4440895

10379: ,x_ci_all_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10380: ,x_budget_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10381: ,x_fin_plan_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10382: ,x_fin_plan_type_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type --File.Sql.39 bug 4440895
10383: ,x_submit_version_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type --File.Sql.39 bug 4440895
10384: ,x_ci_number OUT NOCOPY SYSTEM.pa_varchar2_100_tbl_type --File.Sql.39 bug 4440895
10385: ,x_budget_ci_map_rec_tbl OUT NOCOPY budget_ci_map_rec_tbl_type --File.Sql.39 bug 4440895
10386: ,x_agreement_id OUT NOCOPY pa_agreements_all.agreement_id%TYPE --File.Sql.39 bug 4440895
10387: ,x_funding_category OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 10415: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

10411: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
10412: l_project_id pa_projects_all.project_id%TYPE;
10413: l_source_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
10414: l_calling_mode_for_chk_api VARCHAR2(30);
10415: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
10416: l_copy_ci_ver_flag VARCHAR2(1);
10417: l_record_version_number pa_budget_versions.record_Version_number%TYPE;
10418: l_cost_ci_ver_index NUMBER;
10419: l_rev_ci_ver_index NUMBER;

Line 10433: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;

10429: l_rev_impact_impl_flag VARCHAR2(1);
10430: l_partially_impl_flag VARCHAR2(1);
10431: l_agreement_num pa_agreements_all.agreement_num%TYPE;
10432: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10433: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10434: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10435: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
10437: l_total_amount NUMBER;

Line 10434: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;

10430: l_partially_impl_flag VARCHAR2(1);
10431: l_agreement_num pa_agreements_all.agreement_num%TYPE;
10432: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10433: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10434: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10435: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
10437: l_total_amount NUMBER;
10438: l_implemented_amount NUMBER;

Line 10467: l_app_cost_plan_type_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

10463: l_version_type pa_budget_versions.version_type%TYPE;
10464: l_version_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
10465: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
10466: -- Bug 5845142
10467: l_app_cost_plan_type_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
10468: l_app_rev_plan_type_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
10469: l_app_cost_plan_type_flag VARCHAR2(1);
10470: l_app_rev_plan_type_flag VARCHAR2(1);
10471:

Line 10468: l_app_rev_plan_type_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

10464: l_version_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
10465: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
10466: -- Bug 5845142
10467: l_app_cost_plan_type_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
10468: l_app_rev_plan_type_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
10469: l_app_cost_plan_type_flag VARCHAR2(1);
10470: l_app_rev_plan_type_flag VARCHAR2(1);
10471:
10472: l_part_impl_err VARCHAR2(1);

Line 10652: l_impl_cost_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();

10648: x_ci_rev_version_id_tbl :=SYSTEM.pa_num_tbl_type();
10649: x_ci_all_version_id_tbl :=SYSTEM.pa_num_tbl_type();
10650: x_budget_version_id_tbl :=SYSTEM.pa_num_tbl_type();
10651: x_ci_number :=SYSTEM.pa_varchar2_100_tbl_type();
10652: l_impl_cost_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10653: l_impl_rev_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10654: x_submit_version_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10655: x_fin_plan_type_id_tbl :=SYSTEM.pa_num_tbl_type();
10656: x_fin_plan_type_name_tbl :=SYSTEM.pa_varchar2_150_tbl_type();

Line 10653: l_impl_rev_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();

10649: x_ci_all_version_id_tbl :=SYSTEM.pa_num_tbl_type();
10650: x_budget_version_id_tbl :=SYSTEM.pa_num_tbl_type();
10651: x_ci_number :=SYSTEM.pa_varchar2_100_tbl_type();
10652: l_impl_cost_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10653: l_impl_rev_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10654: x_submit_version_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10655: x_fin_plan_type_id_tbl :=SYSTEM.pa_num_tbl_type();
10656: x_fin_plan_type_name_tbl :=SYSTEM.pa_varchar2_150_tbl_type();
10657: IF p_funding_category IS NULL THEN

Line 10654: x_submit_version_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();

10650: x_budget_version_id_tbl :=SYSTEM.pa_num_tbl_type();
10651: x_ci_number :=SYSTEM.pa_varchar2_100_tbl_type();
10652: l_impl_cost_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10653: l_impl_rev_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10654: x_submit_version_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
10655: x_fin_plan_type_id_tbl :=SYSTEM.pa_num_tbl_type();
10656: x_fin_plan_type_name_tbl :=SYSTEM.pa_varchar2_150_tbl_type();
10657: IF p_funding_category IS NULL THEN
10658: x_funding_category := 'ADDITIONAL';

Line 12542: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

12538: ,p_ci_all_version_id_tbl IN SYSTEM.pa_num_tbl_type
12539: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
12540: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
12541: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
12542: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12543: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12544: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12545: ,p_partial_impl_rev_amt IN NUMBER
12546: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE

Line 12543: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

12539: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
12540: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
12541: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
12542: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12543: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12544: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12545: ,p_partial_impl_rev_amt IN NUMBER
12546: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
12547: ,p_update_agreement_amt_flag IN VARCHAR2

Line 12544: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

12540: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
12541: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
12542: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12543: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12544: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12545: ,p_partial_impl_rev_amt IN NUMBER
12546: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
12547: ,p_update_agreement_amt_flag IN VARCHAR2
12548: ,p_funding_category IN VARCHAR2

Line 12581: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

12577: l_ci_cost_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12578: l_ci_rev_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12579: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12580: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12581: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12582: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12583: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12584: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12585: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

Line 12582: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

12578: l_ci_rev_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12579: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12580: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12581: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12582: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12583: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12584: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12585: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12586: l_succ_impl_plan_types SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

Line 12583: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

12579: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12580: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12581: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12582: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12583: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
12584: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
12585: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12586: l_succ_impl_plan_types SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
12587: l_succ_impl_cos SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

Line 13710: l_found SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

13706: i_PaCiDirCostDetTbl PaCiDirCostTblType;
13707: u_PaCiDirCostDetTbl PaCiDirCostTblType;
13708: x_PaCiDirCostDetTbl PaCiDirCostTblType;
13709:
13710: l_found SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
13711: l_rec_index SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13712:
13713: ins_index number;
13714: upd_index number;