DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_BUDGET_PUB

Line 642: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,

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

Line 653: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,

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

Line 767: (p_api_version_number => PA_BUDGET_PUB.G_API_VERSION_NUMBER,

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

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

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

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

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

Line 1773: l_budget_line_in_out_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;

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

Line 1774: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;

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

Line 6783: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,

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,
6785: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6786: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
6787: p_first_pd_bf_pm_en_dt IN DATE,

Line 10318: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;

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();
10317:
10318: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10319: l_temp_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10320: l_bl_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10321: l_bl_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10322: l_bl_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10319: l_temp_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;

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();
10317:
10318: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10319: l_temp_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10320: l_bl_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10321: l_bl_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10322: l_bl_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10323: l_bl_plan_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 10339: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_out_tbl%TYPE;

10335: l_allow_qty_flag VARCHAR2(1);
10336:
10337: l_set_ppc_flag_on_err VARCHAR2(1);
10338:
10339: l_budget_line_out_tbl PA_BUDGET_PUB.G_budget_lines_out_tbl%TYPE;
10340: l_delete_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10341: l_delete_flag_tbl_1 SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
10342:
10343: i INTEGER;