DBA Data[Home] [Help]

APPS.PA_FP_CI_IMPLEMENT_PKG dependencies on PA_PLSQL_DATATYPES

Line 73: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

69: l_total_amount NUMBER;
70: l_rowid ROWID;
71: l_project_funding_id NUMBER;
72:
73: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: --These tbls will hold the change order amounts in PC and PFC.
76: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;

Line 74: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

70: l_rowid ROWID;
71: l_project_funding_id NUMBER;
72:
73: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: --These tbls will hold the change order amounts in PC and PFC.
76: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
78: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;

Line 76: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;

72:
73: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: --These tbls will hold the change order amounts in PC and PFC.
76: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
78: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
79: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
80: l_debug_mode VARCHAR2(30);

Line 77: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;

73: l_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: --These tbls will hold the change order amounts in PC and PFC.
76: l_amount_tab_in_pc PA_PLSQL_DATATYPES.NumTabTyp;
77: l_amount_tab_in_pfc PA_PLSQL_DATATYPES.NumTabTyp;
78: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
79: l_projfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
80: l_debug_mode VARCHAR2(30);
81: l_tmp_amount NUMBER;

Line 869: p_target_fp_version_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp,

865:
866: PROCEDURE chk_plan_ver_for_merge
867: (
868: p_project_id IN NUMBER,
869: p_target_fp_version_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp,
870: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
871: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
872: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
873: ) IS