DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on STANDARD

Line 646: p_frequency - Standard Conditions PER field

642: DESCRIPTION
643: Validation to ensure that the normal working hours do not exceed
644: the maximum availble for the Frequency.
645: PARAMETERS
646: p_frequency - Standard Conditions PER field
647: - only D,W,M,Y are valid values
648: p_normal_hours - Standard Conditions WORKING HOURS field
649: */
650: PROCEDURE check_hours

Line 648: p_normal_hours - Standard Conditions WORKING HOURS field

644: the maximum availble for the Frequency.
645: PARAMETERS
646: p_frequency - Standard Conditions PER field
647: - only D,W,M,Y are valid values
648: p_normal_hours - Standard Conditions WORKING HOURS field
649: */
650: PROCEDURE check_hours
651: ( p_frequency IN VARCHAR2
652: , p_normal_hours IN NUMBER

Line 4045: This procedure determines the Actual Termination Date, Last Standard

4041: /*
4042: NAME
4043: call_terminate_entries
4044: DESCRIPTION
4045: This procedure determines the Actual Termination Date, Last Standard
4046: Processing Date and Final Process Date in order to terminate element
4047: entries and ALUs when an individual assignment is terminated or ended.
4048:
4049: There are several cases :-

Line 4086: p_last_standard_date DATE;

4082: ,P_START_DATE IN DATE
4083: ) IS
4084: --
4085: p_actual_term_date DATE;
4086: p_last_standard_date DATE;
4087: p_final_process_date DATE;
4088: --
4089: -- VT 10/08/96 bug #306710 new local variable
4090: l_entries_changed VARCHAR2(1) := 'N';

Line 4133: p_last_standard_date := NULL;

4129: --
4130: IF previous_term_exists(p_assignment_id
4131: ,p_start_date) THEN
4132: p_actual_term_date := NULL;
4133: p_last_standard_date := NULL;
4134: p_final_process_date := p_start_date;
4135: ELSE
4136: p_actual_term_date := p_start_date;
4137: p_last_standard_date := p_start_date;

Line 4137: p_last_standard_date := p_start_date;

4133: p_last_standard_date := NULL;
4134: p_final_process_date := p_start_date;
4135: ELSE
4136: p_actual_term_date := p_start_date;
4137: p_last_standard_date := p_start_date;
4138: p_final_process_date := p_start_date;
4139: END IF; -- IF previous_term_exists(....
4140: --
4141: hr_utility.set_location('peassign.call_terminate_entries',3);

Line 4145: ,p_last_standard_date

4141: hr_utility.set_location('peassign.call_terminate_entries',3);
4142: -- VT 10/08/96 bug #306710 added parameter
4143: hrempter.terminate_entries_and_alus(p_assignment_id
4144: ,p_actual_term_date
4145: ,p_last_standard_date
4146: ,p_final_process_date
4147: ,null
4148: ,l_entries_changed);
4149: --

Line 4157: p_last_standard_date := p_start_date -1;

4153: IF previous_term_exists(p_assignment_id
4154: ,p_start_date) THEN NULL;
4155: ELSE
4156: p_actual_term_date := p_start_date -1;
4157: p_last_standard_date := p_start_date -1;
4158: p_final_process_date := NULL;
4159: --
4160: hr_utility.set_location('peassign.call_terminate_entries',5);
4161: BEGIN

Line 4163: into p_last_standard_date

4159: --
4160: hr_utility.set_location('peassign.call_terminate_entries',5);
4161: BEGIN
4162: select tp.end_date
4163: into p_last_standard_date
4164: from per_assignments_f a
4165: , per_time_periods tp
4166: where a.assignment_id = p_assignment_id
4167: and a.effective_end_date = p_start_date - 1

Line 4178: ,p_last_standard_date

4174: hr_utility.set_location('peassign.call_terminate_entries',6);
4175: -- VT 10/08/96 bug #306710 added parameter
4176: hrempter.terminate_entries_and_alus(p_assignment_id
4177: ,p_actual_term_date
4178: ,p_last_standard_date
4179: ,p_final_process_date
4180: ,null
4181: ,l_entries_changed);
4182: --