DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 1665: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,

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

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

2614: is_forecast_version := 'Y';
2615:
2616: -- calling an api to derive the etc_start_date
2617: IF l_debug_mode = 'Y' THEN
2618: pa_debug.g_err_stage := 'Calling pa_fp_gen_amount_utils.get_etc_start_date';
2619: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2620: END IF;
2621:
2622: l_etc_start_date := pa_fp_gen_amount_utils.get_etc_start_date(p_version_info_rec.x_budget_version_id);

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

2618: pa_debug.g_err_stage := 'Calling pa_fp_gen_amount_utils.get_etc_start_date';
2619: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2620: END IF;
2621:
2622: l_etc_start_date := pa_fp_gen_amount_utils.get_etc_start_date(p_version_info_rec.x_budget_version_id);
2623: END IF;
2624:
2625: --log1('----- STAGE 6-------');
2626: BEGIN

Line 6780: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,

6776: (p_context IN VARCHAR2,
6777: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
6778: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6779: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6780: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6781: p_project_id IN pa_projects_all.project_id%TYPE,
6782: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6783: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6784: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,

Line 8121: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,

8117:
8118: PROCEDURE process_budget_lines
8119: ( p_context IN VARCHAR2,
8120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8121: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
8122: p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8123: p_rlm_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8124: p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),-- cbs enhancement changes bug#16445106
8125: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

Line 10312: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

10308: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10309: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10310: l_project_id pa_projects_all.project_id%TYPE;
10311: l_org_id pa_projects_all.org_id%TYPE;
10312: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10313:
10314: -- variable to held the start_date and end_date of individual periods
10315: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10316: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

10662:
10663: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
10664:
10665: IF l_debug_mode = 'Y' THEN
10666: pa_debug.g_err_stage := 'Calling pa_fp_gen_amount_utils.get_plan_version_dtls';
10667: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
10668: END IF;
10669: --log1('----- STAGE 2.1-------'||l_project_id);
10670: --log1('----- STAGE 2.2-------'||l_budget_version_id);

Line 10671: pa_fp_gen_amount_utils.get_plan_version_dtls

10667: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
10668: END IF;
10669: --log1('----- STAGE 2.1-------'||l_project_id);
10670: --log1('----- STAGE 2.2-------'||l_budget_version_id);
10671: pa_fp_gen_amount_utils.get_plan_version_dtls
10672: (p_project_id => l_project_id,
10673: p_budget_version_id => l_budget_version_id,
10674: x_fp_cols_rec => l_version_info_rec,
10675: x_return_status => x_return_status,

Line 12273: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

12269: l_msg_index_out NUMBER;
12270: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12271: l_project_id pa_budget_versions.project_id%TYPE;
12272: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12273: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12274: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12275: l_struct_status_flag VARCHAR2(1);
12276: l_ci_id pa_budget_versions.ci_id%TYPE;
12277: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

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

12381:
12382: /*Getting Budget Version Details by calling the GET_PLAN_VERSION_DTLS api.
12383: The returned PL/SQL record l_version_info will contain the budget version details
12384: */
12385: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => l_project_id,
12386: p_budget_version_id => l_budget_version_id,
12387: x_fp_cols_rec => l_version_info_rec,
12388: x_return_status => l_return_status,
12389: x_msg_count => l_msg_count,