APPS.PA_BUDGET_CHECK_PVT dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1795: p_res_list_mem_id IN pa_resource_list_members.resource_list_member_id%TYPE,

1791: * if the validation succeeds, x_error_code would be returned as null
1792: */
1793: PROCEDURE validate_uom_passed
1794: ( p_context IN VARCHAR2,
1795: p_res_list_mem_id IN pa_resource_list_members.resource_list_member_id%TYPE,
1796: p_uom_passed IN pa_resource_list_members.unit_of_measure%TYPE,
1797: x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1798: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1799: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1796: p_uom_passed IN pa_resource_list_members.unit_of_measure%TYPE,

1792: */
1793: PROCEDURE validate_uom_passed
1794: ( p_context IN VARCHAR2,
1795: p_res_list_mem_id IN pa_resource_list_members.resource_list_member_id%TYPE,
1796: p_uom_passed IN pa_resource_list_members.unit_of_measure%TYPE,
1797: x_error_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1798: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1799: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1800: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895

Line 1814: l_unit_of_measure pa_resource_list_members.unit_of_measure%TYPE;

1810: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1811: l_msg_index_out NUMBER;
1812: l_data VARCHAR2(2000);
1813:
1814: l_unit_of_measure pa_resource_list_members.unit_of_measure%TYPE;
1815:
1816: BEGIN
1817: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1818: x_msg_count := 0;

Line 1851: FROM pa_resource_list_members

1847: -- using the singular select here as no api exists only for this
1848: BEGIN
1849: SELECT unit_of_measure
1850: INTO l_unit_of_measure
1851: FROM pa_resource_list_members
1852: WHERE resource_list_member_id = p_res_list_mem_id;
1853: EXCEPTION
1854: WHEN NO_DATA_FOUND THEN
1855: IF l_debug_mode = 'Y' THEN