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_JOB_USAGES

Line 934: from per_previous_job_usages

930: --
931: cursor csr_previous_job_usages(t_previous_employer_id number) is
932: select previous_job_usage_id
933: ,object_version_number
934: from per_previous_job_usages
935: where previous_employer_id = t_previous_employer_id;
936: --
937: begin
938: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 974: -- Impliment cascading delete on per_previous_job_usages table

970: end loop;
971: -- End of logic to cascade delete all the previous jobs of a perticular
972: -- previous employer
973: --
974: -- Impliment cascading delete on per_previous_job_usages table
975: -- when a previous employer_id is deleted
976: for pju in csr_previous_job_usages(p_previous_employer_id) loop
977: hr_previous_employment_api.delete_previous_job_usage
978: (p_validate => false

Line 1908: from per_previous_job_usages

1904: -- Cursor for all the records in previous job usages
1905: cursor csr_pju is
1906: select previous_job_usage_id
1907: ,object_version_number
1908: from per_previous_job_usages
1909: where previous_job_id = p_previous_job_id;
1910: -- Cursor for all the records in previous job extra info
1911: cursor csr_pji is
1912: select previous_job_extra_info_id

Line 2897: l_start_date per_previous_job_usages.start_date%type;

2893: --
2894: -- Declare cursors and local variables
2895: --
2896: l_flag varchar2(30);
2897: l_start_date per_previous_job_usages.start_date%type;
2898: l_end_date per_previous_job_usages.end_date%type;
2899: l_period_years per_previous_job_usages.period_years%type;
2900: l_period_months per_previous_job_usages.period_months%type;
2901: l_period_days per_previous_job_usages.period_days%type;

Line 2898: l_end_date per_previous_job_usages.end_date%type;

2894: -- Declare cursors and local variables
2895: --
2896: l_flag varchar2(30);
2897: l_start_date per_previous_job_usages.start_date%type;
2898: l_end_date per_previous_job_usages.end_date%type;
2899: l_period_years per_previous_job_usages.period_years%type;
2900: l_period_months per_previous_job_usages.period_months%type;
2901: l_period_days per_previous_job_usages.period_days%type;
2902: l_previous_job_usage_id

Line 2899: l_period_years per_previous_job_usages.period_years%type;

2895: --
2896: l_flag varchar2(30);
2897: l_start_date per_previous_job_usages.start_date%type;
2898: l_end_date per_previous_job_usages.end_date%type;
2899: l_period_years per_previous_job_usages.period_years%type;
2900: l_period_months per_previous_job_usages.period_months%type;
2901: l_period_days per_previous_job_usages.period_days%type;
2902: l_previous_job_usage_id
2903: per_previous_job_usages.previous_job_usage_id%type;

Line 2900: l_period_months per_previous_job_usages.period_months%type;

2896: l_flag varchar2(30);
2897: l_start_date per_previous_job_usages.start_date%type;
2898: l_end_date per_previous_job_usages.end_date%type;
2899: l_period_years per_previous_job_usages.period_years%type;
2900: l_period_months per_previous_job_usages.period_months%type;
2901: l_period_days per_previous_job_usages.period_days%type;
2902: l_previous_job_usage_id
2903: per_previous_job_usages.previous_job_usage_id%type;
2904: l_object_version_number

Line 2901: l_period_days per_previous_job_usages.period_days%type;

2897: l_start_date per_previous_job_usages.start_date%type;
2898: l_end_date per_previous_job_usages.end_date%type;
2899: l_period_years per_previous_job_usages.period_years%type;
2900: l_period_months per_previous_job_usages.period_months%type;
2901: l_period_days per_previous_job_usages.period_days%type;
2902: l_previous_job_usage_id
2903: per_previous_job_usages.previous_job_usage_id%type;
2904: l_object_version_number
2905: per_previous_job_usages.object_version_number%type;

Line 2903: per_previous_job_usages.previous_job_usage_id%type;

2899: l_period_years per_previous_job_usages.period_years%type;
2900: l_period_months per_previous_job_usages.period_months%type;
2901: l_period_days per_previous_job_usages.period_days%type;
2902: l_previous_job_usage_id
2903: per_previous_job_usages.previous_job_usage_id%type;
2904: l_object_version_number
2905: per_previous_job_usages.object_version_number%type;
2906: l_proc varchar2(72) := g_package||'create_prev_job_extra_info';
2907: --

Line 2905: per_previous_job_usages.object_version_number%type;

2901: l_period_days per_previous_job_usages.period_days%type;
2902: l_previous_job_usage_id
2903: per_previous_job_usages.previous_job_usage_id%type;
2904: l_object_version_number
2905: per_previous_job_usages.object_version_number%type;
2906: l_proc varchar2(72) := g_package||'create_prev_job_extra_info';
2907: --
2908: begin
2909: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3234: l_start_date per_previous_job_usages.start_date%type;

3230: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
3231: ,p_object_version_number in out nocopy number
3232: ) is
3233: --
3234: l_start_date per_previous_job_usages.start_date%type;
3235: l_end_date per_previous_job_usages.end_date%type;
3236: --
3237: l_period_years number;
3238: l_period_months number;

Line 3235: l_end_date per_previous_job_usages.end_date%type;

3231: ,p_object_version_number in out nocopy number
3232: ) is
3233: --
3234: l_start_date per_previous_job_usages.start_date%type;
3235: l_end_date per_previous_job_usages.end_date%type;
3236: --
3237: l_period_years number;
3238: l_period_months number;
3239: l_period_days number;

Line 3244: per_previous_job_usages.object_version_number%type

3240: --
3241: l_proc varchar2(72)
3242: := g_package||'update_previous_job_usage';
3243: l_object_version_number
3244: per_previous_job_usages.object_version_number%type
3245: := p_object_version_number;
3246: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;
3247: begin
3248: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3246: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;

3242: := g_package||'update_previous_job_usage';
3243: l_object_version_number
3244: per_previous_job_usages.object_version_number%type
3245: := p_object_version_number;
3246: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;
3247: begin
3248: hr_utility.set_location('Entering:'|| l_proc, 10);
3249: --
3250: -- Issue a savepoint

Line 3522: per_previous_job_usages.previous_job_usage_id%type;

3518: is
3519: l_proc varchar2(72)
3520: := g_package||'delete_previous_job_usage';
3521: l_previous_job_usage_id
3522: per_previous_job_usages.previous_job_usage_id%type;
3523: l_object_version_number
3524: per_previous_job_usages.object_version_number%type
3525: := p_object_version_number;
3526: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;

Line 3524: per_previous_job_usages.object_version_number%type

3520: := g_package||'delete_previous_job_usage';
3521: l_previous_job_usage_id
3522: per_previous_job_usages.previous_job_usage_id%type;
3523: l_object_version_number
3524: per_previous_job_usages.object_version_number%type
3525: := p_object_version_number;
3526: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;
3527: begin
3528: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3526: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;

3522: per_previous_job_usages.previous_job_usage_id%type;
3523: l_object_version_number
3524: per_previous_job_usages.object_version_number%type
3525: := p_object_version_number;
3526: l_ovn per_previous_job_usages.object_version_number%type := p_object_version_number;
3527: begin
3528: hr_utility.set_location('Entering:'|| l_proc, 10);
3529: --
3530: -- Issue a savepoint