APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_BIS_LOCKS_PUB

Line 459: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

455: )IS
456: l_common_tabs VARCHAR2(32000);
457: l_tab VARCHAR2(30);
458: l_Sql VARCHAR2(32000);
459: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
460: BEGIN
461: FND_MSG_PUB.Initialize;
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463:

Line 1482: lg_Dim_Obj_Tab_p BSC_BIS_LOCKS_PUB.t_numberTable;

1478:
1479: l_dim_obj_id VARCHAR2(200);
1480:
1481: -- Start Granular Locking added by Aditya
1482: lg_Dim_Obj_Tab_p BSC_BIS_LOCKS_PUB.t_numberTable;
1483: lg_Dim_Obj_Tab_c BSC_BIS_LOCKS_PUB.t_numberTable;
1484: lg_dim_obj_ids VARCHAR2(32000);
1485:
1486: lg_dim_obj_id VARCHAR2(30);

Line 1483: lg_Dim_Obj_Tab_c BSC_BIS_LOCKS_PUB.t_numberTable;

1479: l_dim_obj_id VARCHAR2(200);
1480:
1481: -- Start Granular Locking added by Aditya
1482: lg_Dim_Obj_Tab_p BSC_BIS_LOCKS_PUB.t_numberTable;
1483: lg_Dim_Obj_Tab_c BSC_BIS_LOCKS_PUB.t_numberTable;
1484: lg_dim_obj_ids VARCHAR2(32000);
1485:
1486: lg_dim_obj_id VARCHAR2(30);
1487: lg_index NUMBER := 0;

Line 1664: BSC_BIS_LOCKS_PUB.LOCK_UPDATE_RELATIONSHIPS

1660: lg_index := lg_index + 1;
1661: END LOOP;
1662: END IF;
1663: -- Lock all the Parent/Children and The Dimension Level affected.
1664: BSC_BIS_LOCKS_PUB.LOCK_UPDATE_RELATIONSHIPS
1665: ( p_dim_object_id => p_dim_obj_id
1666: , p_selected_parends => lg_Dim_Obj_Tab_p
1667: , p_selected_childs => lg_Dim_Obj_Tab_c
1668: , p_time_stamp => p_time_stamp

Line 1751: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL

1747: --DBMS_OUTPUT.PUT_LINE('WRONGLY ENTERED');
1748: IF (l_source = 'BSC') THEN
1749: FOR cd IN c_child_ids LOOP
1750: --contains all the initial childs
1751: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL
1752: ( p_dim_level_id => cd.dim_level_id
1753: , p_time_stamp => NULL
1754: , x_return_status => x_return_status
1755: , x_msg_count => x_msg_count

Line 1765: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL

1761: END LOOP;
1762: l_dim_obj_id := p_dim_obj_id;
1763: FOR pd IN c_par_dim_ids LOOP
1764: --contains all the initial parents
1765: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL
1766: ( p_dim_level_id => pd.parent_dim_level_id
1767: , p_time_stamp => NULL
1768: , x_return_status => x_return_status
1769: , x_msg_count => x_msg_count

Line 1902: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_LEVEL

1898: END IF;
1899: -- START Granluar Locking
1900: -- Change the time stamp of the Child Dimension Level
1901: IF(p_is_not_config) THEN
1902: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_LEVEL
1903: ( p_dim_level_id => l_bsc_dim_obj_rec.Bsc_Level_Id
1904: , x_return_status => x_return_status
1905: , x_msg_count => x_msg_count
1906: , x_msg_data => x_msg_data

Line 2063: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_LEVEL

2059:
2060: -- START Granluar Locking
2061: -- Change the time stamp of the Parent Dimension Level
2062: IF(p_is_not_config) THEN
2063: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_LEVEL
2064: ( p_dim_level_id => l_bsc_dim_obj_rec.bsc_parent_level_id
2065: , x_return_status => x_return_status
2066: , x_msg_count => x_msg_count
2067: , x_msg_data => x_msg_data

Line 2450: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_LEVEL

2446:
2447: -- START Granluar Locking
2448: -- Change the time stamp of the main Dimension Level
2449: IF (p_is_not_config) THEN
2450: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_LEVEL
2451: ( p_dim_level_id => p_dim_obj_id
2452: , x_return_status => x_return_status
2453: , x_msg_count => x_msg_count
2454: , x_msg_data => x_msg_data