APPS.BSC_COMMON_DIMENSIONS_PVT dependencies on BSC_USER_LIST_ACCESS

Line 288: FROM BSC_USER_LIST_ACCESS

284:
285: IF (p_tab_id IS NOT NULL AND p_dim_level_index IS NOT NULL) THEN
286:
287: DELETE
288: FROM BSC_USER_LIST_ACCESS
289: WHERE tab_id = p_tab_id
290: AND DIM_LEVEL_INDEX >= p_dim_level_index;
291:
292: IF (p_commit = FND_API.G_TRUE) THEN

Line 343: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE

339:
340:
341: PROCEDURE insert_user_list_access
342: (
343: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
344: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
345: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE

Line 344: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE

340:
341: PROCEDURE insert_user_list_access
342: (
343: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
344: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
345: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
348: ,p_created_by IN bsc_user_list_access.created_by%TYPE

Line 345: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE

341: PROCEDURE insert_user_list_access
342: (
343: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
344: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
345: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
348: ,p_created_by IN bsc_user_list_access.created_by%TYPE
349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE

Line 346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE

342: (
343: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
344: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
345: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
348: ,p_created_by IN bsc_user_list_access.created_by%TYPE
349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
350: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE

Line 347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE

343: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
344: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
345: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
348: ,p_created_by IN bsc_user_list_access.created_by%TYPE
349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
350: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
351: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE

Line 348: ,p_created_by IN bsc_user_list_access.created_by%TYPE

344: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
345: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
348: ,p_created_by IN bsc_user_list_access.created_by%TYPE
349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
350: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
351: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
352: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE

345: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
348: ,p_created_by IN bsc_user_list_access.created_by%TYPE
349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
350: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
351: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
352: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
353: ,x_return_status OUT NOCOPY VARCHAR2

Line 350: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE

346: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
348: ,p_created_by IN bsc_user_list_access.created_by%TYPE
349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
350: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
351: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
352: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_msg_count OUT NOCOPY NUMBER

Line 351: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE

347: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
348: ,p_created_by IN bsc_user_list_access.created_by%TYPE
349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
350: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
351: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
352: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_msg_count OUT NOCOPY NUMBER
355: ,x_msg_data OUT NOCOPY VARCHAR2

Line 365: bsc_user_list_access(responsibility_id,

361: IF (p_responsibility_id IS NOT NULL AND p_tab_id IS NOT NULL AND p_dim_level_index IS NOT NULL AND p_dim_level_value IS NOT NULL ) THEN
362: IF (p_creation_date IS NOT NULL AND p_created_by IS NOT NULL AND p_last_update_date IS NOT NULL AND p_last_updated_by IS NOT NULL) THEN
363: INSERT
364: INTO
365: bsc_user_list_access(responsibility_id,
366: tab_id,
367: dim_level_index,
368: dim_level_value,
369: creation_date,