APPS.BSC_BIS_LOCKS_PUB dependencies on BSC_SYS_DATASETS_B

Line 80: ,p_lud IN BSC_SYS_DATASETS_B.LAST_UPDATE_DATE%TYPE

76: Bug#4045278: Overloaded for Setting Time Stamp for Data set to take in last_update_date parameter
77: -------------------------------------------------------------------------------------------*/
78: Procedure SET_TIME_STAMP_DATASET (
79: p_dataset_id IN number
80: ,p_lud IN BSC_SYS_DATASETS_B.LAST_UPDATE_DATE%TYPE
81: ,x_return_status OUT NOCOPY varchar2
82: ,x_msg_count OUT NOCOPY number
83: ,x_msg_data OUT NOCOPY varchar2
84: ) is

Line 122: FROM BSC_SYS_DATASETS_B

118: --dbms_output.put_line(' l_measure_id2 = ' || l_measure_id2 );
119: if (l_cursor%found) then
120: l_sql := '
121: SELECT DISTINCT DATASET_ID
122: FROM BSC_SYS_DATASETS_B
123: WHERE (MEASURE_ID1 =:1 OR MEASURE_ID1 =:2
124: OR MEASURE_ID2 =:3 OR MEASURE_ID2 =:4)';
125:
126: open l_cursor for l_sql USING l_measure_id1, nvl(l_measure_id2,l_measure_id1)

Line 290: FROM BSC_SYS_DATASETS_B

286: /* Lock the Datasets using Measures associated with curent dataset */
287:
288: l_sql := '
289: SELECT DISTINCT DATASET_ID
290: FROM BSC_SYS_DATASETS_B
291: WHERE (MEASURE_ID1 =:1 OR MEASURE_ID1 =:2
292: OR MEASURE_ID2 =:3 OR MEASURE_ID2 =:4)';
293:
294: open l_cursor for l_sql USING l_measure_id1, nvl(l_measure_id2,l_measure_id1)

Line 323: FROM BSC_SYS_DATASETS_B

319: l_sql := '
320: SELECT DISTINCT KM.INDICATOR
321: FROM bsc_kpi_analysis_measures_b KM,
322: ( SELECT DATASET_ID
323: FROM BSC_SYS_DATASETS_B
324: WHERE MEASURE_ID1 IN (:1,:2)
325: UNION ALL
326: SELECT DATASET_ID
327: FROM BSC_SYS_DATASETS_B

Line 327: FROM BSC_SYS_DATASETS_B

323: FROM BSC_SYS_DATASETS_B
324: WHERE MEASURE_ID1 IN (:1,:2)
325: UNION ALL
326: SELECT DATASET_ID
327: FROM BSC_SYS_DATASETS_B
328: where MEASURE_ID2 IN (:3,:4)
329: ) D
330: WHERE KM.DATASET_ID = D.DATASET_ID';
331: