34: BEGIN
35: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
37:
38: IF (FND_PROFILE.DEFINED('BIX_PMV_AO_TARCONT')) THEN
39: begin
40: l_contgoal := TO_NUMBER(FND_PROFILE.VALUE('BIX_PMV_AO_TARCONT'));
41: exception
42: when others then
36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
37:
38: IF (FND_PROFILE.DEFINED('BIX_PMV_AO_TARCONT')) THEN
39: begin
40: l_contgoal := TO_NUMBER(FND_PROFILE.VALUE('BIX_PMV_AO_TARCONT'));
41: exception
42: when others then
43: l_contgoal:=0;
44: end;
50: l_contgoal := 0;
51: END IF;
52:
53:
54: IF (FND_PROFILE.DEFINED('BIX_PMV_AO_ABANRATEGOAL')) THEN
55: begin
56: l_abangoal := TO_NUMBER(FND_PROFILE.VALUE('BIX_PMV_AO_ABANRATEGOAL'));
57: exception
58: when others then
52:
53:
54: IF (FND_PROFILE.DEFINED('BIX_PMV_AO_ABANRATEGOAL')) THEN
55: begin
56: l_abangoal := TO_NUMBER(FND_PROFILE.VALUE('BIX_PMV_AO_ABANRATEGOAL'));
57: exception
58: when others then
59: l_abangoal:=0;
60: end;