[Home] [Help]
42: procedure chk_previous_employer_id
43: (p_previous_employer_id
44: in per_previous_employers.previous_employer_id%type
45: ,p_previous_job_usage_id
46: in per_previous_job_usages.previous_job_usage_id%type
47: ,p_object_version_number
48: in per_previous_job_usages.object_version_number%type) is
49: cursor csr_previous_employer_id is
50: select previous_employer_id
44: in per_previous_employers.previous_employer_id%type
45: ,p_previous_job_usage_id
46: in per_previous_job_usages.previous_job_usage_id%type
47: ,p_object_version_number
48: in per_previous_job_usages.object_version_number%type) is
49: cursor csr_previous_employer_id is
50: select previous_employer_id
51: from per_previous_employers
52: where previous_employer_id = p_previous_employer_id
121: procedure chk_previous_job_id
122: (p_previous_job_id
123: in per_previous_jobs.previous_job_id%type
124: ,p_previous_job_usage_id
125: in per_previous_job_usages.previous_job_usage_id%type
126: ,p_object_version_number
127: in per_previous_job_usages.object_version_number%type) is
128: cursor csr_previous_job_id is
129: select previous_job_id
123: in per_previous_jobs.previous_job_id%type
124: ,p_previous_job_usage_id
125: in per_previous_job_usages.previous_job_usage_id%type
126: ,p_object_version_number
127: in per_previous_job_usages.object_version_number%type) is
128: cursor csr_previous_job_id is
129: select previous_job_id
130: from per_previous_jobs
131: where previous_job_id = p_previous_job_id
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: procedure chk_assignment_id
201: (p_previous_job_usage_id
202: in per_previous_job_usages.previous_job_usage_id%type
203: ,p_object_version_number
204: in per_previous_job_usages.object_version_number%type
205: ,p_assignment_id
206: in per_previous_job_usages.assignment_id%type) is
200: procedure chk_assignment_id
201: (p_previous_job_usage_id
202: in per_previous_job_usages.previous_job_usage_id%type
203: ,p_object_version_number
204: in per_previous_job_usages.object_version_number%type
205: ,p_assignment_id
206: in per_previous_job_usages.assignment_id%type) is
207: cursor csr_assignment_id is
208: select assignment_id
202: in per_previous_job_usages.previous_job_usage_id%type
203: ,p_object_version_number
204: in per_previous_job_usages.object_version_number%type
205: ,p_assignment_id
206: in per_previous_job_usages.assignment_id%type) is
207: cursor csr_assignment_id is
208: select assignment_id
209: from per_all_assignments_f
210: where assignment_id = p_assignment_id;
207: cursor csr_assignment_id is
208: select assignment_id
209: from per_all_assignments_f
210: where assignment_id = p_assignment_id;
211: l_assignment_id per_previous_job_usages.assignment_id%type;
212: --
213: l_proc varchar2(72) := g_package||'chk_assignment_id';
214: l_api_updating boolean;
215: begin
275: -- {End Of Comments}
276: -- ----------------------------------------------------------------------------
277: procedure chk_valid_job_dates
278: (p_previous_job_usage_id
279: in per_previous_job_usages.previous_job_usage_id%type
280: ,p_object_version_number
281: in per_previous_job_usages.object_version_number%type
282: ,p_start_date
283: in per_previous_job_usages.start_date%type
277: procedure chk_valid_job_dates
278: (p_previous_job_usage_id
279: in per_previous_job_usages.previous_job_usage_id%type
280: ,p_object_version_number
281: in per_previous_job_usages.object_version_number%type
282: ,p_start_date
283: in per_previous_job_usages.start_date%type
284: ,p_end_date
285: in per_previous_job_usages.end_date%type) is
279: in per_previous_job_usages.previous_job_usage_id%type
280: ,p_object_version_number
281: in per_previous_job_usages.object_version_number%type
282: ,p_start_date
283: in per_previous_job_usages.start_date%type
284: ,p_end_date
285: in per_previous_job_usages.end_date%type) is
286: l_proc varchar2(72) := g_package||'chk_valid_job_dates';
287: l_api_updating boolean;
281: in per_previous_job_usages.object_version_number%type
282: ,p_start_date
283: in per_previous_job_usages.start_date%type
284: ,p_end_date
285: in per_previous_job_usages.end_date%type) is
286: l_proc varchar2(72) := g_package||'chk_valid_job_dates';
287: l_api_updating boolean;
288: begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
348: -- {End Of Comments}
349: -- ----------------------------------------------------------------------------
350: procedure chk_period_years
351: (p_period_years
352: in per_previous_job_usages.period_years%type
353: ,p_previous_job_usage_id
354: in per_previous_job_usages.previous_job_usage_id%type
355: ,p_object_version_number
356: in per_previous_job_usages.object_version_number%type) is
350: procedure chk_period_years
351: (p_period_years
352: in per_previous_job_usages.period_years%type
353: ,p_previous_job_usage_id
354: in per_previous_job_usages.previous_job_usage_id%type
355: ,p_object_version_number
356: in per_previous_job_usages.object_version_number%type) is
357: l_proc varchar2(72) := g_package||'chk_period_years';
358: l_api_updating boolean;
352: in per_previous_job_usages.period_years%type
353: ,p_previous_job_usage_id
354: in per_previous_job_usages.previous_job_usage_id%type
355: ,p_object_version_number
356: in per_previous_job_usages.object_version_number%type) is
357: l_proc varchar2(72) := g_package||'chk_period_years';
358: l_api_updating boolean;
359: begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
416: -- {End Of Comments}
417: -- ----------------------------------------------------------------------------
418: procedure chk_period_months
419: (p_period_months
420: in per_previous_job_usages.period_months%type
421: ,p_previous_job_usage_id
422: in per_previous_job_usages.previous_job_usage_id%type
423: ,p_object_version_number
424: in per_previous_job_usages.object_version_number%type) is
418: procedure chk_period_months
419: (p_period_months
420: in per_previous_job_usages.period_months%type
421: ,p_previous_job_usage_id
422: in per_previous_job_usages.previous_job_usage_id%type
423: ,p_object_version_number
424: in per_previous_job_usages.object_version_number%type) is
425: l_proc varchar2(72) := g_package||'chk_period_months';
426: l_api_updating boolean;
420: in per_previous_job_usages.period_months%type
421: ,p_previous_job_usage_id
422: in per_previous_job_usages.previous_job_usage_id%type
423: ,p_object_version_number
424: in per_previous_job_usages.object_version_number%type) is
425: l_proc varchar2(72) := g_package||'chk_period_months';
426: l_api_updating boolean;
427: begin
428: hr_utility.set_location('Entering:'||l_proc, 5);
484: -- {End Of Comments}
485: -- ----------------------------------------------------------------------------
486: procedure chk_period_days
487: (p_period_days
488: in per_previous_job_usages.period_days%type
489: ,p_previous_job_usage_id
490: in per_previous_job_usages.previous_job_usage_id%type
491: ,p_object_version_number
492: in per_previous_job_usages.object_version_number%type) is
486: procedure chk_period_days
487: (p_period_days
488: in per_previous_job_usages.period_days%type
489: ,p_previous_job_usage_id
490: in per_previous_job_usages.previous_job_usage_id%type
491: ,p_object_version_number
492: in per_previous_job_usages.object_version_number%type) is
493: l_proc varchar2(72) := g_package||'chk_period_days';
494: l_api_updating boolean;
488: in per_previous_job_usages.period_days%type
489: ,p_previous_job_usage_id
490: in per_previous_job_usages.previous_job_usage_id%type
491: ,p_object_version_number
492: in per_previous_job_usages.object_version_number%type) is
493: l_proc varchar2(72) := g_package||'chk_period_days';
494: l_api_updating boolean;
495: begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
558: -- {End Of Comments}
559: -- ----------------------------------------------------------------------------
560: procedure chk_pju_start_end_dates
561: (p_previous_job_usage_id
562: in per_previous_job_usages.previous_job_usage_id%type
563: ,p_object_version_number
564: in per_previous_job_usages.object_version_number%type
565: ,p_previous_employer_id
566: in per_previous_job_usages.previous_employer_id%type
560: procedure chk_pju_start_end_dates
561: (p_previous_job_usage_id
562: in per_previous_job_usages.previous_job_usage_id%type
563: ,p_object_version_number
564: in per_previous_job_usages.object_version_number%type
565: ,p_previous_employer_id
566: in per_previous_job_usages.previous_employer_id%type
567: ,p_start_date
568: in per_previous_job_usages.start_date%type
562: in per_previous_job_usages.previous_job_usage_id%type
563: ,p_object_version_number
564: in per_previous_job_usages.object_version_number%type
565: ,p_previous_employer_id
566: in per_previous_job_usages.previous_employer_id%type
567: ,p_start_date
568: in per_previous_job_usages.start_date%type
569: ,p_end_date
570: in per_previous_job_usages.end_date%type) is
564: in per_previous_job_usages.object_version_number%type
565: ,p_previous_employer_id
566: in per_previous_job_usages.previous_employer_id%type
567: ,p_start_date
568: in per_previous_job_usages.start_date%type
569: ,p_end_date
570: in per_previous_job_usages.end_date%type) is
571: cursor csr_pem_start_end_dates is
572: select previous_employer_id
566: in per_previous_job_usages.previous_employer_id%type
567: ,p_start_date
568: in per_previous_job_usages.start_date%type
569: ,p_end_date
570: in per_previous_job_usages.end_date%type) is
571: cursor csr_pem_start_end_dates is
572: select previous_employer_id
573: from per_previous_employers
574: where previous_employer_id = p_previous_employer_id
651: -- {End Of Comments}
652: -- ----------------------------------------------------------------------------
653: procedure chk_assignment_job
654: (p_previous_job_usage_id
655: in per_previous_job_usages.previous_employer_id%type
656: ,p_object_version_number
657: in per_previous_job_usages.object_version_number%type
658: ,p_previous_job_id
659: in per_previous_job_usages.previous_job_id%type
653: procedure chk_assignment_job
654: (p_previous_job_usage_id
655: in per_previous_job_usages.previous_employer_id%type
656: ,p_object_version_number
657: in per_previous_job_usages.object_version_number%type
658: ,p_previous_job_id
659: in per_previous_job_usages.previous_job_id%type
660: ,p_assignment_id
661: in per_previous_job_usages.assignment_id%type
655: in per_previous_job_usages.previous_employer_id%type
656: ,p_object_version_number
657: in per_previous_job_usages.object_version_number%type
658: ,p_previous_job_id
659: in per_previous_job_usages.previous_job_id%type
660: ,p_assignment_id
661: in per_previous_job_usages.assignment_id%type
662: ) is
663: -- Declare local cursors.
657: in per_previous_job_usages.object_version_number%type
658: ,p_previous_job_id
659: in per_previous_job_usages.previous_job_id%type
660: ,p_assignment_id
661: in per_previous_job_usages.assignment_id%type
662: ) is
663: -- Declare local cursors.
664: cursor csr_asg_job is
665: select previous_job_usage_id
662: ) is
663: -- Declare local cursors.
664: cursor csr_asg_job is
665: select previous_job_usage_id
666: from per_previous_job_usages
667: where assignment_id = p_assignment_id
668: and previous_job_id = p_previous_job_id;
669: -- Declare local variables
670: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
666: from per_previous_job_usages
667: where assignment_id = p_assignment_id
668: and previous_job_id = p_previous_job_id;
669: -- Declare local variables
670: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
671: l_proc varchar2(72) := g_package||'chk_assignment_job';
672: l_api_updating boolean;
673: begin
674: hr_utility.set_location('Entering:'||l_proc, 5);
713: -- ----------------------------------------------------------------------------
714: -- {Start Of Comments}
715: --
716: -- Description:
717: -- This procedure fetches the default values for the per_previous_job_usages
718: -- table. The default values are start_date,end_date,period_years,
719: -- period_months,period_days.
720: --
721: -- In Arguments:
738: -- {End Of Comments}
739: -- ----------------------------------------------------------------------------
740: procedure get_previous_job_dates
741: (p_previous_employer_id
742: in per_previous_job_usages.previous_employer_id%type
743: ,p_previous_job_id
744: in per_previous_job_usages.previous_job_id%type
745: ,p_start_date
746: out nocopy per_previous_job_usages.start_date%type
740: procedure get_previous_job_dates
741: (p_previous_employer_id
742: in per_previous_job_usages.previous_employer_id%type
743: ,p_previous_job_id
744: in per_previous_job_usages.previous_job_id%type
745: ,p_start_date
746: out nocopy per_previous_job_usages.start_date%type
747: ,p_end_date
748: out nocopy per_previous_job_usages.end_date%type
742: in per_previous_job_usages.previous_employer_id%type
743: ,p_previous_job_id
744: in per_previous_job_usages.previous_job_id%type
745: ,p_start_date
746: out nocopy per_previous_job_usages.start_date%type
747: ,p_end_date
748: out nocopy per_previous_job_usages.end_date%type
749: ,p_period_years
750: out nocopy per_previous_job_usages.period_years%type
744: in per_previous_job_usages.previous_job_id%type
745: ,p_start_date
746: out nocopy per_previous_job_usages.start_date%type
747: ,p_end_date
748: out nocopy per_previous_job_usages.end_date%type
749: ,p_period_years
750: out nocopy per_previous_job_usages.period_years%type
751: ,p_period_months
752: out nocopy per_previous_job_usages.period_months%type
746: out nocopy per_previous_job_usages.start_date%type
747: ,p_end_date
748: out nocopy per_previous_job_usages.end_date%type
749: ,p_period_years
750: out nocopy per_previous_job_usages.period_years%type
751: ,p_period_months
752: out nocopy per_previous_job_usages.period_months%type
753: ,p_period_days
754: out nocopy per_previous_job_usages.period_days%type
748: out nocopy per_previous_job_usages.end_date%type
749: ,p_period_years
750: out nocopy per_previous_job_usages.period_years%type
751: ,p_period_months
752: out nocopy per_previous_job_usages.period_months%type
753: ,p_period_days
754: out nocopy per_previous_job_usages.period_days%type
755: ) is
756: -- Declare local variables
750: out nocopy per_previous_job_usages.period_years%type
751: ,p_period_months
752: out nocopy per_previous_job_usages.period_months%type
753: ,p_period_days
754: out nocopy per_previous_job_usages.period_days%type
755: ) is
756: -- Declare local variables
757: l_proc varchar2(72) := g_package||'get_previous_job_dates';
758: -- Declare local cursor
820: -- {End Of Comments}
821: -- ----------------------------------------------------------------------------
822: procedure chk_asg_job_start_date
823: (p_previous_job_usage_id
824: in per_previous_job_usages.previous_job_usage_id%type
825: ,p_object_version_number
826: in per_previous_job_usages.object_version_number%type
827: ,p_assignment_id
828: in per_previous_job_usages.assignment_id%type
822: procedure chk_asg_job_start_date
823: (p_previous_job_usage_id
824: in per_previous_job_usages.previous_job_usage_id%type
825: ,p_object_version_number
826: in per_previous_job_usages.object_version_number%type
827: ,p_assignment_id
828: in per_previous_job_usages.assignment_id%type
829: ,p_previous_job_id
830: in per_previous_job_usages.previous_job_id%type
824: in per_previous_job_usages.previous_job_usage_id%type
825: ,p_object_version_number
826: in per_previous_job_usages.object_version_number%type
827: ,p_assignment_id
828: in per_previous_job_usages.assignment_id%type
829: ,p_previous_job_id
830: in per_previous_job_usages.previous_job_id%type
831: )
832: is
826: in per_previous_job_usages.object_version_number%type
827: ,p_assignment_id
828: in per_previous_job_usages.assignment_id%type
829: ,p_previous_job_id
830: in per_previous_job_usages.previous_job_id%type
831: )
832: is
833: -- Declare local procedure name
834: l_proc varchar2(72) := g_package||'chk_asg_job_start_date';
886: -- Declare cursor
887: cursor csr_sec_grp is
888: select pbg.security_group_id
889: from per_business_groups pbg
890: , per_previous_job_usages pju
891: , per_previous_jobs pjo
892: , per_previous_employers pem
893: where pju.previous_job_usage_id = p_previous_job_usage_id
894: and pju.previous_job_id(+) = pjo.previous_job_id
949: -- Declare cursor
950: cursor csr_leg_code is
951: select pbg.legislation_code
952: from per_business_groups pbg
953: , per_previous_job_usages pju
954: , per_previous_employers pem
955: where pju.previous_job_usage_id = p_previous_job_usage_id
956: and pju.previous_employer_id = pem.previous_employer_id(+)
957: and pem.business_group_id = pbg.business_group_id(+);
1236: -- b) During insert.
1237: --
1238: hr_dflex_utility.ins_or_upd_descflex_attribs
1239: (p_appl_short_name => 'PER'
1240: ,p_descflex_name => 'PER_PREVIOUS_JOB_USAGES'
1241: ,p_attribute_category => p_rec.pju_attribute_category
1242: ,p_attribute1_name => 'PJU_ATTRIBUTE1'
1243: ,p_attribute1_value => p_rec.pju_attribute1
1244: ,p_attribute2_name => 'PJU_ATTRIBUTE2'