DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on STANDARD

Line 676: p_frequency - Standard Conditions PER field

672: DESCRIPTION
673: Validation to ensure that the normal working hours do not exceed
674: the maximum availble for the Frequency.
675: PARAMETERS
676: p_frequency - Standard Conditions PER field
677: - only D,W,M,Y are valid values
678: p_normal_hours - Standard Conditions WORKING HOURS field
679: */
680: PROCEDURE check_hours

Line 678: p_normal_hours - Standard Conditions WORKING HOURS field

674: the maximum availble for the Frequency.
675: PARAMETERS
676: p_frequency - Standard Conditions PER field
677: - only D,W,M,Y are valid values
678: p_normal_hours - Standard Conditions WORKING HOURS field
679: */
680: PROCEDURE check_hours
681: ( p_frequency IN VARCHAR2
682: , p_normal_hours IN NUMBER

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

4081: /*
4082: NAME
4083: call_terminate_entries
4084: DESCRIPTION
4085: This procedure determines the Actual Termination Date, Last Standard
4086: Processing Date and Final Process Date in order to terminate element
4087: entries and ALUs when an individual assignment is terminated or ended.
4088:
4089: There are several cases :-

Line 4126: p_last_standard_date DATE;

4122: ,P_START_DATE IN DATE
4123: ) IS
4124: --
4125: p_actual_term_date DATE;
4126: p_last_standard_date DATE;
4127: p_final_process_date DATE;
4128: --
4129: -- VT 10/08/96 bug #306710 new local variable
4130: l_entries_changed VARCHAR2(1) := 'N';

Line 4173: p_last_standard_date := NULL;

4169: --
4170: IF previous_term_exists(p_assignment_id
4171: ,p_start_date) THEN
4172: p_actual_term_date := NULL;
4173: p_last_standard_date := NULL;
4174: p_final_process_date := p_start_date;
4175: ELSE
4176: p_actual_term_date := p_start_date;
4177: p_last_standard_date := p_start_date;

Line 4177: p_last_standard_date := p_start_date;

4173: p_last_standard_date := NULL;
4174: p_final_process_date := p_start_date;
4175: ELSE
4176: p_actual_term_date := p_start_date;
4177: p_last_standard_date := p_start_date;
4178: p_final_process_date := p_start_date;
4179: END IF; -- IF previous_term_exists(....
4180: --
4181: hr_utility.set_location('peassign.call_terminate_entries',3);

Line 4185: ,p_last_standard_date

4181: hr_utility.set_location('peassign.call_terminate_entries',3);
4182: -- VT 10/08/96 bug #306710 added parameter
4183: hrempter.terminate_entries_and_alus(p_assignment_id
4184: ,p_actual_term_date
4185: ,p_last_standard_date
4186: ,p_final_process_date
4187: ,null
4188: ,l_entries_changed);
4189: --

Line 4197: p_last_standard_date := p_start_date -1;

4193: IF previous_term_exists(p_assignment_id
4194: ,p_start_date) THEN NULL;
4195: ELSE
4196: p_actual_term_date := p_start_date -1;
4197: p_last_standard_date := p_start_date -1;
4198: p_final_process_date := NULL;
4199: --
4200: hr_utility.set_location('peassign.call_terminate_entries',5);
4201: BEGIN

Line 4203: into p_last_standard_date

4199: --
4200: hr_utility.set_location('peassign.call_terminate_entries',5);
4201: BEGIN
4202: select tp.end_date
4203: into p_last_standard_date
4204: from per_assignments_f a
4205: , per_time_periods tp
4206: where a.assignment_id = p_assignment_id
4207: and a.effective_end_date = p_start_date - 1

Line 4218: ,p_last_standard_date

4214: hr_utility.set_location('peassign.call_terminate_entries',6);
4215: -- VT 10/08/96 bug #306710 added parameter
4216: hrempter.terminate_entries_and_alus(p_assignment_id
4217: ,p_actual_term_date
4218: ,p_last_standard_date
4219: ,p_final_process_date
4220: ,null
4221: ,l_entries_changed);
4222: --