DBA Data[Home] [Help]

APPS.BSC_MULTI_USER_PVT dependencies on BSC_TABS_B

Line 225: from BSC_TABS_B

221: begin
222:
223: select last_update_date
224: into l_time_stamp
225: from BSC_TABS_B
226: where tab_id = p_obj_id;
227:
228: if l_time_stamp > p_time_stamp then
229: RAISE FND_API.G_EXC_ERROR;

Line 430: -- We lock tab_id from BSC_TABS_B to prevent "Delete" and "Select Scorecard Items"

426: ,x_msg_data OUT NOCOPY varchar2
427: ) is
428:
429: -- This procedure locks tab_id for a given Tab.
430: -- We lock tab_id from BSC_TABS_B to prevent "Delete" and "Select Scorecard Items"
431: -- sessions to access the screen.
432: -- We lock name from BSC_TABS_B to lock out NOCOPY "Details".
433:
434: l_dummy1 number;

Line 432: -- We lock name from BSC_TABS_B to lock out NOCOPY "Details".

428:
429: -- This procedure locks tab_id for a given Tab.
430: -- We lock tab_id from BSC_TABS_B to prevent "Delete" and "Select Scorecard Items"
431: -- sessions to access the screen.
432: -- We lock name from BSC_TABS_B to lock out NOCOPY "Details".
433:
434: l_dummy1 number;
435: l_dummy2 BSC_TABS_TL.NAME%TYPE;
436:

Line 448: from BSC_TABS_B

444: for update nowait;
445:
446: select tab_id
447: into l_dummy1
448: from BSC_TABS_B
449: where tab_id = p_obj_id
450: for update nowait;
451:
452:

Line 495: -- We lock tab_id from BSC_TABS_B to lock other "Select Scorecard Items"

491: ,x_msg_data OUT NOCOPY varchar2
492: ) is
493:
494: -- This procedure locks tab_id for a given Tab.
495: -- We lock tab_id from BSC_TABS_B to lock other "Select Scorecard Items"
496: -- sessions and to lock out NOCOPY "Delete".
497:
498: l_dummy1 number;
499:

Line 504: from BSC_TABS_B

500: begin
501:
502: select tab_id
503: into l_dummy1
504: from BSC_TABS_B
505: where tab_id = p_obj_id
506: for update nowait;
507:
508: EXCEPTION