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.PER_POS_BGT_PKG dependencies on HR_UTILITY

Line 20: hr_utility.set_message('801','HR_ALL_COUNT_HOLDERS');

16: l_real_holder_name varchar2 (240);
17: --
18: begin
19: --
20: hr_utility.set_message('801','HR_ALL_COUNT_HOLDERS');
21: --
22: -- Assume > 1 holder, so set string to "Holders"
23: --
24: X_HOLDER_NAME := hr_utility.get_message;

Line 24: X_HOLDER_NAME := hr_utility.get_message;

20: hr_utility.set_message('801','HR_ALL_COUNT_HOLDERS');
21: --
22: -- Assume > 1 holder, so set string to "Holders"
23: --
24: X_HOLDER_NAME := hr_utility.get_message;
25: --
26: -- calculate the number of people holding a position and concatenate number
27: -- with "Holders". Get the holder name and holder employee number at the
28: -- same time - we have to use group functions for these, so we get the MAX

Line 54: hr_utility.set_message('801','HR_ALL_NO_HOLDERS');

50: --
51: if X_NO_OF_HOLDERS = 0 then
52: -- return the message no holders
53: --
54: hr_utility.set_message('801','HR_ALL_NO_HOLDERS');
55: X_HOLDER_NAME := hr_utility.get_message;
56: X_HOLDER_EMP_NO := NULL;
57: --
58: elsif X_NO_OF_HOLDERS = 1 then

Line 55: X_HOLDER_NAME := hr_utility.get_message;

51: if X_NO_OF_HOLDERS = 0 then
52: -- return the message no holders
53: --
54: hr_utility.set_message('801','HR_ALL_NO_HOLDERS');
55: X_HOLDER_NAME := hr_utility.get_message;
56: X_HOLDER_EMP_NO := NULL;
57: --
58: elsif X_NO_OF_HOLDERS = 1 then
59: -- set X_HOLDER_NAME to the real holder name.

Line 136: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_PERIOD_START' ,5 ) ;

132: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
133: AND A.ASSIGNMENT_TYPE = 'E';
134: --
135: BEGIN
136: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_PERIOD_START' ,5 ) ;
137: OPEN C;
138: FETCH C INTO X_PERIOD_START;
139: IF (C%NOTFOUND) THEN
140: X_PERIOD_START := 0;

Line 141: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_PERIOD_START' ,10 ) ;

137: OPEN C;
138: FETCH C INTO X_PERIOD_START;
139: IF (C%NOTFOUND) THEN
140: X_PERIOD_START := 0;
141: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_PERIOD_START' ,10 ) ;
142: END IF;
143: CLOSE C;
144:
145: END GET_PERIOD_START;

Line 187: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_PERIOD_END' ,5 ) ;

183: AND AST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
184: AND A.ASSIGNMENT_TYPE = 'E';
185: --
186: BEGIN
187: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_PERIOD_END' ,5 ) ;
188:
189: OPEN C;
190: FETCH C INTO X_PERIOD_END;
191: IF (C%NOTFOUND) THEN

Line 193: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_PERIOD_END' ,10) ;

189: OPEN C;
190: FETCH C INTO X_PERIOD_END;
191: IF (C%NOTFOUND) THEN
192: X_PERIOD_END := 0;
193: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_PERIOD_END' ,10) ;
194: END IF;
195: CLOSE C;
196: END GET_PERIOD_END;
197: --

Line 266: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,5 ) ;

262: l_prev_assgt_end date;
263: --
264: BEGIN
265: --
266: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,5 ) ;
267: x_starters := 0;
268: --
269: FOR c_starters IN C LOOP
270: --

Line 284: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,10) ;

280: -- Removed call to TO_DATE() function forh X_START_DATE.
281: -- PASHUN. 31-OCT-1997. BUG : 572545.
282: --
283: --
284: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,10) ;
285: if c_starters.effective_start_date >= x_start_date then
286: x_starters := x_starters + c_starters.value;
287: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,15) ;
288: end if;

Line 287: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,15) ;

283: --
284: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,10) ;
285: if c_starters.effective_start_date >= x_start_date then
286: x_starters := x_starters + c_starters.value;
287: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,15) ;
288: end if;
289: --
290: -- Note assignment_id for comparison with the next rec.
291: --

Line 301: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,20) ;

297: -- follow on immediately from the previous one. As the cursor only picks
298: -- up rows with one position_id, a gap in the dates means the position_id
299: -- must have just changed.
300: --
301: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,20) ;
302: if c_starters.effective_start_date - 1 <> l_prev_assgt_end then
303: x_starters := x_starters + c_starters.value;
304: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,25) ;
305: end if;

Line 304: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,25) ;

300: --
301: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,20) ;
302: if c_starters.effective_start_date - 1 <> l_prev_assgt_end then
303: x_starters := x_starters + c_starters.value;
304: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,25) ;
305: end if;
306: end if;
307: --
308: -- Note end date for comparison with the next rec.

Line 313: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,30) ;

309: --
310: l_prev_assgt_end := c_starters.effective_end_date;
311: --
312: END LOOP;
313: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_STARTERS' ,30) ;
314: END GET_STARTERS;
315: --
316: -- PROCEDURE GET_LEAVERS: Obtain the number of assignments leaving
317: -- a position within a period.

Line 396: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',5) ;

392: l_prev_assgt_end date;
393: --
394: BEGIN
395: --
396: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',5) ;
397: x_leavers := 0;
398: --
399: FOR c_leavers IN C LOOP
400: --

Line 414: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',10) ;

410: -- BUG. 572545. Removed call to TO_DATE() function for X_END_DATE.
411: -- PASHUN. 31-OCT-1997.
412: --
413: --
414: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',10) ;
415: if (l_prev_assgt_id <> 0 and
416: l_prev_assgt_end <= x_end_date and
417: l_prev_assgt_status <> 'TERM_ASSIGN'
418: ) then

Line 420: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',15) ;

416: l_prev_assgt_end <= x_end_date and
417: l_prev_assgt_status <> 'TERM_ASSIGN'
418: ) then
419: x_leavers := x_leavers + c_leavers.value;
420: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',15) ;
421: end if;
422: --
423: -- As for this assignment, we can't tell whether it's a leaver from
424: -- this record alone - we have to get the next record and compare the

Line 437: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',20) ;

433: -- up rows with one position_id, a gap in the dates means the position_id
434: -- must have just changed in the meantime. Also increment the counter
435: -- if the assgt status has changed to TERM_ASSIGN.
436: --
437: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',20) ;
438: if (c_leavers.effective_start_date - 1 <> l_prev_assgt_end) or
439: (c_leavers.per_system_status = 'TERM_ASSIGN' and
440: l_prev_assgt_status <> 'TERM_ASSIGN') then
441: x_leavers := x_leavers + c_leavers.value;

Line 442: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',25) ;

438: if (c_leavers.effective_start_date - 1 <> l_prev_assgt_end) or
439: (c_leavers.per_system_status = 'TERM_ASSIGN' and
440: l_prev_assgt_status <> 'TERM_ASSIGN') then
441: x_leavers := x_leavers + c_leavers.value;
442: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',25) ;
443: end if;
444: end if;
445: --
446: -- Note end date and assgt status for comparison with the next rec. Also

Line 470: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',30) ;

466: l_prev_assgt_end <= x_end_date and
467: l_prev_assgt_status <> 'TERM_ASSIGN'
468: ) then
469: x_leavers := x_leavers + l_prev_assgt_value;
470: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',30) ;
471: end if;
472: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',35) ;
473: --
474: END GET_LEAVERS;

Line 472: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',35) ;

468: ) then
469: x_leavers := x_leavers + l_prev_assgt_value;
470: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',30) ;
471: end if;
472: hr_utility.set_location ( 'PER_POS_BGT_PKG.GET_LEAVERS',35) ;
473: --
474: END GET_LEAVERS;
475: --
476: --