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_PEM_BUS dependencies on PER_PREVIOUS_EMPLOYERS

Line 20: (p_start_date in per_previous_employers.start_date%type

16: -- -----------------------------------------------------------------------
17: -- |---------------------------< get_period_values >---------------------|
18: -- -----------------------------------------------------------------------
19: procedure get_period_values
20: (p_start_date in per_previous_employers.start_date%type
21: ,p_end_date in per_previous_employers.end_date%type
22: ,p_period_years out nocopy per_previous_employers.period_years%type
23: ,p_period_months out nocopy per_previous_employers.period_months%type
24: ,p_period_days out nocopy per_previous_employers.period_days%type

Line 21: ,p_end_date in per_previous_employers.end_date%type

17: -- |---------------------------< get_period_values >---------------------|
18: -- -----------------------------------------------------------------------
19: procedure get_period_values
20: (p_start_date in per_previous_employers.start_date%type
21: ,p_end_date in per_previous_employers.end_date%type
22: ,p_period_years out nocopy per_previous_employers.period_years%type
23: ,p_period_months out nocopy per_previous_employers.period_months%type
24: ,p_period_days out nocopy per_previous_employers.period_days%type
25: ) is

Line 22: ,p_period_years out nocopy per_previous_employers.period_years%type

18: -- -----------------------------------------------------------------------
19: procedure get_period_values
20: (p_start_date in per_previous_employers.start_date%type
21: ,p_end_date in per_previous_employers.end_date%type
22: ,p_period_years out nocopy per_previous_employers.period_years%type
23: ,p_period_months out nocopy per_previous_employers.period_months%type
24: ,p_period_days out nocopy per_previous_employers.period_days%type
25: ) is
26: l_proc varchar2(72) := g_package||'get_period_values';

Line 23: ,p_period_months out nocopy per_previous_employers.period_months%type

19: procedure get_period_values
20: (p_start_date in per_previous_employers.start_date%type
21: ,p_end_date in per_previous_employers.end_date%type
22: ,p_period_years out nocopy per_previous_employers.period_years%type
23: ,p_period_months out nocopy per_previous_employers.period_months%type
24: ,p_period_days out nocopy per_previous_employers.period_days%type
25: ) is
26: l_proc varchar2(72) := g_package||'get_period_values';
27: l_period_years number; -- Don't change the datatype

Line 24: ,p_period_days out nocopy per_previous_employers.period_days%type

20: (p_start_date in per_previous_employers.start_date%type
21: ,p_end_date in per_previous_employers.end_date%type
22: ,p_period_years out nocopy per_previous_employers.period_years%type
23: ,p_period_months out nocopy per_previous_employers.period_months%type
24: ,p_period_days out nocopy per_previous_employers.period_days%type
25: ) is
26: l_proc varchar2(72) := g_package||'get_period_values';
27: l_period_years number; -- Don't change the datatype
28: l_start_date per_previous_employers.start_date%type;

Line 28: l_start_date per_previous_employers.start_date%type;

24: ,p_period_days out nocopy per_previous_employers.period_days%type
25: ) is
26: l_proc varchar2(72) := g_package||'get_period_values';
27: l_period_years number; -- Don't change the datatype
28: l_start_date per_previous_employers.start_date%type;
29: l_end_date per_previous_employers.end_date%type;
30: begin
31: hr_utility.set_location('Entering:'||l_proc, 5);
32: --

Line 29: l_end_date per_previous_employers.end_date%type;

25: ) is
26: l_proc varchar2(72) := g_package||'get_period_values';
27: l_period_years number; -- Don't change the datatype
28: l_start_date per_previous_employers.start_date%type;
29: l_end_date per_previous_employers.end_date%type;
30: begin
31: hr_utility.set_location('Entering:'||l_proc, 5);
32: --
33: -- Truncate all date datatypes

Line 108: , per_previous_employers pem

104: --
105: cursor csr_sec_grp is
106: select pbg.security_group_id
107: from per_business_groups pbg
108: , per_previous_employers pem
109: where pem.previous_employer_id = p_previous_employer_id
110: and pbg.business_group_id = pem.business_group_id;
111: --
112: -- Declare local variables

Line 170: , per_previous_employers pem

166: --
167: cursor csr_leg_code is
168: select pbg.legislation_code
169: from per_business_groups pbg
170: , per_previous_employers pem
171: where pem.previous_employer_id = p_previous_employer_id
172: and pbg.business_group_id (+) = pem.business_group_id;
173: --
174: -- Declare local variables

Line 515: ,p_descflex_name => 'PER_PREVIOUS_EMPLOYERS'

511: -- b) During insert.
512: --
513: hr_dflex_utility.ins_or_upd_descflex_attribs
514: (p_appl_short_name => 'PER'
515: ,p_descflex_name => 'PER_PREVIOUS_EMPLOYERS'
516: ,p_attribute_category => p_rec.pem_attribute_category
517: ,p_attribute1_name => 'PEM_ATTRIBUTE1'
518: ,p_attribute1_value => p_rec.pem_attribute1
519: ,p_attribute2_name => 'PEM_ATTRIBUTE2'

Line 716: in per_previous_employers.person_id%type

712: --
713: -- {End Of Comments}
714: -- ----------------------------------------------------------------------------
715: procedure chk_person_id(p_person_id
716: in per_previous_employers.person_id%type
717: ,p_previous_employer_id
718: in per_previous_employers.previous_employer_id%type
719: ,p_object_version_number
720: in per_previous_employers.object_version_number%type

Line 718: in per_previous_employers.previous_employer_id%type

714: -- ----------------------------------------------------------------------------
715: procedure chk_person_id(p_person_id
716: in per_previous_employers.person_id%type
717: ,p_previous_employer_id
718: in per_previous_employers.previous_employer_id%type
719: ,p_object_version_number
720: in per_previous_employers.object_version_number%type
721: ,p_effective_date
722: in date)

Line 720: in per_previous_employers.object_version_number%type

716: in per_previous_employers.person_id%type
717: ,p_previous_employer_id
718: in per_previous_employers.previous_employer_id%type
719: ,p_object_version_number
720: in per_previous_employers.object_version_number%type
721: ,p_effective_date
722: in date)
723: is
724: -- Define the cursor for the person_id

Line 791: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERSON_ID'

787: hr_utility.set_location('Leaving:'||l_proc, 40);
788: exception
789: when app_exception.application_exception then
790: if hr_multi_message.exception_add
791: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERSON_ID'
792: ) then
793: hr_utility.set_location('Leaving:'||l_proc, 50);
794: raise;
795: end if;

Line 825: in per_previous_employers.party_id%type

821: --
822: -- {End Of Comments}
823: -- ----------------------------------------------------------------------------
824: procedure chk_party_id(p_party_id
825: in per_previous_employers.party_id%type
826: ,p_previous_employer_id
827: in per_previous_employers.previous_employer_id%type
828: ,p_object_version_number
829: in per_previous_employers.object_version_number%type) is

Line 827: in per_previous_employers.previous_employer_id%type

823: -- ----------------------------------------------------------------------------
824: procedure chk_party_id(p_party_id
825: in per_previous_employers.party_id%type
826: ,p_previous_employer_id
827: in per_previous_employers.previous_employer_id%type
828: ,p_object_version_number
829: in per_previous_employers.object_version_number%type) is
830: --Define the cursor for party_id
831: cursor csr_party_id is

Line 829: in per_previous_employers.object_version_number%type) is

825: in per_previous_employers.party_id%type
826: ,p_previous_employer_id
827: in per_previous_employers.previous_employer_id%type
828: ,p_object_version_number
829: in per_previous_employers.object_version_number%type) is
830: --Define the cursor for party_id
831: cursor csr_party_id is
832: select party_id
833: from hz_parties

Line 874: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PARTY_ID'

870: hr_utility.set_location('Leaving:'||l_proc, 25);
871: exception
872: when app_exception.application_exception then
873: if hr_multi_message.exception_add
874: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PARTY_ID'
875: ) then
876: hr_utility.set_location('Leaving:'||l_proc,30);
877: raise;
878: end if;

Line 910: in per_previous_employers.previous_employer_id%type

906: -- {End Of Comments}
907: -- ----------------------------------------------------------------------------
908: procedure chk_employer_country
909: (p_previous_employer_id
910: in per_previous_employers.previous_employer_id%type
911: ,p_object_version_number
912: in per_previous_employers.object_version_number%type
913: ,p_employer_country
914: in per_previous_employers.employer_country%type) is

Line 912: in per_previous_employers.object_version_number%type

908: procedure chk_employer_country
909: (p_previous_employer_id
910: in per_previous_employers.previous_employer_id%type
911: ,p_object_version_number
912: in per_previous_employers.object_version_number%type
913: ,p_employer_country
914: in per_previous_employers.employer_country%type) is
915: cursor csr_employer_country is
916: select territory_code

Line 914: in per_previous_employers.employer_country%type) is

910: in per_previous_employers.previous_employer_id%type
911: ,p_object_version_number
912: in per_previous_employers.object_version_number%type
913: ,p_employer_country
914: in per_previous_employers.employer_country%type) is
915: cursor csr_employer_country is
916: select territory_code
917: from fnd_territories_vl
918: where territory_code = p_employer_country;

Line 919: l_employer_country per_previous_employers.employer_country%type;

915: cursor csr_employer_country is
916: select territory_code
917: from fnd_territories_vl
918: where territory_code = p_employer_country;
919: l_employer_country per_previous_employers.employer_country%type;
920: --
921: l_proc varchar2(72) := g_package||'chk_employer_country';
922: l_api_updating boolean;
923: begin

Line 958: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_COUNTRY'

954: hr_utility.set_location('Leaving:'||l_proc, 25);
955: exception
956: when app_exception.application_exception then
957: if hr_multi_message.exception_add
958: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_COUNTRY'
959: ) then
960: hr_utility.set_location('Leaving:'||l_proc, 30);
961: raise;
962: end if;

Line 994: in per_previous_employers.previous_employer_id%type

990: -- {End Of Comments}
991: -- ----------------------------------------------------------------------------
992: procedure chk_employer_type
993: (p_previous_employer_id
994: in per_previous_employers.previous_employer_id%type
995: ,p_object_version_number
996: in per_previous_employers.object_version_number%type
997: ,p_employer_type
998: in per_previous_employers.employer_type%type

Line 996: in per_previous_employers.object_version_number%type

992: procedure chk_employer_type
993: (p_previous_employer_id
994: in per_previous_employers.previous_employer_id%type
995: ,p_object_version_number
996: in per_previous_employers.object_version_number%type
997: ,p_employer_type
998: in per_previous_employers.employer_type%type
999: ,p_effective_date in date) is
1000: l_proc varchar2(72) := g_package||'chk_employer_type';

Line 998: in per_previous_employers.employer_type%type

994: in per_previous_employers.previous_employer_id%type
995: ,p_object_version_number
996: in per_previous_employers.object_version_number%type
997: ,p_employer_type
998: in per_previous_employers.employer_type%type
999: ,p_effective_date in date) is
1000: l_proc varchar2(72) := g_package||'chk_employer_type';
1001: l_no_lookup boolean;
1002: l_effective_date date := p_effective_date;

Line 1004: l_lookup_code per_previous_employers.employer_type%type

1000: l_proc varchar2(72) := g_package||'chk_employer_type';
1001: l_no_lookup boolean;
1002: l_effective_date date := p_effective_date;
1003: l_lookup_type fnd_lookups.lookup_type%type := 'PREV_EMP_TYPE';
1004: l_lookup_code per_previous_employers.employer_type%type
1005: := p_employer_type;
1006: l_api_updating boolean;
1007: begin
1008: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1040: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'

1036: hr_utility.set_location('Leaving:'||l_proc, 25);
1037: exception
1038: when app_exception.application_exception then
1039: if hr_multi_message.exception_add
1040: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'
1041: ) then
1042: hr_utility.set_location('Leaving:'||l_proc, 30);
1043: raise;
1044: end if;

Line 1077: in per_previous_employers.previous_employer_id%type

1073: -- {End Of Comments}
1074: -- ----------------------------------------------------------------------------
1075: procedure chk_employer_subtype
1076: (p_previous_employer_id
1077: in per_previous_employers.previous_employer_id%type
1078: ,p_object_version_number
1079: in per_previous_employers.object_version_number%type
1080: ,p_employer_type
1081: in per_previous_employers.employer_type%type

Line 1079: in per_previous_employers.object_version_number%type

1075: procedure chk_employer_subtype
1076: (p_previous_employer_id
1077: in per_previous_employers.previous_employer_id%type
1078: ,p_object_version_number
1079: in per_previous_employers.object_version_number%type
1080: ,p_employer_type
1081: in per_previous_employers.employer_type%type
1082: ,p_employer_subtype
1083: in per_previous_employers.employer_subtype%type

Line 1081: in per_previous_employers.employer_type%type

1077: in per_previous_employers.previous_employer_id%type
1078: ,p_object_version_number
1079: in per_previous_employers.object_version_number%type
1080: ,p_employer_type
1081: in per_previous_employers.employer_type%type
1082: ,p_employer_subtype
1083: in per_previous_employers.employer_subtype%type
1084: ,p_effective_date in date) is
1085: --

Line 1083: in per_previous_employers.employer_subtype%type

1079: in per_previous_employers.object_version_number%type
1080: ,p_employer_type
1081: in per_previous_employers.employer_type%type
1082: ,p_employer_subtype
1083: in per_previous_employers.employer_subtype%type
1084: ,p_effective_date in date) is
1085: --
1086: cursor csr_employer_subtype is
1087: select lookup_code

Line 1108: (p_check_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'

1104: --Only proceed with employer_subtype validation when multiple message list
1105: --does not already contain an error associated with employer type column.
1106: --
1107: if hr_multi_message.no_exclusive_error
1108: (p_check_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'
1109: ) then
1110: if p_employer_subtype is not null then
1111: hr_utility.set_location(l_proc, 10);
1112: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

Line 1156: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'

1152: hr_utility.set_location('Leaving:'||l_proc, 35);
1153: exception
1154: when app_exception.application_exception then
1155: if hr_multi_message.exception_add
1156: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'
1157: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE'
1158: ) then
1159: hr_utility.set_location('Leaving:'||l_proc, 40);
1160: raise;

Line 1157: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE'

1153: exception
1154: when app_exception.application_exception then
1155: if hr_multi_message.exception_add
1156: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'
1157: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE'
1158: ) then
1159: hr_utility.set_location('Leaving:'||l_proc, 40);
1160: raise;
1161: end if;

Line 1194: in per_previous_employers.previous_employer_id%type

1190: -- ----------------------------------------------------------------------------
1191: -- Bug 14316052
1192: procedure chk_start_end_dates
1193: (p_previous_employer_id
1194: in per_previous_employers.previous_employer_id%type
1195: ,p_object_version_number
1196: in per_previous_employers.object_version_number%type
1197: ,p_start_date
1198: in per_previous_employers.start_date%type

Line 1196: in per_previous_employers.object_version_number%type

1192: procedure chk_start_end_dates
1193: (p_previous_employer_id
1194: in per_previous_employers.previous_employer_id%type
1195: ,p_object_version_number
1196: in per_previous_employers.object_version_number%type
1197: ,p_start_date
1198: in per_previous_employers.start_date%type
1199: ,p_end_date
1200: in per_previous_employers.end_date%TYPE

Line 1198: in per_previous_employers.start_date%type

1194: in per_previous_employers.previous_employer_id%type
1195: ,p_object_version_number
1196: in per_previous_employers.object_version_number%type
1197: ,p_start_date
1198: in per_previous_employers.start_date%type
1199: ,p_end_date
1200: in per_previous_employers.end_date%TYPE
1201: ,p_effective_date
1202: IN per_previous_employers.start_date%type

Line 1200: in per_previous_employers.end_date%TYPE

1196: in per_previous_employers.object_version_number%type
1197: ,p_start_date
1198: in per_previous_employers.start_date%type
1199: ,p_end_date
1200: in per_previous_employers.end_date%TYPE
1201: ,p_effective_date
1202: IN per_previous_employers.start_date%type
1203: ,p_business_group_id
1204: IN per_previous_employers.business_group_id%TYPE

Line 1202: IN per_previous_employers.start_date%type

1198: in per_previous_employers.start_date%type
1199: ,p_end_date
1200: in per_previous_employers.end_date%TYPE
1201: ,p_effective_date
1202: IN per_previous_employers.start_date%type
1203: ,p_business_group_id
1204: IN per_previous_employers.business_group_id%TYPE
1205: ,p_employer_type
1206: IN per_previous_employers.employer_type%TYPE) is

Line 1204: IN per_previous_employers.business_group_id%TYPE

1200: in per_previous_employers.end_date%TYPE
1201: ,p_effective_date
1202: IN per_previous_employers.start_date%type
1203: ,p_business_group_id
1204: IN per_previous_employers.business_group_id%TYPE
1205: ,p_employer_type
1206: IN per_previous_employers.employer_type%TYPE) is
1207:
1208: l_proc varchar2(72) := g_package||'chk_start_end_dates';

Line 1206: IN per_previous_employers.employer_type%TYPE) is

1202: IN per_previous_employers.start_date%type
1203: ,p_business_group_id
1204: IN per_previous_employers.business_group_id%TYPE
1205: ,p_employer_type
1206: IN per_previous_employers.employer_type%TYPE) is
1207:
1208: l_proc varchar2(72) := g_package||'chk_start_end_dates';
1209: l_api_updating boolean;
1210:

Line 1266: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'

1262: hr_utility.set_location('Leaving:'||l_proc, 25);
1263: /*exception
1264: when app_exception.application_exception then
1265: if hr_multi_message.exception_add
1266: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'
1267: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.END_DATE'
1268: ) then
1269: hr_utility.set_location('Leaving:'||l_proc, 30);
1270: raise;

Line 1267: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.END_DATE'

1263: /*exception
1264: when app_exception.application_exception then
1265: if hr_multi_message.exception_add
1266: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'
1267: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.END_DATE'
1268: ) then
1269: hr_utility.set_location('Leaving:'||l_proc, 30);
1270: raise;
1271: end if;

Line 1303: in per_previous_employers.period_years%type

1299: -- {End Of Comments}
1300: -- ----------------------------------------------------------------------------
1301: procedure chk_period_years
1302: (p_period_years
1303: in per_previous_employers.period_years%type
1304: ,p_previous_employer_id
1305: in per_previous_employers.previous_employer_id%type
1306: ,p_object_version_number
1307: in per_previous_employers.object_version_number%type) is

Line 1305: in per_previous_employers.previous_employer_id%type

1301: procedure chk_period_years
1302: (p_period_years
1303: in per_previous_employers.period_years%type
1304: ,p_previous_employer_id
1305: in per_previous_employers.previous_employer_id%type
1306: ,p_object_version_number
1307: in per_previous_employers.object_version_number%type) is
1308: l_proc varchar2(72) := g_package||'chk_period_years';
1309: l_api_updating boolean;

Line 1307: in per_previous_employers.object_version_number%type) is

1303: in per_previous_employers.period_years%type
1304: ,p_previous_employer_id
1305: in per_previous_employers.previous_employer_id%type
1306: ,p_object_version_number
1307: in per_previous_employers.object_version_number%type) is
1308: l_proc varchar2(72) := g_package||'chk_period_years';
1309: l_api_updating boolean;
1310: begin
1311: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1340: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS'

1336: hr_utility.set_location('Leaving:'||l_proc, 25);
1337: exception
1338: when app_exception.application_exception then
1339: if hr_multi_message.exception_add
1340: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS'
1341: ) then
1342: hr_utility.set_location('Leaving:'||l_proc, 30);
1343: raise;
1344: end if;

Line 1376: in per_previous_employers.period_months%type

1372: -- {End Of Comments}
1373: -- ----------------------------------------------------------------------------
1374: procedure chk_period_months
1375: (p_period_months
1376: in per_previous_employers.period_months%type
1377: ,p_previous_employer_id
1378: in per_previous_employers.previous_employer_id%type
1379: ,p_object_version_number
1380: in per_previous_employers.object_version_number%type) is

Line 1378: in per_previous_employers.previous_employer_id%type

1374: procedure chk_period_months
1375: (p_period_months
1376: in per_previous_employers.period_months%type
1377: ,p_previous_employer_id
1378: in per_previous_employers.previous_employer_id%type
1379: ,p_object_version_number
1380: in per_previous_employers.object_version_number%type) is
1381: l_proc varchar2(72) := g_package||'chk_period_months';
1382: l_api_updating boolean;

Line 1380: in per_previous_employers.object_version_number%type) is

1376: in per_previous_employers.period_months%type
1377: ,p_previous_employer_id
1378: in per_previous_employers.previous_employer_id%type
1379: ,p_object_version_number
1380: in per_previous_employers.object_version_number%type) is
1381: l_proc varchar2(72) := g_package||'chk_period_months';
1382: l_api_updating boolean;
1383: begin
1384: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1413: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS'

1409: hr_utility.set_location('Leaving:'||l_proc, 25);
1410: exception
1411: when app_exception.application_exception then
1412: if hr_multi_message.exception_add
1413: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS'
1414: ) then
1415: hr_utility.set_location('Leaving:'||l_proc, 30);
1416: raise;
1417: end if;

Line 1449: in per_previous_employers.period_days%type

1445: -- {End Of Comments}
1446: -- ----------------------------------------------------------------------------
1447: procedure chk_period_days
1448: (p_period_days
1449: in per_previous_employers.period_days%type
1450: ,p_previous_employer_id
1451: in per_previous_employers.previous_employer_id%type
1452: ,p_object_version_number
1453: in per_previous_employers.object_version_number%type) is

Line 1451: in per_previous_employers.previous_employer_id%type

1447: procedure chk_period_days
1448: (p_period_days
1449: in per_previous_employers.period_days%type
1450: ,p_previous_employer_id
1451: in per_previous_employers.previous_employer_id%type
1452: ,p_object_version_number
1453: in per_previous_employers.object_version_number%type) is
1454: l_proc varchar2(72) := g_package||'chk_period_days';
1455: l_api_updating boolean;

Line 1453: in per_previous_employers.object_version_number%type) is

1449: in per_previous_employers.period_days%type
1450: ,p_previous_employer_id
1451: in per_previous_employers.previous_employer_id%type
1452: ,p_object_version_number
1453: in per_previous_employers.object_version_number%type) is
1454: l_proc varchar2(72) := g_package||'chk_period_days';
1455: l_api_updating boolean;
1456: begin
1457: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1486: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS'

1482: hr_utility.set_location('Leaving:'||l_proc, 25);
1483: exception
1484: when app_exception.application_exception then
1485: if hr_multi_message.exception_add
1486: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS'
1487: ) then
1488: hr_utility.set_location('Leaving:'||l_proc, 30);
1489: raise;
1490: end if;

Line 1526: in per_previous_employers.previous_employer_id%type

1522: -- {End Of Comments}
1523: -- ----------------------------------------------------------------------------
1524: procedure chk_all_assignments
1525: (p_previous_employer_id
1526: in per_previous_employers.previous_employer_id%type
1527: ,p_object_version_number
1528: in per_previous_employers.object_version_number%type
1529: ,p_all_assignments
1530: in per_previous_employers.all_assignments%type) is

Line 1528: in per_previous_employers.object_version_number%type

1524: procedure chk_all_assignments
1525: (p_previous_employer_id
1526: in per_previous_employers.previous_employer_id%type
1527: ,p_object_version_number
1528: in per_previous_employers.object_version_number%type
1529: ,p_all_assignments
1530: in per_previous_employers.all_assignments%type) is
1531: cursor csr_pem_assignments is
1532: select previous_job_usage_id

Line 1530: in per_previous_employers.all_assignments%type) is

1526: in per_previous_employers.previous_employer_id%type
1527: ,p_object_version_number
1528: in per_previous_employers.object_version_number%type
1529: ,p_all_assignments
1530: in per_previous_employers.all_assignments%type) is
1531: cursor csr_pem_assignments is
1532: select previous_job_usage_id
1533: from per_previous_job_usages
1534: where previous_employer_id = p_previous_employer_id;

Line 1567: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PREVIOUS_EMPLOYER_ID'

1563: hr_utility.set_location(l_proc, 30);
1564: close csr_pem_assignments;
1565: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1566: hr_multi_message.add
1567: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PREVIOUS_EMPLOYER_ID'
1568: );
1569: end if;
1570: if csr_pem_assignments%isopen then
1571: close csr_pem_assignments;

Line 1578: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.ALL_ASSIGNMENTS'

1574: else
1575: hr_utility.set_location(l_proc, 35);
1576: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1577: hr_multi_message.add
1578: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.ALL_ASSIGNMENTS'
1579: );
1580: end if;
1581: end if;
1582: end if;

Line 1618: in per_previous_employers.business_group_id%type

1614: -- {End Of Comments}
1615: -- ----------------------------------------------------------------------------
1616: procedure chk_business_group_id
1617: (p_business_group_id
1618: in per_previous_employers.business_group_id%type
1619: ,p_previous_employer_id
1620: in per_previous_employers.previous_employer_id%type
1621: ,p_object_version_number
1622: in per_previous_employers.object_version_number%type

Line 1620: in per_previous_employers.previous_employer_id%type

1616: procedure chk_business_group_id
1617: (p_business_group_id
1618: in per_previous_employers.business_group_id%type
1619: ,p_previous_employer_id
1620: in per_previous_employers.previous_employer_id%type
1621: ,p_object_version_number
1622: in per_previous_employers.object_version_number%type
1623: ,p_effective_date in date) is
1624: --

Line 1622: in per_previous_employers.object_version_number%type

1618: in per_previous_employers.business_group_id%type
1619: ,p_previous_employer_id
1620: in per_previous_employers.previous_employer_id%type
1621: ,p_object_version_number
1622: in per_previous_employers.object_version_number%type
1623: ,p_effective_date in date) is
1624: --
1625: l_proc varchar2(72) := g_package||'chk_business_group_id';
1626: l_api_updating boolean;

Line 1658: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.BUSINESS_GROUP_ID'

1654: hr_utility.set_location('Leaving:'||l_proc, 40);
1655: exception
1656: when app_exception.application_exception then
1657: if hr_multi_message.exception_add
1658: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.BUSINESS_GROUP_ID'
1659: ) then
1660: hr_utility.set_location('Leaving:'||l_proc, 50);
1661: raise;
1662: end if;