DBA Data[Home] [Help]

APPS.GHR_HISTORY_CONV_RG dependencies on FND_DATE

Line 5122: p_history_data.information2 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_start_date);

5118: l_history_data :=p_history_data; --NOCOPY CHANGES
5119:
5120: hr_utility.set_location('entering:'|| l_proc, 5);
5121: p_history_data.information1 := p_position_data.position_id;
5122: p_history_data.information2 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_start_date);
5123: p_history_data.information3 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_end_date);
5124: p_history_data.information4 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_effective);
5125: p_history_data.information5 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_end);
5126: p_history_data.information6 := p_position_data.name;

Line 5123: p_history_data.information3 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_end_date);

5119:
5120: hr_utility.set_location('entering:'|| l_proc, 5);
5121: p_history_data.information1 := p_position_data.position_id;
5122: p_history_data.information2 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_start_date);
5123: p_history_data.information3 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_end_date);
5124: p_history_data.information4 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_effective);
5125: p_history_data.information5 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_end);
5126: p_history_data.information6 := p_position_data.name;
5127: p_history_data.information7 := p_position_data.relief_position_id;

Line 5124: p_history_data.information4 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_effective);

5120: hr_utility.set_location('entering:'|| l_proc, 5);
5121: p_history_data.information1 := p_position_data.position_id;
5122: p_history_data.information2 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_start_date);
5123: p_history_data.information3 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_end_date);
5124: p_history_data.information4 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_effective);
5125: p_history_data.information5 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_end);
5126: p_history_data.information6 := p_position_data.name;
5127: p_history_data.information7 := p_position_data.relief_position_id;
5128: p_history_data.information8 := p_position_data.location_id;

Line 5125: p_history_data.information5 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_end);

5121: p_history_data.information1 := p_position_data.position_id;
5122: p_history_data.information2 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_start_date);
5123: p_history_data.information3 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_end_date);
5124: p_history_data.information4 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_effective);
5125: p_history_data.information5 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_end);
5126: p_history_data.information6 := p_position_data.name;
5127: p_history_data.information7 := p_position_data.relief_position_id;
5128: p_history_data.information8 := p_position_data.location_id;
5129: p_history_data.information9 := p_position_data.position_definition_id;

Line 5140: p_history_data.information21 := FND_DATE.DATE_TO_CANONICAL(p_position_data.amendment_date);

5136: p_history_data.information17 := p_position_data.replacement_required_flag;
5137: p_history_data.information18 := p_position_data.time_normal_finish;
5138: p_history_data.information19 := p_position_data.time_normal_start;
5139: p_history_data.information20 := p_position_data.working_hours;
5140: p_history_data.information21 := FND_DATE.DATE_TO_CANONICAL(p_position_data.amendment_date);
5141: p_history_data.information22 := p_position_data.amendment_recommendation;
5142: p_history_data.information23 := p_position_data.amendment_ref_number;
5143: p_history_data.information24 := p_position_data.availability_status_id;
5144: p_history_data.information25 := FND_DATE.DATE_TO_CANONICAL(p_position_data.avail_status_prop_end_date);

Line 5144: p_history_data.information25 := FND_DATE.DATE_TO_CANONICAL(p_position_data.avail_status_prop_end_date);

5140: p_history_data.information21 := FND_DATE.DATE_TO_CANONICAL(p_position_data.amendment_date);
5141: p_history_data.information22 := p_position_data.amendment_recommendation;
5142: p_history_data.information23 := p_position_data.amendment_ref_number;
5143: p_history_data.information24 := p_position_data.availability_status_id;
5144: p_history_data.information25 := FND_DATE.DATE_TO_CANONICAL(p_position_data.avail_status_prop_end_date);
5145: p_history_data.information26 := p_position_data.bargaining_unit_cd;
5146: p_history_data.information27 := p_position_data.copied_to_old_table_flag;
5147: p_history_data.information28 := FND_DATE.DATE_TO_CANONICAL(p_position_data.earliest_hire_date);
5148: p_history_data.information29 := p_position_data.entry_grade_id;

Line 5147: p_history_data.information28 := FND_DATE.DATE_TO_CANONICAL(p_position_data.earliest_hire_date);

5143: p_history_data.information24 := p_position_data.availability_status_id;
5144: p_history_data.information25 := FND_DATE.DATE_TO_CANONICAL(p_position_data.avail_status_prop_end_date);
5145: p_history_data.information26 := p_position_data.bargaining_unit_cd;
5146: p_history_data.information27 := p_position_data.copied_to_old_table_flag;
5147: p_history_data.information28 := FND_DATE.DATE_TO_CANONICAL(p_position_data.earliest_hire_date);
5148: p_history_data.information29 := p_position_data.entry_grade_id;
5149: p_history_data.information30 := p_position_data.entry_grade_rule_id;
5150: p_history_data.information31 := p_position_data.entry_step_id;
5151: p_history_data.information32 := FND_DATE.DATE_TO_CANONICAL(p_position_data.fill_by_date);

Line 5151: p_history_data.information32 := FND_DATE.DATE_TO_CANONICAL(p_position_data.fill_by_date);

5147: p_history_data.information28 := FND_DATE.DATE_TO_CANONICAL(p_position_data.earliest_hire_date);
5148: p_history_data.information29 := p_position_data.entry_grade_id;
5149: p_history_data.information30 := p_position_data.entry_grade_rule_id;
5150: p_history_data.information31 := p_position_data.entry_step_id;
5151: p_history_data.information32 := FND_DATE.DATE_TO_CANONICAL(p_position_data.fill_by_date);
5152: p_history_data.information33 := p_position_data.fte;
5153: p_history_data.information34 := p_position_data.max_persons;
5154: p_history_data.information35 := p_position_data.overlap_period;
5155: p_history_data.information36 := p_position_data.overlap_unit_cd;

Line 5178: p_history_data.information59 := FND_DATE.DATE_TO_CANONICAL(p_position_data.current_job_prop_end_date);

5174: p_history_data.information55 := p_position_data.works_council_approval_flag;
5175: p_history_data.information56 := p_position_data.work_period_type_cd;
5176: p_history_data.information57 := p_position_data.work_term_end_day_cd;
5177: p_history_data.information58 := p_position_data.work_term_end_month_cd;
5178: p_history_data.information59 := FND_DATE.DATE_TO_CANONICAL(p_position_data.current_job_prop_end_date);
5179: p_history_data.information60 := FND_DATE.DATE_TO_CANONICAL(p_position_data.current_org_prop_end_date);
5180: p_history_data.information61 := FND_DATE.DATE_TO_CANONICAL(p_position_data.proposed_date_for_layoff);
5181: p_history_data.information62 := p_position_data.proposed_fte_for_layoff;
5182: p_history_data.information121 := p_position_data.status;

Line 5179: p_history_data.information60 := FND_DATE.DATE_TO_CANONICAL(p_position_data.current_org_prop_end_date);

5175: p_history_data.information56 := p_position_data.work_period_type_cd;
5176: p_history_data.information57 := p_position_data.work_term_end_day_cd;
5177: p_history_data.information58 := p_position_data.work_term_end_month_cd;
5178: p_history_data.information59 := FND_DATE.DATE_TO_CANONICAL(p_position_data.current_job_prop_end_date);
5179: p_history_data.information60 := FND_DATE.DATE_TO_CANONICAL(p_position_data.current_org_prop_end_date);
5180: p_history_data.information61 := FND_DATE.DATE_TO_CANONICAL(p_position_data.proposed_date_for_layoff);
5181: p_history_data.information62 := p_position_data.proposed_fte_for_layoff;
5182: p_history_data.information121 := p_position_data.status;
5183: p_history_data.information122 := p_position_data.business_group_id;

Line 5180: p_history_data.information61 := FND_DATE.DATE_TO_CANONICAL(p_position_data.proposed_date_for_layoff);

5176: p_history_data.information57 := p_position_data.work_term_end_day_cd;
5177: p_history_data.information58 := p_position_data.work_term_end_month_cd;
5178: p_history_data.information59 := FND_DATE.DATE_TO_CANONICAL(p_position_data.current_job_prop_end_date);
5179: p_history_data.information60 := FND_DATE.DATE_TO_CANONICAL(p_position_data.current_org_prop_end_date);
5180: p_history_data.information61 := FND_DATE.DATE_TO_CANONICAL(p_position_data.proposed_date_for_layoff);
5181: p_history_data.information62 := p_position_data.proposed_fte_for_layoff;
5182: p_history_data.information121 := p_position_data.status;
5183: p_history_data.information122 := p_position_data.business_group_id;
5184: p_history_data.information123 := p_position_data.request_id;

Line 5187: p_history_data.information126 := FND_DATE.DATE_TO_CANONICAL(p_position_data.program_update_date);

5183: p_history_data.information122 := p_position_data.business_group_id;
5184: p_history_data.information123 := p_position_data.request_id;
5185: p_history_data.information124 := p_position_data.program_application_id;
5186: p_history_data.information125 := p_position_data.program_id;
5187: p_history_data.information126 := FND_DATE.DATE_TO_CANONICAL(p_position_data.program_update_date);
5188: p_history_data.information127 := p_position_data.attribute_category;
5189: p_history_data.information128 := p_position_data.attribute1;
5190: p_history_data.information129 := p_position_data.attribute2;
5191: p_history_data.information130 := p_position_data.attribute3;

Line 5277: p_position_data.effective_start_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information2);

5273: l_position_data :=p_position_data; --NOCOPY Changes
5274: hr_utility.set_location('entering:'|| l_proc, 5);
5275:
5276: p_position_data.position_id := p_history_data.information1 ;
5277: p_position_data.effective_start_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information2);
5278: p_position_data.effective_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information3);
5279: p_position_data.date_effective := FND_DATE.CANONICAL_TO_DATE(p_history_data.information4);
5280: p_position_data.date_end := FND_DATE.CANONICAL_TO_DATE(p_history_data.information5);
5281: p_position_data.name := p_history_data.information6 ;

Line 5278: p_position_data.effective_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information3);

5274: hr_utility.set_location('entering:'|| l_proc, 5);
5275:
5276: p_position_data.position_id := p_history_data.information1 ;
5277: p_position_data.effective_start_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information2);
5278: p_position_data.effective_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information3);
5279: p_position_data.date_effective := FND_DATE.CANONICAL_TO_DATE(p_history_data.information4);
5280: p_position_data.date_end := FND_DATE.CANONICAL_TO_DATE(p_history_data.information5);
5281: p_position_data.name := p_history_data.information6 ;
5282: p_position_data.relief_position_id := p_history_data.information7 ;

Line 5279: p_position_data.date_effective := FND_DATE.CANONICAL_TO_DATE(p_history_data.information4);

5275:
5276: p_position_data.position_id := p_history_data.information1 ;
5277: p_position_data.effective_start_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information2);
5278: p_position_data.effective_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information3);
5279: p_position_data.date_effective := FND_DATE.CANONICAL_TO_DATE(p_history_data.information4);
5280: p_position_data.date_end := FND_DATE.CANONICAL_TO_DATE(p_history_data.information5);
5281: p_position_data.name := p_history_data.information6 ;
5282: p_position_data.relief_position_id := p_history_data.information7 ;
5283: p_position_data.location_id := p_history_data.information8 ;

Line 5280: p_position_data.date_end := FND_DATE.CANONICAL_TO_DATE(p_history_data.information5);

5276: p_position_data.position_id := p_history_data.information1 ;
5277: p_position_data.effective_start_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information2);
5278: p_position_data.effective_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information3);
5279: p_position_data.date_effective := FND_DATE.CANONICAL_TO_DATE(p_history_data.information4);
5280: p_position_data.date_end := FND_DATE.CANONICAL_TO_DATE(p_history_data.information5);
5281: p_position_data.name := p_history_data.information6 ;
5282: p_position_data.relief_position_id := p_history_data.information7 ;
5283: p_position_data.location_id := p_history_data.information8 ;
5284: p_position_data.position_definition_id := p_history_data.information9 ;

Line 5295: p_position_data.amendment_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information21);

5291: p_position_data.replacement_required_flag := p_history_data.information17 ;
5292: p_position_data.time_normal_finish := p_history_data.information18 ;
5293: p_position_data.time_normal_start := p_history_data.information19 ;
5294: p_position_data.working_hours := p_history_data.information20 ;
5295: p_position_data.amendment_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information21);
5296: p_position_data.amendment_recommendation := p_history_data.information22;
5297: p_position_data.amendment_ref_number := p_history_data.information23;
5298: p_position_data.availability_status_id := p_history_data.information24;
5299: p_position_data.avail_status_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information25);

Line 5299: p_position_data.avail_status_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information25);

5295: p_position_data.amendment_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information21);
5296: p_position_data.amendment_recommendation := p_history_data.information22;
5297: p_position_data.amendment_ref_number := p_history_data.information23;
5298: p_position_data.availability_status_id := p_history_data.information24;
5299: p_position_data.avail_status_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information25);
5300: p_position_data.bargaining_unit_cd := p_history_data.information26;
5301: p_position_data.copied_to_old_table_flag := p_history_data.information27;
5302: p_position_data.earliest_hire_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information28);
5303: p_position_data.entry_grade_id := p_history_data.information29;

Line 5302: p_position_data.earliest_hire_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information28);

5298: p_position_data.availability_status_id := p_history_data.information24;
5299: p_position_data.avail_status_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information25);
5300: p_position_data.bargaining_unit_cd := p_history_data.information26;
5301: p_position_data.copied_to_old_table_flag := p_history_data.information27;
5302: p_position_data.earliest_hire_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information28);
5303: p_position_data.entry_grade_id := p_history_data.information29;
5304: p_position_data.entry_grade_rule_id := p_history_data.information30;
5305: p_position_data.entry_step_id := p_history_data.information31;
5306: p_position_data.fill_by_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information32);

Line 5306: p_position_data.fill_by_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information32);

5302: p_position_data.earliest_hire_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information28);
5303: p_position_data.entry_grade_id := p_history_data.information29;
5304: p_position_data.entry_grade_rule_id := p_history_data.information30;
5305: p_position_data.entry_step_id := p_history_data.information31;
5306: p_position_data.fill_by_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information32);
5307: p_position_data.fte := p_history_data.information33;
5308: p_position_data.max_persons := p_history_data.information34;
5309: p_position_data.overlap_period := p_history_data.information35;
5310: p_position_data.overlap_unit_cd := p_history_data.information36;

Line 5333: p_position_data.current_job_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information59);

5329: p_position_data.works_council_approval_flag := p_history_data.information55;
5330: p_position_data.work_period_type_cd := p_history_data.information56;
5331: p_position_data.work_term_end_day_cd := p_history_data.information57;
5332: p_position_data.work_term_end_month_cd := p_history_data.information58;
5333: p_position_data.current_job_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information59);
5334: p_position_data.current_org_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information60);
5335: p_position_data.proposed_date_for_layoff := FND_DATE.CANONICAL_TO_DATE(p_history_data.information61);
5336: p_position_data.proposed_fte_for_layoff := p_history_data.information62;
5337: p_position_data.status := p_history_data.information121 ;

Line 5334: p_position_data.current_org_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information60);

5330: p_position_data.work_period_type_cd := p_history_data.information56;
5331: p_position_data.work_term_end_day_cd := p_history_data.information57;
5332: p_position_data.work_term_end_month_cd := p_history_data.information58;
5333: p_position_data.current_job_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information59);
5334: p_position_data.current_org_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information60);
5335: p_position_data.proposed_date_for_layoff := FND_DATE.CANONICAL_TO_DATE(p_history_data.information61);
5336: p_position_data.proposed_fte_for_layoff := p_history_data.information62;
5337: p_position_data.status := p_history_data.information121 ;
5338: p_position_data.business_group_id := p_history_data.information122 ;

Line 5335: p_position_data.proposed_date_for_layoff := FND_DATE.CANONICAL_TO_DATE(p_history_data.information61);

5331: p_position_data.work_term_end_day_cd := p_history_data.information57;
5332: p_position_data.work_term_end_month_cd := p_history_data.information58;
5333: p_position_data.current_job_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information59);
5334: p_position_data.current_org_prop_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information60);
5335: p_position_data.proposed_date_for_layoff := FND_DATE.CANONICAL_TO_DATE(p_history_data.information61);
5336: p_position_data.proposed_fte_for_layoff := p_history_data.information62;
5337: p_position_data.status := p_history_data.information121 ;
5338: p_position_data.business_group_id := p_history_data.information122 ;
5339: p_position_data.request_id := p_history_data.information123 ;

Line 5342: p_position_data.program_update_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information126);

5338: p_position_data.business_group_id := p_history_data.information122 ;
5339: p_position_data.request_id := p_history_data.information123 ;
5340: p_position_data.program_application_id := p_history_data.information124 ;
5341: p_position_data.program_id := p_history_data.information125 ;
5342: p_position_data.program_update_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information126);
5343: p_position_data.attribute_category := p_history_data.information127 ;
5344: p_position_data.attribute1 := p_history_data.information128 ;
5345: p_position_data.attribute2 := p_history_data.information129 ;
5346: p_position_data.attribute3 := p_history_data.information130 ;