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.HR_SIT_API dependencies on PER_PERSON_ANALYSES

Line 85: l_analysis_criteria_id per_person_analyses.analysis_criteria_id%TYPE := p_analysis_criteria_id;

81: --
82: -- Declare cursors and local variables
83: --
84: l_proc varchar2(72) := g_package||'create_sit';
85: l_analysis_criteria_id per_person_analyses.analysis_criteria_id%TYPE := p_analysis_criteria_id;
86: l_person_analysis_id per_person_analyses.person_analysis_id%TYPE;
87: l_discard number;
88: l_name varchar2(700);
89: l_effective_date date;

Line 86: l_person_analysis_id per_person_analyses.person_analysis_id%TYPE;

82: -- Declare cursors and local variables
83: --
84: l_proc varchar2(72) := g_package||'create_sit';
85: l_analysis_criteria_id per_person_analyses.analysis_criteria_id%TYPE := p_analysis_criteria_id;
86: l_person_analysis_id per_person_analyses.person_analysis_id%TYPE;
87: l_discard number;
88: l_name varchar2(700);
89: l_effective_date date;
90: l_object_version_number per_person_analyses.object_version_number%TYPE;

Line 90: l_object_version_number per_person_analyses.object_version_number%TYPE;

86: l_person_analysis_id per_person_analyses.person_analysis_id%TYPE;
87: l_discard number;
88: l_name varchar2(700);
89: l_effective_date date;
90: l_object_version_number per_person_analyses.object_version_number%TYPE;
91: l_date_from per_person_analyses.date_from%TYPE;
92: l_date_to per_person_analyses.date_to%TYPE;
93: l_program_update_date per_person_analyses.program_update_date%TYPE;
94: l_segment1 varchar2(150) := p_segment1;

Line 91: l_date_from per_person_analyses.date_from%TYPE;

87: l_discard number;
88: l_name varchar2(700);
89: l_effective_date date;
90: l_object_version_number per_person_analyses.object_version_number%TYPE;
91: l_date_from per_person_analyses.date_from%TYPE;
92: l_date_to per_person_analyses.date_to%TYPE;
93: l_program_update_date per_person_analyses.program_update_date%TYPE;
94: l_segment1 varchar2(150) := p_segment1;
95: l_segment2 varchar2(150) := p_segment2;

Line 92: l_date_to per_person_analyses.date_to%TYPE;

88: l_name varchar2(700);
89: l_effective_date date;
90: l_object_version_number per_person_analyses.object_version_number%TYPE;
91: l_date_from per_person_analyses.date_from%TYPE;
92: l_date_to per_person_analyses.date_to%TYPE;
93: l_program_update_date per_person_analyses.program_update_date%TYPE;
94: l_segment1 varchar2(150) := p_segment1;
95: l_segment2 varchar2(150) := p_segment2;
96: l_segment3 varchar2(150) := p_segment3;

Line 93: l_program_update_date per_person_analyses.program_update_date%TYPE;

89: l_effective_date date;
90: l_object_version_number per_person_analyses.object_version_number%TYPE;
91: l_date_from per_person_analyses.date_from%TYPE;
92: l_date_to per_person_analyses.date_to%TYPE;
93: l_program_update_date per_person_analyses.program_update_date%TYPE;
94: l_segment1 varchar2(150) := p_segment1;
95: l_segment2 varchar2(150) := p_segment2;
96: l_segment3 varchar2(150) := p_segment3;
97: l_segment4 varchar2(150) := p_segment4;

Line 454: -- insert person_analyses into PER_PERSON_ANALYSES

450: --
451: if l_analysis_criteria_id is not null
452: then
453: --
454: -- insert person_analyses into PER_PERSON_ANALYSES
455: per_pea_ins.ins
456: (p_business_group_id => p_business_group_id
457: ,p_analysis_criteria_id => l_analysis_criteria_id
458: ,p_person_id => p_person_id

Line 709: l_analysis_criteria_id per_person_analyses.analysis_criteria_id%TYPE := p_analysis_criteria_id;

705: ) is
706: --
707: --
708: l_proc varchar2(72) := g_package||'update_sit';
709: l_analysis_criteria_id per_person_analyses.analysis_criteria_id%TYPE := p_analysis_criteria_id;
710: l_object_version_number per_person_analyses.object_version_number%TYPE;
711: l_pea_object_version_number per_person_analyses.object_version_number%TYPE := p_pea_object_version_number;
712: l_id_flex_num per_person_analyses.id_flex_num%TYPE;
713: l_name varchar2(700);

Line 710: l_object_version_number per_person_analyses.object_version_number%TYPE;

706: --
707: --
708: l_proc varchar2(72) := g_package||'update_sit';
709: l_analysis_criteria_id per_person_analyses.analysis_criteria_id%TYPE := p_analysis_criteria_id;
710: l_object_version_number per_person_analyses.object_version_number%TYPE;
711: l_pea_object_version_number per_person_analyses.object_version_number%TYPE := p_pea_object_version_number;
712: l_id_flex_num per_person_analyses.id_flex_num%TYPE;
713: l_name varchar2(700);
714: l_business_group_id per_person_analyses.business_group_id%TYPE;

Line 711: l_pea_object_version_number per_person_analyses.object_version_number%TYPE := p_pea_object_version_number;

707: --
708: l_proc varchar2(72) := g_package||'update_sit';
709: l_analysis_criteria_id per_person_analyses.analysis_criteria_id%TYPE := p_analysis_criteria_id;
710: l_object_version_number per_person_analyses.object_version_number%TYPE;
711: l_pea_object_version_number per_person_analyses.object_version_number%TYPE := p_pea_object_version_number;
712: l_id_flex_num per_person_analyses.id_flex_num%TYPE;
713: l_name varchar2(700);
714: l_business_group_id per_person_analyses.business_group_id%TYPE;
715: l_api_updating boolean;

Line 712: l_id_flex_num per_person_analyses.id_flex_num%TYPE;

708: l_proc varchar2(72) := g_package||'update_sit';
709: l_analysis_criteria_id per_person_analyses.analysis_criteria_id%TYPE := p_analysis_criteria_id;
710: l_object_version_number per_person_analyses.object_version_number%TYPE;
711: l_pea_object_version_number per_person_analyses.object_version_number%TYPE := p_pea_object_version_number;
712: l_id_flex_num per_person_analyses.id_flex_num%TYPE;
713: l_name varchar2(700);
714: l_business_group_id per_person_analyses.business_group_id%TYPE;
715: l_api_updating boolean;
716: l_date_from per_person_analyses.date_from%TYPE;

Line 714: l_business_group_id per_person_analyses.business_group_id%TYPE;

710: l_object_version_number per_person_analyses.object_version_number%TYPE;
711: l_pea_object_version_number per_person_analyses.object_version_number%TYPE := p_pea_object_version_number;
712: l_id_flex_num per_person_analyses.id_flex_num%TYPE;
713: l_name varchar2(700);
714: l_business_group_id per_person_analyses.business_group_id%TYPE;
715: l_api_updating boolean;
716: l_date_from per_person_analyses.date_from%TYPE;
717: l_date_to per_person_analyses.date_to%TYPE;
718: l_program_update_date per_person_analyses.program_update_date%TYPE;

Line 716: l_date_from per_person_analyses.date_from%TYPE;

712: l_id_flex_num per_person_analyses.id_flex_num%TYPE;
713: l_name varchar2(700);
714: l_business_group_id per_person_analyses.business_group_id%TYPE;
715: l_api_updating boolean;
716: l_date_from per_person_analyses.date_from%TYPE;
717: l_date_to per_person_analyses.date_to%TYPE;
718: l_program_update_date per_person_analyses.program_update_date%TYPE;
719: l_segment1 varchar2(150) := p_segment1;
720: l_segment2 varchar2(150) := p_segment2;

Line 717: l_date_to per_person_analyses.date_to%TYPE;

713: l_name varchar2(700);
714: l_business_group_id per_person_analyses.business_group_id%TYPE;
715: l_api_updating boolean;
716: l_date_from per_person_analyses.date_from%TYPE;
717: l_date_to per_person_analyses.date_to%TYPE;
718: l_program_update_date per_person_analyses.program_update_date%TYPE;
719: l_segment1 varchar2(150) := p_segment1;
720: l_segment2 varchar2(150) := p_segment2;
721: l_segment3 varchar2(150) := p_segment3;

Line 718: l_program_update_date per_person_analyses.program_update_date%TYPE;

714: l_business_group_id per_person_analyses.business_group_id%TYPE;
715: l_api_updating boolean;
716: l_date_from per_person_analyses.date_from%TYPE;
717: l_date_to per_person_analyses.date_to%TYPE;
718: l_program_update_date per_person_analyses.program_update_date%TYPE;
719: l_segment1 varchar2(150) := p_segment1;
720: l_segment2 varchar2(150) := p_segment2;
721: l_segment3 varchar2(150) := p_segment3;
722: l_segment4 varchar2(150) := p_segment4;

Line 796: from per_person_analyses

792: -- Cursor to select the id_flex_num required for the keyflex utility.
793: --
794: cursor c2 is
795: select id_flex_num
796: from per_person_analyses
797: where person_analysis_id = p_person_analysis_id;
798: --
799: --
800: begin

Line 1021: -- update person_analyses into PER_PERSON_ANALYSES

1017: END IF;
1018: --
1019: hr_utility.set_location(l_proc, 80);
1020: --
1021: -- update person_analyses into PER_PERSON_ANALYSES
1022: --
1023: per_pea_upd.upd
1024: (p_person_analysis_id => p_person_analysis_id
1025: ,p_analysis_criteria_id => l_analysis_criteria_id

Line 1201: -- information type record from the table PER_PERSON_ANALYSES. Note

1197: -- {Start Of Comments}
1198: --
1199: -- Description:
1200: -- This Special Information type business process deletes a special
1201: -- information type record from the table PER_PERSON_ANALYSES. Note
1202: -- it does not alter the key flex codes combination table
1203: -- PER_ANALYSIS_CRITERIA, since a single code combination could
1204: -- be used by more than one special information type record on
1205: -- PER_PERSON_ANALYSES

Line 1205: -- PER_PERSON_ANALYSES

1201: -- information type record from the table PER_PERSON_ANALYSES. Note
1202: -- it does not alter the key flex codes combination table
1203: -- PER_ANALYSIS_CRITERIA, since a single code combination could
1204: -- be used by more than one special information type record on
1205: -- PER_PERSON_ANALYSES
1206: --
1207: -- Prerequisites:
1208: -- The SIT specified by p_person_analysis_id and p_object_version_number
1209: -- must exist.

Line 1217: -- p_person_analysis_id Y number ID of PER_PERSON_ANALYSES

1213: -- p_validate N boolean If true, the database
1214: -- remains unchanged. If false
1215: -- then the employee will be
1216: -- deleted from the database.
1217: -- p_person_analysis_id Y number ID of PER_PERSON_ANALYSES
1218: -- record for delete.
1219: -- p_pea_object_version_number Y number Version number of the PPA
1220: -- record
1221:

Line 1223: -- The API deletes the SIT record in PER_PERSON_ANALYSES, but leaves

1219: -- p_pea_object_version_number Y number Version number of the PPA
1220: -- record
1221:
1222: -- Post Success:
1223: -- The API deletes the SIT record in PER_PERSON_ANALYSES, but leaves
1224: -- the code combination unchanged.
1225: --
1226: -- Post Failure:
1227: -- The API does not delete the special infomration type record and raises