DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 1664: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,

1660:
1661: PROCEDURE prepare_val_input
1662: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
1663: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
1664: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
1665: p_prd_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1666: p_prd_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1667: p_org_id IN pa_projects_all.org_id%TYPE,
1668: x_budget_lines OUT NOCOPY PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE, --File.Sql.39 bug 4440895

Line 2570: pa_debug.g_err_stage := 'Calling pa_fp_gen_amount_utils.get_etc_start_date';

2566: is_forecast_version := 'Y';
2567:
2568: -- calling an api to derive the etc_start_date
2569: IF l_debug_mode = 'Y' THEN
2570: pa_debug.g_err_stage := 'Calling pa_fp_gen_amount_utils.get_etc_start_date';
2571: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2572: END IF;
2573:
2574: l_etc_start_date := pa_fp_gen_amount_utils.get_etc_start_date(p_version_info_rec.x_budget_version_id);

Line 2574: l_etc_start_date := pa_fp_gen_amount_utils.get_etc_start_date(p_version_info_rec.x_budget_version_id);

2570: pa_debug.g_err_stage := 'Calling pa_fp_gen_amount_utils.get_etc_start_date';
2571: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2572: END IF;
2573:
2574: l_etc_start_date := pa_fp_gen_amount_utils.get_etc_start_date(p_version_info_rec.x_budget_version_id);
2575: END IF;
2576:
2577: --log1('----- STAGE 6-------');
2578: BEGIN

Line 6673: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,

6669: (p_context IN VARCHAR2,
6670: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
6671: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6672: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6673: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6674: p_project_id IN pa_projects_all.project_id%TYPE,
6675: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6676: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6677: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,

Line 7972: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,

7968:
7969: PROCEDURE process_budget_lines
7970: ( p_context IN VARCHAR2,
7971: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
7972: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
7973: p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
7974: p_rlm_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
7975: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
7976: p_spread_curve_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

Line 10134: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

10130: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10131: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10132: l_project_id pa_projects_all.project_id%TYPE;
10133: l_org_id pa_projects_all.org_id%TYPE;
10134: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10135:
10136: -- variable to held the start_date and end_date of individual periods
10137: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10138: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 10482: pa_debug.g_err_stage := 'Calling pa_fp_gen_amount_utils.get_plan_version_dtls';

10478:
10479: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
10480:
10481: IF l_debug_mode = 'Y' THEN
10482: pa_debug.g_err_stage := 'Calling pa_fp_gen_amount_utils.get_plan_version_dtls';
10483: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
10484: END IF;
10485: --log1('----- STAGE 2.1-------'||l_project_id);
10486: --log1('----- STAGE 2.2-------'||l_budget_version_id);

Line 10487: pa_fp_gen_amount_utils.get_plan_version_dtls

10483: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
10484: END IF;
10485: --log1('----- STAGE 2.1-------'||l_project_id);
10486: --log1('----- STAGE 2.2-------'||l_budget_version_id);
10487: pa_fp_gen_amount_utils.get_plan_version_dtls
10488: (p_project_id => l_project_id,
10489: p_budget_version_id => l_budget_version_id,
10490: x_fp_cols_rec => l_version_info_rec,
10491: x_return_status => x_return_status,

Line 12040: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

12036: l_msg_index_out NUMBER;
12037: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12038: l_project_id pa_budget_versions.project_id%TYPE;
12039: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12040: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12041: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12042: l_struct_status_flag VARCHAR2(1);
12043: l_ci_id pa_budget_versions.ci_id%TYPE;
12044: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 12145: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => l_project_id,

12141:
12142: /*Getting Budget Version Details by calling the GET_PLAN_VERSION_DTLS api.
12143: The returned PL/SQL record l_version_info will contain the budget version details
12144: */
12145: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => l_project_id,
12146: p_budget_version_id => l_budget_version_id,
12147: x_fp_cols_rec => l_version_info_rec,
12148: x_return_status => l_return_status,
12149: x_msg_count => l_msg_count,