APPS.PA_BUDGET_CHECK_PVT dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1817: p_res_list_mem_id IN pa_resource_list_members.resource_list_member_id%TYPE,

1813: * if the validation succeeds, x_error_code would be returned as null
1814: */
1815: PROCEDURE validate_uom_passed
1816: ( p_context IN VARCHAR2,
1817: p_res_list_mem_id IN pa_resource_list_members.resource_list_member_id%TYPE,
1818: p_uom_passed IN pa_resource_list_members.unit_of_measure%TYPE,
1819: x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1820: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1821: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1818: p_uom_passed IN pa_resource_list_members.unit_of_measure%TYPE,

1814: */
1815: PROCEDURE validate_uom_passed
1816: ( p_context IN VARCHAR2,
1817: p_res_list_mem_id IN pa_resource_list_members.resource_list_member_id%TYPE,
1818: p_uom_passed IN pa_resource_list_members.unit_of_measure%TYPE,
1819: x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1820: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1821: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1822: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895

Line 1836: l_unit_of_measure pa_resource_list_members.unit_of_measure%TYPE;

1832: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1833: l_msg_index_out NUMBER;
1834: l_data VARCHAR2(2000);
1835:
1836: l_unit_of_measure pa_resource_list_members.unit_of_measure%TYPE;
1837:
1838: BEGIN
1839: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1840: x_msg_count := 0;

Line 1873: FROM pa_resource_list_members

1869: -- using the singular select here as no api exists only for this
1870: BEGIN
1871: SELECT unit_of_measure
1872: INTO l_unit_of_measure
1873: FROM pa_resource_list_members
1874: WHERE resource_list_member_id = p_res_list_mem_id;
1875: EXCEPTION
1876: WHEN NO_DATA_FOUND THEN
1877: IF l_debug_mode = 'Y' THEN