DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_BIS_LOCKS_PUB

Line 1605: BSC_BIS_LOCKS_PUB.LOCK_TAB(

1601:
1602: --set some default values
1603: l_Bsc_Tab_Entity_Rec.Bsc_Language := 'US';
1604: l_Bsc_Tab_Entity_Rec.Bsc_Source_Language := 'US';
1605: BSC_BIS_LOCKS_PUB.LOCK_TAB(
1606: p_tab_id => p_tab_id
1607: ,p_time_stamp => p_time_stamp -- Granular Locking
1608: ,x_return_status => x_return_status
1609: ,x_msg_count => x_msg_count

Line 2543: BSC_BIS_LOCKS_PUB.LOCK_TAB(

2539: into l_count
2540: from BSC_TAB_INDICATORS
2541: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2542:
2543: BSC_BIS_LOCKS_PUB.LOCK_TAB(
2544: p_tab_id => p_tab_id
2545: ,p_time_stamp => p_time_stamp -- Granular Locking
2546: ,x_return_status => x_return_status
2547: ,x_msg_count => x_msg_count

Line 2817: BSC_BIS_LOCKS_PUB.LOCK_TAB(

2813: and indicator in (select indicator from BSC_KPIS_B
2814: where source_indicator = l_Master_KPI_id
2815: );
2816: -- Granular Locking
2817: BSC_BIS_LOCKS_PUB.LOCK_TAB(
2818: p_tab_id => p_tab_id
2819: ,p_time_stamp => p_time_stamp -- Granular Locking
2820: ,x_return_status => x_return_status
2821: ,x_msg_count => x_msg_count

Line 5198: ,l_periodicities_tbl IN BSC_BIS_LOCKS_PUB.t_numberTable

5194: PROCEDURE Update_Obj_Cal_properties (
5195: p_commit IN VARCHAR2
5196: ,p_calendar_id IN NUMBER
5197: ,l_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
5198: ,l_periodicities_tbl IN BSC_BIS_LOCKS_PUB.t_numberTable
5199: ,l_current_periods IN BSC_BIS_LOCKS_PUB.t_numberTable
5200: ,l_Dft_periodicity_id IN NUMBER
5201: ,l_action_flag IN NUMBER
5202: ,x_return_status OUT NOCOPY VARCHAR2

Line 5199: ,l_current_periods IN BSC_BIS_LOCKS_PUB.t_numberTable

5195: p_commit IN VARCHAR2
5196: ,p_calendar_id IN NUMBER
5197: ,l_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
5198: ,l_periodicities_tbl IN BSC_BIS_LOCKS_PUB.t_numberTable
5199: ,l_current_periods IN BSC_BIS_LOCKS_PUB.t_numberTable
5200: ,l_Dft_periodicity_id IN NUMBER
5201: ,l_action_flag IN NUMBER
5202: ,x_return_status OUT NOCOPY VARCHAR2
5203: ,x_msg_count OUT NOCOPY NUMBER

Line 5466: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

5462: l_per_count NUMBER;
5463: l_cur_cal_id NUMBER;
5464: l_cur_periodicity_id NUMBER;
5465: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
5466: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
5467: l_sql varchar2(500);
5468: l_Dft_periodicity_id NUMBER ;
5469: l_periodicity_id NUMBER;
5470: l_current_period NUMBER;

Line 5471: l_periodicities_tbl BSC_BIS_LOCKS_PUB.t_numberTable;

5467: l_sql varchar2(500);
5468: l_Dft_periodicity_id NUMBER ;
5469: l_periodicity_id NUMBER;
5470: l_current_period NUMBER;
5471: l_periodicities_tbl BSC_BIS_LOCKS_PUB.t_numberTable;
5472: l_current_periods BSC_BIS_LOCKS_PUB.t_numberTable;
5473: l_Indic_Type BSC_KPIS_B.INDICATOR_TYPE%TYPE;
5474: l_Indic_Config_Type BSC_KPIS_B.CONFIG_TYPE%TYPE;
5475: l_Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE;

Line 5472: l_current_periods BSC_BIS_LOCKS_PUB.t_numberTable;

5468: l_Dft_periodicity_id NUMBER ;
5469: l_periodicity_id NUMBER;
5470: l_current_period NUMBER;
5471: l_periodicities_tbl BSC_BIS_LOCKS_PUB.t_numberTable;
5472: l_current_periods BSC_BIS_LOCKS_PUB.t_numberTable;
5473: l_Indic_Type BSC_KPIS_B.INDICATOR_TYPE%TYPE;
5474: l_Indic_Config_Type BSC_KPIS_B.CONFIG_TYPE%TYPE;
5475: l_Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE;
5476: l_Is_Invalid_Per_Sim BOOLEAN := FALSE;

Line 5750: BSC_BIS_LOCKS_PUB.LOCK_KPI

5746: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_kpi_id;
5747: l_periodicity_ids := TRIM(p_periodicity_ids);
5748:
5749: -- lock the KPI
5750: BSC_BIS_LOCKS_PUB.LOCK_KPI
5751: ( p_kpi_Id => l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
5752: , p_time_stamp => NULL
5753: , p_full_lock_flag => FND_API.G_FALSE
5754: , x_return_status => x_return_status