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.PER_PJO_BUS dependencies on PER_PREVIOUS_JOBS

Line 31: , per_previous_jobs pjo

27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_previous_jobs pjo
32: , per_all_people_f ppf
33: , per_previous_employers pem
34: where pjo.previous_job_id = p_previous_job_id
35: and pbg.business_group_id = ppf.business_group_id

Line 98: , per_previous_jobs pjo

94: --
95: cursor csr_leg_code is
96: select pbg.legislation_code
97: from per_business_groups pbg
98: , per_previous_jobs pjo
99: , per_all_people_f ppf
100: , per_previous_employers pem
101: where pjo.previous_job_id = p_previous_job_id
102: and ppf.business_group_id = pbg.business_group_id(+)

Line 447: ,p_descflex_name => 'PER_PREVIOUS_JOBS'

443: -- b) During insert.
444: --
445: hr_dflex_utility.ins_or_upd_descflex_attribs
446: (p_appl_short_name => 'PER'
447: ,p_descflex_name => 'PER_PREVIOUS_JOBS'
448: ,p_attribute_category => p_rec.pjo_attribute_category
449: ,p_attribute1_name => 'PJO_ATTRIBUTE1'
450: ,p_attribute1_value => p_rec.pjo_attribute1
451: ,p_attribute2_name => 'PJO_ATTRIBUTE2'

Line 612: in per_previous_jobs.previous_employer_id%type

608: -- {End Of Comments}
609: -- ----------------------------------------------------------------------------
610: procedure chk_previous_employer_id
611: (p_previous_employer_id
612: in per_previous_jobs.previous_employer_id%type
613: ,p_previous_job_id
614: in per_previous_jobs.previous_job_id%type
615: ,p_object_version_number
616: in per_previous_jobs.object_version_number%type) is

Line 614: in per_previous_jobs.previous_job_id%type

610: procedure chk_previous_employer_id
611: (p_previous_employer_id
612: in per_previous_jobs.previous_employer_id%type
613: ,p_previous_job_id
614: in per_previous_jobs.previous_job_id%type
615: ,p_object_version_number
616: in per_previous_jobs.object_version_number%type) is
617: cursor csr_previous_employer_id is
618: select previous_employer_id

Line 616: in per_previous_jobs.object_version_number%type) is

612: in per_previous_jobs.previous_employer_id%type
613: ,p_previous_job_id
614: in per_previous_jobs.previous_job_id%type
615: ,p_object_version_number
616: in per_previous_jobs.object_version_number%type) is
617: cursor csr_previous_employer_id is
618: select previous_employer_id
619: from per_previous_employers
620: where previous_employer_id = p_previous_employer_id;

Line 658: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'

654: hr_utility.set_location('Leaving:'||l_proc, 25);
655: exception
656: when app_exception.application_exception then
657: if hr_multi_message.exception_add
658: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
659: ) then
660: hr_utility.set_location(' Leaving:'|| l_proc, 30);
661: raise;
662: end if;

Line 694: in per_previous_jobs.previous_job_id%type

690: -- {End Of Comments}
691: -- ----------------------------------------------------------------------------
692: procedure chk_start_end_dates
693: (p_previous_job_id
694: in per_previous_jobs.previous_job_id%type
695: ,p_object_version_number
696: in per_previous_jobs.object_version_number%type
697: ,p_start_date
698: in per_previous_jobs.start_date%type

Line 696: in per_previous_jobs.object_version_number%type

692: procedure chk_start_end_dates
693: (p_previous_job_id
694: in per_previous_jobs.previous_job_id%type
695: ,p_object_version_number
696: in per_previous_jobs.object_version_number%type
697: ,p_start_date
698: in per_previous_jobs.start_date%type
699: ,p_end_date
700: in per_previous_jobs.end_date%type) is

Line 698: in per_previous_jobs.start_date%type

694: in per_previous_jobs.previous_job_id%type
695: ,p_object_version_number
696: in per_previous_jobs.object_version_number%type
697: ,p_start_date
698: in per_previous_jobs.start_date%type
699: ,p_end_date
700: in per_previous_jobs.end_date%type) is
701: l_proc varchar2(72) := g_package||'chk_start_end_dates';
702: l_api_updating boolean;

Line 700: in per_previous_jobs.end_date%type) is

696: in per_previous_jobs.object_version_number%type
697: ,p_start_date
698: in per_previous_jobs.start_date%type
699: ,p_end_date
700: in per_previous_jobs.end_date%type) is
701: l_proc varchar2(72) := g_package||'chk_start_end_dates';
702: l_api_updating boolean;
703: begin
704: hr_utility.set_location('Entering:'||l_proc, 5);

Line 735: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'

731: hr_utility.set_location('Leaving:'||l_proc, 25);
732: exception
733: when app_exception.application_exception then
734: if hr_multi_message.exception_add
735: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
736: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 50);
739: raise;

Line 736: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'

732: exception
733: when app_exception.application_exception then
734: if hr_multi_message.exception_add
735: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
736: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 50);
739: raise;
740: end if;

Line 772: in per_previous_jobs.previous_job_id%type

768: -- {End Of Comments}
769: -- ----------------------------------------------------------------------------
770: procedure chk_employment_category
771: (p_previous_job_id
772: in per_previous_jobs.previous_job_id%type
773: ,p_object_version_number
774: in per_previous_jobs.object_version_number%type
775: ,p_employment_category
776: in per_previous_jobs.employment_category%type

Line 774: in per_previous_jobs.object_version_number%type

770: procedure chk_employment_category
771: (p_previous_job_id
772: in per_previous_jobs.previous_job_id%type
773: ,p_object_version_number
774: in per_previous_jobs.object_version_number%type
775: ,p_employment_category
776: in per_previous_jobs.employment_category%type
777: ,p_effective_date in date) is
778: l_proc varchar2(72) := g_package||'chk_employment_category';

Line 776: in per_previous_jobs.employment_category%type

772: in per_previous_jobs.previous_job_id%type
773: ,p_object_version_number
774: in per_previous_jobs.object_version_number%type
775: ,p_employment_category
776: in per_previous_jobs.employment_category%type
777: ,p_effective_date in date) is
778: l_proc varchar2(72) := g_package||'chk_employment_category';
779: l_no_lookup boolean;
780: l_effective_date date := p_effective_date;

Line 782: l_lookup_code per_previous_jobs.employment_category%type

778: l_proc varchar2(72) := g_package||'chk_employment_category';
779: l_no_lookup boolean;
780: l_effective_date date := p_effective_date;
781: l_lookup_type fnd_lookups.lookup_type%type := 'EMPLOYEE_CATG';
782: l_lookup_code per_previous_jobs.employment_category%type
783: := p_employment_category;
784: l_api_updating boolean;
785: begin
786: hr_utility.set_location('Entering:'||l_proc, 5);

Line 819: (p_associated_column1 => 'PER_PREVIOUS_JOBS.EMPLOYMENT_CATEGORY'

815: hr_utility.set_location('Leaving:'||l_proc, 30);
816: exception
817: when app_exception.application_exception then
818: if hr_multi_message.exception_add
819: (p_associated_column1 => 'PER_PREVIOUS_JOBS.EMPLOYMENT_CATEGORY'
820: ) then
821: hr_utility.set_location(' Leaving:'|| l_proc, 50);
822: raise;
823: end if;

Line 854: in per_previous_jobs.period_years%type

850: -- {End Of Comments}
851: -- ----------------------------------------------------------------------------
852: procedure chk_period_years
853: (p_period_years
854: in per_previous_jobs.period_years%type
855: ,p_previous_job_id
856: in per_previous_jobs.previous_job_id%type
857: ,p_object_version_number
858: in per_previous_jobs.object_version_number%type) is

Line 856: in per_previous_jobs.previous_job_id%type

852: procedure chk_period_years
853: (p_period_years
854: in per_previous_jobs.period_years%type
855: ,p_previous_job_id
856: in per_previous_jobs.previous_job_id%type
857: ,p_object_version_number
858: in per_previous_jobs.object_version_number%type) is
859: l_proc varchar2(72) := g_package||'chk_period_years';
860: l_api_updating boolean;

Line 858: in per_previous_jobs.object_version_number%type) is

854: in per_previous_jobs.period_years%type
855: ,p_previous_job_id
856: in per_previous_jobs.previous_job_id%type
857: ,p_object_version_number
858: in per_previous_jobs.object_version_number%type) is
859: l_proc varchar2(72) := g_package||'chk_period_years';
860: l_api_updating boolean;
861: begin
862: hr_utility.set_location('Entering:'||l_proc, 5);

Line 892: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_YEARS'

888: hr_utility.set_location('Leaving:'||l_proc, 30);
889: exception
890: when app_exception.application_exception then
891: if hr_multi_message.exception_add
892: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_YEARS'
893: ) then
894: hr_utility.set_location(' Leaving:'|| l_proc, 40);
895: raise;
896: end if;

Line 927: in per_previous_jobs.period_months%type

923: -- {End Of Comments}
924: -- ----------------------------------------------------------------------------
925: procedure chk_period_months
926: (p_period_months
927: in per_previous_jobs.period_months%type
928: ,p_previous_job_id
929: in per_previous_jobs.previous_job_id%type
930: ,p_object_version_number
931: in per_previous_jobs.object_version_number%type) is

Line 929: in per_previous_jobs.previous_job_id%type

925: procedure chk_period_months
926: (p_period_months
927: in per_previous_jobs.period_months%type
928: ,p_previous_job_id
929: in per_previous_jobs.previous_job_id%type
930: ,p_object_version_number
931: in per_previous_jobs.object_version_number%type) is
932: l_proc varchar2(72) := g_package||'chk_period_months';
933: l_api_updating boolean;

Line 931: in per_previous_jobs.object_version_number%type) is

927: in per_previous_jobs.period_months%type
928: ,p_previous_job_id
929: in per_previous_jobs.previous_job_id%type
930: ,p_object_version_number
931: in per_previous_jobs.object_version_number%type) is
932: l_proc varchar2(72) := g_package||'chk_period_months';
933: l_api_updating boolean;
934: begin
935: hr_utility.set_location('Entering:'||l_proc, 5);

Line 965: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_MONTHS'

961: hr_utility.set_location('Leaving:'||l_proc, 30);
962: exception
963: when app_exception.application_exception then
964: if hr_multi_message.exception_add
965: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_MONTHS'
966: ) then
967: hr_utility.set_location(' Leaving:'|| l_proc, 40);
968: raise;
969: end if;

Line 1000: in per_previous_jobs.period_days%type

996: -- {End Of Comments}
997: -- ----------------------------------------------------------------------------
998: procedure chk_period_days
999: (p_period_days
1000: in per_previous_jobs.period_days%type
1001: ,p_previous_job_id
1002: in per_previous_jobs.previous_job_id%type
1003: ,p_object_version_number
1004: in per_previous_jobs.object_version_number%type) is

Line 1002: in per_previous_jobs.previous_job_id%type

998: procedure chk_period_days
999: (p_period_days
1000: in per_previous_jobs.period_days%type
1001: ,p_previous_job_id
1002: in per_previous_jobs.previous_job_id%type
1003: ,p_object_version_number
1004: in per_previous_jobs.object_version_number%type) is
1005: l_proc varchar2(72) := g_package||'chk_period_days';
1006: l_api_updating boolean;

Line 1004: in per_previous_jobs.object_version_number%type) is

1000: in per_previous_jobs.period_days%type
1001: ,p_previous_job_id
1002: in per_previous_jobs.previous_job_id%type
1003: ,p_object_version_number
1004: in per_previous_jobs.object_version_number%type) is
1005: l_proc varchar2(72) := g_package||'chk_period_days';
1006: l_api_updating boolean;
1007: begin
1008: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1038: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_DAYS'

1034: hr_utility.set_location('Leaving:'||l_proc, 30);
1035: exception
1036: when app_exception.application_exception then
1037: if hr_multi_message.exception_add
1038: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PERIOD_DAYS'
1039: ) then
1040: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1041: raise;
1042: end if;

Line 1079: in per_previous_jobs.previous_job_id%type

1075: -- {End Of Comments}
1076: -- ----------------------------------------------------------------------------
1077: procedure chk_pjo_start_end_dates
1078: (p_previous_job_id
1079: in per_previous_jobs.previous_job_id%type
1080: ,p_previous_employer_id
1081: in per_previous_jobs.previous_employer_id%type
1082: ,p_object_version_number
1083: in per_previous_jobs.object_version_number%type

Line 1081: in per_previous_jobs.previous_employer_id%type

1077: procedure chk_pjo_start_end_dates
1078: (p_previous_job_id
1079: in per_previous_jobs.previous_job_id%type
1080: ,p_previous_employer_id
1081: in per_previous_jobs.previous_employer_id%type
1082: ,p_object_version_number
1083: in per_previous_jobs.object_version_number%type
1084: ,p_start_date
1085: in per_previous_jobs.start_date%type

Line 1083: in per_previous_jobs.object_version_number%type

1079: in per_previous_jobs.previous_job_id%type
1080: ,p_previous_employer_id
1081: in per_previous_jobs.previous_employer_id%type
1082: ,p_object_version_number
1083: in per_previous_jobs.object_version_number%type
1084: ,p_start_date
1085: in per_previous_jobs.start_date%type
1086: ,p_end_date
1087: in per_previous_jobs.end_date%TYPE

Line 1085: in per_previous_jobs.start_date%type

1081: in per_previous_jobs.previous_employer_id%type
1082: ,p_object_version_number
1083: in per_previous_jobs.object_version_number%type
1084: ,p_start_date
1085: in per_previous_jobs.start_date%type
1086: ,p_end_date
1087: in per_previous_jobs.end_date%TYPE
1088: ,p_effective_date
1089: IN per_previous_jobs.start_date%type) is

Line 1087: in per_previous_jobs.end_date%TYPE

1083: in per_previous_jobs.object_version_number%type
1084: ,p_start_date
1085: in per_previous_jobs.start_date%type
1086: ,p_end_date
1087: in per_previous_jobs.end_date%TYPE
1088: ,p_effective_date
1089: IN per_previous_jobs.start_date%type) is
1090: cursor csr_pem_start_end_dates is
1091: select previous_employer_id

Line 1089: IN per_previous_jobs.start_date%type) is

1085: in per_previous_jobs.start_date%type
1086: ,p_end_date
1087: in per_previous_jobs.end_date%TYPE
1088: ,p_effective_date
1089: IN per_previous_jobs.start_date%type) is
1090: cursor csr_pem_start_end_dates is
1091: select previous_employer_id
1092: from per_previous_employers
1093: where previous_employer_id = p_previous_employer_id

Line 1106: (p_check_column1 => 'PER_PREVIOUS_JOBS.START_DATE'

1102: begin
1103: hr_utility.set_location('Entering:'||l_proc, 5);
1104: --
1105: if hr_multi_message.no_all_inclusive_error
1106: (p_check_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1107: ,p_check_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1108: ,p_check_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1109: ) THEN
1110: hr_utility.set_location('Entering:'||l_proc, 6);

Line 1107: ,p_check_column2 => 'PER_PREVIOUS_JOBS.END_DATE'

1103: hr_utility.set_location('Entering:'||l_proc, 5);
1104: --
1105: if hr_multi_message.no_all_inclusive_error
1106: (p_check_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1107: ,p_check_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1108: ,p_check_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1109: ) THEN
1110: hr_utility.set_location('Entering:'||l_proc, 6);
1111: -- This if condition added for bug 7112425

Line 1108: ,p_check_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'

1104: --
1105: if hr_multi_message.no_all_inclusive_error
1106: (p_check_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1107: ,p_check_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1108: ,p_check_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1109: ) THEN
1110: hr_utility.set_location('Entering:'||l_proc, 6);
1111: -- This if condition added for bug 7112425
1112: IF p_start_date is not null AND p_start_date > p_effective_date THEN

Line 1152: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'

1148: hr_utility.set_location('Leaving:'||l_proc, 25);
1149: exception
1150: when app_exception.application_exception then
1151: if hr_multi_message.exception_add
1152: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1153: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1154: ,p_associated_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1155: ) then
1156: hr_utility.set_location(' Leaving:'|| l_proc, 30);

Line 1153: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'

1149: exception
1150: when app_exception.application_exception then
1151: if hr_multi_message.exception_add
1152: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1153: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1154: ,p_associated_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1155: ) then
1156: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1157: raise;

Line 1154: ,p_associated_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'

1150: when app_exception.application_exception then
1151: if hr_multi_message.exception_add
1152: (p_associated_column1 => 'PER_PREVIOUS_JOBS.START_DATE'
1153: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.END_DATE'
1154: ,p_associated_column3 => 'PER_PREVIOUS_JOBS.PREVIOUS_EMPLOYER_ID'
1155: ) then
1156: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1157: raise;
1158: end if;

Line 1193: in per_previous_jobs.previous_job_id%type

1189: -- {End Of Comments}
1190: -- ----------------------------------------------------------------------------
1191: procedure chk_all_assignments
1192: (p_previous_job_id
1193: in per_previous_jobs.previous_job_id%type
1194: ,p_object_version_number
1195: in per_previous_jobs.object_version_number%type
1196: ,p_all_assignments
1197: in per_previous_jobs.all_assignments%type) is

Line 1195: in per_previous_jobs.object_version_number%type

1191: procedure chk_all_assignments
1192: (p_previous_job_id
1193: in per_previous_jobs.previous_job_id%type
1194: ,p_object_version_number
1195: in per_previous_jobs.object_version_number%type
1196: ,p_all_assignments
1197: in per_previous_jobs.all_assignments%type) is
1198: cursor csr_pjo_assignments is
1199: select previous_job_usage_id

Line 1197: in per_previous_jobs.all_assignments%type) is

1193: in per_previous_jobs.previous_job_id%type
1194: ,p_object_version_number
1195: in per_previous_jobs.object_version_number%type
1196: ,p_all_assignments
1197: in per_previous_jobs.all_assignments%type) is
1198: cursor csr_pjo_assignments is
1199: select previous_job_usage_id
1200: from per_previous_job_usages
1201: where previous_job_id = p_previous_job_id;

Line 1210: (p_check_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'

1206: begin
1207: hr_utility.set_location('Entering:'||l_proc, 5);
1208: --
1209: if hr_multi_message.no_exclusive_error
1210: (p_check_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'
1211: ) then
1212: if p_all_assignments is not null then
1213: hr_utility.set_location(l_proc, 10);
1214: l_api_updating := per_pjo_shd.api_updating(p_previous_job_id

Line 1235: (p_associated_column1 => 'PER_PREVIOUS_JOBS.

1231: hr_utility.set_location(l_proc, 30);
1232: close csr_pjo_assignments;
1233: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1234: hr_multi_message.add
1235: (p_associated_column1 => 'PER_PREVIOUS_JOBS.
1236: PREVIOUS_JOB_ID'
1237: );
1238: end if;
1239: if csr_pjo_assignments%isopen then

Line 1247: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'

1243: else
1244: hr_utility.set_location(l_proc, 35);
1245: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1246: hr_multi_message.add
1247: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'
1248: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.ALL_ASSIGNMENTS'
1249: );
1250: end if;
1251: end if;

Line 1248: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.ALL_ASSIGNMENTS'

1244: hr_utility.set_location(l_proc, 35);
1245: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1246: hr_multi_message.add
1247: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'
1248: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.ALL_ASSIGNMENTS'
1249: );
1250: end if;
1251: end if;
1252: end if;