DBA Data[Home] [Help]

APPS.HRGETACT dependencies on HR_UTILITY

Line 80: hr_utility.set_location ('hrgetact.get_actuals', 5);

76: -- SASmith 31-MAR-1998
77:
78: IF (p_organisation_id is null) then
79:
80: hr_utility.set_location ('hrgetact.get_actuals', 5);
81: DECLARE
82: CURSOR C IS
83: SELECT NVL(SUM(ABV.VALUE),0)
84: FROM per_assignment_budget_values_f abv,

Line 116: hr_utility.set_location ('hrgetact.get_actuals', 10);

112: OPEN C;
113: FETCH C INTO p_actual_start_val;
114: IF (C%NOTFOUND) THEN
115: p_actual_start_val := 0;
116: hr_utility.set_location ('hrgetact.get_actuals', 10);
117: END IF;
118: CLOSE C;
119: END;
120: hr_utility.set_location ('hrgetact.get_actuals', 15);

Line 120: hr_utility.set_location ('hrgetact.get_actuals', 15);

116: hr_utility.set_location ('hrgetact.get_actuals', 10);
117: END IF;
118: CLOSE C;
119: END;
120: hr_utility.set_location ('hrgetact.get_actuals', 15);
121: --
122: DECLARE
123: CURSOR C2 IS
124: SELECT NVL(SUM(ABV.VALUE),0)

Line 157: hr_utility.set_location ('hrgetact.get_actuals', 20);

153: OPEN C2;
154: FETCH C2 INTO l_actual_end_val;
155: IF (C2%NOTFOUND) THEN
156: l_actual_end_val := 0;
157: hr_utility.set_location ('hrgetact.get_actuals', 20);
158: END IF;
159: CLOSE C2;
160: END;
161:

Line 163: hr_utility.set_location ('hrgetact.get_actuals', 25);

159: CLOSE C2;
160: END;
161:
162: ELSE
163: hr_utility.set_location ('hrgetact.get_actuals', 25);
164: DECLARE
165: CURSOR C IS
166: SELECT NVL(SUM(ABV.VALUE),0)
167: FROM per_assignment_budget_values_f abv,

Line 198: hr_utility.set_location ('hrgetact.get_actuals', 30);

194: OPEN C;
195: FETCH C INTO p_actual_start_val;
196: IF (C%NOTFOUND) THEN
197: p_actual_start_val := 0;
198: hr_utility.set_location ('hrgetact.get_actuals', 30);
199: END IF;
200: CLOSE C;
201: END;
202: --

Line 203: hr_utility.set_location ('hrgetact.get_actuals', 35);

199: END IF;
200: CLOSE C;
201: END;
202: --
203: hr_utility.set_location ('hrgetact.get_actuals', 35);
204: DECLARE
205: CURSOR C2 IS
206: SELECT NVL(SUM(ABV.VALUE),0)
207: FROM per_assignment_budget_values_f abv,

Line 238: hr_utility.set_location ('hrgetact.get_actuals', 40);

234: OPEN C2;
235: FETCH C2 INTO l_actual_end_val;
236: IF (C2%NOTFOUND) THEN
237: l_actual_end_val := 0;
238: hr_utility.set_location ('hrgetact.get_actuals', 40);
239: END IF;
240: CLOSE C2;
241: END;
242:

Line 244: hr_utility.set_location ('hrgetact.get_actuals',45);

240: CLOSE C2;
241: END;
242:
243: END IF;
244: hr_utility.set_location ('hrgetact.get_actuals',45);
245:
246:
247: --------------------------------------------------------------------
248: