APPS.BSC_SEC_UTILITY dependencies on BSC_USER_LIST_ACCESS

Line 55: from bsc_user_list_access

51: cursor c_dim_values is
52: select
53: DIM_LEVEL_INDEX,
54: DIM_LEVEL_VALUE
55: from bsc_user_list_access
56: where RESPONSIBILITY_ID=p_resp_id
57: and TAB_ID=p_tab_id
58: order by DIM_LEVEL_INDEX desc;
59:

Line 303: update bsc_user_list_access

299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: if (P_ROWID is not null) then
303: update bsc_user_list_access
304: set responsibility_id = P_RESP_ID,
305: tab_id = P_TAB_ID,
306: DIM_LEVEL_INDEX = P_DIM_LEVEL_INDEX,
307: DIM_LEVEL_VALUE = P_DIM_LEVEL_VALUE,

Line 313: UPDATE bsc_user_list_access

309: last_update_login = l_last_update_login,
310: last_update_date = l_last_update_date
311: where rowid = P_ROWID;
312: else
313: UPDATE bsc_user_list_access
314: SET
315: DIM_LEVEL_VALUE = P_DIM_LEVEL_VALUE,
316: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
317: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 395: insert into bsc_user_list_access

391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394:
395: insert into bsc_user_list_access
396: (
397: RESPONSIBILITY_ID ,
398: TAB_ID ,
399: DIM_LEVEL_INDEX ,

Line 484: (select 'Y' from bsc_user_list_access

480: cursor exist_user_list_access is
481: select 'Y'
482: from dual
483: where exists
484: (select 'Y' from bsc_user_list_access
485: where RESPONSIBILITY_ID=p_resp_id
486: and TAB_ID=p_tab_id);
487: l_dummy varchar2(1);
488: begin

Line 635: -----insert into bsc_user_List_access

631: end loop;
632:
633: end if;
634:
635: -----insert into bsc_user_List_access
636: if has_access_level(p_tab_id) ='Y' then
637: if exist_user_list_access(p_resp_id,p_tab_id)='N' then
638: for l_comm_dim_value_rec in comm_dim_value loop
639: insert_list_access (