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 3489: l_impl_qty_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

3485: l_fp_version_ids_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3486:
3487: l_src_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3488: l_impl_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3489: l_impl_qty_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3490:
3491: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
3492:
3493: l_record_version_number pa_budget_versions.record_version_number%TYPE;

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

3560: l_targ_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE:= SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
3561: l_targ_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3562: l_targ_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3563: l_targ_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3564: l_targ_INCURED_BY_RES_FLAG_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3565: l_targ_RATE_BASED_FLAG_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3566: l_targ_RES_RATE_BASED_FLAG_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); --IPM Architecture Enhancement
3567: l_targ_RESOURCE_CLASS_FLAG_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3568: l_targ_NAMED_ROLE_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE:= SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

3584: --etc of RAs that have got updated. Bug 3678314.
3585: l_upd_ra_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3586: l_upd_ra_rbs_elem_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3587: l_upd_ra_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3588: l_upd_ra_rbf_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3589: l_upd_ra_res_asmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3590:
3591:
3592: l_index NUMBER;

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

3592: l_index NUMBER;
3593: l_matching_index NUMBER;
3594: -- Start of local Variables for calling get_resource_defaults API
3595: l_da_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
3596: l_da_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3597: l_da_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3598: l_da_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3599: l_da_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3600: l_da_person_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();

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

3615: l_da_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3616: l_da_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3617: l_da_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3618: l_da_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3619: l_da_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3620: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3621: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3622: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3623: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();

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

3620: l_da_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3621: l_da_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3622: l_da_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3623: l_da_org_id_tab SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3624: l_da_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3625: l_da_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3626: l_da_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3627: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3628:

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

3627: l_da_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3628:
3629: --for Start bug 5291484
3630: lresource_list_members_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3631: lresource_class_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3632: lresource_class_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3633: lresource_class_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3634: lres_type_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3635: lperson_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();

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

3650: l_da_supplier_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3651: l_da_spread_curve_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3652: l_da_etc_method_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3653: l_da_mfc_cost_type_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3654: lincurred_by_res_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3655: lincur_by_res_cls_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3656: l_da_incur_by_role_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3657: l_da_unit_of_measure_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3658: l_da_org_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();

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

3655: lincur_by_res_cls_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3656: l_da_incur_by_role_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3657: l_da_unit_of_measure_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3658: l_da_org_id_tab_1 SYSTEM.PA_NUM_TBL_TYPE:= SYSTEM.PA_NUM_TBL_TYPE();
3659: l_da_rate_based_flag_tab_1 SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3660: lrate_expenditure_type_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3661: l_da_rate_func_curr_code_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3662: l_da_incur_by_res_type_tab_1 SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3663: ltxnsrctyp_code_rbs_prm_tbl_1 SYSTEM.pa_varchar2_30_tbl_type:= SYSTEM.pa_varchar2_30_tbl_type();

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

3700: l_pfc_cur_conv_rejection_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3701: l_pji_prm_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3702: l_pji_prm_rbs_elem_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3703: l_pji_prm_res_cls_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3704: l_pji_prm_rbf_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
3705: l_upd_bl_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3706: l_upd_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3707: l_upd_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
3708: l_upd_bl_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE :=SYSTEM.PA_DATE_TBL_TYPE();

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

3714: l_upd_pc_cur_conv_rej_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3715: l_upd_pfc_cur_conv_rej_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3716:
3717: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3718: l_delete_budget_lines_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3719: L_SPREAD_AMOUNT_FLAGS_TBL SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3720:
3721:
3722: -- End of variable to be used in Calculate API Call

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

3715: l_upd_pfc_cur_conv_rej_code SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
3716:
3717: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3718: l_delete_budget_lines_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3719: L_SPREAD_AMOUNT_FLAGS_TBL SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
3720:
3721:
3722: -- End of variable to be used in Calculate API Call
3723:

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

3770: l_bl_REVENUE_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3771: l_bl_BURDEN_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3772: l_bl_OTHER_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3773: l_bl_CODE_COMBINATION_ID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3774: l_bl_CCID_GEN_STATUS_CODE_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3775: l_bl_CCID_GEN_REJ_MESSAGE_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3776: l_bl_REQUEST_ID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3777: l_bl_BORROWED_REVENUE_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3778: l_bl_TP_REVENUE_IN_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

3824: l_bl_BURDEN_COST_RATE_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3825: l_bl_BURDEN_COST_RAT_OVRID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3826: l_bl_PC_CUR_CONV_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3827: l_bl_PFC_CUR_CONV_REJ_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3828: l_bl_rbf_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3829:
3830: -- End of tables prepared to insert/update into pa_budget_lines
3831:
3832: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;

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

9374: --for the resource assignment to which the budget line corresponds. This will help in populating
9375: --correct values in quantity and rate columns of budget lines.Bug 3621847
9376: IF l_upd_ra_bl_dml_code_tbl.COUNT>0 THEN
9377:
9378: l_bl_rbf_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
9379: l_bl_rbf_flag_tbl.EXTEND(l_bl_RESOURCE_ASIGNMENT_ID_tbl.COUNT);
9380: --dbms_output.put_line('I42');
9381: FOR KK IN l_bl_RESOURCE_ASIGNMENT_ID_tbl.FIRST..l_bl_RESOURCE_ASIGNMENT_ID_tbl.LAST LOOP
9382:

Line 10963: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

10959: ,p_ci_all_version_id_tbl IN SYSTEM.pa_num_tbl_type
10960: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
10961: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
10962: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
10963: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10964: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10965: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10966: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10967: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE

Line 10964: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

10960: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
10961: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
10962: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
10963: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10964: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10965: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10966: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10967: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
10968: ,p_update_agreement_amt_flag IN VARCHAR2

Line 10965: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

10961: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
10962: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
10963: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10964: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10965: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10966: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10967: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
10968: ,p_update_agreement_amt_flag IN VARCHAR2
10969: ,p_funding_category IN VARCHAR2

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

10973: ,x_ci_all_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10974: ,x_budget_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10975: ,x_fin_plan_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10976: ,x_fin_plan_type_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type --File.Sql.39 bug 4440895
10977: ,x_submit_version_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type --File.Sql.39 bug 4440895
10978: ,x_ci_number OUT NOCOPY SYSTEM.pa_varchar2_100_tbl_type --File.Sql.39 bug 4440895
10979: ,x_budget_ci_map_rec_tbl OUT NOCOPY budget_ci_map_rec_tbl_type --File.Sql.39 bug 4440895
10980: ,x_agreement_id OUT NOCOPY pa_agreements_all.agreement_id%TYPE --File.Sql.39 bug 4440895
10981: ,x_funding_category OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

11005: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
11006: l_project_id pa_projects_all.project_id%TYPE;
11007: l_source_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
11008: l_calling_mode_for_chk_api VARCHAR2(30);
11009: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
11010: l_copy_ci_ver_flag VARCHAR2(1);
11011: l_record_version_number pa_budget_versions.record_Version_number%TYPE;
11012: l_cost_ci_ver_index NUMBER;
11013: l_rev_ci_ver_index NUMBER;

Line 11027: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;

11023: l_rev_impact_impl_flag VARCHAR2(1);
11024: l_partially_impl_flag VARCHAR2(1);
11025: l_agreement_num pa_agreements_all.agreement_num%TYPE;
11026: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11027: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11028: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11029: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11030: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
11031: l_total_amount NUMBER;

Line 11028: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;

11024: l_partially_impl_flag VARCHAR2(1);
11025: l_agreement_num pa_agreements_all.agreement_num%TYPE;
11026: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11027: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11028: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11029: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11030: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
11031: l_total_amount NUMBER;
11032: l_implemented_amount NUMBER;

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

11231: x_ci_rev_version_id_tbl :=SYSTEM.pa_num_tbl_type();
11232: x_ci_all_version_id_tbl :=SYSTEM.pa_num_tbl_type();
11233: x_budget_version_id_tbl :=SYSTEM.pa_num_tbl_type();
11234: x_ci_number :=SYSTEM.pa_varchar2_100_tbl_type();
11235: l_impl_cost_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11236: l_impl_rev_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11237: x_submit_version_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11238: x_fin_plan_type_id_tbl :=SYSTEM.pa_num_tbl_type();
11239: x_fin_plan_type_name_tbl :=SYSTEM.pa_varchar2_150_tbl_type();

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

11232: x_ci_all_version_id_tbl :=SYSTEM.pa_num_tbl_type();
11233: x_budget_version_id_tbl :=SYSTEM.pa_num_tbl_type();
11234: x_ci_number :=SYSTEM.pa_varchar2_100_tbl_type();
11235: l_impl_cost_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11236: l_impl_rev_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11237: x_submit_version_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11238: x_fin_plan_type_id_tbl :=SYSTEM.pa_num_tbl_type();
11239: x_fin_plan_type_name_tbl :=SYSTEM.pa_varchar2_150_tbl_type();
11240: IF p_funding_category IS NULL THEN

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

11233: x_budget_version_id_tbl :=SYSTEM.pa_num_tbl_type();
11234: x_ci_number :=SYSTEM.pa_varchar2_100_tbl_type();
11235: l_impl_cost_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11236: l_impl_rev_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11237: x_submit_version_flag_tbl :=SYSTEM.pa_varchar2_1_tbl_type();
11238: x_fin_plan_type_id_tbl :=SYSTEM.pa_num_tbl_type();
11239: x_fin_plan_type_name_tbl :=SYSTEM.pa_varchar2_150_tbl_type();
11240: IF p_funding_category IS NULL THEN
11241: x_funding_category := 'ADDITIONAL';

Line 13066: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

13062: ,p_ci_all_version_id_tbl IN SYSTEM.pa_num_tbl_type
13063: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
13064: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
13065: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
13066: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13067: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13068: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13069: ,p_partial_impl_rev_amt IN NUMBER
13070: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE

Line 13067: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

13063: ,p_fin_plan_type_id_tbl IN SYSTEM.pa_num_tbl_type
13064: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
13065: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
13066: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13067: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13068: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13069: ,p_partial_impl_rev_amt IN NUMBER
13070: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
13071: ,p_update_agreement_amt_flag IN VARCHAR2

Line 13068: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

13064: ,p_fin_plan_type_name_tbl IN SYSTEM.pa_varchar2_150_tbl_type
13065: ,p_budget_version_id_tbl IN SYSTEM.pa_num_tbl_type
13066: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13067: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13068: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13069: ,p_partial_impl_rev_amt IN NUMBER
13070: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
13071: ,p_update_agreement_amt_flag IN VARCHAR2
13072: ,p_funding_category IN VARCHAR2

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

13101: l_ci_cost_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13102: l_ci_rev_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13103: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13104: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13105: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13106: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13107: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13108: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13109: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

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

13102: l_ci_rev_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13103: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13104: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13105: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13106: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13107: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13108: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13109: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
13110: l_succ_impl_plan_types SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();

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

13103: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13104: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13105: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13106: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13107: l_submit_version_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
13108: l_fin_plan_type_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
13109: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
13110: l_succ_impl_plan_types SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
13111: l_succ_impl_cos SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();