DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_BUDGET_PUB

Line 641: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,

637:
638: IF l_ci_id = -1 THEN
639: -- budget version
640: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY
641: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,
642: p_project_id => l_project_id,
643: p_fin_plan_type_id => l_fin_plan_type_id,
644: p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN,
645: p_function_name => 'PA_PM_UPDATE_BUDGET',

Line 652: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,

648: x_ret_code => l_sec_ret_code);
649: ELSE
650: -- change order version
651: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY
652: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,
653: p_project_id => l_project_id,
654: p_fin_plan_type_id => l_fin_plan_type_id,
655: p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN,
656: p_function_name => 'PA_PM_UPDATE_CHG_DOC',

Line 766: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,

762: --Update the interface table with error_code 'PA_FP_WA_CI_VER_SUBMIT_FLAG';
763: END IF;
764:
765: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY
766: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,
767: p_project_id => l_project_id,
768: p_fin_plan_type_id => l_fin_plan_type_id,
769: p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN,
770: p_function_name => 'PA_PM_SUBMIT_BUDGET',

Line 1419: (p_budget_line_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,

1415: -- as the cursor on the interface table would be opened again in prepare_pbl_input
1416: -- to prepare the input tables to process_budget_lines.
1417:
1418: PROCEDURE check_and_update_txn_curr_code
1419: (p_budget_line_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
1420: px_inf_cur_rec_tbl IN OUT NOCOPY inf_cur_tbl_typ, --File.Sql.39 bug 4440895
1421: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1422: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1423: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1668: x_budget_lines OUT NOCOPY PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE, --File.Sql.39 bug 4440895

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
1669: x_etc_quantity_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1670: x_etc_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1671: x_etc_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1672: x_etc_revenue_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1771: l_budget_line_in_out_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;

1767: -- variable to keep track of number of records inserted to the budget line record type
1768: bl_count INTEGER := 1;
1769:
1770: -- variables to be used to pass data to validate_budget_line
1771: l_budget_line_in_out_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
1772: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
1773:
1774: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1775: l_allow_qty_flag VARCHAR2(1);

Line 1772: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;

1768: bl_count INTEGER := 1;
1769:
1770: -- variables to be used to pass data to validate_budget_line
1771: l_budget_line_in_out_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
1772: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
1773:
1774: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1775: l_allow_qty_flag VARCHAR2(1);
1776:

Line 6676: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,

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,
6678: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6679: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
6680: p_first_pd_bf_pm_en_dt IN DATE,

Line 10140: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;

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();
10139:
10140: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10141: l_bl_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10142: l_bl_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10143: l_bl_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10144: l_bl_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 10160: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_out_tbl%TYPE;

10156: l_allow_qty_flag VARCHAR2(1);
10157:
10158: l_set_ppc_flag_on_err VARCHAR2(1);
10159:
10160: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_out_tbl%TYPE;
10161: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10162: l_delete_flag_tbl_1 SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10163:
10164: i INTEGER;