APPS.BSC_BIS_LOCKS_PVT dependencies on BSC_TABS_B

Line 1435: temp BSC_TABS_B.last_update_date%TYPE;

1431: )RETURN VARCHAR2
1432: IS
1433: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1434: l_sql VARCHAR2(32000);
1435: temp BSC_TABS_B.last_update_date%TYPE;
1436: BEGIN
1437: l_sql := 'SELECT LAST_UPDATE_DATE ' ||
1438: ' FROM BSC_TABS_B ' ||
1439: ' WHERE TAB_ID =:1 ';

Line 1438: ' FROM BSC_TABS_B ' ||

1434: l_sql VARCHAR2(32000);
1435: temp BSC_TABS_B.last_update_date%TYPE;
1436: BEGIN
1437: l_sql := 'SELECT LAST_UPDATE_DATE ' ||
1438: ' FROM BSC_TABS_B ' ||
1439: ' WHERE TAB_ID =:1 ';
1440:
1441:
1442: OPEN l_cursor FOR l_sql USING p_tab_id;

Line 2570: tab_id in BSC_TABS_B table.

2566:
2567: /************************************************************************
2568: Name :- LOCK_TAB
2569: Description :- This procedure will lock the row corresponding to
2570: tab_id in BSC_TABS_B table.
2571: Input :- p_tab_id
2572:
2573: Creator :- ashankar 05-NOV-2003
2574: /************************************************************************/

Line 2596: FROM BSC_TABS_B

2592: FND_MSG_PUB.Initialize;
2593: x_return_status := FND_API.G_RET_STS_SUCCESS;
2594:
2595: l_sql := ' SELECT TAB_ID
2596: FROM BSC_TABS_B
2597: WHERE TAB_ID = :1
2598: FOR UPDATE NOWAIT ';
2599:
2600: