APPS.HR_PROCESS_SIT_SS dependencies on PER_ANALYSIS_CRITERIA

Line 620: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;

616: -- Declare cursors and local variables
617: --
618: l_proc varchar2(72) := g_package||'insert_sit';
619: l_analysis_criteria_id number;
620: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
621: l_error_message long default null;
622: --
623: begin
624: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 759: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;

755: --
756: --
757: l_proc varchar2(72) := g_package||'update_sit';
758: l_analysis_criteria_id number;
759: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
760: l_error_message long default null;
761: --
762: begin
763: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 919: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;

915: l_id_flex_num number;
916: l_structure_code varchar2(30);
917: l_structure_name varchar2(30);
918: l_action varchar2(100);
919: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
920: l_error_message long default null;
921: l_attribute_category PER_PERSON_ANALYSES.attribute_category%type;
922: l_attribute1 PER_PERSON_ANALYSES.attribute1%type;
923: l_attribute2 PER_PERSON_ANALYSES.attribute2%type;

Line 1191: RETURN per_analysis_criteria_rec IS

1187: -- |----------------------< get_segments_from_ccid >--------------------------|
1188: -- ----------------------------------------------------------------------------
1189:
1190: FUNCTION get_segments_from_ccid(p_analysis_criteria_id IN NUMBER)
1191: RETURN per_analysis_criteria_rec IS
1192:
1193: cursor csr_criteria_segments is
1194: select *
1195: from per_analysis_criteria

Line 1195: from per_analysis_criteria

1191: RETURN per_analysis_criteria_rec IS
1192:
1193: cursor csr_criteria_segments is
1194: select *
1195: from per_analysis_criteria
1196: where analysis_criteria_id = p_analysis_criteria_id;
1197:
1198:
1199: l_criteria_segments csr_criteria_segments%ROWTYPE;

Line 1200: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;

1196: where analysis_criteria_id = p_analysis_criteria_id;
1197:
1198:
1199: l_criteria_segments csr_criteria_segments%ROWTYPE;
1200: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
1201: l_proc varchar2(72) := g_package||'get_segments_from_ccid';
1202:
1203: BEGIN
1204: