[Home] [Help]
121:
122: /***********************************************************/
123: PROCEDURE Delete_Ana_Opt_Mult_Groups
124: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
125: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
126: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
127: , p_max_group_count IN NUMBER
128: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
129: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
134:
135: PROCEDURE Synch_Kpi_Anal_Group
136: (
137: p_commit IN VARCHAR2:=FND_API.G_FALSE
138: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
139: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
140: , x_return_status OUT NOCOPY VARCHAR2
141: , x_msg_count OUT NOCOPY NUMBER
142: , x_msg_data OUT NOCOPY VARCHAR2
231: )RETURN BOOLEAN;
232:
233: PROCEDURE Initialize_Anal_Opt_Tbl
234: (
235: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
236: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
237: , p_max_group_count IN NUMBER
238: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
239: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type
241:
242: PROCEDURE Set_Default_Analysis_Option
243: (
244: p_commit IN VARCHAR2
245: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
246: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
247: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
248: , x_return_status OUT NOCOPY VARCHAR2
249: , x_msg_count OUT NOCOPY NUMBER
243: (
244: p_commit IN VARCHAR2
245: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
246: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
247: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
248: , x_return_status OUT NOCOPY VARCHAR2
249: , x_msg_count OUT NOCOPY NUMBER
250: , x_msg_data OUT NOCOPY VARCHAR2
251: );