DBA Data[Home] [Help]

APPS.PA_FP_CI_IMPLEMENT_PKG dependencies on PA_PLSQL_DATATYPES

Line 72: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 73: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 75: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;

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);

Line 76: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 866: p_target_fp_version_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp,

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