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 104: , per_previous_employers pem

100: --
101: cursor csr_sec_grp is
102: select pbg.security_group_id
103: from per_business_groups pbg
104: , per_previous_employers pem
105: where pem.previous_employer_id = p_previous_employer_id
106: and pbg.business_group_id = pem.business_group_id;
107: --
108: -- Declare local variables

Line 166: , per_previous_employers pem

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

Line 511: ,p_descflex_name => 'PER_PREVIOUS_EMPLOYERS'

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

Line 712: in per_previous_employers.person_id%type

708: --
709: -- {End Of Comments}
710: -- ----------------------------------------------------------------------------
711: procedure chk_person_id(p_person_id
712: in per_previous_employers.person_id%type
713: ,p_previous_employer_id
714: in per_previous_employers.previous_employer_id%type
715: ,p_object_version_number
716: in per_previous_employers.object_version_number%type

Line 714: in per_previous_employers.previous_employer_id%type

710: -- ----------------------------------------------------------------------------
711: procedure chk_person_id(p_person_id
712: in per_previous_employers.person_id%type
713: ,p_previous_employer_id
714: in per_previous_employers.previous_employer_id%type
715: ,p_object_version_number
716: in per_previous_employers.object_version_number%type
717: ,p_effective_date
718: in date)

Line 716: in per_previous_employers.object_version_number%type

712: in per_previous_employers.person_id%type
713: ,p_previous_employer_id
714: in per_previous_employers.previous_employer_id%type
715: ,p_object_version_number
716: in per_previous_employers.object_version_number%type
717: ,p_effective_date
718: in date)
719: is
720: -- Define the cursor for the person_id

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

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

Line 821: in per_previous_employers.party_id%type

817: --
818: -- {End Of Comments}
819: -- ----------------------------------------------------------------------------
820: procedure chk_party_id(p_party_id
821: in per_previous_employers.party_id%type
822: ,p_previous_employer_id
823: in per_previous_employers.previous_employer_id%type
824: ,p_object_version_number
825: in per_previous_employers.object_version_number%type) is

Line 823: in per_previous_employers.previous_employer_id%type

819: -- ----------------------------------------------------------------------------
820: procedure chk_party_id(p_party_id
821: in per_previous_employers.party_id%type
822: ,p_previous_employer_id
823: in per_previous_employers.previous_employer_id%type
824: ,p_object_version_number
825: in per_previous_employers.object_version_number%type) is
826: --Define the cursor for party_id
827: cursor csr_party_id is

Line 825: in per_previous_employers.object_version_number%type) is

821: in per_previous_employers.party_id%type
822: ,p_previous_employer_id
823: in per_previous_employers.previous_employer_id%type
824: ,p_object_version_number
825: in per_previous_employers.object_version_number%type) is
826: --Define the cursor for party_id
827: cursor csr_party_id is
828: select party_id
829: from hz_parties

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

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

Line 906: in per_previous_employers.previous_employer_id%type

902: -- {End Of Comments}
903: -- ----------------------------------------------------------------------------
904: procedure chk_employer_country
905: (p_previous_employer_id
906: in per_previous_employers.previous_employer_id%type
907: ,p_object_version_number
908: in per_previous_employers.object_version_number%type
909: ,p_employer_country
910: in per_previous_employers.employer_country%type) is

Line 908: in per_previous_employers.object_version_number%type

904: procedure chk_employer_country
905: (p_previous_employer_id
906: in per_previous_employers.previous_employer_id%type
907: ,p_object_version_number
908: in per_previous_employers.object_version_number%type
909: ,p_employer_country
910: in per_previous_employers.employer_country%type) is
911: cursor csr_employer_country is
912: select territory_code

Line 910: in per_previous_employers.employer_country%type) is

906: in per_previous_employers.previous_employer_id%type
907: ,p_object_version_number
908: in per_previous_employers.object_version_number%type
909: ,p_employer_country
910: in per_previous_employers.employer_country%type) is
911: cursor csr_employer_country is
912: select territory_code
913: from fnd_territories_vl
914: where territory_code = p_employer_country;

Line 915: l_employer_country per_previous_employers.employer_country%type;

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

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

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

Line 990: in per_previous_employers.previous_employer_id%type

986: -- {End Of Comments}
987: -- ----------------------------------------------------------------------------
988: procedure chk_employer_type
989: (p_previous_employer_id
990: in per_previous_employers.previous_employer_id%type
991: ,p_object_version_number
992: in per_previous_employers.object_version_number%type
993: ,p_employer_type
994: in per_previous_employers.employer_type%type

Line 992: in per_previous_employers.object_version_number%type

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

Line 994: in per_previous_employers.employer_type%type

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

Line 1000: l_lookup_code per_previous_employers.employer_type%type

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

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

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

Line 1073: in per_previous_employers.previous_employer_id%type

1069: -- {End Of Comments}
1070: -- ----------------------------------------------------------------------------
1071: procedure chk_employer_subtype
1072: (p_previous_employer_id
1073: in per_previous_employers.previous_employer_id%type
1074: ,p_object_version_number
1075: in per_previous_employers.object_version_number%type
1076: ,p_employer_type
1077: in per_previous_employers.employer_type%type

Line 1075: in per_previous_employers.object_version_number%type

1071: procedure chk_employer_subtype
1072: (p_previous_employer_id
1073: in per_previous_employers.previous_employer_id%type
1074: ,p_object_version_number
1075: in per_previous_employers.object_version_number%type
1076: ,p_employer_type
1077: in per_previous_employers.employer_type%type
1078: ,p_employer_subtype
1079: in per_previous_employers.employer_subtype%type

Line 1077: in per_previous_employers.employer_type%type

1073: in per_previous_employers.previous_employer_id%type
1074: ,p_object_version_number
1075: in per_previous_employers.object_version_number%type
1076: ,p_employer_type
1077: in per_previous_employers.employer_type%type
1078: ,p_employer_subtype
1079: in per_previous_employers.employer_subtype%type
1080: ,p_effective_date in date) is
1081: --

Line 1079: in per_previous_employers.employer_subtype%type

1075: in per_previous_employers.object_version_number%type
1076: ,p_employer_type
1077: in per_previous_employers.employer_type%type
1078: ,p_employer_subtype
1079: in per_previous_employers.employer_subtype%type
1080: ,p_effective_date in date) is
1081: --
1082: cursor csr_employer_subtype is
1083: select lookup_code

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

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

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

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

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

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

Line 1189: in per_previous_employers.previous_employer_id%type

1185: -- {End Of Comments}
1186: -- ----------------------------------------------------------------------------
1187: procedure chk_start_end_dates
1188: (p_previous_employer_id
1189: in per_previous_employers.previous_employer_id%type
1190: ,p_object_version_number
1191: in per_previous_employers.object_version_number%type
1192: ,p_start_date
1193: in per_previous_employers.start_date%type

Line 1191: in per_previous_employers.object_version_number%type

1187: procedure chk_start_end_dates
1188: (p_previous_employer_id
1189: in per_previous_employers.previous_employer_id%type
1190: ,p_object_version_number
1191: in per_previous_employers.object_version_number%type
1192: ,p_start_date
1193: in per_previous_employers.start_date%type
1194: ,p_end_date
1195: in per_previous_employers.end_date%TYPE

Line 1193: in per_previous_employers.start_date%type

1189: in per_previous_employers.previous_employer_id%type
1190: ,p_object_version_number
1191: in per_previous_employers.object_version_number%type
1192: ,p_start_date
1193: in per_previous_employers.start_date%type
1194: ,p_end_date
1195: in per_previous_employers.end_date%TYPE
1196: ,p_effective_date
1197: IN per_previous_employers.start_date%type) is

Line 1195: in per_previous_employers.end_date%TYPE

1191: in per_previous_employers.object_version_number%type
1192: ,p_start_date
1193: in per_previous_employers.start_date%type
1194: ,p_end_date
1195: in per_previous_employers.end_date%TYPE
1196: ,p_effective_date
1197: IN per_previous_employers.start_date%type) is
1198: l_proc varchar2(72) := g_package||'chk_start_end_dates';
1199: l_api_updating boolean;

Line 1197: IN per_previous_employers.start_date%type) is

1193: in per_previous_employers.start_date%type
1194: ,p_end_date
1195: in per_previous_employers.end_date%TYPE
1196: ,p_effective_date
1197: IN per_previous_employers.start_date%type) is
1198: l_proc varchar2(72) := g_package||'chk_start_end_dates';
1199: l_api_updating boolean;
1200: begin
1201: hr_utility.set_location('Entering:'||l_proc, 5);

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

1238: hr_utility.set_location('Leaving:'||l_proc, 25);
1239: /*exception
1240: when app_exception.application_exception then
1241: if hr_multi_message.exception_add
1242: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'
1243: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.END_DATE'
1244: ) then
1245: hr_utility.set_location('Leaving:'||l_proc, 30);
1246: raise;

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

1239: /*exception
1240: when app_exception.application_exception then
1241: if hr_multi_message.exception_add
1242: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'
1243: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.END_DATE'
1244: ) then
1245: hr_utility.set_location('Leaving:'||l_proc, 30);
1246: raise;
1247: end if;

Line 1279: in per_previous_employers.period_years%type

1275: -- {End Of Comments}
1276: -- ----------------------------------------------------------------------------
1277: procedure chk_period_years
1278: (p_period_years
1279: in per_previous_employers.period_years%type
1280: ,p_previous_employer_id
1281: in per_previous_employers.previous_employer_id%type
1282: ,p_object_version_number
1283: in per_previous_employers.object_version_number%type) is

Line 1281: in per_previous_employers.previous_employer_id%type

1277: procedure chk_period_years
1278: (p_period_years
1279: in per_previous_employers.period_years%type
1280: ,p_previous_employer_id
1281: in per_previous_employers.previous_employer_id%type
1282: ,p_object_version_number
1283: in per_previous_employers.object_version_number%type) is
1284: l_proc varchar2(72) := g_package||'chk_period_years';
1285: l_api_updating boolean;

Line 1283: in per_previous_employers.object_version_number%type) is

1279: in per_previous_employers.period_years%type
1280: ,p_previous_employer_id
1281: in per_previous_employers.previous_employer_id%type
1282: ,p_object_version_number
1283: in per_previous_employers.object_version_number%type) is
1284: l_proc varchar2(72) := g_package||'chk_period_years';
1285: l_api_updating boolean;
1286: begin
1287: hr_utility.set_location('Entering:'||l_proc, 5);

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

1312: hr_utility.set_location('Leaving:'||l_proc, 25);
1313: exception
1314: when app_exception.application_exception then
1315: if hr_multi_message.exception_add
1316: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS'
1317: ) then
1318: hr_utility.set_location('Leaving:'||l_proc, 30);
1319: raise;
1320: end if;

Line 1352: in per_previous_employers.period_months%type

1348: -- {End Of Comments}
1349: -- ----------------------------------------------------------------------------
1350: procedure chk_period_months
1351: (p_period_months
1352: in per_previous_employers.period_months%type
1353: ,p_previous_employer_id
1354: in per_previous_employers.previous_employer_id%type
1355: ,p_object_version_number
1356: in per_previous_employers.object_version_number%type) is

Line 1354: in per_previous_employers.previous_employer_id%type

1350: procedure chk_period_months
1351: (p_period_months
1352: in per_previous_employers.period_months%type
1353: ,p_previous_employer_id
1354: in per_previous_employers.previous_employer_id%type
1355: ,p_object_version_number
1356: in per_previous_employers.object_version_number%type) is
1357: l_proc varchar2(72) := g_package||'chk_period_months';
1358: l_api_updating boolean;

Line 1356: in per_previous_employers.object_version_number%type) is

1352: in per_previous_employers.period_months%type
1353: ,p_previous_employer_id
1354: in per_previous_employers.previous_employer_id%type
1355: ,p_object_version_number
1356: in per_previous_employers.object_version_number%type) is
1357: l_proc varchar2(72) := g_package||'chk_period_months';
1358: l_api_updating boolean;
1359: begin
1360: hr_utility.set_location('Entering:'||l_proc, 5);

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

1385: hr_utility.set_location('Leaving:'||l_proc, 25);
1386: exception
1387: when app_exception.application_exception then
1388: if hr_multi_message.exception_add
1389: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS'
1390: ) then
1391: hr_utility.set_location('Leaving:'||l_proc, 30);
1392: raise;
1393: end if;

Line 1425: in per_previous_employers.period_days%type

1421: -- {End Of Comments}
1422: -- ----------------------------------------------------------------------------
1423: procedure chk_period_days
1424: (p_period_days
1425: in per_previous_employers.period_days%type
1426: ,p_previous_employer_id
1427: in per_previous_employers.previous_employer_id%type
1428: ,p_object_version_number
1429: in per_previous_employers.object_version_number%type) is

Line 1427: in per_previous_employers.previous_employer_id%type

1423: procedure chk_period_days
1424: (p_period_days
1425: in per_previous_employers.period_days%type
1426: ,p_previous_employer_id
1427: in per_previous_employers.previous_employer_id%type
1428: ,p_object_version_number
1429: in per_previous_employers.object_version_number%type) is
1430: l_proc varchar2(72) := g_package||'chk_period_days';
1431: l_api_updating boolean;

Line 1429: in per_previous_employers.object_version_number%type) is

1425: in per_previous_employers.period_days%type
1426: ,p_previous_employer_id
1427: in per_previous_employers.previous_employer_id%type
1428: ,p_object_version_number
1429: in per_previous_employers.object_version_number%type) is
1430: l_proc varchar2(72) := g_package||'chk_period_days';
1431: l_api_updating boolean;
1432: begin
1433: hr_utility.set_location('Entering:'||l_proc, 5);

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

1458: hr_utility.set_location('Leaving:'||l_proc, 25);
1459: exception
1460: when app_exception.application_exception then
1461: if hr_multi_message.exception_add
1462: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS'
1463: ) then
1464: hr_utility.set_location('Leaving:'||l_proc, 30);
1465: raise;
1466: end if;

Line 1502: in per_previous_employers.previous_employer_id%type

1498: -- {End Of Comments}
1499: -- ----------------------------------------------------------------------------
1500: procedure chk_all_assignments
1501: (p_previous_employer_id
1502: in per_previous_employers.previous_employer_id%type
1503: ,p_object_version_number
1504: in per_previous_employers.object_version_number%type
1505: ,p_all_assignments
1506: in per_previous_employers.all_assignments%type) is

Line 1504: in per_previous_employers.object_version_number%type

1500: procedure chk_all_assignments
1501: (p_previous_employer_id
1502: in per_previous_employers.previous_employer_id%type
1503: ,p_object_version_number
1504: in per_previous_employers.object_version_number%type
1505: ,p_all_assignments
1506: in per_previous_employers.all_assignments%type) is
1507: cursor csr_pem_assignments is
1508: select previous_job_usage_id

Line 1506: in per_previous_employers.all_assignments%type) is

1502: in per_previous_employers.previous_employer_id%type
1503: ,p_object_version_number
1504: in per_previous_employers.object_version_number%type
1505: ,p_all_assignments
1506: in per_previous_employers.all_assignments%type) is
1507: cursor csr_pem_assignments is
1508: select previous_job_usage_id
1509: from per_previous_job_usages
1510: where previous_employer_id = p_previous_employer_id;

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

1539: hr_utility.set_location(l_proc, 30);
1540: close csr_pem_assignments;
1541: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1542: hr_multi_message.add
1543: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PREVIOUS_EMPLOYER_ID'
1544: );
1545: end if;
1546: if csr_pem_assignments%isopen then
1547: close csr_pem_assignments;

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

1550: else
1551: hr_utility.set_location(l_proc, 35);
1552: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1553: hr_multi_message.add
1554: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.ALL_ASSIGNMENTS'
1555: );
1556: end if;
1557: end if;
1558: end if;

Line 1594: in per_previous_employers.business_group_id%type

1590: -- {End Of Comments}
1591: -- ----------------------------------------------------------------------------
1592: procedure chk_business_group_id
1593: (p_business_group_id
1594: in per_previous_employers.business_group_id%type
1595: ,p_previous_employer_id
1596: in per_previous_employers.previous_employer_id%type
1597: ,p_object_version_number
1598: in per_previous_employers.object_version_number%type

Line 1596: in per_previous_employers.previous_employer_id%type

1592: procedure chk_business_group_id
1593: (p_business_group_id
1594: in per_previous_employers.business_group_id%type
1595: ,p_previous_employer_id
1596: in per_previous_employers.previous_employer_id%type
1597: ,p_object_version_number
1598: in per_previous_employers.object_version_number%type
1599: ,p_effective_date in date) is
1600: --

Line 1598: in per_previous_employers.object_version_number%type

1594: in per_previous_employers.business_group_id%type
1595: ,p_previous_employer_id
1596: in per_previous_employers.previous_employer_id%type
1597: ,p_object_version_number
1598: in per_previous_employers.object_version_number%type
1599: ,p_effective_date in date) is
1600: --
1601: l_proc varchar2(72) := g_package||'chk_business_group_id';
1602: l_api_updating boolean;

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

1630: hr_utility.set_location('Leaving:'||l_proc, 40);
1631: exception
1632: when app_exception.application_exception then
1633: if hr_multi_message.exception_add
1634: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.BUSINESS_GROUP_ID'
1635: ) then
1636: hr_utility.set_location('Leaving:'||l_proc, 50);
1637: raise;
1638: end if;