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_API dependencies on PER_POSITION_DEFINITIONS

Line 432: from hr_all_positions_f pos, per_position_definitions pdf

428: -- l_numrows integer := NULL;
429: --
430: cursor c_pos_seg1 (pos_id number) is
431: select pdf.segment1
432: from hr_all_positions_f pos, per_position_definitions pdf
433: where pos.position_definition_id = pdf.position_definition_id
434: and pos.position_id = pos_id
435: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
436: --

Line 439: from hr_all_positions_f pos, per_position_definitions pdf

435: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
436: --
437: cursor c_pos_seg2 (pos_id number) is
438: select pdf.segment2
439: from hr_all_positions_f pos, per_position_definitions pdf
440: where pos.position_definition_id = pdf.position_definition_id
441: and pos.position_id = pos_id
442: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
443: --

Line 446: from hr_all_positions_f pos, per_position_definitions pdf

442: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
443: --
444: cursor c_pos_seg3 (pos_id number) is
445: select pdf.segment3
446: from hr_all_positions_f pos, per_position_definitions pdf
447: where pos.position_definition_id = pdf.position_definition_id
448: and pos.position_id = pos_id
449: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
450: --

Line 453: from hr_all_positions_f pos, per_position_definitions pdf

449: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
450: --
451: cursor c_pos_seg4 (pos_id number) is
452: select pdf.segment4
453: from hr_all_positions_f pos, per_position_definitions pdf
454: where pos.position_definition_id = pdf.position_definition_id
455: and pos.position_id = pos_id
456: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
457: --

Line 460: from hr_all_positions_f pos, per_position_definitions pdf

456: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
457: --
458: cursor c_pos_seg5 (pos_id number) is
459: select pdf.segment5
460: from hr_all_positions_f pos, per_position_definitions pdf
461: where pos.position_definition_id = pdf.position_definition_id
462: and pos.position_id = pos_id
463: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
464: --

Line 467: from hr_all_positions_f pos, per_position_definitions pdf

463: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
464: --
465: cursor c_pos_seg6 (pos_id number) is
466: select pdf.segment6
467: from hr_all_positions_f pos, per_position_definitions pdf
468: where pos.position_definition_id = pdf.position_definition_id
469: and pos.position_id = pos_id
470: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
471: --

Line 474: from hr_all_positions_f pos, per_position_definitions pdf

470: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
471: --
472: cursor c_pos_seg7 (pos_id number) is
473: select pdf.segment7
474: from hr_all_positions_f pos, per_position_definitions pdf
475: where pos.position_definition_id = pdf.position_definition_id
476: and pos.position_id = pos_id
477: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
478: --

Line 481: from hr_all_positions_f pos, per_position_definitions pdf

477: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
478: --
479: cursor c_pos_seg8 (pos_id number) is
480: select pdf.segment8
481: from hr_all_positions_f pos, per_position_definitions pdf
482: where pos.position_definition_id = pdf.position_definition_id
483: and pos.position_id = pos_id
484: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
485: --

Line 488: from hr_all_positions_f pos, per_position_definitions pdf

484: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
485: --
486: cursor c_pos_seg9 (pos_id number) is
487: select pdf.segment9
488: from hr_all_positions_f pos, per_position_definitions pdf
489: where pos.position_definition_id = pdf.position_definition_id
490: and pos.position_id = pos_id
491: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
492: --

Line 495: from hr_all_positions_f pos, per_position_definitions pdf

491: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
492: --
493: cursor c_pos_seg10 (pos_id number) is
494: select pdf.segment10
495: from hr_all_positions_f pos, per_position_definitions pdf
496: where pos.position_definition_id = pdf.position_definition_id
497: and pos.position_id = pos_id
498: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
499: --

Line 502: from hr_all_positions_f pos, per_position_definitions pdf

498: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
499: --
500: cursor c_pos_seg11 (pos_id number) is
501: select pdf.segment11
502: from hr_all_positions_f pos, per_position_definitions pdf
503: where pos.position_definition_id = pdf.position_definition_id
504: and pos.position_id = pos_id
505: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
506: --

Line 509: from hr_all_positions_f pos, per_position_definitions pdf

505: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
506: --
507: cursor c_pos_seg12 (pos_id number) is
508: select pdf.segment12
509: from hr_all_positions_f pos, per_position_definitions pdf
510: where pos.position_definition_id = pdf.position_definition_id
511: and pos.position_id = pos_id
512: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
513: --

Line 516: from hr_all_positions_f pos, per_position_definitions pdf

512: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
513: --
514: cursor c_pos_seg13 (pos_id number) is
515: select pdf.segment13
516: from hr_all_positions_f pos, per_position_definitions pdf
517: where pos.position_definition_id = pdf.position_definition_id
518: and pos.position_id = pos_id
519: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
520: --

Line 523: from hr_all_positions_f pos, per_position_definitions pdf

519: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
520: --
521: cursor c_pos_seg14 (pos_id number) is
522: select pdf.segment14
523: from hr_all_positions_f pos, per_position_definitions pdf
524: where pos.position_definition_id = pdf.position_definition_id
525: and pos.position_id = pos_id
526: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
527: --

Line 530: from hr_all_positions_f pos, per_position_definitions pdf

526: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
527: --
528: cursor c_pos_seg15 (pos_id number) is
529: select pdf.segment15
530: from hr_all_positions_f pos, per_position_definitions pdf
531: where pos.position_definition_id = pdf.position_definition_id
532: and pos.position_id = pos_id
533: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
534: --

Line 537: from hr_all_positions_f pos, per_position_definitions pdf

533: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
534: --
535: cursor c_pos_seg16 (pos_id number) is
536: select pdf.segment16
537: from hr_all_positions_f pos, per_position_definitions pdf
538: where pos.position_definition_id = pdf.position_definition_id
539: and pos.position_id = pos_id
540: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
541: --

Line 544: from hr_all_positions_f pos, per_position_definitions pdf

540: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
541: --
542: cursor c_pos_seg17 (pos_id number) is
543: select pdf.segment17
544: from hr_all_positions_f pos, per_position_definitions pdf
545: where pos.position_definition_id = pdf.position_definition_id
546: and pos.position_id = pos_id
547: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
548: --

Line 551: from hr_all_positions_f pos, per_position_definitions pdf

547: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
548: --
549: cursor c_pos_seg18 (pos_id number) is
550: select pdf.segment18
551: from hr_all_positions_f pos, per_position_definitions pdf
552: where pos.position_definition_id = pdf.position_definition_id
553: and pos.position_id = pos_id
554: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
555: --

Line 558: from hr_all_positions_f pos, per_position_definitions pdf

554: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
555: --
556: cursor c_pos_seg19 (pos_id number) is
557: select pdf.segment19
558: from hr_all_positions_f pos, per_position_definitions pdf
559: where pos.position_definition_id = pdf.position_definition_id
560: and pos.position_id = pos_id
561: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
562: --

Line 565: from hr_all_positions_f pos, per_position_definitions pdf

561: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
562: --
563: cursor c_pos_seg20 (pos_id number) is
564: select pdf.segment20
565: from hr_all_positions_f pos, per_position_definitions pdf
566: where pos.position_definition_id = pdf.position_definition_id
567: and pos.position_id = pos_id
568: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
569: --

Line 572: from hr_all_positions_f pos, per_position_definitions pdf

568: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
569: --
570: cursor c_pos_seg21 (pos_id number) is
571: select pdf.segment21
572: from hr_all_positions_f pos, per_position_definitions pdf
573: where pos.position_definition_id = pdf.position_definition_id
574: and pos.position_id = pos_id
575: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
576: --

Line 579: from hr_all_positions_f pos, per_position_definitions pdf

575: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
576: --
577: cursor c_pos_seg22 (pos_id number) is
578: select pdf.segment22
579: from hr_all_positions_f pos, per_position_definitions pdf
580: where pos.position_definition_id = pdf.position_definition_id
581: and pos.position_id = pos_id
582: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
583: --

Line 586: from hr_all_positions_f pos, per_position_definitions pdf

582: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
583: --
584: cursor c_pos_seg23 (pos_id number) is
585: select pdf.segment23
586: from hr_all_positions_f pos, per_position_definitions pdf
587: where pos.position_definition_id = pdf.position_definition_id
588: and pos.position_id = pos_id
589: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
590: --

Line 593: from hr_all_positions_f pos, per_position_definitions pdf

589: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
590: --
591: cursor c_pos_seg24 (pos_id number) is
592: select pdf.segment24
593: from hr_all_positions_f pos, per_position_definitions pdf
594: where pos.position_definition_id = pdf.position_definition_id
595: and pos.position_id = pos_id
596: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
597: --

Line 600: from hr_all_positions_f pos, per_position_definitions pdf

596: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
597: --
598: cursor c_pos_seg25 (pos_id number) is
599: select pdf.segment25
600: from hr_all_positions_f pos, per_position_definitions pdf
601: where pos.position_definition_id = pdf.position_definition_id
602: and pos.position_id = pos_id
603: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
604: --

Line 607: from hr_all_positions_f pos, per_position_definitions pdf

603: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
604: --
605: cursor c_pos_seg26 (pos_id number) is
606: select pdf.segment26
607: from hr_all_positions_f pos, per_position_definitions pdf
608: where pos.position_definition_id = pdf.position_definition_id
609: and pos.position_id = pos_id
610: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
611: --

Line 614: from hr_all_positions_f pos, per_position_definitions pdf

610: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
611: --
612: cursor c_pos_seg27 (pos_id number) is
613: select pdf.segment27
614: from hr_all_positions_f pos, per_position_definitions pdf
615: where pos.position_definition_id = pdf.position_definition_id
616: and pos.position_id = pos_id
617: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
618: --

Line 621: from hr_all_positions_f pos, per_position_definitions pdf

617: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
618: --
619: cursor c_pos_seg28 (pos_id number) is
620: select pdf.segment28
621: from hr_all_positions_f pos, per_position_definitions pdf
622: where pos.position_definition_id = pdf.position_definition_id
623: and pos.position_id = pos_id
624: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
625: --

Line 628: from hr_all_positions_f pos, per_position_definitions pdf

624: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
625: --
626: cursor c_pos_seg29 (pos_id number) is
627: select pdf.segment29
628: from hr_all_positions_f pos, per_position_definitions pdf
629: where pos.position_definition_id = pdf.position_definition_id
630: and pos.position_id = pos_id
631: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
632: --

Line 635: from hr_all_positions_f pos, per_position_definitions pdf

631: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
632: --
633: cursor c_pos_seg30 (pos_id number) is
634: select pdf.segment30
635: from hr_all_positions_f pos, per_position_definitions pdf
636: where pos.position_definition_id = pdf.position_definition_id
637: and pos.position_id = pos_id
638: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
639: --

Line 837: || ' from per_positions pos, per_position_definitions pdf'

833: --
834: if p_code = 'POS' then
835: l_select_string
836: := 'select pdf.' || p_information
837: || ' from per_positions pos, per_position_definitions pdf'
838: || ' where pos.position_definition_id = pdf.position_definition_id'
839: || ' and pos.position_id = ' || p_id;
840: elsif p_code = 'JOB' then
841: l_select_string

Line 1932: l_segment per_position_definitions.segment1%type;

1928: l_effective_date date;
1929: l_business_group_id per_all_positions.business_group_id%type;
1930: l_position_id per_all_positions.position_id%type;
1931: l_segment_rec org_info_rec_type;
1932: l_segment per_position_definitions.segment1%type;
1933: l_asg_pos_by_per_id_found boolean := FALSE;
1934: l_asg_pos_by_asg_id_found boolean := FALSE;
1935: --
1936: begin

Line 2018: l_segment per_position_definitions.segment1%type;

2014: ) return varchar2 IS
2015: --
2016: l_proc varchar2(72) := g_package||'get_position_title_pos';
2017: l_segment_rec org_info_rec_type;
2018: l_segment per_position_definitions.segment1%type;
2019: --
2020: begin
2021: -- hr_utility.set_location('Entering:'||l_proc, 1);
2022: --

Line 2067: l_segment per_position_definitions.segment1%type;

2063: l_effective_date date;
2064: l_business_group_id per_all_positions.business_group_id%type;
2065: l_position_id per_all_positions.position_id%type;
2066: l_segment_rec org_info_rec_type;
2067: l_segment per_position_definitions.segment1%type;
2068: l_asg_pos_by_per_id_found boolean := FALSE;
2069: l_asg_pos_by_asg_id_found boolean := FALSE;
2070: --
2071: begin

Line 2155: l_segment per_position_definitions.segment1%type;

2151: ) return varchar2 IS
2152: --
2153: l_proc varchar2(72) := g_package||'get_position_desc_no_pos';
2154: l_segment_rec org_info_rec_type;
2155: l_segment per_position_definitions.segment1%type;
2156: --
2157: begin
2158: -- hr_utility.set_location('Entering:'||l_proc, 1);
2159: --

Line 2204: l_segment per_position_definitions.segment1%type;

2200: l_effective_date date;
2201: l_business_group_id per_all_positions.business_group_id%type;
2202: l_position_id per_all_positions.position_id%type;
2203: l_segment_rec org_info_rec_type;
2204: l_segment per_position_definitions.segment1%type;
2205: l_asg_pos_by_per_id_found boolean := FALSE;
2206: l_asg_pos_by_asg_id_found boolean := FALSE;
2207: --
2208: begin

Line 2292: l_segment per_position_definitions.segment1%type;

2288: ) return varchar2 IS
2289: --
2290: l_proc varchar2(72) := g_package||'get_position_desc_no_pos';
2291: l_segment_rec org_info_rec_type;
2292: l_segment per_position_definitions.segment1%type;
2293: --
2294: begin
2295: -- hr_utility.set_location('Entering:'||l_proc, 1);
2296: --

Line 2341: l_segment per_position_definitions.segment1%type;

2337: l_effective_date date;
2338: l_business_group_id per_all_positions.business_group_id%type;
2339: l_position_id per_all_positions.position_id%type;
2340: l_segment_rec org_info_rec_type;
2341: l_segment per_position_definitions.segment1%type;
2342: l_asg_pos_by_per_id_found boolean := FALSE;
2343: l_asg_pos_by_asg_id_found boolean := FALSE;
2344: --
2345: begin

Line 2429: l_segment per_position_definitions.segment1%type;

2425: ) return varchar2 IS
2426: --
2427: l_proc varchar2(72) := g_package||'get_position_agency_code_pos';
2428: l_segment_rec org_info_rec_type;
2429: l_segment per_position_definitions.segment1%type;
2430: --
2431: begin
2432: -- hr_utility.set_location('Entering:'||l_proc, 1);
2433: --

Line 2478: l_segment per_position_definitions.segment1%type;

2474: l_effective_date date;
2475: l_business_group_id per_all_positions.business_group_id%type;
2476: l_job_id per_jobs.job_id%type;
2477: l_segment_rec org_info_rec_type;
2478: l_segment per_position_definitions.segment1%type;
2479: l_asg_job_by_per_id_found boolean := FALSE;
2480: l_asg_job_by_asg_id_found boolean := FALSE;
2481: --
2482: begin

Line 2565: l_segment per_position_definitions.segment1%type;

2561: ) return varchar2 IS
2562: --
2563: l_proc varchar2(72) := g_package||'get_job_occ_series_job';
2564: l_segment_rec org_info_rec_type;
2565: l_segment per_position_definitions.segment1%type;
2566: --
2567: begin
2568: -- hr_utility.set_location('Entering:'||l_proc, 1);
2569: --