eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PMF_DEFINER_WRAPPER_PVT dependencies on BIS_UTILITIES_PUB

Line 45: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

41: g_api_version NUMBER := 1;
42: g_ampersand VARCHAR2(100) := '&';
43:
44: Procedure Create_Performance_Measure
45: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
46: ,p_Measure_Short_Name IN VARCHAR2
47: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
48: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 47: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

43:
44: Procedure Create_Performance_Measure
45: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
46: ,p_Measure_Short_Name IN VARCHAR2
47: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
48: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 48: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

44: Procedure Create_Performance_Measure
45: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
46: ,p_Measure_Short_Name IN VARCHAR2
47: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
48: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

45: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
46: ,p_Measure_Short_Name IN VARCHAR2
47: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
48: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

46: ,p_Measure_Short_Name IN VARCHAR2
47: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
48: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

47: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
48: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

48: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

49: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: --Fix for 1850860 starts here

Line 54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

50: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: --Fix for 1850860 starts here
58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

51: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: --Fix for 1850860 starts here
58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

52: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: --Fix for 1850860 starts here
58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
60: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

54: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: --Fix for 1850860 starts here
58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
60: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 59: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

55: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: --Fix for 1850860 starts here
58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
60: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: -- Fix for 1850860 ends here

Line 60: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

56: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: --Fix for 1850860 starts here
58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
60: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: -- Fix for 1850860 ends here
64: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739

Line 61: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

57: --Fix for 1850860 starts here
58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
60: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: -- Fix for 1850860 ends here
64: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
65: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711

Line 62: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

58: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
60: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: -- Fix for 1850860 ends here
64: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
65: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
66: ,p_measure_Type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 66: ,p_measure_Type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

62: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: -- Fix for 1850860 ends here
64: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
65: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
66: ,p_measure_Type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
67: ,p_application_id IN NUMBER := c_default_appl --2465354
68: ,x_return_status OUT NOCOPY VARCHAR2
69: ,x_msg_count OUT NOCOPY VARCHAR2
70: ,x_msg_data OUT NOCOPY VARCHAR2

Line 74: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

70: ,x_msg_data OUT NOCOPY VARCHAR2
71: )
72: IS
73: l_return_status varchar2(32000);
74: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
75: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
76: l_ret VARCHAR2(32000);
77: Begin
78: FND_MSG_PUB.initialize;

Line 79: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);

75: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
76: l_ret VARCHAR2(32000);
77: Begin
78: FND_MSG_PUB.initialize;
79: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);
80: IF (l_ret = FND_API.G_FALSE) THEN
81: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
82: END IF;
83:

Line 84: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Name);

80: IF (l_ret = FND_API.G_FALSE) THEN
81: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
82: END IF;
83:
84: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Name);
85: IF (l_ret = FND_API.G_FALSE) THEN
86: l_measure_rec.Measure_Name := p_Measure_Name;
87: END IF;
88:

Line 89: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Description);

85: IF (l_ret = FND_API.G_FALSE) THEN
86: l_measure_rec.Measure_Name := p_Measure_Name;
87: END IF;
88:
89: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Description);
90: IF (l_ret = FND_API.G_FALSE) THEN
91: l_measure_rec.Description := p_Description;
92: END IF;
93:

Line 94: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension1_ID);

90: IF (l_ret = FND_API.G_FALSE) THEN
91: l_measure_rec.Description := p_Description;
92: END IF;
93:
94: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension1_ID);
95: IF (l_ret = FND_API.G_FALSE) THEN
96: l_measure_rec.Dimension1_ID := p_Dimension1_ID;
97: END IF;
98:

Line 99: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension2_ID);

95: IF (l_ret = FND_API.G_FALSE) THEN
96: l_measure_rec.Dimension1_ID := p_Dimension1_ID;
97: END IF;
98:
99: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension2_ID);
100: IF (l_ret = FND_API.G_FALSE) THEN
101: l_measure_rec.Dimension2_ID := p_Dimension2_ID;
102: END IF;
103:

Line 104: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension3_ID);

100: IF (l_ret = FND_API.G_FALSE) THEN
101: l_measure_rec.Dimension2_ID := p_Dimension2_ID;
102: END IF;
103:
104: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension3_ID);
105: IF (l_ret = FND_API.G_FALSE) THEN
106: l_measure_rec.Dimension3_ID := p_Dimension3_ID;
107: END IF;
108:

Line 109: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension4_ID);

105: IF (l_ret = FND_API.G_FALSE) THEN
106: l_measure_rec.Dimension3_ID := p_Dimension3_ID;
107: END IF;
108:
109: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension4_ID);
110: IF (l_ret = FND_API.G_FALSE) THEN
111: l_measure_rec.Dimension4_ID := p_Dimension4_ID;
112: END IF;
113:

Line 114: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension5_ID);

110: IF (l_ret = FND_API.G_FALSE) THEN
111: l_measure_rec.Dimension4_ID := p_Dimension4_ID;
112: END IF;
113:
114: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension5_ID);
115: IF (l_ret = FND_API.G_FALSE) THEN
116: l_measure_rec.Dimension5_ID := p_Dimension5_ID;
117: END IF;
118:

Line 119: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension6_ID);

115: IF (l_ret = FND_API.G_FALSE) THEN
116: l_measure_rec.Dimension5_ID := p_Dimension5_ID;
117: END IF;
118:
119: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension6_ID);
120: IF (l_ret = FND_API.G_FALSE) THEN
121: l_measure_rec.Dimension6_ID := p_Dimension6_ID;
122: END IF;
123:

Line 124: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension7_ID);

120: IF (l_ret = FND_API.G_FALSE) THEN
121: l_measure_rec.Dimension6_ID := p_Dimension6_ID;
122: END IF;
123:
124: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension7_ID);
125: IF (l_ret = FND_API.G_FALSE) THEN
126: l_measure_rec.Dimension7_ID := p_Dimension7_ID;
127: END IF;
128:

Line 130: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Unit_Of_Measure_Class);

126: l_measure_rec.Dimension7_ID := p_Dimension7_ID;
127: END IF;
128:
129: -----
130: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Unit_Of_Measure_Class);
131: IF (l_ret = FND_API.G_FALSE) THEN
132: l_measure_rec.Unit_Of_Measure_Class := p_Unit_Of_Measure_Class;
133: END IF;
134:

Line 136: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);

132: l_measure_rec.Unit_Of_Measure_Class := p_Unit_Of_Measure_Class;
133: END IF;
134:
135: --Fix for 1850860 starts here
136: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);
137: IF (l_ret = FND_API.G_FALSE) THEN
138: l_measure_rec.actual_data_source_type := p_actual_data_source_type;
139: END IF;
140: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);

Line 140: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);

136: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);
137: IF (l_ret = FND_API.G_FALSE) THEN
138: l_measure_rec.actual_data_source_type := p_actual_data_source_type;
139: END IF;
140: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);
141: IF (l_ret = FND_API.G_FALSE) THEN
142: l_measure_rec.actual_data_source := p_actual_data_source;
143: END IF;
144: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);

Line 144: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);

140: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);
141: IF (l_ret = FND_API.G_FALSE) THEN
142: l_measure_rec.actual_data_source := p_actual_data_source;
143: END IF;
144: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);
145: IF (l_ret = FND_API.G_FALSE) THEN
146: l_measure_rec.function_name := p_function_name;
147: END IF;
148: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);

Line 148: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);

144: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);
145: IF (l_ret = FND_API.G_FALSE) THEN
146: l_measure_rec.function_name := p_function_name;
147: END IF;
148: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);
149: IF (l_ret = FND_API.G_FALSE) THEN
150: l_measure_rec.comparison_source := p_comparison_source;
151: END IF;
152: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);

Line 152: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);

148: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);
149: IF (l_ret = FND_API.G_FALSE) THEN
150: l_measure_rec.comparison_source := p_comparison_source;
151: END IF;
152: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);
153: IF (l_ret = FND_API.G_FALSE) THEN
154: l_measure_rec.increase_in_measure := p_increase_in_measure;
155: END IF;
156: -- Fix for 1850860 ends here

Line 158: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_enable_link);

154: l_measure_rec.increase_in_measure := p_increase_in_measure;
155: END IF;
156: -- Fix for 1850860 ends here
157: -- 2440739
158: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_enable_link);
159: IF (l_ret = FND_API.G_FALSE) THEN
160: l_measure_rec.enable_link := p_enable_link;
161: END IF;
162: -- 2440739

Line 163: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_obsolete);

159: IF (l_ret = FND_API.G_FALSE) THEN
160: l_measure_rec.enable_link := p_enable_link;
161: END IF;
162: -- 2440739
163: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_obsolete);
164: IF (l_ret = FND_API.G_FALSE) THEN
165: l_measure_rec.obsolete := p_obsolete;
166: END IF;
167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_type);

Line 167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_type);

163: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_obsolete);
164: IF (l_ret = FND_API.G_FALSE) THEN
165: l_measure_rec.obsolete := p_obsolete;
166: END IF;
167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_type);
168: IF (l_ret = FND_API.G_FALSE) THEN
169: l_measure_rec.measure_type := p_measure_type;
170: END IF;
171:

Line 216: p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

212: END Create_Performance_Measure;
213:
214: --
215: Procedure Update_Performance_Measure(
216: p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: , p_Measure_Short_Name IN VARCHAR2
218: , p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
219: , p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 218: , p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

214: --
215: Procedure Update_Performance_Measure(
216: p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: , p_Measure_Short_Name IN VARCHAR2
218: , p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
219: , p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 219: , p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

215: Procedure Update_Performance_Measure(
216: p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: , p_Measure_Short_Name IN VARCHAR2
218: , p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
219: , p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

216: p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: , p_Measure_Short_Name IN VARCHAR2
218: , p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
219: , p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

217: , p_Measure_Short_Name IN VARCHAR2
218: , p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
219: , p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

218: , p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
219: , p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

219: , p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

220: , p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
228: -- Fix for 1850860 starts here

Line 225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

221: , p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
228: -- Fix for 1850860 starts here
229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

222: , p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
228: -- Fix for 1850860 starts here
229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
230: , p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

223: , p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
224: , p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
228: -- Fix for 1850860 starts here
229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
230: , p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
231: , p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

225: , p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
228: -- Fix for 1850860 starts here
229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
230: , p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
231: , p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
232: , p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
233: , p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 230: , p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

226: , p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
228: -- Fix for 1850860 starts here
229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
230: , p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
231: , p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
232: , p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
233: , p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
234: -- Fix for 1850860 ends here

Line 231: , p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

227: , p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
228: -- Fix for 1850860 starts here
229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
230: , p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
231: , p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
232: , p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
233: , p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
234: -- Fix for 1850860 ends here
235: , p_enable_link IN VARCHAR2 := c_hide_url -- 2440739

Line 232: , p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

228: -- Fix for 1850860 starts here
229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
230: , p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
231: , p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
232: , p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
233: , p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
234: -- Fix for 1850860 ends here
235: , p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
236: , p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711

Line 233: , p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

229: , p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
230: , p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
231: , p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
232: , p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
233: , p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
234: -- Fix for 1850860 ends here
235: , p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
236: , p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
237: , p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 237: , p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

233: , p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
234: -- Fix for 1850860 ends here
235: , p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
236: , p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
237: , p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
238: , p_application_id IN NUMBER := c_default_appl -- 2465354
239: , x_return_status OUT NOCOPY VARCHAR2
240: , x_msg_count OUT NOCOPY VARCHAR2
241: , x_msg_data OUT NOCOPY VARCHAR2

Line 246: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

242: )
243: IS
244:
245: l_return_status varchar2(32000);
246: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
247: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
248:
249: Begin
250: FND_MSG_PUB.initialize;

Line 316: p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

312:
313: END Update_Performance_Measure;
314:
315: Procedure Delete_Performance_Measure(
316: p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
317: , p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
318: ,x_return_status OUT NOCOPY VARCHAR2
319: ,x_msg_count OUT NOCOPY VARCHAR2
320: ,x_msg_data OUT NOCOPY VARCHAR2

Line 317: , p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

313: END Update_Performance_Measure;
314:
315: Procedure Delete_Performance_Measure(
316: p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
317: , p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
318: ,x_return_status OUT NOCOPY VARCHAR2
319: ,x_msg_count OUT NOCOPY VARCHAR2
320: ,x_msg_data OUT NOCOPY VARCHAR2
321: )

Line 325: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

321: )
322: IS
323:
324: l_return_status varchar2(32000);
325: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
326: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
327: l_ret VARCHAR2(32000);
328: -- 2218333
329: l_msg_count VARCHAR2(32000);

Line 335: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_ID);

331: -- 2218333
332: Begin
333: FND_MSG_PUB.initialize;
334:
335: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_ID);
336: IF (l_ret = FND_API.G_FALSE) THEN
337: l_measure_rec.Measure_ID := p_Measure_ID;
338: END IF;
339:

Line 340: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);

336: IF (l_ret = FND_API.G_FALSE) THEN
337: l_measure_rec.Measure_ID := p_Measure_ID;
338: END IF;
339:
340: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);
341: IF (l_ret = FND_API.G_FALSE) THEN
342: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
343: END IF;
344:

Line 413: , P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

409:
410: Procedure Delete_target_levels(
411: P_TARGET_LEVEL_ID IN NUMBER
412: , p_force_delete IN NUMBER := 0 --gbhaloti #3148615
413: , P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
414: ,x_return_status OUT NOCOPY VARCHAR2
415: ,x_msg_count OUT NOCOPY VARCHAR2
416: ,x_msg_data OUT NOCOPY VARCHAR2
417: )

Line 421: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

417: )
418: IS
419:
420: l_return_status varchar2(32000);
421: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
422: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
423: l_ret VARCHAR2(32000);
424:
425: Begin

Line 428: IF (BIS_UTILITIES_PUB.Value_Missing

424:
425: Begin
426: FND_MSG_PUB.initialize;
427:
428: IF (BIS_UTILITIES_PUB.Value_Missing
429: (p_Target_Level_Id) = FND_API.G_FALSE) THEN
430: l_target_level_rec.Target_Level_Id :=
431: p_Target_Level_Id;
432: END IF;

Line 434: IF (BIS_UTILITIES_PUB.Value_Missing

430: l_target_level_rec.Target_Level_Id :=
431: p_Target_Level_Id;
432: END IF;
433:
434: IF (BIS_UTILITIES_PUB.Value_Missing
435: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN
436: l_target_level_rec.Target_Level_Short_Name :=
437: p_Target_Level_Short_Name;
438: END IF;

Line 474: , P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

470:
471:
472: Procedure Update_target_levels(
473: P_TARGET_LEVEL_ID IN NUMBER
474: , P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
475: , P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
476: , P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 475: , P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

471:
472: Procedure Update_target_levels(
473: P_TARGET_LEVEL_ID IN NUMBER
474: , P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
475: , P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
476: , P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 476: , P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

472: Procedure Update_target_levels(
473: P_TARGET_LEVEL_ID IN NUMBER
474: , P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
475: , P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
476: , P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

473: P_TARGET_LEVEL_ID IN NUMBER
474: , P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
475: , P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
476: , P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

474: , P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
475: , P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
476: , P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

475: , P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
476: , P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

476: , P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
484: , P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

477: , P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
484: , P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
485: , P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

478: , P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
484: , P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
485: , P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
486: , P_WORKFLOW_PROCESS_SHORT_NAME

Line 483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

479: , P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
484: , P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
485: , P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
486: , P_WORKFLOW_PROCESS_SHORT_NAME
487: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 484: , P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

480: , P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
484: , P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
485: , P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
486: , P_WORKFLOW_PROCESS_SHORT_NAME
487: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
488: , P_DEFAULT_NOTIFY_RESP_ID

Line 485: , P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

481: , P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
482: , P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
484: , P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
485: , P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
486: , P_WORKFLOW_PROCESS_SHORT_NAME
487: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
488: , P_DEFAULT_NOTIFY_RESP_ID
489: IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 487: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

483: , P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
484: , P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
485: , P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
486: , P_WORKFLOW_PROCESS_SHORT_NAME
487: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
488: , P_DEFAULT_NOTIFY_RESP_ID
489: IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
490: , P_DEFAULT_NOT_RESP_SHORT_NAME
491: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 489: IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

485: , P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
486: , P_WORKFLOW_PROCESS_SHORT_NAME
487: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
488: , P_DEFAULT_NOTIFY_RESP_ID
489: IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
490: , P_DEFAULT_NOT_RESP_SHORT_NAME
491: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
492: , P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
493: , P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 491: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

487: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
488: , P_DEFAULT_NOTIFY_RESP_ID
489: IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
490: , P_DEFAULT_NOT_RESP_SHORT_NAME
491: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
492: , P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
493: , P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
494: , P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
495: , P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 492: , P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

488: , P_DEFAULT_NOTIFY_RESP_ID
489: IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
490: , P_DEFAULT_NOT_RESP_SHORT_NAME
491: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
492: , P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
493: , P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
494: , P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
495: , P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
496: , p_SOURCE IN VARCHAR2

Line 493: , P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

489: IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
490: , P_DEFAULT_NOT_RESP_SHORT_NAME
491: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
492: , P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
493: , P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
494: , P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
495: , P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
496: , p_SOURCE IN VARCHAR2
497: , p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354

Line 494: , P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

490: , P_DEFAULT_NOT_RESP_SHORT_NAME
491: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
492: , P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
493: , P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
494: , P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
495: , P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
496: , p_SOURCE IN VARCHAR2
497: , p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
498: ,x_return_status OUT NOCOPY VARCHAR2

Line 495: , P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

491: IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
492: , P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
493: , P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
494: , P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
495: , P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
496: , p_SOURCE IN VARCHAR2
497: , p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
498: ,x_return_status OUT NOCOPY VARCHAR2
499: ,x_msg_count OUT NOCOPY VARCHAR2

Line 506: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

502: )
503: IS
504:
505: l_return_status varchar2(32000);
506: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
507: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
508: l_ret VARCHAR2(32000);
509: l_owner VARCHAR2(200); --2465354
510: Begin

Line 513: IF (BIS_UTILITIES_PUB.Value_Missing

509: l_owner VARCHAR2(200); --2465354
510: Begin
511: FND_MSG_PUB.initialize;
512:
513: IF (BIS_UTILITIES_PUB.Value_Missing
514: (p_Target_Level_Id) = FND_API.G_FALSE) THEN
515: l_target_level_rec.Target_Level_Id :=
516: p_Target_Level_Id;
517: END IF;

Line 519: IF (BIS_UTILITIES_PUB.Value_Missing

515: l_target_level_rec.Target_Level_Id :=
516: p_Target_Level_Id;
517: END IF;
518:
519: IF (BIS_UTILITIES_PUB.Value_Missing
520: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN
521: l_target_level_rec.Target_Level_Short_Name :=
522: p_Target_Level_Short_Name;
523: END IF;

Line 525: IF (BIS_UTILITIES_PUB.Value_Missing

521: l_target_level_rec.Target_Level_Short_Name :=
522: p_Target_Level_Short_Name;
523: END IF;
524:
525: IF (BIS_UTILITIES_PUB.Value_Missing
526: (p_Target_Level_Name) = FND_API.G_FALSE) THEN
527: l_target_level_rec.Target_Level_Name :=
528: p_Target_Level_Name;
529: END IF;

Line 531: IF (BIS_UTILITIES_PUB.Value_Missing

527: l_target_level_rec.Target_Level_Name :=
528: p_Target_Level_Name;
529: END IF;
530:
531: IF (BIS_UTILITIES_PUB.Value_Missing
532: (p_Description) = FND_API.G_FALSE) THEN
533: l_target_level_rec.Description := p_Description;
534: END IF;
535:

Line 536: IF (BIS_UTILITIES_PUB.Value_Missing

532: (p_Description) = FND_API.G_FALSE) THEN
533: l_target_level_rec.Description := p_Description;
534: END IF;
535:
536: IF (BIS_UTILITIES_PUB.Value_Missing
537: (p_Measure_Id) = FND_API.G_FALSE) THEN
538: l_target_level_rec.Measure_Id := p_Measure_Id;
539: END IF;
540:

Line 541: IF (BIS_UTILITIES_PUB.Value_Missing

537: (p_Measure_Id) = FND_API.G_FALSE) THEN
538: l_target_level_rec.Measure_Id := p_Measure_Id;
539: END IF;
540:
541: IF (BIS_UTILITIES_PUB.Value_Missing
542: (p_Dimension1_Level_ID) = FND_API.G_FALSE) THEN
543: l_target_level_rec.Dimension1_Level_ID :=
544: p_Dimension1_Level_ID;
545: END IF;

Line 547: IF (BIS_UTILITIES_PUB.Value_Missing

543: l_target_level_rec.Dimension1_Level_ID :=
544: p_Dimension1_Level_ID;
545: END IF;
546:
547: IF (BIS_UTILITIES_PUB.Value_Missing
548: (p_Dimension2_Level_ID) = FND_API.G_FALSE) THEN
549: l_target_level_rec.Dimension2_Level_ID :=
550: p_Dimension2_Level_ID;
551: END IF;

Line 553: IF (BIS_UTILITIES_PUB.Value_Missing

549: l_target_level_rec.Dimension2_Level_ID :=
550: p_Dimension2_Level_ID;
551: END IF;
552:
553: IF (BIS_UTILITIES_PUB.Value_Missing
554: (p_Dimension3_Level_ID) = FND_API.G_FALSE) THEN
555: l_target_level_rec.Dimension3_Level_ID :=
556: p_Dimension3_Level_ID;
557: END IF;

Line 559: IF (BIS_UTILITIES_PUB.Value_Missing

555: l_target_level_rec.Dimension3_Level_ID :=
556: p_Dimension3_Level_ID;
557: END IF;
558:
559: IF (BIS_UTILITIES_PUB.Value_Missing
560: (p_Dimension4_Level_ID) = FND_API.G_FALSE) THEN
561: l_target_level_rec.Dimension4_Level_ID :=
562: p_Dimension4_Level_ID;
563: END IF;

Line 565: IF (BIS_UTILITIES_PUB.Value_Missing

561: l_target_level_rec.Dimension4_Level_ID :=
562: p_Dimension4_Level_ID;
563: END IF;
564:
565: IF (BIS_UTILITIES_PUB.Value_Missing
566: (p_Dimension5_Level_ID) = FND_API.G_FALSE) THEN
567: l_target_level_rec.Dimension5_Level_ID :=
568: p_Dimension5_Level_ID;
569: END IF;

Line 571: IF (BIS_UTILITIES_PUB.Value_Missing

567: l_target_level_rec.Dimension5_Level_ID :=
568: p_Dimension5_Level_ID;
569: END IF;
570:
571: IF (BIS_UTILITIES_PUB.Value_Missing
572: (p_Dimension6_Level_ID) = FND_API.G_FALSE) THEN
573: l_target_level_rec.Dimension6_Level_ID :=
574: p_Dimension6_Level_ID;
575: END IF;

Line 577: IF (BIS_UTILITIES_PUB.Value_Missing

573: l_target_level_rec.Dimension6_Level_ID :=
574: p_Dimension6_Level_ID;
575: END IF;
576:
577: IF (BIS_UTILITIES_PUB.Value_Missing
578: (p_Dimension7_Level_ID) = FND_API.G_FALSE) THEN
579: l_target_level_rec.Dimension7_Level_ID :=
580: p_Dimension7_Level_ID;
581: END IF;

Line 583: IF (BIS_UTILITIES_PUB.Value_Missing

579: l_target_level_rec.Dimension7_Level_ID :=
580: p_Dimension7_Level_ID;
581: END IF;
582:
583: IF (BIS_UTILITIES_PUB.Value_Missing
584: (P_WORKFLOW_ITEM_TYPE) = FND_API.G_FALSE) THEN
585: l_target_level_rec.Workflow_Item_type :=
586: P_WORKFLOW_ITEM_TYPE;
587: END IF;

Line 589: IF (BIS_UTILITIES_PUB.Value_Missing

585: l_target_level_rec.Workflow_Item_type :=
586: P_WORKFLOW_ITEM_TYPE;
587: END IF;
588:
589: IF (BIS_UTILITIES_PUB.Value_Missing
590: (p_Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN
591: l_target_level_rec.Workflow_Process_Short_Name :=
592: p_Workflow_Process_Short_Name;
593: END IF;

Line 595: IF (BIS_UTILITIES_PUB.Value_Missing

591: l_target_level_rec.Workflow_Process_Short_Name :=
592: p_Workflow_Process_Short_Name;
593: END IF;
594:
595: IF (BIS_UTILITIES_PUB.Value_Missing
596: (p_Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN
597: l_target_level_rec.Default_Notify_Resp_ID :=
598: p_Default_Notify_Resp_ID;
599: END IF;

Line 601: IF (BIS_UTILITIES_PUB.Value_Missing

597: l_target_level_rec.Default_Notify_Resp_ID :=
598: p_Default_Notify_Resp_ID;
599: END IF;
600:
601: IF (BIS_UTILITIES_PUB.Value_Missing
602: (p_Default_Not_Resp_short_name)=FND_API.G_FALSE) THEN
603: l_target_level_rec.Default_Notify_Resp_short_name :=
604: p_Default_Not_Resp_short_name;
605: END IF;

Line 612: IF (BIS_UTILITIES_PUB.Value_Missing

608: l_target_level_rec.computing_function_name := p_computing_function_name;
609: l_target_level_rec.unit_of_measure := p_unit_of_measure;
610: -- l_target_level_rec.Source := 'EDW';
611: ---------------
612: IF (BIS_UTILITIES_PUB.Value_Missing
613: (p_Source) = FND_API.G_FALSE) THEN
614: l_target_level_rec.Source := p_Source;
615: END IF;
616: -----------------------------------

Line 619: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;

615: END IF;
616: -----------------------------------
617: -- 2465354
618: IF ( p_IS_SEED_USER = 'Y' ) THEN
619: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;
620: ELSE
621: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;
622: END IF;
623: -- 2465354

Line 621: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;

617: -- 2465354
618: IF ( p_IS_SEED_USER = 'Y' ) THEN
619: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;
620: ELSE
621: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;
622: END IF;
623: -- 2465354
624:
625: BIS_Target_Level_PVT.Update_Target_Level

Line 658: P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

654: end Update_target_levels;
655:
656:
657: Procedure Create_target_levels(
658: P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
659: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
660: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
661: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 660: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

656:
657: Procedure Create_target_levels(
658: P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
659: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
660: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
661: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 661: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

657: Procedure Create_target_levels(
658: P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
659: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
660: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
661: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

658: P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
659: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
660: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
661: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

659: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
660: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
661: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

660: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
661: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

661: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

662: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

663: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

664: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

665: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

666: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

667: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
675: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

668: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
675: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
676: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

669: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
675: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
676: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
677: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

670: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
675: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
676: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
677: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
678: ,p_SOURCE IN VARCHAR2

Line 675: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

671: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
675: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
676: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
677: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
678: ,p_SOURCE IN VARCHAR2
679: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354

Line 676: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

672: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
675: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
676: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
677: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
678: ,p_SOURCE IN VARCHAR2
679: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
680: ,x_return_status OUT NOCOPY VARCHAR2

Line 677: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

673: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
674: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
675: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
676: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
677: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
678: ,p_SOURCE IN VARCHAR2
679: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
680: ,x_return_status OUT NOCOPY VARCHAR2
681: ,x_msg_count OUT NOCOPY VARCHAR2

Line 687: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

683: )
684: IS
685:
686: l_return_status varchar2(32000);
687: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
688: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
689: l_ret VARCHAR2(32000);
690: l_time_seq_num NUMBER;
691: l_org_seq_num NUMBER;

Line 699: IF (BIS_UTILITIES_PUB.Value_Missing

695: l_owner VARCHAR2(200); --2465354
696: Begin
697: FND_MSG_PUB.initialize;
698:
699: IF (BIS_UTILITIES_PUB.Value_Missing
700: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN
701: l_target_level_rec.Target_Level_Short_Name :=
702: p_Target_Level_Short_Name;
703: END IF;

Line 705: IF (BIS_UTILITIES_PUB.Value_Missing

701: l_target_level_rec.Target_Level_Short_Name :=
702: p_Target_Level_Short_Name;
703: END IF;
704:
705: IF (BIS_UTILITIES_PUB.Value_Missing
706: (p_Target_Level_Name) = FND_API.G_FALSE) THEN
707: l_target_level_rec.Target_Level_Name :=
708: p_Target_Level_Name;
709: END IF;

Line 711: IF (BIS_UTILITIES_PUB.Value_Missing

707: l_target_level_rec.Target_Level_Name :=
708: p_Target_Level_Name;
709: END IF;
710:
711: IF (BIS_UTILITIES_PUB.Value_Missing
712: (p_Description) = FND_API.G_FALSE) THEN
713: l_target_level_rec.Description := p_Description;
714: END IF;
715:

Line 716: IF (BIS_UTILITIES_PUB.Value_Missing

712: (p_Description) = FND_API.G_FALSE) THEN
713: l_target_level_rec.Description := p_Description;
714: END IF;
715:
716: IF (BIS_UTILITIES_PUB.Value_Missing
717: (p_Measure_Id) = FND_API.G_FALSE) THEN
718: l_target_level_rec.Measure_Id := p_Measure_Id;
719: END IF;
720:

Line 721: IF (BIS_UTILITIES_PUB.Value_Missing

717: (p_Measure_Id) = FND_API.G_FALSE) THEN
718: l_target_level_rec.Measure_Id := p_Measure_Id;
719: END IF;
720:
721: IF (BIS_UTILITIES_PUB.Value_Missing
722: (p_Dimension1_Level_ID) = FND_API.G_FALSE) THEN
723: l_target_level_rec.Dimension1_Level_ID :=
724: p_Dimension1_Level_ID;
725: END IF;

Line 727: IF (BIS_UTILITIES_PUB.Value_Missing

723: l_target_level_rec.Dimension1_Level_ID :=
724: p_Dimension1_Level_ID;
725: END IF;
726:
727: IF (BIS_UTILITIES_PUB.Value_Missing
728: (p_Dimension2_Level_ID) = FND_API.G_FALSE) THEN
729: l_target_level_rec.Dimension2_Level_ID :=
730: p_Dimension2_Level_ID;
731: END IF;

Line 733: IF (BIS_UTILITIES_PUB.Value_Missing

729: l_target_level_rec.Dimension2_Level_ID :=
730: p_Dimension2_Level_ID;
731: END IF;
732:
733: IF (BIS_UTILITIES_PUB.Value_Missing
734: (p_Dimension3_Level_ID) = FND_API.G_FALSE) THEN
735: l_target_level_rec.Dimension3_Level_ID :=
736: p_Dimension3_Level_ID;
737: END IF;

Line 739: IF (BIS_UTILITIES_PUB.Value_Missing

735: l_target_level_rec.Dimension3_Level_ID :=
736: p_Dimension3_Level_ID;
737: END IF;
738:
739: IF (BIS_UTILITIES_PUB.Value_Missing
740: (p_Dimension4_Level_ID) = FND_API.G_FALSE) THEN
741: l_target_level_rec.Dimension4_Level_ID :=
742: p_Dimension4_Level_ID;
743: END IF;

Line 745: IF (BIS_UTILITIES_PUB.Value_Missing

741: l_target_level_rec.Dimension4_Level_ID :=
742: p_Dimension4_Level_ID;
743: END IF;
744:
745: IF (BIS_UTILITIES_PUB.Value_Missing
746: (p_Dimension5_Level_ID) = FND_API.G_FALSE) THEN
747: l_target_level_rec.Dimension5_Level_ID :=
748: p_Dimension5_Level_ID;
749: END IF;

Line 751: IF (BIS_UTILITIES_PUB.Value_Missing

747: l_target_level_rec.Dimension5_Level_ID :=
748: p_Dimension5_Level_ID;
749: END IF;
750:
751: IF (BIS_UTILITIES_PUB.Value_Missing
752: (p_Dimension6_Level_ID) = FND_API.G_FALSE) THEN
753: l_target_level_rec.Dimension6_Level_ID :=
754: p_Dimension6_Level_ID;
755: END IF;

Line 757: IF (BIS_UTILITIES_PUB.Value_Missing

753: l_target_level_rec.Dimension6_Level_ID :=
754: p_Dimension6_Level_ID;
755: END IF;
756:
757: IF (BIS_UTILITIES_PUB.Value_Missing
758: (p_Dimension7_Level_ID) = FND_API.G_FALSE) THEN
759: l_target_level_rec.Dimension7_Level_ID :=
760: p_Dimension7_Level_ID;
761: END IF;

Line 763: IF (BIS_UTILITIES_PUB.Value_Missing

759: l_target_level_rec.Dimension7_Level_ID :=
760: p_Dimension7_Level_ID;
761: END IF;
762:
763: IF (BIS_UTILITIES_PUB.Value_Missing
764: (P_WORKFLOW_ITEM_TYPE) = FND_API.G_FALSE) THEN
765: l_target_level_rec.Workflow_Item_type :=
766: P_WORKFLOW_ITEM_TYPE;
767: END IF;

Line 769: IF (BIS_UTILITIES_PUB.Value_Missing

765: l_target_level_rec.Workflow_Item_type :=
766: P_WORKFLOW_ITEM_TYPE;
767: END IF;
768:
769: IF (BIS_UTILITIES_PUB.Value_Missing
770: (p_Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN
771: l_target_level_rec.Workflow_Process_Short_Name :=
772: p_Workflow_Process_Short_Name;
773: END IF;

Line 775: IF (BIS_UTILITIES_PUB.Value_Missing

771: l_target_level_rec.Workflow_Process_Short_Name :=
772: p_Workflow_Process_Short_Name;
773: END IF;
774:
775: IF (BIS_UTILITIES_PUB.Value_Missing
776: (p_Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN
777: l_target_level_rec.Default_Notify_Resp_ID :=
778: p_Default_Notify_Resp_ID;
779: END IF;

Line 781: IF (BIS_UTILITIES_PUB.Value_Missing

777: l_target_level_rec.Default_Notify_Resp_ID :=
778: p_Default_Notify_Resp_ID;
779: END IF;
780:
781: IF (BIS_UTILITIES_PUB.Value_Missing
782: (p_Default_Not_Resp_short_name)=FND_API.G_FALSE) THEN
783: l_target_level_rec.Default_Notify_Resp_short_name :=
784: p_Default_Not_Resp_short_name;
785: END IF;

Line 792: IF (BIS_UTILITIES_PUB.Value_Missing

788: l_target_level_rec.computing_function_name := p_computing_function_name;
789: l_target_level_rec.unit_of_measure := p_unit_of_measure;
790: -- l_target_level_rec.Source := 'EDW';
791: ---------------
792: IF (BIS_UTILITIES_PUB.Value_Missing
793: (p_Source) = FND_API.G_FALSE) THEN
794: l_target_level_rec.Source := p_Source;
795: END IF;
796: -----------------------------------

Line 883: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;

879: END IF;
880:
881: -- 2465354
882: IF ( p_IS_SEED_USER = 'Y' ) THEN
883: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;
884: ELSE
885: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;
886: END IF;
887: -- 2465354

Line 885: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;

881: -- 2465354
882: IF ( p_IS_SEED_USER = 'Y' ) THEN
883: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;
884: ELSE
885: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;
886: END IF;
887: -- 2465354
888:
889: BIS_Target_Level_PVT.Create_Target_Level

Line 920: P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

916: -- Fix for 2254597 ends here
917: end Create_target_levels;
918: --
919: Procedure Create_Measure_Security(
920: P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
921: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
922: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
923: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
924: ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354

Line 921: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

917: end Create_target_levels;
918: --
919: Procedure Create_Measure_Security(
920: P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
921: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
922: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
923: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
924: ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354
925: ,x_return_status OUT NOCOPY VARCHAR2

Line 922: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

918: --
919: Procedure Create_Measure_Security(
920: P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
921: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
922: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
923: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
924: ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354
925: ,x_return_status OUT NOCOPY VARCHAR2
926: ,x_msg_count OUT NOCOPY VARCHAR2

Line 923: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

919: Procedure Create_Measure_Security(
920: P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
921: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
922: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
923: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
924: ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354
925: ,x_return_status OUT NOCOPY VARCHAR2
926: ,x_msg_count OUT NOCOPY VARCHAR2
927: ,x_msg_data OUT NOCOPY VARCHAR2

Line 932: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

928: )
929: IS
930: l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
931: l_return_status varchar2(32000);
932: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
933: l_owner VARCHAR2(200); --2465354
934: BEGIN
935: FND_MSG_PUB.initialize;
936: --

Line 937: IF (BIS_UTILITIES_PUB.Value_Missing

933: l_owner VARCHAR2(200); --2465354
934: BEGIN
935: FND_MSG_PUB.initialize;
936: --
937: IF (BIS_UTILITIES_PUB.Value_Missing
938: (p_Target_Level_ID) = FND_API.G_FALSE) THEN
939: l_Measure_Security_Rec.Target_Level_ID :=
940: p_Target_Level_ID;
941: END IF;

Line 943: IF (BIS_UTILITIES_PUB.Value_Missing

939: l_Measure_Security_Rec.Target_Level_ID :=
940: p_Target_Level_ID;
941: END IF;
942:
943: IF (BIS_UTILITIES_PUB.Value_Missing
944: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN
945: l_Measure_Security_Rec.Target_Level_Short_Name :=
946: p_Target_Level_Short_Name;
947: END IF;

Line 949: IF (BIS_UTILITIES_PUB.Value_Missing

945: l_Measure_Security_Rec.Target_Level_Short_Name :=
946: p_Target_Level_Short_Name;
947: END IF;
948:
949: IF (BIS_UTILITIES_PUB.Value_Missing
950: (p_Responsibility_ID) = FND_API.G_FALSE) THEN
951: l_Measure_Security_Rec.Responsibility_ID :=
952: p_Responsibility_ID;
953: END IF;

Line 955: IF (BIS_UTILITIES_PUB.Value_Missing

951: l_Measure_Security_Rec.Responsibility_ID :=
952: p_Responsibility_ID;
953: END IF;
954:
955: IF (BIS_UTILITIES_PUB.Value_Missing
956: (p_Responsibility_Short_Name) = FND_API.G_FALSE) THEN
957: l_Measure_Security_Rec.Responsibility_Short_Name :=
958: p_Responsibility_Short_Name;
959: END IF;

Line 962: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;

958: p_Responsibility_Short_Name;
959: END IF;
960: -- 2465354
961: IF ( p_IS_SEED_USER = 'Y' ) THEN
962: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;
963: ELSE
964: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;
965: END IF;
966: -- 2465354

Line 964: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;

960: -- 2465354
961: IF ( p_IS_SEED_USER = 'Y' ) THEN
962: l_owner := BIS_UTILITIES_PUB.G_SEED_OWNER ;
963: ELSE
964: l_owner := BIS_UTILITIES_PUB.G_CUSTOM_OWNER;
965: END IF;
966: -- 2465354
967:
968: BIS_MEASURE_SECURITY_PVT.Create_Measure_Security

Line 1000: P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

996:
997: END Create_Measure_Security;
998:
999: Procedure Delete_Measure_Security(
1000: P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1001: , P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1002: ,x_return_status OUT NOCOPY VARCHAR2
1003: ,x_msg_count OUT NOCOPY VARCHAR2
1004: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1001: , P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

997: END Create_Measure_Security;
998:
999: Procedure Delete_Measure_Security(
1000: P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1001: , P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1002: ,x_return_status OUT NOCOPY VARCHAR2
1003: ,x_msg_count OUT NOCOPY VARCHAR2
1004: ,x_msg_data OUT NOCOPY VARCHAR2
1005: )

Line 1010: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1006: IS
1007:
1008: l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
1009: l_return_status varchar2(32000);
1010: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1011:
1012: BEGIN
1013: FND_MSG_PUB.initialize;
1014: --

Line 1016: IF (BIS_UTILITIES_PUB.Value_Missing

1012: BEGIN
1013: FND_MSG_PUB.initialize;
1014: --
1015: FND_MSG_PUB.initialize;
1016: IF (BIS_UTILITIES_PUB.Value_Missing
1017: (p_Target_Level_ID) = FND_API.G_FALSE) THEN
1018: l_Measure_Security_Rec.Target_Level_ID :=
1019: p_Target_Level_ID;
1020: END IF;

Line 1022: IF (BIS_UTILITIES_PUB.Value_Missing

1018: l_Measure_Security_Rec.Target_Level_ID :=
1019: p_Target_Level_ID;
1020: END IF;
1021:
1022: IF (BIS_UTILITIES_PUB.Value_Missing
1023: (p_Responsibility_ID) = FND_API.G_FALSE) THEN
1024: l_Measure_Security_Rec.Responsibility_ID :=
1025: p_Responsibility_ID;
1026: END IF;

Line 1059: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1055:
1056: END Delete_Measure_Security;
1057:
1058: PROCEDURE CREATE_TARGET
1059: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1060: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
1061: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1062: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1061: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1057:
1058: PROCEDURE CREATE_TARGET
1059: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1060: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
1061: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1062: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1062: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1058: PROCEDURE CREATE_TARGET
1059: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1060: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
1061: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1062: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1059: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1060: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
1061: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1062: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1060: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
1061: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1062: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1061: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1062: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1062: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1063: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1064: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1065: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1066: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1067: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1068: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1069: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1070: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1071: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1072: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1073: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1074: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1075: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1076: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1077: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1078: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1079: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1080: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1081: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1082: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1083: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1084: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1085: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1093: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1086: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1093: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1094: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1087: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1093: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1094: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1095: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1088: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1093: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1094: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1095: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1096: ,x_return_status OUT NOCOPY VARCHAR2

Line 1093: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1089: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1093: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1094: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1095: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1096: ,x_return_status OUT NOCOPY VARCHAR2
1097: ,x_msg_count OUT NOCOPY NUMBER

Line 1094: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1090: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1093: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1094: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1095: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1096: ,x_return_status OUT NOCOPY VARCHAR2
1097: ,x_msg_count OUT NOCOPY NUMBER
1098: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1095: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1091: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1092: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1093: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1094: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1095: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1096: ,x_return_status OUT NOCOPY VARCHAR2
1097: ,x_msg_count OUT NOCOPY NUMBER
1098: ,x_msg_data OUT NOCOPY VARCHAR2
1099: )

Line 1103: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

1099: )
1100: IS
1101: l_target_rec BIS_TARGET_PUB.TARGET_REC_TYPE;
1102: l_target_rec_out BIS_TARGET_PUB.TARGET_REC_TYPE;
1103: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1104: l_time_seq_num NUMBER;
1105: l_org_seq_num NUMBER;
1106: l_dim_level_id NUMBER;
1107: l_Dim_level_short_name VARCHAR2(32000);

Line 1114: IF BIS_UTILITIES_PUB.VALUE_MISSINg(p_target_id)=FND_API.G_FALSE THEN

1110: l_return_status varchar2(10);
1111:
1112: BEGIN
1113: FND_MSG_PUB.initialize;
1114: IF BIS_UTILITIES_PUB.VALUE_MISSINg(p_target_id)=FND_API.G_FALSE THEN
1115: l_target_rec.target_id := p_target_id;
1116: END IF;
1117:
1118: l_target_rec.target_level_id := p_target_level_id;

Line 1169: -- IF( BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec_out.TARGET_ID)

1165: ,x_msg_count => x_msg_count
1166: ,x_msg_data => x_msg_data
1167: );
1168:
1169: -- IF( BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec_out.TARGET_ID)
1170: -- = FND_API.G_TRUE
1171: -- OR l_Target_Rec_out.TARGET_ID IS NULL
1172: -- ) THEN
1173:

Line 1174: IF( BIS_UTILITIES_PUB.Value_Missing(P_TARGET_ID)

1170: -- = FND_API.G_TRUE
1171: -- OR l_Target_Rec_out.TARGET_ID IS NULL
1172: -- ) THEN
1173:
1174: IF( BIS_UTILITIES_PUB.Value_Missing(P_TARGET_ID)
1175: = FND_API.G_TRUE
1176: OR P_TARGET_ID IS NULL
1177: ) THEN
1178: BIS_PMF_DEFINER_WRAPPER_PVT.GET_TIME_LEVEL_ID

Line 1306: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1302:
1303: END;
1304: --
1305: PROCEDURE UPDATE_TARGET
1306: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1307: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1308: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1307: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1303: END;
1304: --
1305: PROCEDURE UPDATE_TARGET
1306: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1307: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1308: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1308: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1304: --
1305: PROCEDURE UPDATE_TARGET
1306: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1307: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1308: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1305: PROCEDURE UPDATE_TARGET
1306: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1307: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1308: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1306: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1307: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1308: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1307: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1308: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1308: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1309: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1310: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1311: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1312: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1313: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1314: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1315: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1316: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1317: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1318: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1319: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1320: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1321: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1322: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1323: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1324: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1325: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1326: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1327: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1328: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1329: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1330: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1331: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1339: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1332: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1339: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1340: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1333: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1339: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1340: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1341: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1334: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1339: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1340: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1341: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1342: ,x_return_status OUT NOCOPY VARCHAR2

Line 1339: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1335: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1339: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1340: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1341: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1342: ,x_return_status OUT NOCOPY VARCHAR2
1343: ,x_msg_count OUT NOCOPY NUMBER

Line 1340: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1336: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1339: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1340: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1341: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1342: ,x_return_status OUT NOCOPY VARCHAR2
1343: ,x_msg_count OUT NOCOPY NUMBER
1344: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1341: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1337: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1338: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1339: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1340: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1341: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1342: ,x_return_status OUT NOCOPY VARCHAR2
1343: ,x_msg_count OUT NOCOPY NUMBER
1344: ,x_msg_data OUT NOCOPY VARCHAR2
1345:

Line 1349: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

1345:
1346: )
1347: IS
1348: l_target_rec BIS_TARGET_PUB.TARGET_REC_TYPE;
1349: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1350:
1351: l_return_status varchar2(10);
1352:
1353: BEGIN

Line 1355: IF BIS_UTILITIES_PUB.VALUE_MISSINg(p_target_id)=FND_API.G_FALSE THEN

1351: l_return_status varchar2(10);
1352:
1353: BEGIN
1354: FND_MSG_PUB.initialize;
1355: IF BIS_UTILITIES_PUB.VALUE_MISSINg(p_target_id)=FND_API.G_FALSE THEN
1356: l_target_rec.target_id := p_target_id;
1357: END IF;
1358: l_target_rec.target_level_id := p_target_level_id;
1359: l_target_rec.target_level_short_name := p_target_level_short_name;

Line 1423: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1419:
1420: END;
1421: --
1422: PROCEDURE DELETE_TARGET
1423: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1424: ,p_Target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1425: ,p_target_level_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1426: ,x_return_status OUT NOCOPY VARCHAR2
1427: ,x_msg_count OUT NOCOPY NUMBER

Line 1424: ,p_Target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

1420: END;
1421: --
1422: PROCEDURE DELETE_TARGET
1423: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1424: ,p_Target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1425: ,p_target_level_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1426: ,x_return_status OUT NOCOPY VARCHAR2
1427: ,x_msg_count OUT NOCOPY NUMBER
1428: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1425: ,p_target_level_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

1421: --
1422: PROCEDURE DELETE_TARGET
1423: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1424: ,p_Target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
1425: ,p_target_level_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
1426: ,x_return_status OUT NOCOPY VARCHAR2
1427: ,x_msg_count OUT NOCOPY NUMBER
1428: ,x_msg_data OUT NOCOPY VARCHAR2
1429: )

Line 1432: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

1428: ,x_msg_data OUT NOCOPY VARCHAR2
1429: )
1430: IS
1431: l_TargeT_rec BIS_TARGET_PUB.TARGET_REC_TYPE;
1432: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1433:
1434: l_return_status varchar2(10);
1435: BEGIN
1436: FND_MSG_PUB.initialize;

Line 1469: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM

1465:
1466: END;
1467: --
1468: PROCEDURE GET_TIME_LEVEL_ID
1469: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1470: ,p_target_level_id IN NUMBER
1471: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1472: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1473: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1471: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1467: --
1468: PROCEDURE GET_TIME_LEVEL_ID
1469: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1470: ,p_target_level_id IN NUMBER
1471: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1472: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1473: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1474: ,x_sequence_no OUT NOCOPY NUMBER
1475: ,x_dim_level_id OUT NOCOPY NUMBER

Line 1472: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1468: PROCEDURE GET_TIME_LEVEL_ID
1469: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1470: ,p_target_level_id IN NUMBER
1471: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1472: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1473: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1474: ,x_sequence_no OUT NOCOPY NUMBER
1475: ,x_dim_level_id OUT NOCOPY NUMBER
1476: ,x_dim_level_short_name OUT NOCOPY VARCHAR2

Line 1473: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1469: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1470: ,p_target_level_id IN NUMBER
1471: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1472: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1473: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1474: ,x_sequence_no OUT NOCOPY NUMBER
1475: ,x_dim_level_id OUT NOCOPY NUMBER
1476: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
1477: ,x_dim_level_name OUT NOCOPY VARCHAR2

Line 1479: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE

1475: ,x_dim_level_id OUT NOCOPY NUMBER
1476: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
1477: ,x_dim_level_name OUT NOCOPY VARCHAR2
1478: ,x_return_status OUT NOCOPY VARCHAR2
1479: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
1480: )
1481: IS
1482: CURSOR c_perf_dim_src IS
1483: SELECT x.sequence_no

Line 1532: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

1528: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1529: l_dimension7_level_id NUMBER;
1530: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1531: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1532: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1533:
1534: BEGIN
1535: IF (p_performance_measure_id <> FND_API.G_MISS_NUM AND
1536: p_source <> FND_API.G_MISS_CHAR) THEN

Line 1656: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM

1652: END;
1653: --
1654:
1655: PROCEDURE GET_TIME_LEVEL_ID
1656: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1657: ,p_target_level_id IN NUMBER
1658: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1659: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1660: ,x_sequence_no OUT NOCOPY NUMBER

Line 1658: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1654:
1655: PROCEDURE GET_TIME_LEVEL_ID
1656: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1657: ,p_target_level_id IN NUMBER
1658: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1659: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1660: ,x_sequence_no OUT NOCOPY NUMBER
1661: ,x_dim_level_id OUT NOCOPY NUMBER
1662: ,x_dim_level_short_name OUT NOCOPY VARCHAR2

Line 1659: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1655: PROCEDURE GET_TIME_LEVEL_ID
1656: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1657: ,p_target_level_id IN NUMBER
1658: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1659: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1660: ,x_sequence_no OUT NOCOPY NUMBER
1661: ,x_dim_level_id OUT NOCOPY NUMBER
1662: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
1663: ,x_dim_level_name OUT NOCOPY VARCHAR2

Line 1795: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM

1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792: END;
1793: --
1794: PROCEDURE GET_ORG_LEVEL_ID
1795: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1796: ,p_target_level_id IN NUMBER
1797: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1798: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1799: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

Line 1797: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1793: --
1794: PROCEDURE GET_ORG_LEVEL_ID
1795: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1796: ,p_target_level_id IN NUMBER
1797: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1798: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1799: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1800: ,x_sequence_no OUT NOCOPY NUMBER
1801: ,x_dim_level_id OUT NOCOPY NUMBER

Line 1798: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1794: PROCEDURE GET_ORG_LEVEL_ID
1795: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1796: ,p_target_level_id IN NUMBER
1797: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1798: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1799: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1800: ,x_sequence_no OUT NOCOPY NUMBER
1801: ,x_dim_level_id OUT NOCOPY NUMBER
1802: ,x_dim_level_short_name OUT NOCOPY VARCHAR2

Line 1799: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1795: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1796: ,p_target_level_id IN NUMBER
1797: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1798: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1799: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1800: ,x_sequence_no OUT NOCOPY NUMBER
1801: ,x_dim_level_id OUT NOCOPY NUMBER
1802: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
1803: ,x_dim_level_name OUT NOCOPY VARCHAR2

Line 1805: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE

1801: ,x_dim_level_id OUT NOCOPY NUMBER
1802: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
1803: ,x_dim_level_name OUT NOCOPY VARCHAR2
1804: ,x_return_status OUT NOCOPY VARCHAR2
1805: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
1806: )
1807: IS
1808: CURSOR c_perf_dim_src IS
1809: SELECT x.sequence_no

Line 1858: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

1854: l_dimension6_level_name BISFV_TARGET_LEVELS.dimension6_level_name%TYPE;
1855: l_dimension7_level_id NUMBER;
1856: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1857: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1858: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1859:
1860: BEGIN
1861: IF (p_performance_measure_id <> FND_API.G_MISS_NUM
1862: AND p_source <> FND_API.G_MISS_CHAR) THEN

Line 1984: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM

1980:
1981:
1982: ---
1983: PROCEDURE GET_ORG_LEVEL_ID
1984: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1985: ,p_target_level_id IN NUMBER
1986: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1987: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1988: ,x_sequence_no OUT NOCOPY NUMBER

Line 1986: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1982: ---
1983: PROCEDURE GET_ORG_LEVEL_ID
1984: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1985: ,p_target_level_id IN NUMBER
1986: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1987: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1988: ,x_sequence_no OUT NOCOPY NUMBER
1989: ,x_dim_level_id OUT NOCOPY NUMBER
1990: ,x_dim_level_short_name OUT NOCOPY VARCHAR2

Line 1987: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR

1983: PROCEDURE GET_ORG_LEVEL_ID
1984: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
1985: ,p_target_level_id IN NUMBER
1986: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1987: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
1988: ,x_sequence_no OUT NOCOPY NUMBER
1989: ,x_dim_level_id OUT NOCOPY NUMBER
1990: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
1991: ,x_dim_level_name OUT NOCOPY VARCHAR2

Line 2124: (p_error_tbl IN BIS_UTILITIES_PUB.ERROR_TBL_TYPE

2120: END;
2121:
2122:
2123: PROCEDURE ADD_TO_FND_MSG_STACK
2124: (p_error_tbl IN BIS_UTILITIES_PUB.ERROR_TBL_TYPE
2125: ,x_msg_count OUT NOCOPY NUMBER
2126: ,x_msg_data OUT NOCOPY VARCHAR2
2127: ,x_return_status OUT NOCOPY VARCHAR2
2128: )

Line 2183: ||BIS_UTILITIES_PUB.encode(p_measure_id);

2179: IF (p_measure_id IS NOT NULL) THEN
2180: l_alert_url := l_alert_url || G_AMPERSAND ||'perfMeasureId='
2181: -- 2280993 starts
2182: -- ||wfa_html.conv_special_url_chars(p_measure_id);
2183: ||BIS_UTILITIES_PUB.encode(p_measure_id);
2184: -- 2280993 ends
2185: END IF;
2186: --added target_level_id
2187: IF (p_target_level_id IS NOT NULL) THEN

Line 2191: ||BIS_UTILITIES_PUB.encode(p_target_level_id);

2187: IF (p_target_level_id IS NOT NULL) THEN
2188: l_alert_url := l_alert_url || G_AMPERSAND ||'targetLevelId='
2189: -- 2280993 starts
2190: -- ||wfa_html.conv_special_url_chars(p_target_level_id);
2191: ||BIS_UTILITIES_PUB.encode(p_target_level_id);
2192: -- 2280993 ends
2193: END IF;
2194: ------
2195: IF (p_dim1_level_id IS NOT NULL) THEN

Line 2199: ||BIS_UTILITIES_PUB.encode(p_dim1_level_id);

2195: IF (p_dim1_level_id IS NOT NULL) THEN
2196: l_alert_url := l_alert_url || G_AMPERSAND||'parameter1Level='
2197: -- 2280993 starts
2198: -- ||wfa_html.conv_special_url_chars(p_dim1_level_id);
2199: ||BIS_UTILITIES_PUB.encode(p_dim1_level_id);
2200: -- 2280993 ends
2201: END IF;
2202: IF (p_dim2_level_id IS NOT NULL) THEN
2203: l_alert_url := l_alert_url || G_AMPERSAND||'parameter2Level='

Line 2206: ||BIS_UTILITIES_PUB.encode(p_dim2_level_id);

2202: IF (p_dim2_level_id IS NOT NULL) THEN
2203: l_alert_url := l_alert_url || G_AMPERSAND||'parameter2Level='
2204: -- 2280993 starts
2205: -- ||wfa_html.conv_special_url_chars(p_dim2_level_id);
2206: ||BIS_UTILITIES_PUB.encode(p_dim2_level_id);
2207: -- 2280993 ends
2208: END IF;
2209: IF (p_dim3_level_id IS NOT NULL) THEN
2210: l_alert_url := l_alert_url || G_AMPERSAND||'parameter3Level='

Line 2213: ||BIS_UTILITIES_PUB.encode(p_dim3_level_id);

2209: IF (p_dim3_level_id IS NOT NULL) THEN
2210: l_alert_url := l_alert_url || G_AMPERSAND||'parameter3Level='
2211: -- 2280993 starts
2212: -- ||wfa_html.conv_special_url_chars(p_dim3_level_id);
2213: ||BIS_UTILITIES_PUB.encode(p_dim3_level_id);
2214: -- 2280993 ends
2215: END IF;
2216: IF (p_dim4_level_id IS NOT NULL) THEN
2217: l_alert_url := l_alert_url || G_AMPERSAND||'parameter4Level='

Line 2220: ||BIS_UTILITIES_PUB.encode(p_dim4_level_id);

2216: IF (p_dim4_level_id IS NOT NULL) THEN
2217: l_alert_url := l_alert_url || G_AMPERSAND||'parameter4Level='
2218: -- 2280993 starts
2219: -- ||wfa_html.conv_special_url_chars(p_dim4_level_id);
2220: ||BIS_UTILITIES_PUB.encode(p_dim4_level_id);
2221: -- 2280993 ends
2222: END IF;
2223: IF (p_dim5_level_id IS NOT NULL) THEN
2224: l_alert_url := l_alert_url || G_AMPERSAND||'parameter5Level='

Line 2227: ||BIS_UTILITIES_PUB.encode(p_dim5_level_id);

2223: IF (p_dim5_level_id IS NOT NULL) THEN
2224: l_alert_url := l_alert_url || G_AMPERSAND||'parameter5Level='
2225: -- 2280993 starts
2226: -- ||wfa_html.conv_special_url_chars(p_dim5_level_id);
2227: ||BIS_UTILITIES_PUB.encode(p_dim5_level_id);
2228: -- 2280993 ends
2229: END IF;
2230: IF (p_dim6_level_id IS NOT NULL) THEN
2231: l_alert_url := l_alert_url || G_AMPERSAND||'parameter6Level='

Line 2234: ||BIS_UTILITIES_PUB.encode(p_dim6_level_id);

2230: IF (p_dim6_level_id IS NOT NULL) THEN
2231: l_alert_url := l_alert_url || G_AMPERSAND||'parameter6Level='
2232: -- 2280993 starts
2233: -- ||wfa_html.conv_special_url_chars(p_dim6_level_id);
2234: ||BIS_UTILITIES_PUB.encode(p_dim6_level_id);
2235: -- 2280993 ends
2236: END IF;
2237: IF (p_dim7_level_id IS NOT NULL) THEN
2238: l_alert_url := l_alert_url || G_AMPERSAND||'parameter7Level='

Line 2241: ||BIS_UTILITIES_PUB.encode(p_dim7_level_id);

2237: IF (p_dim7_level_id IS NOT NULL) THEN
2238: l_alert_url := l_alert_url || G_AMPERSAND||'parameter7Level='
2239: -- 2280993 starts
2240: -- ||wfa_html.conv_special_url_chars(p_dim7_level_id);
2241: ||BIS_UTILITIES_PUB.encode(p_dim7_level_id);
2242: -- 2280993 ends
2243: END IF;
2244: RETURN l_alert_url;
2245: END BuildAlertRegURLTL;

Line 2288: || BIS_UTILITIES_PUB.encode(p_measure_id);

2284: IF (p_measure_id IS NOT NULL) THEN
2285: l_alert_url := l_alert_url || G_AMPERSAND || 'perfMeasureId='
2286: -- 2280993 starts
2287: -- || wfa_html.conv_special_url_chars(p_measure_id);
2288: || BIS_UTILITIES_PUB.encode(p_measure_id);
2289: -- 2280993 ends
2290: END IF;
2291: IF (p_plan_id IS NOT NULL) THEN
2292: l_alert_url := l_alert_url || G_AMPERSAND || 'planId='

Line 2295: || BIS_UTILITIES_PUB.encode(p_plan_id);

2291: IF (p_plan_id IS NOT NULL) THEN
2292: l_alert_url := l_alert_url || G_AMPERSAND || 'planId='
2293: -- 2280993 starts
2294: -- || wfa_html.conv_special_url_chars(p_plan_id);
2295: || BIS_UTILITIES_PUB.encode(p_plan_id);
2296: -- 2280993 ends
2297: END IF;
2298: IF (p_target_level_id IS NOT NULL) THEN
2299: l_Alert_url := l_alert_url || G_AMPERSAND || 'targetLevelId='

Line 2302: ||BIS_UTILITIES_PUB.encode(p_target_level_id);

2298: IF (p_target_level_id IS NOT NULL) THEN
2299: l_Alert_url := l_alert_url || G_AMPERSAND || 'targetLevelId='
2300: -- 2280993 starts
2301: -- ||wfa_html.conv_special_url_chars(p_target_level_id);
2302: ||BIS_UTILITIES_PUB.encode(p_target_level_id);
2303: -- 2280993 ends
2304: END IF;
2305: IF (p_parameter1levelId IS NOT NULL) THEN
2306: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter1LevelId='

Line 2309: ||BIS_UTILITIES_PUB.encode(p_parameter1levelId);

2305: IF (p_parameter1levelId IS NOT NULL) THEN
2306: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter1LevelId='
2307: -- 2280993 starts
2308: -- ||wfa_html.conv_special_url_chars(p_parameter1levelId);
2309: ||BIS_UTILITIES_PUB.encode(p_parameter1levelId);
2310: -- 2280993 ends
2311: END IF;
2312: IF (p_parameter1ValueId IS NOT NULL) THEN
2313: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter1ValueId='

Line 2316: ||BIS_UTILITIES_PUB.encode(p_parameter1ValueId);

2312: IF (p_parameter1ValueId IS NOT NULL) THEN
2313: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter1ValueId='
2314: -- 2280993 starts
2315: -- ||wfa_html.conv_special_url_chars(p_parameter1ValueId);
2316: ||BIS_UTILITIES_PUB.encode(p_parameter1ValueId);
2317: -- 2280993 ends
2318: END IF;
2319: IF (p_parameter2levelId IS NOT NULL) THEN
2320: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter2LevelId='

Line 2323: ||BIS_UTILITIES_PUB.encode(p_parameter2levelId);

2319: IF (p_parameter2levelId IS NOT NULL) THEN
2320: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter2LevelId='
2321: -- 2280993 starts
2322: -- ||wfa_html.conv_special_url_chars(p_parameter2levelId);
2323: ||BIS_UTILITIES_PUB.encode(p_parameter2levelId);
2324: -- 2280993 ends
2325: END IF;
2326: IF (p_parameter2ValueId IS NOT NULL) THEN
2327: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter2ValueId='

Line 2330: ||BIS_UTILITIES_PUB.encode(p_parameter2ValueId);

2326: IF (p_parameter2ValueId IS NOT NULL) THEN
2327: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter2ValueId='
2328: -- 2280993 starts
2329: -- ||wfa_html.conv_special_url_chars(p_parameter2ValueId);
2330: ||BIS_UTILITIES_PUB.encode(p_parameter2ValueId);
2331: -- 2280993 ends
2332: END IF;
2333: IF (p_parameter3levelId IS NOT NULL) THEN
2334: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter3LevelId='

Line 2337: ||BIS_UTILITIES_PUB.encode(p_parameter3levelId);

2333: IF (p_parameter3levelId IS NOT NULL) THEN
2334: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter3LevelId='
2335: -- 2280993 starts
2336: -- ||wfa_html.conv_special_url_chars(p_parameter3levelId);
2337: ||BIS_UTILITIES_PUB.encode(p_parameter3levelId);
2338: -- 2280993 ends
2339: END IF;
2340: IF (p_parameter3ValueId IS NOT NULL) THEN
2341: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter3ValueId='

Line 2344: ||BIS_UTILITIES_PUB.encode(p_parameter3ValueId);

2340: IF (p_parameter3ValueId IS NOT NULL) THEN
2341: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter3ValueId='
2342: -- 2280993 starts
2343: -- ||wfa_html.conv_special_url_chars(p_parameter3ValueId);
2344: ||BIS_UTILITIES_PUB.encode(p_parameter3ValueId);
2345: -- 2280993 ends
2346: END IF;
2347: IF (p_parameter4levelId IS NOT NULL) THEN
2348: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter4LevelId='

Line 2351: ||BIS_UTILITIES_PUB.encode(p_parameter4levelId);

2347: IF (p_parameter4levelId IS NOT NULL) THEN
2348: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter4LevelId='
2349: -- 2280993 starts
2350: -- ||wfa_html.conv_special_url_chars(p_parameter4levelId);
2351: ||BIS_UTILITIES_PUB.encode(p_parameter4levelId);
2352: -- 2280993 ends
2353: END IF;
2354: IF (p_parameter4ValueId IS NOT NULL) THEN
2355: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter4ValueId='

Line 2358: ||BIS_UTILITIES_PUB.encode(p_parameter4ValueId);

2354: IF (p_parameter4ValueId IS NOT NULL) THEN
2355: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter4ValueId='
2356: -- 2280993 starts
2357: -- ||wfa_html.conv_special_url_chars(p_parameter4ValueId);
2358: ||BIS_UTILITIES_PUB.encode(p_parameter4ValueId);
2359: -- 2280993 ends
2360: END IF;
2361: IF (p_parameter5levelId IS NOT NULL) THEN
2362: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter5LevelId='

Line 2365: ||BIS_UTILITIES_PUB.encode(p_parameter5levelId);

2361: IF (p_parameter5levelId IS NOT NULL) THEN
2362: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter5LevelId='
2363: -- 2280993 starts
2364: -- ||wfa_html.conv_special_url_chars(p_parameter5levelId);
2365: ||BIS_UTILITIES_PUB.encode(p_parameter5levelId);
2366: -- 2280993 ends
2367: END IF;
2368: IF (p_parameter5ValueId IS NOT NULL) THEN
2369: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter5ValueId='

Line 2372: ||BIS_UTILITIES_PUB.encode(p_parameter5ValueId);

2368: IF (p_parameter5ValueId IS NOT NULL) THEN
2369: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter5ValueId='
2370: -- 2280993 starts
2371: -- ||wfa_html.conv_special_url_chars(p_parameter5ValueId);
2372: ||BIS_UTILITIES_PUB.encode(p_parameter5ValueId);
2373: -- 2280993 ends
2374: END IF;
2375: IF (p_parameter6levelId IS NOT NULL) THEN
2376: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter6LevelId='

Line 2379: ||BIS_UTILITIES_PUB.encode(p_parameter6levelId);

2375: IF (p_parameter6levelId IS NOT NULL) THEN
2376: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter6LevelId='
2377: -- 2280993 starts
2378: -- ||wfa_html.conv_special_url_chars(p_parameter6levelId);
2379: ||BIS_UTILITIES_PUB.encode(p_parameter6levelId);
2380: -- 2280993 ends
2381: END IF;
2382: IF (p_parameter6ValueId IS NOT NULL) THEN
2383: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter6ValueId='

Line 2386: ||BIS_UTILITIES_PUB.encode(p_parameter6ValueId);

2382: IF (p_parameter6ValueId IS NOT NULL) THEN
2383: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter6ValueId='
2384: -- 2280993 starts
2385: -- ||wfa_html.conv_special_url_chars(p_parameter6ValueId);
2386: ||BIS_UTILITIES_PUB.encode(p_parameter6ValueId);
2387: -- 2280993 ends
2388: END IF;
2389: IF (p_parameter7levelId IS NOT NULL) THEN
2390: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter7LevelId='

Line 2393: ||BIS_UTILITIES_PUB.encode(p_parameter7levelId);

2389: IF (p_parameter7levelId IS NOT NULL) THEN
2390: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter7LevelId='
2391: -- 2280993 starts
2392: -- ||wfa_html.conv_special_url_chars(p_parameter7levelId);
2393: ||BIS_UTILITIES_PUB.encode(p_parameter7levelId);
2394: -- 2280993 ends
2395: END IF;
2396: IF (p_parameter7ValueId IS NOT NULL) THEN
2397: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter7ValueId='

Line 2400: ||BIS_UTILITIES_PUB.encode(p_parameter7ValueId);

2396: IF (p_parameter7ValueId IS NOT NULL) THEN
2397: l_alert_url := l_alert_url || G_AMPERSAND || 'parameter7ValueId='
2398: -- 2280993 starts
2399: -- ||wfa_html.conv_special_url_chars(p_parameter7ValueId);
2400: ||BIS_UTILITIES_PUB.encode(p_parameter7ValueId);
2401: -- 2280993 ends
2402: END IF;
2403: RETURN l_alert_url;
2404: END BuildAlertRegURLTarget;

Line 2527: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

2523: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
2524: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
2525: l_target_rec BIS_TARGET_PUB.TARGET_REC_TYPE;
2526: l_target_rec_p BIS_TARGET_PUB.TARGET_REC_TYPE;
2527: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
2528: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
2529: l_dim_level_value_rec BIS_DIM_lEVEL_VALUE_PUB.DIM_LEVEL_VALUE_REC_TYPE;
2530: G_PKG_NAME VARCHAR2(32000):= 'BIS_PMF_DEFINER_WRAPPER_PVT';
2531: l_api_name VARCHAR2(32000):= 'GET_TARGET_DETAILS';

Line 2807: p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,

2803:
2804: END;
2805: PROCEDURE UPDATE_MEASURE_SECURITY
2806: (
2807: p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
2808: p_responsibilities IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
2809: x_return_status OUT NOCOPY VARCHAR2,
2810: x_msg_count OUT NOCOPY VARCHAR2,
2811: x_msg_data OUT NOCOPY VARCHAR2

Line 2808: p_responsibilities IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,

2804: END;
2805: PROCEDURE UPDATE_MEASURE_SECURITY
2806: (
2807: p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
2808: p_responsibilities IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
2809: x_return_status OUT NOCOPY VARCHAR2,
2810: x_msg_count OUT NOCOPY VARCHAR2,
2811: x_msg_data OUT NOCOPY VARCHAR2
2812: )

Line 2815: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

2811: x_msg_data OUT NOCOPY VARCHAR2
2812: )
2813: IS
2814: l_return_status VARCHAR2(32000);
2815: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
2816: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
2817: l_measure_security_rec BIS_MEASURE_SECURITY_PUB.MEASURE_SECURITY_REC_TYPE;
2818: l_responsibilities VARCHAR2(32000);
2819: l_responsibility_id PLS_INTEGER;

Line 2825: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN

2821: BEGIN
2822: FND_MSG_PUB.initialize;
2823: -- Delete all responsibility associated with this target level
2824:
2825: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN
2826: l_target_level_rec.target_level_id := p_target_level_id;
2827: l_measure_security_rec.target_level_id := p_target_level_id;
2828: END IF;
2829:

Line 2862: IF (BIS_UTILITIES_PUB.VALUE_MISSING(l_responsibility_id) = FND_API.G_FALSE) THEN

2858: l_responsibility_id := l_responsibilities;
2859: l_responsibilities := '';
2860: END IF;
2861:
2862: IF (BIS_UTILITIES_PUB.VALUE_MISSING(l_responsibility_id) = FND_API.G_FALSE) THEN
2863: l_measure_security_rec.responsibility_id := l_responsibility_id;
2864:
2865: BIS_MEASURE_SECURITY_PVT.Create_Measure_Security
2866: (

Line 2890: p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,

2886:
2887:
2888: PROCEDURE GET_TARGET_LEVEL_NAMES
2889: (
2890: p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
2891: x_measure_name OUT NOCOPY VARCHAR2,
2892: x_dim_names OUT NOCOPY VARCHAR2,
2893: x_return_status OUT NOCOPY VARCHAR2,
2894: x_msg_count OUT NOCOPY VARCHAR2,

Line 2900: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

2896: )
2897: IS
2898: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
2899: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
2900: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
2901: l_names VARCHAR2(32000) := '';
2902: l_sep VARCHAR2(2) := '';
2903: BEGIN
2904: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN

Line 2904: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN

2900: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
2901: l_names VARCHAR2(32000) := '';
2902: l_sep VARCHAR2(2) := '';
2903: BEGIN
2904: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN
2905: l_target_level_rec.target_level_id := p_target_level_id;
2906: END IF;
2907:
2908: l_target_level_rec_p := l_target_level_rec;

Line 3009: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3005: END;
3006:
3007: -- Fix for 2126074 starts here
3008: Procedure Retrieve_Performance_Measure
3009: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3010: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3011: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3010: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3006:
3007: -- Fix for 2126074 starts here
3008: Procedure Retrieve_Performance_Measure
3009: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3010: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3011: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3011: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3007: -- Fix for 2126074 starts here
3008: Procedure Retrieve_Performance_Measure
3009: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3010: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3011: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3008: Procedure Retrieve_Performance_Measure
3009: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3010: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3011: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3009: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3010: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3011: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3010: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3011: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3011: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3012: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3013: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3014: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3015: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3023: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3016: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3023: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3024: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3017: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3023: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3024: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3025: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3018: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3023: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3024: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3025: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3026: ,x_return_status OUT NOCOPY VARCHAR2

Line 3023: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3019: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3023: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3024: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3025: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3026: ,x_return_status OUT NOCOPY VARCHAR2
3027: ,x_msg_count OUT NOCOPY VARCHAR2

Line 3024: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3020: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3023: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3024: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3025: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3026: ,x_return_status OUT NOCOPY VARCHAR2
3027: ,x_msg_count OUT NOCOPY VARCHAR2
3028: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3025: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3021: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3022: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3023: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3024: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3025: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3026: ,x_return_status OUT NOCOPY VARCHAR2
3027: ,x_msg_count OUT NOCOPY VARCHAR2
3028: ,x_msg_data OUT NOCOPY VARCHAR2
3029: ,x_Measure_ID OUT NOCOPY NUMBER

Line 3107: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3103:
3104: -- Fix for 2126074 ends here
3105: -- overloaded with enable_link param for bug 2440739
3106: Procedure Retrieve_Performance_Measure
3107: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3108: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3109: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3108: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3104: -- Fix for 2126074 ends here
3105: -- overloaded with enable_link param for bug 2440739
3106: Procedure Retrieve_Performance_Measure
3107: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3108: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3109: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3109: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3105: -- overloaded with enable_link param for bug 2440739
3106: Procedure Retrieve_Performance_Measure
3107: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3108: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3109: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3106: Procedure Retrieve_Performance_Measure
3107: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3108: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3109: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3107: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3108: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3109: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3108: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3109: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3109: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3110: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3111: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3112: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

3113: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3121: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3114: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3121: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3122: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3115: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3121: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3122: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3123: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3116: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3121: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3122: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3123: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3124: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739

Line 3121: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3117: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3121: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3122: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3123: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3124: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
3125: ,x_return_status OUT NOCOPY VARCHAR2

Line 3122: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3118: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3121: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3122: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3123: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3124: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
3125: ,x_return_status OUT NOCOPY VARCHAR2
3126: ,x_msg_count OUT NOCOPY VARCHAR2

Line 3123: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

3119: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3120: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3121: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3122: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3123: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
3124: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
3125: ,x_return_status OUT NOCOPY VARCHAR2
3126: ,x_msg_count OUT NOCOPY VARCHAR2
3127: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3154: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3150: )
3151: IS
3152:
3153: l_return_status varchar2(32000);
3154: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3155: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
3156: x_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
3157: l_ret VARCHAR2(32000);
3158:

Line 3162: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Id);

3158:
3159: Begin
3160:
3161: FND_MSG_PUB.initialize;
3162: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Id);
3163: IF (l_ret = FND_API.G_FALSE) THEN
3164: l_measure_rec.Measure_Id := p_Measure_Id;
3165: END IF;
3166:

Line 3167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);

3163: IF (l_ret = FND_API.G_FALSE) THEN
3164: l_measure_rec.Measure_Id := p_Measure_Id;
3165: END IF;
3166:
3167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);
3168: IF (l_ret = FND_API.G_FALSE) THEN
3169: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
3170: END IF;
3171:

Line 3172: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Name);

3168: IF (l_ret = FND_API.G_FALSE) THEN
3169: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
3170: END IF;
3171:
3172: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Name);
3173: IF (l_ret = FND_API.G_FALSE) THEN
3174: l_measure_rec.Measure_Name := p_Measure_Name;
3175: END IF;
3176:

Line 3177: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Description);

3173: IF (l_ret = FND_API.G_FALSE) THEN
3174: l_measure_rec.Measure_Name := p_Measure_Name;
3175: END IF;
3176:
3177: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Description);
3178: IF (l_ret = FND_API.G_FALSE) THEN
3179: l_measure_rec.Description := p_Description;
3180: END IF;
3181:

Line 3182: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension1_ID);

3178: IF (l_ret = FND_API.G_FALSE) THEN
3179: l_measure_rec.Description := p_Description;
3180: END IF;
3181:
3182: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension1_ID);
3183: IF (l_ret = FND_API.G_FALSE) THEN
3184: l_measure_rec.Dimension1_ID := p_Dimension1_ID;
3185: END IF;
3186:

Line 3187: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension2_ID);

3183: IF (l_ret = FND_API.G_FALSE) THEN
3184: l_measure_rec.Dimension1_ID := p_Dimension1_ID;
3185: END IF;
3186:
3187: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension2_ID);
3188: IF (l_ret = FND_API.G_FALSE) THEN
3189: l_measure_rec.Dimension2_ID := p_Dimension2_ID;
3190: END IF;
3191:

Line 3192: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension3_ID);

3188: IF (l_ret = FND_API.G_FALSE) THEN
3189: l_measure_rec.Dimension2_ID := p_Dimension2_ID;
3190: END IF;
3191:
3192: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension3_ID);
3193: IF (l_ret = FND_API.G_FALSE) THEN
3194: l_measure_rec.Dimension3_ID := p_Dimension3_ID;
3195: END IF;
3196:

Line 3197: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension4_ID);

3193: IF (l_ret = FND_API.G_FALSE) THEN
3194: l_measure_rec.Dimension3_ID := p_Dimension3_ID;
3195: END IF;
3196:
3197: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension4_ID);
3198: IF (l_ret = FND_API.G_FALSE) THEN
3199: l_measure_rec.Dimension4_ID := p_Dimension4_ID;
3200: END IF;
3201:

Line 3202: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension5_ID);

3198: IF (l_ret = FND_API.G_FALSE) THEN
3199: l_measure_rec.Dimension4_ID := p_Dimension4_ID;
3200: END IF;
3201:
3202: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension5_ID);
3203: IF (l_ret = FND_API.G_FALSE) THEN
3204: l_measure_rec.Dimension5_ID := p_Dimension5_ID;
3205: END IF;
3206:

Line 3207: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension6_ID);

3203: IF (l_ret = FND_API.G_FALSE) THEN
3204: l_measure_rec.Dimension5_ID := p_Dimension5_ID;
3205: END IF;
3206:
3207: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension6_ID);
3208: IF (l_ret = FND_API.G_FALSE) THEN
3209: l_measure_rec.Dimension6_ID := p_Dimension6_ID;
3210: END IF;
3211:

Line 3212: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension7_ID);

3208: IF (l_ret = FND_API.G_FALSE) THEN
3209: l_measure_rec.Dimension6_ID := p_Dimension6_ID;
3210: END IF;
3211:
3212: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension7_ID);
3213: IF (l_ret = FND_API.G_FALSE) THEN
3214: l_measure_rec.Dimension7_ID := p_Dimension7_ID;
3215: END IF;
3216:

Line 3218: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Unit_Of_Measure_Class);

3214: l_measure_rec.Dimension7_ID := p_Dimension7_ID;
3215: END IF;
3216:
3217: -----
3218: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Unit_Of_Measure_Class);
3219: IF (l_ret = FND_API.G_FALSE) THEN
3220: l_measure_rec.Unit_Of_Measure_Class := p_Unit_Of_Measure_Class;
3221: END IF;
3222:

Line 3223: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);

3219: IF (l_ret = FND_API.G_FALSE) THEN
3220: l_measure_rec.Unit_Of_Measure_Class := p_Unit_Of_Measure_Class;
3221: END IF;
3222:
3223: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);
3224: IF (l_ret = FND_API.G_FALSE) THEN
3225: l_measure_rec.actual_data_source_type := p_actual_data_source_type;
3226: END IF;
3227: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);

Line 3227: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);

3223: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);
3224: IF (l_ret = FND_API.G_FALSE) THEN
3225: l_measure_rec.actual_data_source_type := p_actual_data_source_type;
3226: END IF;
3227: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);
3228: IF (l_ret = FND_API.G_FALSE) THEN
3229: l_measure_rec.actual_data_source := p_actual_data_source;
3230: END IF;
3231: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);

Line 3231: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);

3227: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);
3228: IF (l_ret = FND_API.G_FALSE) THEN
3229: l_measure_rec.actual_data_source := p_actual_data_source;
3230: END IF;
3231: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);
3232: IF (l_ret = FND_API.G_FALSE) THEN
3233: l_measure_rec.function_name := p_function_name;
3234: END IF;
3235: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);

Line 3235: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);

3231: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);
3232: IF (l_ret = FND_API.G_FALSE) THEN
3233: l_measure_rec.function_name := p_function_name;
3234: END IF;
3235: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);
3236: IF (l_ret = FND_API.G_FALSE) THEN
3237: l_measure_rec.comparison_source := p_comparison_source;
3238: END IF;
3239: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);

Line 3239: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);

3235: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);
3236: IF (l_ret = FND_API.G_FALSE) THEN
3237: l_measure_rec.comparison_source := p_comparison_source;
3238: END IF;
3239: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);
3240: IF (l_ret = FND_API.G_FALSE) THEN
3241: l_measure_rec.increase_in_measure := p_increase_in_measure;
3242: END IF;
3243: --2440739

Line 3244: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_enable_link);

3240: IF (l_ret = FND_API.G_FALSE) THEN
3241: l_measure_rec.increase_in_measure := p_increase_in_measure;
3242: END IF;
3243: --2440739
3244: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_enable_link);
3245: IF (l_ret = FND_API.G_FALSE) THEN
3246: l_measure_rec.increase_in_measure := p_enable_link;
3247: END IF;
3248: --2440739