DBA Data[Home] [Help]

APPS.PA_FP_GEN_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 730: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;

726: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
727: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
728:
729: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
730: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
731: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
732: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
733: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
734: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;

Line 1580: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;

1576: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1577:
1578: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1579: l_org_id pa_projects_all.org_id%TYPE;
1580: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1581: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1582: l_target_period_name pa_budget_lines.period_name%TYPE;
1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;

Line 1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;

1581: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1582: l_target_period_name pa_budget_lines.period_name%TYPE;
1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;
1588: l_source_start_date pa_budget_lines.start_date%TYPE;
1589: l_source_end_date pa_budget_lines.end_date%TYPE;

Line 1664: pa_proj_fp_options po,

1660: l_source_set_of_books_id,
1661: l_source_bv_id
1662: from pa_resource_assignments ra,
1663: pa_projects_all p,
1664: pa_proj_fp_options po,
1665: pa_implementations_all pia
1666: where ra.resource_assignment_id = p_src_res_asg_id_tab(1) and
1667: ra.project_id = p.project_id and
1668: ra.budget_version_id = po.fin_plan_version_id and

Line 2007: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;

2003:
2004: l_src_version_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2005: l_gen_etc_src_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2006: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2007: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
2008: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2009:
2010: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2011: