eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PREVIOUS_EMPLOYMENT_API dependencies on PER_PREVIOUS_JOBS

Line 928: from per_previous_jobs

924: --
925: cursor csr_previous_jobs(t_previous_employer_id number) is
926: select previous_job_id
927: ,object_version_number
928: from per_previous_jobs
929: where previous_employer_id = t_previous_employer_id;
930: --
931: cursor csr_previous_job_usages(t_previous_employer_id number) is
932: select previous_job_usage_id

Line 962: -- Impliment Cascading delete on per_previous_jobs table

958: );
959: end;
960: --
961: -- Process Logic
962: -- Impliment Cascading delete on per_previous_jobs table
963: -- when a previous_employer is deleted
964: for pjo in csr_previous_jobs(p_previous_employer_id) loop
965: hr_previous_employment_api.delete_previous_job
966: (p_validate => false

Line 1138: l_start_date per_previous_jobs.start_date%type;

1134: l_flag varchar2(30);
1135: l_proc varchar2(72)
1136: := g_package||'create_previous_job';
1137: --
1138: l_start_date per_previous_jobs.start_date%type;
1139: l_end_date per_previous_jobs.end_date%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;

Line 1139: l_end_date per_previous_jobs.end_date%type;

1135: l_proc varchar2(72)
1136: := g_package||'create_previous_job';
1137: --
1138: l_start_date per_previous_jobs.start_date%type;
1139: l_end_date per_previous_jobs.end_date%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: --

Line 1141: l_previous_job_id per_previous_jobs.previous_job_id%type;

1137: --
1138: l_start_date per_previous_jobs.start_date%type;
1139: l_end_date per_previous_jobs.end_date%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;

Line 1142: l_object_version_number per_previous_jobs.object_version_number%type;

1138: l_start_date per_previous_jobs.start_date%type;
1139: l_end_date per_previous_jobs.end_date%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;

Line 1148: l_all_assignments per_previous_jobs.all_assignments%type;

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);
1151: --
1152: -- Issue a savepoint

Line 1557: l_previous_employer_id per_previous_jobs.previous_employer_id%type;

1553: ,p_object_version_number in out nocopy number
1554: ) is
1555: l_proc varchar2(72)
1556: := g_package||'update_previous_job';
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;

Line 1558: l_object_version_number per_previous_jobs.object_version_number%type

1554: ) is
1555: l_proc varchar2(72)
1556: := g_package||'update_previous_job';
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: --

Line 1560: l_ovn per_previous_jobs.object_version_number%type := p_object_version_number;

1556: := g_package||'update_previous_job';
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;

Line 1563: l_start_date per_previous_jobs.start_date%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: --
1566: l_period_years Number(10); --per_previous_jobs.period_years%type;
1567: l_period_months Number(10); --per_previous_jobs.period_months%type;

Line 1564: l_end_date per_previous_jobs.end_date%type;

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: --
1566: l_period_years Number(10); --per_previous_jobs.period_years%type;
1567: l_period_months Number(10); --per_previous_jobs.period_months%type;
1568: l_period_days Number(10); --per_previous_jobs.period_days%type;

Line 1566: l_period_years Number(10); --per_previous_jobs.period_years%type;

1562: --
1563: l_start_date per_previous_jobs.start_date%type;
1564: l_end_date per_previous_jobs.end_date%type;
1565: --
1566: l_period_years Number(10); --per_previous_jobs.period_years%type;
1567: l_period_months Number(10); --per_previous_jobs.period_months%type;
1568: l_period_days Number(10); --per_previous_jobs.period_days%type;
1569: --
1570: l_all_assignments per_previous_jobs.all_assignments%type;

Line 1567: l_period_months Number(10); --per_previous_jobs.period_months%type;

1563: l_start_date per_previous_jobs.start_date%type;
1564: l_end_date per_previous_jobs.end_date%type;
1565: --
1566: l_period_years Number(10); --per_previous_jobs.period_years%type;
1567: l_period_months Number(10); --per_previous_jobs.period_months%type;
1568: l_period_days Number(10); --per_previous_jobs.period_days%type;
1569: --
1570: l_all_assignments per_previous_jobs.all_assignments%type;
1571: begin

Line 1568: l_period_days Number(10); --per_previous_jobs.period_days%type;

1564: l_end_date per_previous_jobs.end_date%type;
1565: --
1566: l_period_years Number(10); --per_previous_jobs.period_years%type;
1567: l_period_months Number(10); --per_previous_jobs.period_months%type;
1568: l_period_days Number(10); --per_previous_jobs.period_days%type;
1569: --
1570: l_all_assignments per_previous_jobs.all_assignments%type;
1571: begin
1572: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1570: l_all_assignments per_previous_jobs.all_assignments%type;

1566: l_period_years Number(10); --per_previous_jobs.period_years%type;
1567: l_period_months Number(10); --per_previous_jobs.period_months%type;
1568: l_period_days Number(10); --per_previous_jobs.period_days%type;
1569: --
1570: l_all_assignments per_previous_jobs.all_assignments%type;
1571: begin
1572: hr_utility.set_location('Entering:'|| l_proc, 10);
1573: --
1574: -- Issue a savepoint

Line 1899: l_previous_employer_id per_previous_jobs.previous_employer_id%type;

1895: ,p_object_version_number in out nocopy number
1896: ) is
1897: l_proc varchar2(72)
1898: := g_package||'delete_previous_job';
1899: l_previous_employer_id per_previous_jobs.previous_employer_id%type;
1900: l_object_version_number per_previous_jobs.object_version_number%type
1901: := p_object_version_number;
1902: l_ovn per_previous_jobs.object_version_number%type := p_object_version_number;
1903: --

Line 1900: l_object_version_number per_previous_jobs.object_version_number%type

1896: ) is
1897: l_proc varchar2(72)
1898: := g_package||'delete_previous_job';
1899: l_previous_employer_id per_previous_jobs.previous_employer_id%type;
1900: l_object_version_number per_previous_jobs.object_version_number%type
1901: := p_object_version_number;
1902: l_ovn per_previous_jobs.object_version_number%type := p_object_version_number;
1903: --
1904: -- Cursor for all the records in previous job usages

Line 1902: l_ovn per_previous_jobs.object_version_number%type := p_object_version_number;

1898: := g_package||'delete_previous_job';
1899: l_previous_employer_id per_previous_jobs.previous_employer_id%type;
1900: l_object_version_number per_previous_jobs.object_version_number%type
1901: := p_object_version_number;
1902: l_ovn per_previous_jobs.object_version_number%type := p_object_version_number;
1903: --
1904: -- Cursor for all the records in previous job usages
1905: cursor csr_pju is
1906: select previous_job_usage_id