APPS.BSC_DESIGNER_PVT dependencies on DUAL

Line 2003: SELECT bsc_color_range_id_s.NEXTVAL INTO l_trg_color_range_id from dual;

1999: END IF;
2000: FETCH c_color_range INTO l_src_color_range_id, l_src_property_value;
2001: WHILE c_color_range%FOUND LOOP
2002:
2003: SELECT bsc_color_range_id_s.NEXTVAL INTO l_trg_color_range_id from dual;
2004:
2005: IF p_trg_kpi_measure_id IS NOT NULL THEN
2006: UPDATE bsc_color_type_props
2007: SET color_range_id = l_trg_color_range_id

Line 2075: SELECT bsc_kpi_measure_s.NEXTVAL INTO l_trg_kpi_measure_id from dual;

2071: LOOP
2072: FETCH c_src_ao_comb INTO l_src_kpi_measure_id;
2073: EXIT WHEN c_src_ao_comb%NOTFOUND;
2074:
2075: SELECT bsc_kpi_measure_s.NEXTVAL INTO l_trg_kpi_measure_id from dual;
2076:
2077: FOR i IN 1 .. g_num_obj_kpi_metadata_tables LOOP
2078: IF (g_obj_kpi_metadata_tables(i).duplicate_data = BSC_UTILITY.YES) THEN
2079: insert_kpi_meas_data (

Line 3146: INTO l_owner FROM DUAL;

3142: SAVEPOINT BscProcessTLTableInfo;
3143:
3144: IF(INSTR(p_table_name,'BSC') = 1)THEN
3145: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BSC'),USER)
3146: INTO l_owner FROM DUAL;
3147: ELSIF(INSTR(p_table_name,'BIS') = 1)THEN
3148: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
3149: INTO l_owner FROM DUAL;
3150: ELSIF(INSTR(p_table_name,'FND') = 1) THEN

Line 3149: INTO l_owner FROM DUAL;

3145: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BSC'),USER)
3146: INTO l_owner FROM DUAL;
3147: ELSIF(INSTR(p_table_name,'BIS') = 1)THEN
3148: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
3149: INTO l_owner FROM DUAL;
3150: ELSIF(INSTR(p_table_name,'FND') = 1) THEN
3151: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
3152: INTO l_owner FROM DUAL;
3153: ELSE

Line 3152: INTO l_owner FROM DUAL;

3148: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
3149: INTO l_owner FROM DUAL;
3150: ELSIF(INSTR(p_table_name,'FND') = 1) THEN
3151: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
3152: INTO l_owner FROM DUAL;
3153: ELSE
3154: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)
3155: INTO l_owner FROM DUAL;
3156: END IF;

Line 3155: INTO l_owner FROM DUAL;

3151: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
3152: INTO l_owner FROM DUAL;
3153: ELSE
3154: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)
3155: INTO l_owner FROM DUAL;
3156: END IF;
3157:
3158: -- Get supported languages in source system
3159: l_sql := 'SELECT DISTINCT language_code, installed_flag'||

Line 3346: FROM DUAL;

3342: SELECT
3343: BSC_INDICATOR_ID_S.NEXTVAL
3344: INTO
3345: l_Target_Value
3346: FROM DUAL;
3347:
3348: IF l_Target_Value IS NOT NULL THEN
3349: FOR i IN 1..g_num_kpi_metadata_tables LOOP
3350: IF g_kpi_metadata_tables(i).copy_type >= l_Copy_Type THEN