DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_SYS_DATASETS_TL

Line 2464: l_name bsc_sys_datasets_tl.name%TYPE;

2460: ) is
2461:
2462: l_Bsc_Cause_Effect_Rel_Rec BSC_CAUSE_EFFECT_REL_PUB.Bsc_Cause_Effect_Rel_Rec;
2463: l_measure_names varchar2(32000);
2464: l_name bsc_sys_datasets_tl.name%TYPE;
2465: l_max_count number := 1500;
2466: l_temp_dataset_id NUMBER;
2467: l_found BOOLEAN;
2468: CURSOR c_cause_list

Line 3510: l_measure_col bsc_sys_datasets_tl.name%TYPE;

3506: ,p_source IN VARCHAR2
3507: ,p_measure_id IN NUMBER
3508: ,p_short_name IN VARCHAR2
3509: ) return VARCHAR2 is
3510: l_measure_col bsc_sys_datasets_tl.name%TYPE;
3511: l_flag BOOLEAN := FALSE;
3512: l_alias VARCHAR2(30);
3513: l_temp_var VARCHAR2(30);
3514: l_count NUMBER;

Line 4259: l_measure_col bsc_sys_datasets_tl.name%TYPE;

4255: p_name IN VARCHAR2
4256: )RETURN VARCHAR2 IS
4257:
4258: l_asc number;
4259: l_measure_col bsc_sys_datasets_tl.name%TYPE;
4260: l_char varchar2(1);
4261: l_alias VARCHAR2(30);
4262: l_StartingWithInvalidType BOOLEAN; --invalid type => numeric and underscore
4263: