DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PVT dependencies on PA_CLIENT_EXTN_BUDGET_WF

Line 509: PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used

505:
506: --dbms_output.put_line('big select statement executed');
507: -- Check whether workflow is being used for this project budget
508: -- If so, get the employee id based on the baselined_by_user_id
509: PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used
510: (p_draft_version_id => p_budget_version_id,
511: p_project_id => p_project_id,
512: p_budget_type_code => NULL,
513: p_pm_product_code => l_pm_product_code,

Line 523: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used executed');

519: p_err_stack => l_msg_data);
520: If l_workflow_is_used = 'T' Then
521: v_emp_id := pa_utils.GetEmpIdFromUser(pa_budget_wf.g_baselined_by_user_id);
522: end if;
523: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used executed');
524: -- Verify budget rules if indicated
525: -- This API call is different from in PA_BUDGET_CORE.baseline
526: -- We need to set p_budget_type_code = null so that the verify API will use
527: -- p_fin_plan_type_id and p_version_type for the new budget model

Line 1544: PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used

1540: where budget_version_id = p_budget_version_id;
1541: --dbms_output.put_line('update pa_budget_versions statement executed');
1542: -- Check whether workflow is being used for this project budget
1543: -- If so, get the employee id based on the baselined_by_user_id
1544: PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used
1545: (p_draft_version_id => p_budget_version_id,
1546: p_project_id => p_project_id,
1547: p_budget_type_code => NULL,
1548: p_pm_product_code => l_pm_product_code,

Line 1555: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used called');

1551: p_result => l_workflow_is_used,
1552: p_err_code => l_err_code,
1553: p_err_stage => l_err_stage,
1554: p_err_stack => l_err_stack);
1555: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used called');
1556: -- l_err_code = 0 ==> SUCCESS
1557: if l_err_code <> 0 then
1558: -- PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used returned errors
1559: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used: RETURNED ERRORS');

Line 1558: -- PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used returned errors

1554: p_err_stack => l_err_stack);
1555: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used called');
1556: -- l_err_code = 0 ==> SUCCESS
1557: if l_err_code <> 0 then
1558: -- PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used returned errors
1559: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used: RETURNED ERRORS');
1560: raise pa_fin_plan_pvt.check_wf_error;
1561: else
1562: If l_workflow_is_used = 'T' Then

Line 1559: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used: RETURNED ERRORS');

1555: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used called');
1556: -- l_err_code = 0 ==> SUCCESS
1557: if l_err_code <> 0 then
1558: -- PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used returned errors
1559: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used: RETURNED ERRORS');
1560: raise pa_fin_plan_pvt.check_wf_error;
1561: else
1562: If l_workflow_is_used = 'T' Then
1563: v_emp_id := pa_utils.GetEmpIdFromUser(pa_budget_wf.g_baselined_by_user_id);