DBA Data[Home] [Help]

APPS.PA_BUDGET_PVT dependencies on PA_BUDGET_PUB

Line 127: ( p_pkg_name => 'PA_BUDGET_PUB'

123: x_msg_count := 1;
124: x_msg_data := SQLERRM;
125:
126: FND_MSG_PUB.add_exc_msg
127: ( p_pkg_name => 'PA_BUDGET_PUB'
128: ,p_procedure_name => 'VALID_RATE_TYPE'
129: ,p_error_text => sqlerrm);
130:
131: IF l_debug_mode = 'Y' THEN

Line 2645: --required for PA_BUDGET_PUB.add_budget_line have been added to this API.

2641:
2642:
2643: --###This API is an overloaded version of an already existing procedure. It is
2644: --created as part of FP.M Changes for FP AMG Apis. All header level validations
2645: --required for PA_BUDGET_PUB.add_budget_line have been added to this API.
2646: --This API handles validations for budget versions in new as well as old models.
2647:
2648: -- 26-APR-2005 Ritesh Shukla Created.
2649: -- 01-Jun-2005 Ritesh Shukla Bug 4224464: Commented out the budgetary control check

Line 2894: IF NOT FND_API.compatible_api_call ( PA_BUDGET_PUB.g_api_version_number,

2890: --Standard call to check for call compatibility.
2891: --We do not perform the call compatibility check if p_api_name
2892: --is null. Internal APIs should pass this parameter as null.
2893: IF p_api_name IS NOT NULL THEN
2894: IF NOT FND_API.compatible_api_call ( PA_BUDGET_PUB.g_api_version_number,
2895: p_api_version_number ,
2896: p_api_name ,
2897: PA_BUDGET_PUB.G_PKG_NAME )
2898: THEN

Line 2897: PA_BUDGET_PUB.G_PKG_NAME )

2893: IF p_api_name IS NOT NULL THEN
2894: IF NOT FND_API.compatible_api_call ( PA_BUDGET_PUB.g_api_version_number,
2895: p_api_version_number ,
2896: p_api_name ,
2897: PA_BUDGET_PUB.G_PKG_NAME )
2898: THEN
2899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2900: END IF;
2901: END IF;

Line 3065: PA_BUDGET_PUB.G_Latest_Encumbrance_Year := -99;

3061:
3062: -- Storing -99 here is essential for proper Budget LINE conditional validation
3063: -- for both the budget_type and FP models.
3064:
3065: PA_BUDGET_PUB.G_Latest_Encumbrance_Year := -99;
3066:
3067:
3068: -- End Bug 4588279, 27-SEP-05, jwhite -----------------------------------------
3069:

Line 3207: ,x_latest_encumbrance_year => PA_BUDGET_PUB.G_Latest_Encumbrance_Year

3203: -- Storing a value other than -99 is essential to conditional LINE validation
3204:
3205: PA_BUDGET_PVT.Get_Latest_BC_Year
3206: ( p_pa_project_id => px_pa_project_id
3207: ,x_latest_encumbrance_year => PA_BUDGET_PUB.G_Latest_Encumbrance_Year
3208: ,x_return_status => x_return_status
3209: ,x_msg_count => x_msg_count
3210: ,x_msg_data => x_msg_data
3211: );

Line 4091: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */

4087: l_description pa_budget_lines.description%TYPE;
4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4089: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4090:
4091: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */
4092: l_budget_lines_out_tbl PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE;
4093: i NUMBER;
4094: l_msg_data VARCHAR2(2000);
4095: l_msg_count NUMBER;

Line 4092: l_budget_lines_out_tbl PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE;

4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4089: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4090:
4091: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */
4092: l_budget_lines_out_tbl PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE;
4093: i NUMBER;
4094: l_msg_data VARCHAR2(2000);
4095: l_msg_count NUMBER;
4096: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 4370: -- of p_budget_lines_rec (as defined in pa_budget_pub)

4366: ELSE
4367: l_revenue := p_revenue;
4368: END IF;
4369: -- extending this null assignment to all other parameters passed as part
4370: -- of p_budget_lines_rec (as defined in pa_budget_pub)
4371: -- Added for bug 3062294 :
4372:
4373: IF p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4374: THEN

Line 5744: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895

5740: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
5741: ,p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
5742: /* Bug 3986129: end*/
5743:
5744: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895
5745: /* Bug 3133930- a new output variable is introduced to return the error status */
5746: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
5747: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
5748: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 5746: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895

5742: /* Bug 3986129: end*/
5743:
5744: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895
5745: /* Bug 3133930- a new output variable is introduced to return the error status */
5746: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
5747: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
5748: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
5749: ,x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type --File.Sql.39 bug 4440895
5750: ,x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 7851: --CREATE_DRAFT_BUDGET (PACKAGE PA_BUDGET_PUB)

7847:
7848: --Bug#4457546:Added code to throw an error when amounts are entered for a period which
7849: --does not fall within the planning start/end dates of resource assignment
7850: --This API validate_budget_lines is being called from the following API's
7851: --CREATE_DRAFT_BUDGET (PACKAGE PA_BUDGET_PUB)
7852: --ADD_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7853: --UPDATE_BUDGET (PACKAGE PA_BUDGET_PUB)
7854: --UPDATE_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7855: --CREATE_DRAFT_FINPLAN (PACKAGE PA_BUDGET_PUB)

Line 7852: --ADD_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)

7848: --Bug#4457546:Added code to throw an error when amounts are entered for a period which
7849: --does not fall within the planning start/end dates of resource assignment
7850: --This API validate_budget_lines is being called from the following API's
7851: --CREATE_DRAFT_BUDGET (PACKAGE PA_BUDGET_PUB)
7852: --ADD_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7853: --UPDATE_BUDGET (PACKAGE PA_BUDGET_PUB)
7854: --UPDATE_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7855: --CREATE_DRAFT_FINPLAN (PACKAGE PA_BUDGET_PUB)
7856: --INSERT_BUDGET_LINE (PACKAGE PA_BUDGET_PVT)

Line 7853: --UPDATE_BUDGET (PACKAGE PA_BUDGET_PUB)

7849: --does not fall within the planning start/end dates of resource assignment
7850: --This API validate_budget_lines is being called from the following API's
7851: --CREATE_DRAFT_BUDGET (PACKAGE PA_BUDGET_PUB)
7852: --ADD_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7853: --UPDATE_BUDGET (PACKAGE PA_BUDGET_PUB)
7854: --UPDATE_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7855: --CREATE_DRAFT_FINPLAN (PACKAGE PA_BUDGET_PUB)
7856: --INSERT_BUDGET_LINE (PACKAGE PA_BUDGET_PVT)
7857: -- Of all the above places the below if condition would only be satisfied by ADD_BUDGET_LINE, UPDATE_BUDGET,

Line 7854: --UPDATE_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)

7850: --This API validate_budget_lines is being called from the following API's
7851: --CREATE_DRAFT_BUDGET (PACKAGE PA_BUDGET_PUB)
7852: --ADD_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7853: --UPDATE_BUDGET (PACKAGE PA_BUDGET_PUB)
7854: --UPDATE_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7855: --CREATE_DRAFT_FINPLAN (PACKAGE PA_BUDGET_PUB)
7856: --INSERT_BUDGET_LINE (PACKAGE PA_BUDGET_PVT)
7857: -- Of all the above places the below if condition would only be satisfied by ADD_BUDGET_LINE, UPDATE_BUDGET,
7858: --UPDATE_BUDGET_LINE for finplan model only which is what is required here. This validation should only be done

Line 7855: --CREATE_DRAFT_FINPLAN (PACKAGE PA_BUDGET_PUB)

7851: --CREATE_DRAFT_BUDGET (PACKAGE PA_BUDGET_PUB)
7852: --ADD_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7853: --UPDATE_BUDGET (PACKAGE PA_BUDGET_PUB)
7854: --UPDATE_BUDGET_LINE (PACKAGE PA_BUDGET_PUB)
7855: --CREATE_DRAFT_FINPLAN (PACKAGE PA_BUDGET_PUB)
7856: --INSERT_BUDGET_LINE (PACKAGE PA_BUDGET_PVT)
7857: -- Of all the above places the below if condition would only be satisfied by ADD_BUDGET_LINE, UPDATE_BUDGET,
7858: --UPDATE_BUDGET_LINE for finplan model only which is what is required here. This validation should only be done
7859: --only from these calling places and only for finplan model.

Line 8645: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type

8641:
8642: PROCEDURE GET_FIN_PLAN_LINES_STATUS
8643: (p_calling_context IN VARCHAR2 DEFAULT NULL
8644: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
8645: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
8646: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
8647: ,x_return_status OUT NOCOPY VARCHAR2
8648: ,x_msg_count OUT NOCOPY NUMBER
8649: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 8646: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type

8642: PROCEDURE GET_FIN_PLAN_LINES_STATUS
8643: (p_calling_context IN VARCHAR2 DEFAULT NULL
8644: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
8645: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
8646: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
8647: ,x_return_status OUT NOCOPY VARCHAR2
8648: ,x_msg_count OUT NOCOPY NUMBER
8649: ,x_msg_data OUT NOCOPY VARCHAR2)
8650:

Line 8661: l_fp_lines_retn_status_tab PA_BUDGET_PUB.budget_line_out_tbl_type;

8657: l_pfc_conv_rejection_data_tab PA_PLSQL_DATATYPES.Char2000TabTyp;
8658: l_other_rejection_data_tab PA_PLSQL_DATATYPES.Char2000TabTyp;
8659: l_return_status VARCHAR2(1);
8660: l_fin_plan_line_id_tab PA_PLSQL_DATATYPES.IDTABTYP;
8661: l_fp_lines_retn_status_tab PA_BUDGET_PUB.budget_line_out_tbl_type;
8662: l_debug_mode VARCHAR2(1);
8663: l_module_name VARCHAR2(80);
8664: l_tmp_return_status VARCHAR2(1);
8665: I NUMBER;