APPS.BSC_SEC_UTILITY dependencies on BSC_USER_TAB_ACCESS

Line 181: update bsc_user_tab_access

177: FND_MSG_PUB.initialize;
178: END IF;
179:
180: if (P_ROWID is not null) then
181: update bsc_user_tab_access
182: set responsibility_id = P_RESP_ID,
183: tab_id = P_TAB_ID,
184: start_date = P_START_DATE,
185: end_date = P_END_DATE,

Line 191: UPDATE bsc_user_tab_access

187: last_update_login = l_last_update_login,
188: last_update_date = l_last_update_date
189: where rowid = P_ROWID;
190: else
191: UPDATE bsc_user_tab_access
192: SET
193: start_date = P_START_DATE,
194: end_date = P_END_DATE,
195: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,

Line 540: from bsc_user_tab_access

536: select 'Y'
537: from dual
538: where exists
539: (select 'Y'
540: from bsc_user_tab_access
541: where responsibility_id=p_resp_id
542: and tab_id=p_tab_id);
543:
544: l_dummy varchar2(1);

Line 597: insert into bsc_user_tab_access (

593: ) ;
594:
595: else
596: ---insert a new row
597: insert into bsc_user_tab_access (
598: responsibility_id,
599: tab_id,
600: start_date,
601: end_date,