APPS.HR_PREVIOUS_EMPLOYMENT_API dependencies on PER_PREVIOUS_EMPLOYERS

Line 100: l_start_date per_previous_employers.start_date%TYPE;

96: --
97: l_flag varchar2(30);
98: l_proc varchar2(72) := g_package||'create_previous_employer';
99: --
100: l_start_date per_previous_employers.start_date%TYPE;
101: l_end_date per_previous_employers.end_date%TYPE;
102: --
103: l_previous_employer_id
104: per_previous_employers.previous_employer_id%type;

Line 101: l_end_date per_previous_employers.end_date%TYPE;

97: l_flag varchar2(30);
98: l_proc varchar2(72) := g_package||'create_previous_employer';
99: --
100: l_start_date per_previous_employers.start_date%TYPE;
101: l_end_date per_previous_employers.end_date%TYPE;
102: --
103: l_previous_employer_id
104: per_previous_employers.previous_employer_id%type;
105: l_object_version_number

Line 104: per_previous_employers.previous_employer_id%type;

100: l_start_date per_previous_employers.start_date%TYPE;
101: l_end_date per_previous_employers.end_date%TYPE;
102: --
103: l_previous_employer_id
104: per_previous_employers.previous_employer_id%type;
105: l_object_version_number
106: per_previous_employers.object_version_number%type;
107: l_period_years per_previous_employers.period_years%type
108: := p_period_years;

Line 106: per_previous_employers.object_version_number%type;

102: --
103: l_previous_employer_id
104: per_previous_employers.previous_employer_id%type;
105: l_object_version_number
106: per_previous_employers.object_version_number%type;
107: l_period_years per_previous_employers.period_years%type
108: := p_period_years;
109: l_period_months per_previous_employers.period_months%type
110: := p_period_months;

Line 107: l_period_years per_previous_employers.period_years%type

103: l_previous_employer_id
104: per_previous_employers.previous_employer_id%type;
105: l_object_version_number
106: per_previous_employers.object_version_number%type;
107: l_period_years per_previous_employers.period_years%type
108: := p_period_years;
109: l_period_months per_previous_employers.period_months%type
110: := p_period_months;
111: l_period_days per_previous_employers.period_days%type

Line 109: l_period_months per_previous_employers.period_months%type

105: l_object_version_number
106: per_previous_employers.object_version_number%type;
107: l_period_years per_previous_employers.period_years%type
108: := p_period_years;
109: l_period_months per_previous_employers.period_months%type
110: := p_period_months;
111: l_period_days per_previous_employers.period_days%type
112: := p_period_days;
113: l_employer_type per_previous_employers.employer_type%type

Line 111: l_period_days per_previous_employers.period_days%type

107: l_period_years per_previous_employers.period_years%type
108: := p_period_years;
109: l_period_months per_previous_employers.period_months%type
110: := p_period_months;
111: l_period_days per_previous_employers.period_days%type
112: := p_period_days;
113: l_employer_type per_previous_employers.employer_type%type
114: := p_employer_type;
115: l_employer_subtype per_previous_employers.employer_subtype%type;

Line 113: l_employer_type per_previous_employers.employer_type%type

109: l_period_months per_previous_employers.period_months%type
110: := p_period_months;
111: l_period_days per_previous_employers.period_days%type
112: := p_period_days;
113: l_employer_type per_previous_employers.employer_type%type
114: := p_employer_type;
115: l_employer_subtype per_previous_employers.employer_subtype%type;
116: l_all_assignments per_previous_employers.all_assignments%type
117: := p_all_assignments;

Line 115: l_employer_subtype per_previous_employers.employer_subtype%type;

111: l_period_days per_previous_employers.period_days%type
112: := p_period_days;
113: l_employer_type per_previous_employers.employer_type%type
114: := p_employer_type;
115: l_employer_subtype per_previous_employers.employer_subtype%type;
116: l_all_assignments per_previous_employers.all_assignments%type
117: := p_all_assignments;
118: begin
119: hr_utility.set_location('Entering:'||l_proc, 10);

Line 116: l_all_assignments per_previous_employers.all_assignments%type

112: := p_period_days;
113: l_employer_type per_previous_employers.employer_type%type
114: := p_employer_type;
115: l_employer_subtype per_previous_employers.employer_subtype%type;
116: l_all_assignments per_previous_employers.all_assignments%type
117: := p_all_assignments;
118: begin
119: hr_utility.set_location('Entering:'||l_proc, 10);
120: --

Line 548: per_previous_employers.previous_employer_id%type;

544: ) is
545: l_proc varchar2(72)
546: := g_package||'update_previous_employer';
547: l_previous_employer_id
548: per_previous_employers.previous_employer_id%type;
549: l_object_version_number
550: per_previous_employers.object_version_number%type
551: := p_object_version_number;
552: l_ovn per_previous_employers.object_version_number%type := p_object_version_number;

Line 550: per_previous_employers.object_version_number%type

546: := g_package||'update_previous_employer';
547: l_previous_employer_id
548: per_previous_employers.previous_employer_id%type;
549: l_object_version_number
550: per_previous_employers.object_version_number%type
551: := p_object_version_number;
552: l_ovn per_previous_employers.object_version_number%type := p_object_version_number;
553: l_business_group_id per_previous_employers.business_group_id%type;
554: --

Line 552: l_ovn per_previous_employers.object_version_number%type := p_object_version_number;

548: per_previous_employers.previous_employer_id%type;
549: l_object_version_number
550: per_previous_employers.object_version_number%type
551: := p_object_version_number;
552: l_ovn per_previous_employers.object_version_number%type := p_object_version_number;
553: l_business_group_id per_previous_employers.business_group_id%type;
554: --
555: l_start_date per_previous_employers.start_date%type;
556: l_end_date per_previous_employers.end_date%type;

Line 553: l_business_group_id per_previous_employers.business_group_id%type;

549: l_object_version_number
550: per_previous_employers.object_version_number%type
551: := p_object_version_number;
552: l_ovn per_previous_employers.object_version_number%type := p_object_version_number;
553: l_business_group_id per_previous_employers.business_group_id%type;
554: --
555: l_start_date per_previous_employers.start_date%type;
556: l_end_date per_previous_employers.end_date%type;
557: --

Line 555: l_start_date per_previous_employers.start_date%type;

551: := p_object_version_number;
552: l_ovn per_previous_employers.object_version_number%type := p_object_version_number;
553: l_business_group_id per_previous_employers.business_group_id%type;
554: --
555: l_start_date per_previous_employers.start_date%type;
556: l_end_date per_previous_employers.end_date%type;
557: --
558: -- Bug 3702553: changed datatype from %type to number(10).
559: --

Line 556: l_end_date per_previous_employers.end_date%type;

552: l_ovn per_previous_employers.object_version_number%type := p_object_version_number;
553: l_business_group_id per_previous_employers.business_group_id%type;
554: --
555: l_start_date per_previous_employers.start_date%type;
556: l_end_date per_previous_employers.end_date%type;
557: --
558: -- Bug 3702553: changed datatype from %type to number(10).
559: --
560: l_period_years number(10)

Line 566: l_employer_type per_previous_employers.employer_type%type

562: l_period_months number(10)
563: := p_period_months;
564: l_period_days number(10)
565: := p_period_days;
566: l_employer_type per_previous_employers.employer_type%type
567: := p_employer_type;
568: l_employer_subtype per_previous_employers.employer_subtype%type;
569: l_all_assignments per_previous_employers.all_assignments%type
570: := p_all_assignments;

Line 568: l_employer_subtype per_previous_employers.employer_subtype%type;

564: l_period_days number(10)
565: := p_period_days;
566: l_employer_type per_previous_employers.employer_type%type
567: := p_employer_type;
568: l_employer_subtype per_previous_employers.employer_subtype%type;
569: l_all_assignments per_previous_employers.all_assignments%type
570: := p_all_assignments;
571: begin
572: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 569: l_all_assignments per_previous_employers.all_assignments%type

565: := p_period_days;
566: l_employer_type per_previous_employers.employer_type%type
567: := p_employer_type;
568: l_employer_subtype per_previous_employers.employer_subtype%type;
569: l_all_assignments per_previous_employers.all_assignments%type
570: := p_all_assignments;
571: begin
572: hr_utility.set_location('Entering:'|| l_proc, 10);
573: --

Line 917: l_previous_employer_id per_previous_employers.previous_employer_id%TYPE;

913: )
914: is
915: l_proc varchar2(72)
916: := g_package||'delete_previous_employer';
917: l_previous_employer_id per_previous_employers.previous_employer_id%TYPE;
918: l_object_version_number per_previous_employers.object_version_number%TYPE
919: := p_object_version_number;
920: l_ovn per_previous_employers.object_version_number%TYPE := p_object_version_number;
921: --

Line 918: l_object_version_number per_previous_employers.object_version_number%TYPE

914: is
915: l_proc varchar2(72)
916: := g_package||'delete_previous_employer';
917: l_previous_employer_id per_previous_employers.previous_employer_id%TYPE;
918: l_object_version_number per_previous_employers.object_version_number%TYPE
919: := p_object_version_number;
920: l_ovn per_previous_employers.object_version_number%TYPE := p_object_version_number;
921: --
922: -- Define cursor to select all the previous jobs of a

Line 920: l_ovn per_previous_employers.object_version_number%TYPE := p_object_version_number;

916: := g_package||'delete_previous_employer';
917: l_previous_employer_id per_previous_employers.previous_employer_id%TYPE;
918: l_object_version_number per_previous_employers.object_version_number%TYPE
919: := p_object_version_number;
920: l_ovn per_previous_employers.object_version_number%TYPE := p_object_version_number;
921: --
922: -- Define cursor to select all the previous jobs of a
923: -- perticular employer
924: --

Line 1144: l_period_years per_previous_employers.period_years%type;

1140: --
1141: l_previous_job_id per_previous_jobs.previous_job_id%type;
1142: l_object_version_number per_previous_jobs.object_version_number%type;
1143: --
1144: l_period_years per_previous_employers.period_years%type;
1145: l_period_months per_previous_employers.period_months%type;
1146: l_period_days per_previous_employers.period_days%type;
1147: --
1148: l_all_assignments per_previous_jobs.all_assignments%type;

Line 1145: l_period_months per_previous_employers.period_months%type;

1141: l_previous_job_id per_previous_jobs.previous_job_id%type;
1142: l_object_version_number per_previous_jobs.object_version_number%type;
1143: --
1144: l_period_years per_previous_employers.period_years%type;
1145: l_period_months per_previous_employers.period_months%type;
1146: l_period_days per_previous_employers.period_days%type;
1147: --
1148: l_all_assignments per_previous_jobs.all_assignments%type;
1149: begin

Line 1146: l_period_days per_previous_employers.period_days%type;

1142: l_object_version_number per_previous_jobs.object_version_number%type;
1143: --
1144: l_period_years per_previous_employers.period_years%type;
1145: l_period_months per_previous_employers.period_months%type;
1146: l_period_days per_previous_employers.period_days%type;
1147: --
1148: l_all_assignments per_previous_jobs.all_assignments%type;
1149: begin
1150: hr_utility.set_location('Entering:'||l_proc, 10);

Line 1561: l_business_group_id per_previous_employers.business_group_id%type;

1557: l_previous_employer_id per_previous_jobs.previous_employer_id%type;
1558: l_object_version_number per_previous_jobs.object_version_number%type
1559: := p_object_version_number;
1560: l_ovn per_previous_jobs.object_version_number%type := p_object_version_number;
1561: l_business_group_id per_previous_employers.business_group_id%type;
1562: --
1563: l_start_date per_previous_jobs.start_date%type;
1564: l_end_date per_previous_jobs.end_date%type;
1565: --