68: l_total_amount NUMBER;
69: l_rowid ROWID;
70: l_project_funding_id NUMBER;
71:
72: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
74: --These tbls will hold the change order amounts in PC and PFC.
75: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
76: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
69: l_rowid ROWID;
70: l_project_funding_id NUMBER;
71:
72: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
74: --These tbls will hold the change order amounts in PC and PFC.
75: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
76: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
71:
72: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
74: --These tbls will hold the change order amounts in PC and PFC.
75: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
76: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
78: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
79: l_debug_mode VARCHAR2(30);
72: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
74: --These tbls will hold the change order amounts in PC and PFC.
75: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
76: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
78: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
79: l_debug_mode VARCHAR2(30);
80: l_tmp_amount NUMBER;
862:
863: PROCEDURE chk_plan_ver_for_merge
864: (
865: p_project_id IN NUMBER,
866: p_target_fp_version_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp,
867: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
868: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
869: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
870: ) IS