[Home] [Help]
306: end if;
307: --
308: -- 4888485 Ends here
309: --
310: per_asg_bus2.chk_system_pers_type
311: (p_person_id => per_asg_shd.g_old_rec.person_id
312: ,p_validation_start_date => p_validation_start_date
313: ,p_validation_end_date => p_validation_end_date
314: ,p_datetrack_mode => p_datetrack_mode
318: if g_debug then
319: hr_utility.set_location(l_proc, 6);
320: end if;
321: --
322: per_asg_bus2.chk_ref_int_del
323: (p_assignment_id => p_rec.assignment_id
324: ,p_validation_start_date => p_validation_start_date
325: ,p_validation_end_date => p_validation_end_date
326: ,p_datetrack_mode => p_datetrack_mode
345: if g_debug then
346: hr_utility.set_location(l_proc, 9);
347: end if;
348: --
349: per_asg_bus2.chk_term_status
350: (p_assignment_id => p_rec.assignment_id
351: ,p_datetrack_mode => p_datetrack_mode
352: ,p_validation_start_date => p_validation_start_date
353: );
366: if g_debug then
367: hr_utility.set_location(l_proc, 20);
368: end if;
369: --
370: per_asg_bus2.chk_payroll_id
371: (p_assignment_id => p_rec.assignment_id
372: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
373: ,p_person_id => per_asg_shd.g_old_rec.person_id
374: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
1028: if g_debug then
1029: hr_utility.set_location(l_proc, 15);
1030: end if;
1031: --
1032: -- per_asg_bus2.chk_title (p_title => p_rec.title);
1033: --
1034: per_asg_bus2.chk_dup_apl_vacancy
1035: (p_person_id => p_rec.person_id
1036: ,p_business_group_id => p_rec.business_group_id
1030: end if;
1031: --
1032: -- per_asg_bus2.chk_title (p_title => p_rec.title);
1033: --
1034: per_asg_bus2.chk_dup_apl_vacancy
1035: (p_person_id => p_rec.person_id
1036: ,p_business_group_id => p_rec.business_group_id
1037: ,p_vacancy_id => p_rec.vacancy_id
1038: ,p_effective_date => p_effective_date
1041: if g_debug then
1042: hr_utility.set_location(l_proc, 22);
1043: end if;
1044: --
1045: per_asg_bus2.chk_time_finish_formatted --#2734822
1046: (p_time_normal_finish => p_rec.time_normal_finish
1047: );
1048: if g_debug then
1049: hr_utility.set_location(l_proc, 25);
1048: if g_debug then
1049: hr_utility.set_location(l_proc, 25);
1050: end if;
1051: --
1052: per_asg_bus2.chk_time_start_formatted --#2734822
1053: (p_time_normal_start => p_rec.time_normal_start
1054: );
1055: if g_debug then
1056: hr_utility.set_location(l_proc, 27);
1069: end if;
1070: --
1071: hr_multi_message.end_validation_set;
1072: --
1073: per_asg_bus2.chk_probation_unit
1074: (p_assignment_id => p_rec.assignment_id
1075: ,p_probation_unit => p_rec.probation_unit
1076: ,p_effective_date => p_effective_date
1077: ,p_validation_start_date => p_validation_start_date
1081: if g_debug then
1082: hr_utility.set_location(l_proc, 40);
1083: end if;
1084: --
1085: per_asg_bus2.chk_probation_period
1086: (p_assignment_id => p_rec.assignment_id
1087: ,p_probation_period => p_rec.probation_period
1088: ,p_effective_date => p_effective_date
1089: ,p_object_version_number => p_rec.object_version_number
1091: if g_debug then
1092: hr_utility.set_location(l_proc, 50);
1093: end if;
1094: --
1095: per_asg_bus2.chk_prob_unit_prob_period
1096: (p_assignment_id => p_rec.assignment_id
1097: ,p_probation_unit => p_rec.probation_unit
1098: ,p_probation_period => p_rec.probation_period
1099: ,p_effective_date => p_effective_date
1116:
1117: --- Fix For Bug # 7481310 Starts ---
1118: if NOT (NVL(l_source_type,'IREC') = NVL(p_rec.source_type,'IREC') AND p_rec.assignment_type = 'O') then
1119: --
1120: per_asg_bus2.chk_source_type
1121: (p_assignment_id => p_rec.assignment_id
1122: ,p_source_type => p_rec.source_type
1123: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1124: ,p_effective_date => p_effective_date
1145: if g_debug then
1146: hr_utility.set_location(l_proc, 80);
1147: end if;
1148: --
1149: per_asg_bus2.chk_internal_address_line
1150: (p_assignment_id => p_rec.assignment_id
1151: ,p_assignment_type => p_rec.assignment_type
1152: ,p_internal_address_line => p_rec.internal_address_line
1153: ,p_effective_date => p_effective_date
1194: if g_debug then
1195: hr_utility.set_location(l_proc, 120);
1196: end if;
1197: --
1198: per_asg_bus2.chk_sal_review_period
1199: (p_assignment_id => p_rec.assignment_id
1200: ,p_sal_review_period => p_rec.sal_review_period
1201: ,p_assignment_type => p_rec.assignment_type
1202: ,p_effective_date => p_effective_date
1205: if g_debug then
1206: hr_utility.set_location(l_proc, 130);
1207: end if;
1208: --
1209: per_asg_bus2.chk_sal_review_period_freq
1210: (p_assignment_id => p_rec.assignment_id
1211: ,p_sal_review_period_frequency => p_rec.sal_review_period_frequency
1212: ,p_assignment_type => p_rec.assignment_type
1213: ,p_effective_date => p_effective_date
1218: if g_debug then
1219: hr_utility.set_location(l_proc, 140);
1220: end if;
1221: --
1222: per_asg_bus2.chk_sal_rp_freq_sal_rp
1223: (p_assignment_id => p_rec.assignment_id
1224: ,p_sal_review_period_frequency => p_rec.sal_review_period_frequency
1225: ,p_sal_review_period => p_rec.sal_review_period
1226: ,p_effective_date => p_effective_date
1229: if g_debug then
1230: hr_utility.set_location(l_proc, 150);
1231: end if;
1232: --
1233: per_asg_bus2.chk_perf_review_period
1234: (p_assignment_id => p_rec.assignment_id
1235: ,p_perf_review_period => p_rec.perf_review_period
1236: ,p_assignment_type => p_rec.assignment_type
1237: ,p_effective_date => p_effective_date
1240: if g_debug then
1241: hr_utility.set_location(l_proc, 160);
1242: end if;
1243: --
1244: per_asg_bus2.chk_perf_review_period_freq
1245: (p_assignment_id => p_rec.assignment_id
1246: ,p_perf_review_period_frequency => p_rec.perf_review_period_frequency
1247: ,p_assignment_type => p_rec.assignment_type
1248: ,p_effective_date => p_effective_date
1253: if g_debug then
1254: hr_utility.set_location(l_proc, 170);
1255: end if;
1256: --
1257: per_asg_bus2.chk_perf_rp_freq_perf_rp
1258: (p_assignment_id => p_rec.assignment_id
1259: ,p_perf_review_period_frequency => p_rec.perf_review_period_frequency
1260: ,p_perf_review_period => p_rec.perf_review_period
1261: ,p_effective_date => p_effective_date
1287: if g_debug then
1288: hr_utility.set_location(l_proc, 200);
1289: end if;
1290: --
1291: per_asg_bus2.chk_set_of_books_id
1292: (p_assignment_id => p_rec.assignment_id
1293: ,p_assignment_type => p_rec.assignment_type
1294: ,p_business_group_id => p_rec.business_group_id
1295: ,p_set_of_books_id => p_rec.set_of_books_id
1299: if g_debug then
1300: hr_utility.set_location(l_proc, 210);
1301: end if;
1302: --
1303: per_asg_bus2.chk_source_organization_id
1304: (p_assignment_id => p_rec.assignment_id
1305: ,p_assignment_type => p_rec.assignment_type
1306: ,p_business_group_id => p_rec.business_group_id
1307: ,p_source_organization_id => p_rec.source_organization_id
1313: if g_debug then
1314: hr_utility.set_location(l_proc, 230);
1315: end if;
1316: --
1317: per_asg_bus2.chk_soft_coding_keyflex_id
1318: (p_assignment_id => p_rec.assignment_id
1319: ,p_assignment_type => p_rec.assignment_type
1320: ,p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id
1321: ,p_effective_date => p_effective_date
1327: if g_debug then
1328: hr_utility.set_location(l_proc, 240);
1329: end if;
1330: --
1331: per_asg_bus2.chk_pay_basis_id
1332: (p_assignment_id => p_rec.assignment_id
1333: ,p_pay_basis_id => p_rec.pay_basis_id
1334: ,p_assignment_type => p_rec.assignment_type
1335: ,p_business_group_id => p_rec.business_group_id
1340: if g_debug then
1341: hr_utility.set_location(l_proc, 250);
1342: end if;
1343: --
1344: per_asg_bus2.chk_recruitment_activity_id
1345: (p_assignment_id => p_rec.assignment_id
1346: ,p_assignment_type => p_rec.assignment_type
1347: ,p_business_group_id => p_rec.business_group_id
1348: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1354: if g_debug then
1355: hr_utility.set_location(l_proc, 260);
1356: end if;
1357: --
1358: per_asg_bus2.chk_vacancy_id
1359: (p_assignment_id => p_rec.assignment_id
1360: ,p_assignment_type => p_rec.assignment_type
1361: ,p_business_group_id => p_rec.business_group_id
1362: ,p_vacancy_id => p_rec.vacancy_id
1382: if g_debug then
1383: hr_utility.set_location(l_proc, 280);
1384: end if;
1385: --
1386: per_asg_bus2.chk_people_group_id
1387: (p_assignment_id => p_rec.assignment_id
1388: ,p_business_group_id => p_rec.business_group_id
1389: ,p_assignment_type => p_rec.assignment_type
1390: ,p_people_group_id => p_rec.people_group_id
1403: end if;
1404: if g_debug then
1405: hr_utility.set_location(p_validation_end_date, 290);
1406: end if;
1407: per_asg_bus2.chk_position_id
1408: (p_assignment_id => p_rec.assignment_id
1409: ,p_position_id => p_rec.position_id
1410: ,p_business_group_id => p_rec.business_group_id
1411: ,p_assignment_type => p_rec.assignment_type
1443: if g_debug then
1444: hr_utility.set_location(l_proc, 310);
1445: end if;
1446: --
1447: per_asg_bus2.chk_position_id_job_id
1448: (p_assignment_id => p_rec.assignment_id
1449: ,p_position_id => p_rec.position_id
1450: ,p_job_id => p_rec.job_id
1451: ,p_validation_start_date => p_validation_start_date
1472: if g_debug then
1473: hr_utility.set_location(l_proc, 330);
1474: end if;
1475: --
1476: per_asg_bus2.chk_special_ceiling_step_id
1477: (p_assignment_id => p_rec.assignment_id
1478: ,p_assignment_type => p_rec.assignment_type
1479: ,p_special_ceiling_step_id => p_rec.special_ceiling_step_id
1480: ,p_grade_id => p_rec.grade_id
1487: if g_debug then
1488: hr_utility.set_location(l_proc, 340);
1489: end if;
1490: --
1491: per_asg_bus2.chk_position_id_grade_id
1492: (p_assignment_id => p_rec.assignment_id
1493: ,p_position_id => p_rec.position_id
1494: ,p_grade_id => p_rec.grade_id
1495: ,p_validation_start_date => p_validation_start_date
1515: if g_debug then
1516: hr_utility.set_location(l_proc, 360);
1517: end if;
1518: --
1519: per_asg_bus2.chk_person_id
1520: (p_person_id => p_rec.person_id
1521: ,p_business_group_id => p_rec.business_group_id
1522: ,p_effective_date => p_effective_date
1523: );
1524: if g_debug then
1525: hr_utility.set_location(l_proc, 370);
1526: end if;
1527: --
1528: per_asg_bus2.chk_supervisor_id
1529: (p_assignment_id => p_rec.assignment_id
1530: ,p_supervisor_id => p_rec.supervisor_id
1531: ,p_person_id => p_rec.person_id
1532: ,p_business_group_id => p_rec.business_group_id
1537: if g_debug then
1538: hr_utility.set_location(l_proc, 375);
1539: end if;
1540: --
1541: per_asg_bus2.chk_supervisor_assignment_id
1542: (p_assignment_id => p_rec.assignment_id
1543: ,p_supervisor_id => p_rec.supervisor_id
1544: ,p_supervisor_assignment_id => p_rec.supervisor_assignment_id
1545: ,p_validation_start_date => p_validation_start_date
1549: if g_debug then
1550: hr_utility.set_location(l_proc, 380);
1551: end if;
1552: --
1553: per_asg_bus2.chk_person_referred_by_id
1554: (p_assignment_id => p_rec.assignment_id
1555: ,p_assignment_type => p_rec.assignment_type
1556: ,p_person_id => p_rec.person_id
1557: ,p_person_referred_by_id => p_rec.person_referred_by_id
1564: if g_debug then
1565: hr_utility.set_location(l_proc, 390);
1566: end if;
1567: --
1568: per_asg_bus2.chk_recruiter_id
1569: (p_assignment_id => p_rec.assignment_id
1570: ,p_person_id => p_rec.person_id
1571: ,p_assignment_type => p_rec.assignment_type
1572: ,p_business_group_id => p_rec.business_group_id
1580: if g_debug then
1581: hr_utility.set_location(l_proc, 400);
1582: end if;
1583: --
1584: per_asg_bus2.chk_period_of_service_id
1585: (p_assignment_id => p_rec.assignment_id
1586: ,p_business_group_id => p_rec.business_group_id
1587: ,p_person_id => p_rec.person_id
1588: ,p_assignment_type => p_rec.assignment_type
1595: if g_debug then
1596: hr_utility.set_location(l_proc, 405);
1597: end if;
1598: --
1599: per_asg_bus2.gen_assignment_sequence
1600: (p_assignment_type => p_rec.assignment_type
1601: ,p_person_id => p_rec.person_id
1602: ,p_assignment_sequence => p_rec.assignment_sequence
1603: );
1618: if g_debug then
1619: hr_utility.set_location(l_proc, 420);
1620: end if;
1621: --
1622: per_asg_bus2.chk_primary_flag
1623: (p_assignment_id => p_rec.assignment_id
1624: ,p_primary_flag => p_rec.primary_flag
1625: ,p_assignment_type => p_rec.assignment_type
1626: ,p_person_id => p_rec.person_id
1634: if g_debug then
1635: hr_utility.set_location(l_proc, 430);
1636: end if;
1637: --
1638: per_asg_bus2.chk_applicant_rank
1639: (p_applicant_rank => p_rec.applicant_rank
1640: ,p_assignment_type => p_rec.assignment_type
1641: ,p_assignment_id => p_rec.assignment_id
1642: ,p_object_version_number => p_rec.object_version_number
1641: ,p_assignment_id => p_rec.assignment_id
1642: ,p_object_version_number => p_rec.object_version_number
1643: ,p_effective_date => p_effective_date);
1644:
1645: per_asg_bus2.chk_posting_content_id
1646: (p_posting_content_id => p_rec.posting_content_id
1647: ,p_assignment_type => p_rec.assignment_type
1648: ,p_assignment_id => p_rec.assignment_id
1649: ,p_object_version_number => p_rec.object_version_number
1681: if g_debug then
1682: hr_utility.set_location(l_proc, 450);
1683: end if;
1684: --
1685: per_asg_bus2.chk_position_id_org_id
1686: (p_assignment_id => p_rec.assignment_id
1687: ,p_position_id => p_rec.position_id
1688: ,p_organization_id => p_rec.organization_id
1689: ,p_validation_start_date => p_validation_start_date
1708: if g_debug then
1709: hr_utility.set_location(l_proc, 470);
1710: end if;
1711: --
1712: per_asg_bus2.chk_payroll_id
1713: (p_assignment_id => p_rec.assignment_id
1714: ,p_business_group_id => p_rec.business_group_id
1715: ,p_person_id => p_rec.person_id
1716: ,p_payroll_id => p_rec.payroll_id
2141: if g_debug then
2142: hr_utility.set_location(l_proc, 20);
2143: end if;
2144: --
2145: per_asg_bus2.chk_system_pers_type
2146: (p_person_id => p_rec.person_id
2147: ,p_validation_start_date => p_validation_start_date
2148: ,p_validation_end_date => p_validation_end_date
2149: ,p_datetrack_mode => p_datetrack_mode
2153: if g_debug then
2154: hr_utility.set_location(l_proc, 21);
2155: end if;
2156: --
2157: per_asg_bus2.chk_term_status
2158: (p_assignment_id => p_rec.assignment_id
2159: ,p_datetrack_mode => p_datetrack_mode
2160: ,p_validation_start_date => p_validation_start_date
2161: );
2162: if g_debug then
2163: hr_utility.set_location(l_proc, 22);
2164: end if;
2165: --
2166: -- per_asg_bus2.chk_title(p_title => p_rec.title);
2167: --
2168: per_asg_bus2.chk_time_finish_formatted --#2734822
2169: (p_time_normal_finish => p_rec.time_normal_finish
2170: );
2164: end if;
2165: --
2166: -- per_asg_bus2.chk_title(p_title => p_rec.title);
2167: --
2168: per_asg_bus2.chk_time_finish_formatted --#2734822
2169: (p_time_normal_finish => p_rec.time_normal_finish
2170: );
2171: if g_debug then
2172: hr_utility.set_location(l_proc, 25);
2171: if g_debug then
2172: hr_utility.set_location(l_proc, 25);
2173: end if;
2174: --
2175: per_asg_bus2.chk_time_start_formatted --#2734822
2176: (p_time_normal_start => p_rec.time_normal_start
2177: );
2178: if g_debug then
2179: hr_utility.set_location(l_proc, 30);
2190: if g_debug then
2191: hr_utility.set_location(l_proc, 30);
2192: end if;
2193: --
2194: per_asg_bus2.chk_probation_unit
2195: (p_assignment_id => p_rec.assignment_id
2196: ,p_probation_unit => p_rec.probation_unit
2197: ,p_effective_date => p_effective_date
2198: ,p_validation_start_date => p_validation_start_date
2203: if g_debug then
2204: hr_utility.set_location(l_proc, 40);
2205: end if;
2206: --
2207: per_asg_bus2.chk_probation_period
2208: (p_assignment_id => p_rec.assignment_id
2209: ,p_probation_period => p_rec.probation_period
2210: ,p_effective_date => p_effective_date
2211: ,p_object_version_number => p_rec.object_version_number
2214: hr_utility.set_location(l_proc, 50);
2215: end if;
2216: --
2217:
2218: per_asg_bus2.chk_prob_unit_prob_period
2219: (p_assignment_id => p_rec.assignment_id
2220: ,p_probation_unit => p_rec.probation_unit
2221: ,p_probation_period => p_rec.probation_period
2222: ,p_effective_date => p_effective_date
2225: if g_debug then
2226: hr_utility.set_location(l_proc, 60);
2227: end if;
2228: --
2229: per_asg_bus2.chk_source_type
2230: (p_assignment_id => p_rec.assignment_id
2231: ,p_source_type => p_rec.source_type
2232: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
2233:
2254: if g_debug then
2255: hr_utility.set_location(l_proc, 80);
2256: end if;
2257: --
2258: per_asg_bus2.chk_internal_address_line
2259: (p_assignment_id => p_rec.assignment_id
2260: ,p_assignment_type => p_rec.assignment_type
2261: ,p_internal_address_line => p_rec.internal_address_line
2262: ,p_effective_date => p_effective_date
2306: if g_debug then
2307: hr_utility.set_location(l_proc, 120);
2308: end if;
2309: --
2310: per_asg_bus2.chk_sal_review_period
2311: (p_assignment_id => p_rec.assignment_id
2312: ,p_sal_review_period => p_rec.sal_review_period
2313: ,p_assignment_type => p_rec.assignment_type
2314: ,p_effective_date => p_effective_date
2318: if g_debug then
2319: hr_utility.set_location(l_proc, 130);
2320: end if;
2321: --
2322: per_asg_bus2.chk_sal_review_period_freq
2323: (p_assignment_id => p_rec.assignment_id
2324: ,p_sal_review_period_frequency => p_rec.sal_review_period_frequency
2325: ,p_assignment_type => p_rec.assignment_type
2326: ,p_effective_date => p_effective_date
2332: if g_debug then
2333: hr_utility.set_location(l_proc, 140);
2334: end if;
2335: --
2336: per_asg_bus2.chk_sal_rp_freq_sal_rp
2337: (p_assignment_id => p_rec.assignment_id
2338: ,p_sal_review_period_frequency => p_rec.sal_review_period_frequency
2339: ,p_sal_review_period => p_rec.sal_review_period
2340: ,p_effective_date => p_effective_date
2343: if g_debug then
2344: hr_utility.set_location(l_proc, 150);
2345: end if;
2346: --
2347: per_asg_bus2.chk_perf_review_period
2348: (p_assignment_id => p_rec.assignment_id
2349:
2350: ,p_perf_review_period => p_rec.perf_review_period
2351: ,p_assignment_type => p_rec.assignment_type
2355: if g_debug then
2356: hr_utility.set_location(l_proc, 160);
2357: end if;
2358: --
2359: per_asg_bus2.chk_perf_review_period_freq
2360: (p_assignment_id => p_rec.assignment_id
2361: ,p_perf_review_period_frequency => p_rec.perf_review_period_frequency
2362: ,p_assignment_type => p_rec.assignment_type
2363: ,p_effective_date => p_effective_date
2369: if g_debug then
2370: hr_utility.set_location(l_proc, 170);
2371: end if;
2372: --
2373: per_asg_bus2.chk_perf_rp_freq_perf_rp
2374: (p_assignment_id => p_rec.assignment_id
2375: ,p_perf_review_period_frequency => p_rec.perf_review_period_frequency
2376: ,p_perf_review_period => p_rec.perf_review_period
2377: ,p_effective_date => p_effective_date
2405: if g_debug then
2406: hr_utility.set_location(l_proc, 200);
2407: end if;
2408: --
2409: per_asg_bus2.chk_set_of_books_id
2410: (p_assignment_id => p_rec.assignment_id
2411: ,p_assignment_type => p_rec.assignment_type
2412: ,p_business_group_id => p_rec.business_group_id
2413: ,p_set_of_books_id => p_rec.set_of_books_id
2418: if g_debug then
2419: hr_utility.set_location(l_proc, 210);
2420: end if;
2421: --
2422: per_asg_bus2.chk_source_organization_id
2423: (p_assignment_id => p_rec.assignment_id
2424: ,p_assignment_type => p_rec.assignment_type
2425: ,p_business_group_id => p_rec.business_group_id
2426: ,p_source_organization_id => p_rec.source_organization_id
2433: if g_debug then
2434: hr_utility.set_location(l_proc, 220);
2435: end if;
2436: --
2437: per_asg_bus2.chk_soft_coding_keyflex_id
2438: (p_assignment_id => p_rec.assignment_id
2439: ,p_assignment_type => p_rec.assignment_type
2440: ,p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id
2441: ,p_effective_date => p_effective_date
2448: hr_utility.set_location(l_proc, 230);
2449: end if;
2450: --
2451:
2452: per_asg_bus2.chk_pay_basis_id
2453: (p_assignment_id => p_rec.assignment_id
2454: ,p_pay_basis_id => p_rec.pay_basis_id
2455: ,p_assignment_type => p_rec.assignment_type
2456: ,p_business_group_id => p_rec.business_group_id
2461: if g_debug then
2462: hr_utility.set_location(l_proc, 240);
2463: end if;
2464: --
2465: per_asg_bus2.chk_recruitment_activity_id
2466: (p_assignment_id => p_rec.assignment_id
2467: ,p_assignment_type => p_rec.assignment_type
2468: ,p_business_group_id => p_rec.business_group_id
2469: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
2475: if g_debug then
2476: hr_utility.set_location(l_proc, 250);
2477: end if;
2478: --
2479: per_asg_bus2.chk_vacancy_id
2480: (p_assignment_id => p_rec.assignment_id
2481: ,p_assignment_type => p_rec.assignment_type
2482:
2483: ,p_business_group_id => p_rec.business_group_id
2505: if g_debug then
2506: hr_utility.set_location(l_proc, 270);
2507: end if;
2508: --
2509: per_asg_bus2.chk_people_group_id
2510: (p_assignment_id => p_rec.assignment_id
2511: ,p_business_group_id => p_rec.business_group_id
2512: ,p_assignment_type => p_rec.assignment_type
2513: ,p_people_group_id => p_rec.people_group_id
2527: end if;
2528: if g_debug then
2529: hr_utility.set_location(p_validation_end_date, 290);
2530: end if;
2531: per_asg_bus2.chk_position_id
2532: (p_assignment_id => p_rec.assignment_id
2533: ,p_position_id => p_rec.position_id
2534: ,p_business_group_id => p_rec.business_group_id
2535: ,p_assignment_type => p_rec.assignment_type
2559: if g_debug then
2560: hr_utility.set_location(l_proc, 300);
2561: end if;
2562: --
2563: per_asg_bus2.chk_position_id_job_id
2564: (p_assignment_id => p_rec.assignment_id
2565: ,p_position_id => p_rec.position_id
2566: ,p_job_id => p_rec.job_id
2567: ,p_validation_start_date => p_validation_start_date
2590: if g_debug then
2591: hr_utility.set_location(l_proc, 320);
2592: end if;
2593: --
2594: per_asg_bus2.chk_special_ceiling_step_id
2595: (p_assignment_id => p_rec.assignment_id
2596: ,p_assignment_type => p_rec.assignment_type
2597: ,p_special_ceiling_step_id => p_rec.special_ceiling_step_id
2598: ,p_grade_id => p_rec.grade_id
2606: if g_debug then
2607: hr_utility.set_location(l_proc, 330);
2608: end if;
2609: --
2610: per_asg_bus2.chk_position_id_grade_id
2611: (p_assignment_id => p_rec.assignment_id
2612: ,p_position_id => p_rec.position_id
2613: ,p_grade_id => p_rec.grade_id
2614: ,p_validation_start_date => p_validation_start_date
2636: if g_debug then
2637: hr_utility.set_location(l_proc, 350);
2638: end if;
2639: --
2640: per_asg_bus2.chk_supervisor_id
2641: (p_assignment_id => p_rec.assignment_id
2642: ,p_supervisor_id => p_rec.supervisor_id
2643: ,p_person_id => p_rec.person_id
2644: ,p_business_group_id => p_rec.business_group_id
2649: if g_debug then
2650: hr_utility.set_location(l_proc, 360);
2651: end if;
2652: --
2653: per_asg_bus2.chk_supervisor_assignment_id
2654: (p_assignment_id => p_rec.assignment_id
2655: ,p_supervisor_id => p_rec.supervisor_id
2656: ,p_supervisor_assignment_id => p_rec.supervisor_assignment_id
2657: ,p_validation_start_date => p_validation_start_date
2661: if g_debug then
2662: hr_utility.set_location(l_proc, 350);
2663: end if;
2664: --
2665: per_asg_bus2.chk_person_referred_by_id
2666: (p_assignment_id => p_rec.assignment_id
2667: ,p_assignment_type => p_rec.assignment_type
2668: ,p_person_id => p_rec.person_id
2669: ,p_person_referred_by_id => p_rec.person_referred_by_id
2677: if g_debug then
2678: hr_utility.set_location(l_proc, 370);
2679: end if;
2680: --
2681: per_asg_bus2.chk_recruiter_id
2682: (p_assignment_id => p_rec.assignment_id
2683: ,p_person_id => p_rec.person_id
2684: ,p_assignment_type => p_rec.assignment_type
2685: ,p_business_group_id => p_rec.business_group_id
2694: if g_debug then
2695: hr_utility.set_location(l_proc, 380);
2696: end if;
2697: --
2698: per_asg_bus2.chk_period_of_service_id
2699: (p_assignment_id => p_rec.assignment_id
2700: ,p_business_group_id => p_rec.business_group_id
2701: ,p_person_id => p_rec.person_id
2702: ,p_assignment_type => p_rec.assignment_type
2762: if g_debug then
2763: hr_utility.set_location(l_proc, 390);
2764: end if;
2765: --
2766: per_asg_bus2.chk_primary_flag
2767: (p_assignment_id => p_rec.assignment_id
2768: ,p_primary_flag => p_rec.primary_flag
2769: ,p_assignment_type => p_rec.assignment_type
2770: ,p_person_id => p_rec.person_id
2813: if g_debug then
2814: hr_utility.set_location(l_proc, 410);
2815: end if;
2816: --
2817: per_asg_bus2.chk_position_id_org_id
2818: (p_assignment_id => p_rec.assignment_id
2819: ,p_position_id => p_rec.position_id
2820: ,p_organization_id => p_rec.organization_id
2821: ,p_validation_start_date => p_validation_start_date
2842: if g_debug then
2843: hr_utility.set_location(l_proc, 430);
2844: end if;
2845: --
2846: per_asg_bus2.chk_payroll_id
2847: (p_assignment_id => p_rec.assignment_id
2848: ,p_business_group_id => p_rec.business_group_id
2849: ,p_person_id => p_rec.person_id
2850: ,p_payroll_id => p_rec.payroll_id
3153: if g_debug then
3154: hr_utility.set_location(l_proc, 730);
3155: end if;
3156: --
3157: per_asg_bus2.chk_applicant_rank
3158: (p_applicant_rank => p_rec.applicant_rank
3159: ,p_assignment_type => p_rec.assignment_type
3160: ,p_assignment_id => p_rec.assignment_id
3161: ,p_object_version_number => p_rec.object_version_number
3160: ,p_assignment_id => p_rec.assignment_id
3161: ,p_object_version_number => p_rec.object_version_number
3162: ,p_effective_date => p_effective_date);
3163:
3164: per_asg_bus2.chk_posting_content_id
3165: (p_posting_content_id => p_rec.posting_content_id
3166: ,p_assignment_type => p_rec.assignment_type
3167: ,p_assignment_id => p_rec.assignment_id
3168: ,p_object_version_number => p_rec.object_version_number
5372: --
5373: -- Check whether another current assignment exists in the same
5374: -- organization with manager flag set to 'Y'.
5375: --
5376: if not per_asg_bus2.other_managers_in_org
5377: (p_organization_id => p_organization_id
5378: ,p_assignment_id => p_assignment_id
5379: ,p_effective_date => p_effective_date
5380: )
6468: -- Check if the assignment is an employee assignment.
6469: --
6470: --
6471: -- Remainder of procedure modidied as part of bug 892583. Changes
6472: -- made have effected the call to the per_asg_bus2.other_managers_in_org
6473: -- function. Previously ALL new employees, regardless of their
6474: -- manager flag, called this function. Now only NEW MANAGERS will call
6475: -- this function.
6476: --
6489: --
6490: -- Check whether another current assignment exists in the same
6491: -- organization with manager flag set to 'Y'.
6492: --
6493: if per_asg_bus2.other_managers_in_org
6494: (p_organization_id => p_organization_id
6495: ,p_assignment_id => p_assignment_id
6496: ,p_effective_date => p_effective_date) then
6497: --
6507: --
6508: -- Check whether another current assignment exists in the
6509: -- same organization with manager flag set to 'Y'
6510: --
6511: if per_asg_bus2.other_managers_in_org
6512: (p_organization_id => p_organization_id
6513: ,p_assignment_id => p_assignment_id
6514: ,p_effective_date => p_effective_date) then
6515: --
6851: --
6852: -- Check whether another current assignment exists in the same
6853: -- organization with manager flag set to 'Y'.
6854: --
6855: if per_asg_bus2.other_managers_in_org
6856: (p_organization_id => p_organization_id
6857: ,p_assignment_id => p_assignment_id
6858: ,p_effective_date => p_effective_date
6859: )