APPS.PA_ROLE_PROFILES_UTILS dependencies on PA_NUM_TBL_TYPE

Line 358: ( p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

354: -- This procedure checks the roles and their weightings.
355: --
356:
357: PROCEDURE Validate_Profile_Lines
358: ( p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
359: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
360: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
361: x_role_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
362: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 360: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

356:
357: PROCEDURE Validate_Profile_Lines
358: ( p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
359: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
360: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
361: x_role_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
362: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
363: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
364: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 361: x_role_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

357: PROCEDURE Validate_Profile_Lines
358: ( p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
359: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
360: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
361: x_role_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
362: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
363: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
364: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
365:

Line 366: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := p_role_id_tbl;

362: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
363: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
364: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
365:
366: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := p_role_id_tbl;
367: l_return_status VARCHAR2(1);
368: l_error_msg_code VARCHAR2(500);
369: l_sum NUMBER := 0;
370: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');