[Home] [Help]
58:
59:
60: PROCEDURE insert_user_list_access
61: (
62: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
63: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
64: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
65: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
59:
60: PROCEDURE insert_user_list_access
61: (
62: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
63: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
64: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
65: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67: ,p_created_by IN bsc_user_list_access.created_by%TYPE
60: PROCEDURE insert_user_list_access
61: (
62: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
63: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
64: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
65: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67: ,p_created_by IN bsc_user_list_access.created_by%TYPE
68: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
61: (
62: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
63: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
64: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
65: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67: ,p_created_by IN bsc_user_list_access.created_by%TYPE
68: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
69: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
62: p_responsibility_id IN bsc_user_list_access.responsibility_id%TYPE
63: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
64: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
65: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67: ,p_created_by IN bsc_user_list_access.created_by%TYPE
68: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
69: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
70: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
63: ,p_tab_id IN bsc_user_list_access.tab_id%TYPE
64: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
65: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67: ,p_created_by IN bsc_user_list_access.created_by%TYPE
68: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
69: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
70: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
64: ,p_dim_level_index IN bsc_user_list_access.dim_level_index%TYPE
65: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67: ,p_created_by IN bsc_user_list_access.created_by%TYPE
68: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
69: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
70: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72: ,x_return_status OUT NOCOPY VARCHAR2
65: ,p_dim_level_value IN bsc_user_list_access.dim_level_value%TYPE
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67: ,p_created_by IN bsc_user_list_access.created_by%TYPE
68: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
69: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
70: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72: ,x_return_status OUT NOCOPY VARCHAR2
73: ,x_msg_count OUT NOCOPY NUMBER
66: ,p_creation_date IN bsc_user_list_access.creation_date%TYPE
67: ,p_created_by IN bsc_user_list_access.created_by%TYPE
68: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
69: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
70: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72: ,x_return_status OUT NOCOPY VARCHAR2
73: ,x_msg_count OUT NOCOPY NUMBER
74: ,x_msg_data OUT NOCOPY VARCHAR2