DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_CAUSE_EFFECT_REL_PUB

Line 2462: l_Bsc_Cause_Effect_Rel_Rec BSC_CAUSE_EFFECT_REL_PUB.Bsc_Cause_Effect_Rel_Rec;

2458: ,x_msg_count OUT NOCOPY NUMBER
2459: ,x_msg_data OUT NOCOPY VARCHAR2
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;

Line 2572: BSC_CAUSE_EFFECT_REL_PUB.Delete_All_Cause_Effect_Rels(

2568: END IF;
2569: END LOOP;
2570: CLOSE c_effect_list;
2571:
2572: BSC_CAUSE_EFFECT_REL_PUB.Delete_All_Cause_Effect_Rels(
2573: p_commit => p_commit
2574: ,p_indicator => p_dataset_id
2575: ,p_level => BSC_BIS_MEASURE_PUB.c_LEVEL
2576: ,x_return_status => x_return_status

Line 2587: BSC_CAUSE_EFFECT_REL_PUB.Create_Cause_Effect_Rel(

2583: l_Bsc_Cause_Effect_Rel_Rec.Cause_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2584: l_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator := p_dataset_id;
2585: l_Bsc_Cause_Effect_Rel_Rec.Effect_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2586:
2587: BSC_CAUSE_EFFECT_REL_PUB.Create_Cause_Effect_Rel(
2588: p_commit => p_commit
2589: ,p_Bsc_Cause_Effect_Rel_Rec => l_Bsc_Cause_Effect_Rel_Rec
2590: ,x_return_status => x_return_status
2591: ,x_msg_count => x_msg_count

Line 2605: BSC_CAUSE_EFFECT_REL_PUB.Create_Cause_Effect_Rel(

2601: l_Bsc_Cause_Effect_Rel_Rec.Cause_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2602: l_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator := p_effects_table(i);
2603: l_Bsc_Cause_Effect_Rel_Rec.Effect_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2604:
2605: BSC_CAUSE_EFFECT_REL_PUB.Create_Cause_Effect_Rel(
2606: p_commit => p_commit
2607: ,p_Bsc_Cause_Effect_Rel_Rec => l_Bsc_Cause_Effect_Rel_Rec
2608: ,x_return_status => x_return_status
2609: ,x_msg_count => x_msg_count