APPS.BSC_UTILITY dependencies on DUAL

Line 1024: from dual;

1020: FND_MSG_PUB.Initialize;
1021:
1022: select userenv('SESSIONID')
1023: into l_session_id
1024: from dual;
1025:
1026: select count(message)
1027: into l_count
1028: from BSC_MESSAGE_LOGS

Line 1187: SELECT FND_PROFILE.VALUE('BSC_INTERNAL_USER') INTO l_internal FROM DUAL;

1183: FUNCTION is_Internal_User
1184: RETURN BOOLEAN IS
1185: l_internal VARCHAR2(30);
1186: BEGIN
1187: SELECT FND_PROFILE.VALUE('BSC_INTERNAL_USER') INTO l_internal FROM DUAL;
1188: IF((l_internal IS NOT NULL) AND (UPPER(l_internal) = 'YES')) THEN
1189: RETURN TRUE;
1190: ELSE
1191: RETURN FALSE;

Line 1248: from dual;

1244: l_tempalias := RTRIM(LTRIM(l_tempalias));
1245:
1246: select replace(translate(l_tempalias,'0123456789.','???????????'), '?', '')
1247: into l_isNumber
1248: from dual;
1249:
1250: if(l_number = 0 or (l_isNumber is not null)) then
1251: l_return := l_alias ||' '||TO_CHAR(1);
1252: else

Line 1598: FROM DUAL;

1594: BEGIN
1595:
1596: SELECT FND_PROFILE.VALUE(c_ADV_SUMMARIZATION_LEVEL)
1597: INTO l_Profile_Value
1598: FROM DUAL;
1599:
1600: IF (TO_NUMBER(NVL(l_Profile_Value, '-1')) >= 0) THEN
1601: RETURN FND_API.G_TRUE;
1602: ELSE

Line 2084: -- each Dimension/Dimension Object combination split that and call API individually.

2080: l_temp_snames := p_Entity_Short_Names;
2081: WHILE (Is_More(l_temp_snames, l_Short_Name)) LOOP
2082:
2083: IF(p_Entity_Type = c_MIXED_DIM_OBJS) THEN
2084: -- each Dimension/Dimension Object combination split that and call API individually.
2085: l_pos_value := INSTR(l_Short_Name, '+');
2086: IF (l_pos_value > 0) THEN
2087: l_dim_sname := TRIM(SUBSTR(l_Short_Name, 1, l_pos_value - 1));
2088: l_dim_obj_sname := TRIM(SUBSTR(l_Short_Name, l_pos_value + 1));