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.GHR_SF52_POS_UPDATE dependencies on HR_ALL_POSITIONS_F

Line 125: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;

121: procedure update_position_kff
122: IS
123: l_proc varchar2(25) := 'update_position_kff';
124:
125: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
126: l_position_name hr_all_positions_f.name%TYPE;
127: l_organization_id per_organization_units.organization_id%TYPE;
128: l_business_group_id number;
129: l_object_version_number number;

Line 126: l_position_name hr_all_positions_f.name%TYPE;

122: IS
123: l_proc varchar2(25) := 'update_position_kff';
124:
125: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
126: l_position_name hr_all_positions_f.name%TYPE;
127: l_organization_id per_organization_units.organization_id%TYPE;
128: l_business_group_id number;
129: l_object_version_number number;
130: l_valid_grades_changed_warning BOOLEAN;

Line 143: FROM hr_all_positions_f pos

139: IS
140:
141: SELECT name,position_definition_id,
142: organization_id,object_version_number,business_group_id
143: FROM hr_all_positions_f pos
144: WHERE position_id = c_position_id -- Venkat -- Position DT
145: and p_pos_data_rec.effective_date between
146: pos.effective_start_date and pos.effective_end_date;
147:

Line 303: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;

299: procedure update_pos_organization
300: IS
301:
302: l_object_version_number number;
303: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
304: l_pos_name hr_all_positions_f.name%TYPE;
305: l_valid_grade_warning boolean;
306: l_effective_start_date date;
307: l_effective_end_date date;

Line 304: l_pos_name hr_all_positions_f.name%TYPE;

300: IS
301:
302: l_object_version_number number;
303: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
304: l_pos_name hr_all_positions_f.name%TYPE;
305: l_valid_grade_warning boolean;
306: l_effective_start_date date;
307: l_effective_end_date date;
308: l_location_id hr_all_positions_f.location_id%TYPE;

Line 308: l_location_id hr_all_positions_f.location_id%TYPE;

304: l_pos_name hr_all_positions_f.name%TYPE;
305: l_valid_grade_warning boolean;
306: l_effective_start_date date;
307: l_effective_end_date date;
308: l_location_id hr_all_positions_f.location_id%TYPE;
309:
310: cursor c_get_position_details(c_position_id IN number)
311: IS
312:

Line 316: FROM hr_all_positions_f pos

312:
313: SELECT name,position_definition_id,
314: organization_id,object_version_number,business_group_id
315: ,location_id -- Bug 3219207 added by Ashley
316: FROM hr_all_positions_f pos
317: WHERE position_id = c_position_id -- Venkat -- Position DT
318: and p_pos_data_rec.effective_date between
319: pos.effective_start_date and pos.effective_end_date;
320:

Line 355: UPDATE hr_all_positions_f

351: p_effective_end_date => l_effective_end_date,
352: p_effective_date => p_pos_data_rec.effective_date,
353: p_datetrack_mode => l_datetrack_mode);
354:
355: UPDATE hr_all_positions_f
356: SET organization_id = p_pos_data_rec.organization_id
357: WHERE position_id = p_pos_data_rec.position_id
358: AND effective_start_date = l_effective_start_date;
359:

Line 377: UPDATE hr_all_positions_f

373: p_effective_date => p_pos_data_rec.effective_date,
374: p_datetrack_mode => l_datetrack_mode
375: );
376:
377: UPDATE hr_all_positions_f
378: SET organization_id = p_pos_data_rec.organization_id
379: WHERE position_id = p_pos_data_rec.position_id
380: AND effective_start_date = l_effective_start_date;
381:

Line 395: FROM hr_all_positions_f

391: cursor c_get_position_details(c_position_id IN number, c_effective_date date)
392: IS
393: SELECT name,position_definition_id,
394: organization_id,object_version_number,business_group_id
395: FROM hr_all_positions_f
396: WHERE position_id = c_position_id
397: AND nvl(c_effective_date,sysdate)
398: between effective_start_date and effective_end_Date;
399:

Line 405: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;

401: SELECT shared_type_id,shared_type_name from per_shared_types
402: WHERE system_type_cd = 'ELIMINATED';
403:
404: l_object_version_number number;
405: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
406: l_pos_name hr_all_positions_f.name%TYPE;
407: l_valid_grade_warning boolean;
408: l_location_id hr_all_positions_f.location_id%TYPE;
409: l_effective_start_date date;

Line 406: l_pos_name hr_all_positions_f.name%TYPE;

402: WHERE system_type_cd = 'ELIMINATED';
403:
404: l_object_version_number number;
405: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
406: l_pos_name hr_all_positions_f.name%TYPE;
407: l_valid_grade_warning boolean;
408: l_location_id hr_all_positions_f.location_id%TYPE;
409: l_effective_start_date date;
410: l_effective_end_date date;

Line 408: l_location_id hr_all_positions_f.location_id%TYPE;

404: l_object_version_number number;
405: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
406: l_pos_name hr_all_positions_f.name%TYPE;
407: l_valid_grade_warning boolean;
408: l_location_id hr_all_positions_f.location_id%TYPE;
409: l_effective_start_date date;
410: l_effective_end_date date;
411: l_shared_type_id number;
412:

Line 440: --UPDATE hr_all_positions_f

436: p_datetrack_mode => l_datetrack_mode);
437: hr_utility.set_location('After update of position',1);
438:
439:
440: --UPDATE hr_all_positions_f
441: --SET date_end = p_pos_data_rec.effective_end_date
442: --WHERE position_id = p_pos_data_rec.position_id
443: --AND effective_start_date = p_pos_data_rec.effective_date;
444:

Line 453: l_pos_name hr_all_positions_f.name%type;

449: procedure update_pos_job_id
450: IS
451: l_effective_start_Date date;
452: l_effective_end_Date date;
453: l_pos_name hr_all_positions_f.name%type;
454: l_position_Definition_id hr_all_positions_f.position_Definition_id%type;
455: l_object_version_number number;
456: l_valid_grade_warning boolean;
457:

Line 454: l_position_Definition_id hr_all_positions_f.position_Definition_id%type;

450: IS
451: l_effective_start_Date date;
452: l_effective_end_Date date;
453: l_pos_name hr_all_positions_f.name%type;
454: l_position_Definition_id hr_all_positions_f.position_Definition_id%type;
455: l_object_version_number number;
456: l_valid_grade_warning boolean;
457:
458: cursor c_get_position_details(c_position_id IN number,c_effective_date date)

Line 463: FROM hr_all_positions_f

459: IS
460:
461: SELECT name,position_definition_id,
462: job_id,object_version_number,business_group_id
463: FROM hr_all_positions_f
464: WHERE position_id = c_position_id
465: and nvl(c_effective_date,sysdate) between
466: effective_start_date and effective_end_date;
467:

Line 489: UPDATE hr_all_positions_f

485: p_effective_end_date => l_effective_end_date,
486: p_effective_date => p_pos_data_rec.effective_date,
487: p_datetrack_mode => l_datetrack_mode);
488:
489: UPDATE hr_all_positions_f
490: SET job_id = p_pos_data_rec.job_id
491: WHERE position_id = p_pos_data_rec.position_id
492: and effective_start_date = l_effective_start_date;
493:

Line 553: (p_position_id IN hr_all_positions_f.position_id%type,

549:
550: END;
551:
552: FUNCTION pos_return_update_mode
553: (p_position_id IN hr_all_positions_f.position_id%type,
554: p_effective_date IN date)
555:
556: RETURN varchar2 is
557:

Line 567: from hr_all_positions_f pos

563:
564: cursor c_update_mode_pos is
565: select pos.effective_start_date ,
566: pos.effective_end_date
567: from hr_all_positions_f pos
568: where pos.position_id = p_position_id
569: and p_effective_date
570: between pos.effective_start_date
571: and pos.effective_end_date;

Line 576: from hr_all_positions_f pos

572:
573: cursor c_update_mode_pos1 is
574: select pos.effective_start_date ,
575: pos.effective_end_date
576: from hr_all_positions_f pos
577: where pos.position_id = p_position_id
578: and p_effective_date < pos.effective_start_date;
579:
580: Begin

Line 614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');

610: hr_utility.set_location(l_proc,55);
611: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
612: If l_mode is null then
613: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');
615: hr_utility.raise_error;
616: End if;
617: return l_mode;
618: hr_utility.set_location('Leaving ' ||l_proc,60);

Line 625: (p_position_id IN hr_all_positions_f.position_id%TYPE,

621: -----
622: -- JH Added for bug 773795, Position's location is now updated with update to HR.
623: -----
624: PROCEDURE update_positions_location
625: (p_position_id IN hr_all_positions_f.position_id%TYPE,
626: p_location_id IN hr_all_positions_f.location_id%TYPE,
627: p_effective_date IN date) IS
628:
629: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;

Line 626: p_location_id IN hr_all_positions_f.location_id%TYPE,

622: -- JH Added for bug 773795, Position's location is now updated with update to HR.
623: -----
624: PROCEDURE update_positions_location
625: (p_position_id IN hr_all_positions_f.position_id%TYPE,
626: p_location_id IN hr_all_positions_f.location_id%TYPE,
627: p_effective_date IN date) IS
628:
629: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
630: l_position_name hr_all_positions_f.name%TYPE;

Line 629: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;

625: (p_position_id IN hr_all_positions_f.position_id%TYPE,
626: p_location_id IN hr_all_positions_f.location_id%TYPE,
627: p_effective_date IN date) IS
628:
629: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
630: l_position_name hr_all_positions_f.name%TYPE;
631: l_object_version_number number;
632: l_location_id hr_all_positions_f.location_id%TYPE;
633: l_valid_grade_warning BOOLEAN;

Line 630: l_position_name hr_all_positions_f.name%TYPE;

626: p_location_id IN hr_all_positions_f.location_id%TYPE,
627: p_effective_date IN date) IS
628:
629: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
630: l_position_name hr_all_positions_f.name%TYPE;
631: l_object_version_number number;
632: l_location_id hr_all_positions_f.location_id%TYPE;
633: l_valid_grade_warning BOOLEAN;
634: l_effective_start_date date;

Line 632: l_location_id hr_all_positions_f.location_id%TYPE;

628:
629: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
630: l_position_name hr_all_positions_f.name%TYPE;
631: l_object_version_number number;
632: l_location_id hr_all_positions_f.location_id%TYPE;
633: l_valid_grade_warning BOOLEAN;
634: l_effective_start_date date;
635: l_effective_end_date date;
636: l_datetrack_mode VARCHAR2(20);

Line 642: FROM hr_all_positions_f

638: cursor c_get_position_details
639: IS
640:
641: SELECT name, position_definition_id, location_id, object_version_number
642: FROM hr_all_positions_f
643: WHERE position_id = p_position_id
644: and nvl(p_effective_date,sysdate) between
645: effective_start_date and effective_end_date;
646: