[Home] [Help]
1: Package Body hr_assignment_api as
2: /* $Header: peasgapi.pkb 120.20.12010000.4 2008/09/29 13:00:03 ubhat ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: peasgapi.pkb 120.20.12010000.4 2008/09/29 13:00:03 ubhat ship $ */
3: --
4: -- Package Variables
5: --
6: g_package CONSTANT varchar2(33) := ' hr_assignment_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: ----------------------------------------------------------------------------
10: -- |----------------------< update_pgp_concat_segs >------------------------|
320: -- make the data in the other tables ( namely tax records , secondary assignments statuses , letter requests )
321: --to be in sync with the assignments data
322:
323: hr_utility.set_location('Entering:'|| l_proc, 50);
324: hr_assignment.tidy_up_ref_int ( p_assignment_id,
325: 'FUTURE',
326: null,
327: l_asg_end_date,
328: null,
450:
451: -- make the data in the other tables ( namely tax records , secondary assignments statuses , letter requests )
452: --to be in sync with the assignments data
453:
454: hr_assignment.tidy_up_ref_int ( p_assignment_id,
455: 'FUTURE',
456: null,
457: l_asg_end_date,
458: null,
1283: --
1284: -- Start of API User Hook for the before hook of activate_emp_asg.
1285: --
1286: begin
1287: hr_assignment_bk6.activate_emp_asg_b
1288: (p_effective_date => l_effective_date
1289: ,p_datetrack_update_mode => p_datetrack_update_mode
1290: ,p_assignment_id => p_assignment_id
1291: ,p_change_reason => p_change_reason
1301: end;
1302: --
1303: -- Update employee assignment.
1304: --
1305: hr_assignment_internal.update_status_type_emp_asg
1306: (p_effective_date => l_effective_date
1307: ,p_datetrack_update_mode => p_datetrack_update_mode
1308: ,p_assignment_id => p_assignment_id
1309: ,p_change_reason => p_change_reason
1320: --
1321: -- Start of API User Hook for the after hook of activate_emp_asg.
1322: --
1323: begin
1324: hr_assignment_bk6.activate_emp_asg_a
1325: (p_effective_date => l_effective_date
1326: ,p_datetrack_update_mode => p_datetrack_update_mode
1327: ,p_assignment_id => p_assignment_id
1328: ,p_change_reason => p_change_reason
1451: --
1452: -- Start of API User Hook for the before hook of activate_cwk_asg.
1453: --
1454: begin
1455: hr_assignment_bkj.activate_cwk_asg_b
1456: (p_effective_date => l_effective_date
1457: ,p_datetrack_update_mode => p_datetrack_update_mode
1458: ,p_assignment_id => p_assignment_id
1459: ,p_change_reason => p_change_reason
1469: end;
1470: --
1471: -- Update contingent worker assignment.
1472: --
1473: hr_assignment_internal.update_status_type_cwk_asg
1474: (p_effective_date => l_effective_date
1475: ,p_datetrack_update_mode => p_datetrack_update_mode
1476: ,p_assignment_id => p_assignment_id
1477: ,p_change_reason => p_change_reason
1488: --
1489: -- Start of API User Hook for the after hook of activate_cwk_asg.
1490: --
1491: begin
1492: hr_assignment_bkj.activate_cwk_asg_a
1493: (p_effective_date => l_effective_date
1494: ,p_datetrack_update_mode => p_datetrack_update_mode
1495: ,p_assignment_id => p_assignment_id
1496: ,p_change_reason => p_change_reason
1695: --
1696: -- Start of API User Hook for the before hook of actual_termination_cwk_asg.
1697: --
1698: begin
1699: hr_assignment_bkk.actual_termination_cwk_asg_b
1700: (p_assignment_id => p_assignment_id
1701: ,p_object_version_number => p_object_version_number
1702: ,p_actual_termination_date => l_actual_termination_date
1703: ,p_assignment_status_type_id => p_assignment_status_type_id
1866: -- Call the business support process to update assignment and maintain the
1867: -- element entries. We call this procedure for contingent workers
1868: -- because they are processed in the same way as employees.
1869: --
1870: hr_assignment_internal.actual_term_cwk_asg
1871: (p_assignment_id => p_assignment_id
1872: ,p_object_version_number => l_object_version_number
1873: ,p_actual_termination_date => l_actual_termination_date
1874: ,p_last_standard_process_date => l_last_standard_process_date
1892: -- be placed before the validate check and therefore before the code that
1893: -- sets all out parms.
1894: --
1895: begin
1896: hr_assignment_bkk.actual_termination_cwk_asg_a
1897: (p_assignment_id => p_assignment_id
1898: ,p_object_version_number => l_object_version_number
1899: ,p_actual_termination_date => l_actual_termination_date
1900: ,p_assignment_status_type_id => p_assignment_status_type_id
2093: --
2094: -- Start of API User Hook for the before hook of final_process_cwk_asg.
2095: --
2096: begin
2097: hr_assignment_bkh.final_process_cwk_asg_b
2098: (p_assignment_id => p_assignment_id
2099: ,p_object_version_number => p_object_version_number
2100: ,p_final_process_date => l_final_process_date
2101: );
2209: -- Call the business support process to update assignment and maintain the
2210: -- element entries. Here we call the emp procedure because processing
2211: -- for a contingent worker is identical from this point.
2212: --
2213: hr_assignment_internal.final_process_cwk_asg
2214: (p_assignment_id => p_assignment_id
2215: ,p_object_version_number => l_object_version_number
2216: ,p_final_process_date => l_final_process_date
2217: ,p_actual_termination_date => l_actual_termination_date
2228: --
2229: -- Start of API User Hook for the after hook of final_process_cwk_asg.
2230: --
2231: begin
2232: hr_assignment_bkh.final_process_cwk_asg_a
2233: (p_assignment_id => p_assignment_id
2234: ,p_object_version_number => l_object_version_number
2235: ,p_final_process_date => p_final_process_date
2236: ,p_effective_start_date => l_effective_start_date
2364: --
2365: -- Start of API User Hook for the before hook of suspend_cwk_asg.
2366: --
2367: begin
2368: hr_assignment_bkl.suspend_cwk_asg_b
2369: (p_effective_date => l_effective_date
2370: ,p_datetrack_update_mode => p_datetrack_update_mode
2371: ,p_assignment_id => p_assignment_id
2372: ,p_change_reason => p_change_reason
2383: --
2384: --
2385: -- Update contingent worker assignment.
2386: --
2387: hr_assignment_internal.update_status_type_cwk_asg
2388: (p_effective_date => l_effective_date
2389: ,p_datetrack_update_mode => p_datetrack_update_mode
2390: ,p_assignment_id => p_assignment_id
2391: ,p_change_reason => p_change_reason
2402: --
2403: -- Start of API User Hook for the after hook of suspend_cwk_asg.
2404: --
2405: begin
2406: hr_assignment_bkl.suspend_cwk_asg_a
2407: (p_effective_date => l_effective_date
2408: ,p_datetrack_update_mode => p_datetrack_update_mode
2409: ,p_assignment_id => p_assignment_id
2410: ,p_change_reason => p_change_reason
2605: --
2606: -- Start of API User Hook for the before hook of actual_termination_emp_asg.
2607: --
2608: begin
2609: hr_assignment_bk4.actual_termination_emp_asg_b
2610: (p_assignment_id => p_assignment_id
2611: ,p_object_version_number => p_object_version_number
2612: ,p_actual_termination_date => l_actual_termination_date
2613: ,p_assignment_status_type_id => p_assignment_status_type_id
2775: --
2776: -- Call the business support process to update assignment and maintain the
2777: -- element entries.
2778: --
2779: hr_assignment_internal.actual_term_emp_asg_sup
2780: (p_assignment_id => p_assignment_id
2781: ,p_object_version_number => l_object_version_number
2782: ,p_actual_termination_date => l_actual_termination_date
2783: ,p_last_standard_process_date => l_last_standard_process_date
2801: -- be placed before the validate check and therefore before the code that
2802: -- sets all out parms.
2803: --
2804: begin
2805: hr_assignment_bk4.actual_termination_emp_asg_a
2806: (p_assignment_id => p_assignment_id
2807: ,p_object_version_number => l_object_version_number
2808: ,p_actual_termination_date => l_actual_termination_date
2809: ,p_assignment_status_type_id => p_assignment_status_type_id
3091: l_assignment_number := p_assignment_number;
3092: --
3093: -- Call the new code
3094: --
3095: hr_assignment_api.create_secondary_emp_asg(
3096: p_validate => p_validate
3097: ,p_effective_date => p_effective_date
3098: ,p_person_id => p_person_id
3099: ,p_organization_id => p_organization_id
3521: l_assignment_number := p_assignment_number;
3522: --
3523: -- Call the new code
3524: --
3525: hr_assignment_api.create_secondary_emp_asg(
3526: p_validate => p_validate
3527: ,p_effective_date => p_effective_date
3528: ,p_person_id => p_person_id
3529: ,p_organization_id => p_organization_id
3965: l_assignment_number := p_assignment_number;
3966: --
3967: -- Call the new code
3968: --
3969: hr_assignment_api.create_secondary_emp_asg(
3970: p_validate => p_validate
3971: ,p_effective_date => p_effective_date
3972: ,p_person_id => p_person_id
3973: ,p_organization_id => p_organization_id
4814: --
4815: --
4816: -- Start of API User Hook for the before hook of create_secondary_emp_asg
4817: --
4818: hr_assignment_bk1.create_secondary_emp_asg_b
4819: (p_effective_date => l_effective_date
4820: ,p_person_id => p_person_id
4821: ,p_organization_id => p_organization_id
4822: ,p_grade_id => p_grade_id
5317: --
5318: --
5319: -- Insert secondary assignment
5320: --
5321: hr_assignment_internal.create_emp_asg
5322: (p_effective_date => l_effective_date
5323: ,p_legislation_code => l_legislation_code
5324: ,p_business_group_id => l_business_group_id
5325: ,p_person_id => p_person_id
5431: -- Bug 944911
5432: -- No amendments required for outs as the values carried forward
5433: -- Adding the 2 additional ins - p_concat_segments and p_pgp_concat_segments
5434: -- Both with the same value as passed to _b proc
5435: hr_assignment_bk1.create_secondary_emp_asg_a
5436: (p_effective_date => l_effective_date
5437: ,p_person_id => p_person_id
5438: ,p_organization_id => p_organization_id
5439: ,p_grade_id => p_grade_id
6014: BEGIN
6015: --
6016: -- Start of API User Hook for the before hook of create_secondary_emp_asg
6017: --
6018: hr_assignment_bkn.create_secondary_cwk_asg_b
6019: (p_effective_date => l_effective_date
6020: ,p_business_group_id => p_business_group_id
6021: ,p_person_id => p_person_id
6022: ,p_organization_id => p_organization_id
6507: */
6508: --
6509: -- Insert secondary assignment
6510: --
6511: hr_assignment_internal.create_cwk_asg
6512: (p_validate => p_validate
6513: ,p_effective_date => l_effective_date
6514: ,p_business_group_id => l_business_group_id
6515: ,p_legislation_code => l_legislation_code
6612: -- No amendments required for outs as the values carried forward
6613: -- Adding the 2 additional ins - p_concat_segments and p_pgp_concat_segments
6614: -- Both with the same value as passed to _b proc
6615: --
6616: hr_assignment_bkn.create_secondary_cwk_asg_a
6617: (p_effective_date => l_effective_date
6618: ,p_business_group_id => p_business_group_id
6619: ,p_person_id => p_person_id
6620: ,p_organization_id => p_organization_id
7222: -- Call create_secondary_emp_asg
7223: --
7224: -- Bug 944911
7225: -- Amended param p_scl_concatenated_segments to p_concatenated_segments
7226: hr_assignment_api.create_secondary_emp_asg
7227: (p_validate => p_validate
7228: ,p_effective_date => l_effective_date
7229: ,p_person_id => p_person_id
7230: ,p_organization_id => p_organization_id
7531: -- Call create_secondary_emp_asg
7532: --
7533: -- Bug 944911
7534: -- Amended param p_scl_concatenated_segments to p_concatenated_segments
7535: hr_assignment_api.create_secondary_emp_asg
7536: (p_validate => p_validate
7537: ,p_effective_date => l_effective_date
7538: ,p_person_id => p_person_id
7539: ,p_organization_id => p_organization_id
7853: -- Added new param p_concat_segments in
7854: -- made p_concatenated_segments to be out only
7855: -- Amended p_scl_concatenated_segments to be p_concatenated_segments
7856:
7857: hr_assignment_api.create_secondary_emp_asg
7858: (p_validate => p_validate
7859: ,p_effective_date => l_effective_date
7860: ,p_person_id => p_person_id
7861: ,p_organization_id => p_organization_id
8186: -- Added new param p_concat_segments in
8187: -- made p_concatenated_segments to be out only
8188: -- Amended p_scl_concatenated_segments to be p_concatenated_segments
8189:
8190: hr_assignment_api.create_secondary_emp_asg
8191: (p_validate => p_validate
8192: ,p_effective_date => l_effective_date
8193: ,p_person_id => p_person_id
8194: ,p_organization_id => p_organization_id
8451: --
8452: -- Start of API User Hook for the before hook of final_process_emp_asg.
8453: --
8454: begin
8455: hr_assignment_bka.final_process_emp_asg_b
8456: (p_assignment_id => p_assignment_id
8457: ,p_object_version_number => p_object_version_number
8458: ,p_final_process_date => l_final_process_date
8459: );
8566: --
8567: -- Call the business support process to update assignment and maintain the
8568: -- element entries.
8569: --
8570: hr_assignment_internal.final_process_emp_asg_sup
8571: (p_assignment_id => p_assignment_id
8572: ,p_object_version_number => l_object_version_number
8573: ,p_final_process_date => l_final_process_date
8574: ,p_actual_termination_date => l_actual_termination_date
8585: --
8586: -- Start of API User Hook for the after hook of final_process_emp_asg.
8587: --
8588: begin
8589: hr_assignment_bka.final_process_emp_asg_a
8590: (p_assignment_id => p_assignment_id
8591: ,p_object_version_number => l_object_version_number
8592: ,p_final_process_date => p_final_process_date
8593: ,p_effective_start_date => l_effective_start_date
8726: --
8727: -- Start of API User Hook for the before hook of suspend_emp_asg.
8728: --
8729: begin
8730: hr_assignment_bk7.suspend_emp_asg_b
8731: (p_effective_date => l_effective_date
8732: ,p_datetrack_update_mode => p_datetrack_update_mode
8733: ,p_assignment_id => p_assignment_id
8734: ,p_change_reason => p_change_reason
8745: --
8746: --
8747: -- Update employee assignment.
8748: --
8749: hr_assignment_internal.update_status_type_emp_asg
8750: (p_effective_date => l_effective_date
8751: ,p_datetrack_update_mode => p_datetrack_update_mode
8752: ,p_assignment_id => p_assignment_id
8753: ,p_change_reason => p_change_reason
8764: --
8765: -- Start of API User Hook for the after hook of suspend_emp_asg.
8766: --
8767: begin
8768: hr_assignment_bk7.suspend_emp_asg_a
8769: (p_effective_date => l_effective_date
8770: ,p_datetrack_update_mode => p_datetrack_update_mode
8771: ,p_assignment_id => p_assignment_id
8772: ,p_change_reason => p_change_reason
8977: l_proc := g_package||'update_emp_asg';
8978: hr_utility.set_location('Entering:'|| l_proc, 5);
8979: end if;
8980: ---- Call the new code
8981: hr_assignment_api.update_emp_asg
8982: (p_validate => p_validate
8983: ,p_effective_date => p_effective_date
8984: ,p_datetrack_update_mode => p_datetrack_update_mode
8985: ,p_assignment_id => p_assignment_id
9306: -- Added notice_period through to job_post_source_name in this call as they
9307: -- were missing
9308: -- see bug 2122535 for details
9309: --
9310: hr_assignment_api.update_emp_asg
9311: (p_validate => p_validate
9312: ,p_effective_date => p_effective_date
9313: ,p_datetrack_update_mode => p_datetrack_update_mode
9314: ,p_assignment_id => p_assignment_id
9656: --
9657: -- Call the new code
9658: -- Added p_gsp_post_process_warning
9659: --
9660: hr_assignment_api.update_emp_asg
9661: (p_validate => p_validate
9662: ,p_effective_date => p_effective_date
9663: ,p_datetrack_update_mode => p_datetrack_update_mode
9664: ,p_assignment_id => p_assignment_id
10293: begin
10294: --
10295: -- Start of API User Hook for the before hook of update_emp_asg
10296: --
10297: hr_assignment_bk2.update_emp_asg_b
10298: (p_effective_date => l_effective_date
10299: ,p_datetrack_update_mode => p_datetrack_update_mode
10300: ,p_assignment_id => p_assignment_id
10301: ,p_object_version_number => p_object_version_number
10913: begin
10914: --
10915: -- Start of API User Hook for the after hook of update_emp_asg
10916: --
10917: hr_assignment_bk2.update_emp_asg_a
10918: (p_effective_date => l_effective_date
10919: ,p_datetrack_update_mode => p_datetrack_update_mode
10920: ,p_assignment_id => p_assignment_id
10921: ,p_object_version_number => p_object_version_number
11401: BEGIN
11402: --
11403: -- Start of API User Hook for the before hook of update_emp_asg
11404: --
11405: hr_assignment_bkm.update_cwk_asg_b
11406: (p_effective_date => l_effective_date
11407: ,p_datetrack_update_mode => p_datetrack_update_mode
11408: ,p_assignment_id => p_assignment_id
11409: ,p_object_version_number => p_object_version_number
11962: BEGIN
11963: --
11964: -- Start of API User Hook for the after hook of update_cwk_asg
11965: --
11966: hr_assignment_bkm.update_cwk_asg_a
11967: (p_effective_date => l_effective_date
11968: ,p_datetrack_update_mode => p_datetrack_update_mode
11969: ,p_assignment_id => p_assignment_id
11970: ,p_object_version_number => p_object_version_number
12392: BEGIN
12393: --
12394: -- Start of API User Hook for the before hook of update_emp_asg_criteria
12395: --
12396: hr_assignment_bko.update_cwk_asg_criteria_b
12397: (p_effective_date => l_effective_date
12398: ,p_datetrack_update_mode => l_dt_update_mode
12399: ,p_assignment_id => p_assignment_id
12400: ,p_object_version_number => p_object_version_number
12833: end if;
12834: --
12835: -- Maintain spinal point placements.
12836: --
12837: hr_assignment_internal.maintain_spp_asg
12838: (p_assignment_id => p_assignment_id
12839: ,p_datetrack_mode => l_new_dt_update_mode
12840: ,p_validation_start_date => l_validation_start_date
12841: ,p_validation_end_date => l_validation_end_date
12923: BEGIN
12924: --
12925: -- Start of API User Hook for the after hook of update_emp_asg_criteria
12926: --
12927: hr_assignment_bko.update_cwk_asg_criteria_a
12928: (p_effective_date => l_effective_date
12929: ,p_datetrack_update_mode => l_dt_update_mode
12930: ,p_assignment_id => p_assignment_id
12931: ,p_object_version_number => p_object_version_number
13151: end if;
13152: --
13153: -- Call the overloaded procedure
13154: --
13155: hr_assignment_api.update_gb_emp_asg
13156: (p_validate => p_validate
13157: ,p_effective_date => p_effective_date
13158: ,p_datetrack_update_mode => p_datetrack_update_mode
13159: ,p_assignment_id => p_assignment_id
13377: end if;
13378: --
13379: -- Call update_emp_asg business process
13380: --
13381: hr_assignment_api.update_emp_asg
13382: (p_validate => p_validate
13383: ,p_effective_date => p_effective_date
13384: ,p_datetrack_update_mode => p_datetrack_update_mode
13385: ,p_assignment_id => p_assignment_id
13614: end if;
13615: --
13616: -- Call update_emp_asg business process
13617: --
13618: hr_assignment_api.update_emp_asg
13619: (p_validate => p_validate
13620: ,p_effective_date => p_effective_date
13621: ,p_datetrack_update_mode => p_datetrack_update_mode
13622: ,p_assignment_id => p_assignment_id
13808: end if;
13809: --
13810: -- Call the overloaded procedure update_us_emp_asg
13811: --
13812: hr_assignment_api.update_emp_asg
13813: (p_validate => p_validate
13814: ,p_effective_date => p_effective_date
13815: ,p_datetrack_update_mode => p_datetrack_update_mode
13816: ,p_assignment_id => p_assignment_id
14062: end if;
14063: --
14064: -- Call update_emp_asg business process
14065: --
14066: hr_assignment_api.update_emp_asg
14067: (p_validate => p_validate
14068: ,p_effective_date => p_effective_date
14069: ,p_datetrack_update_mode => p_datetrack_update_mode
14070: ,p_assignment_id => p_assignment_id
14328: end if;
14329: --
14330: -- Call update_emp_asg business process
14331: --
14332: hr_assignment_api.update_emp_asg
14333: (p_validate => p_validate
14334: ,p_effective_date => p_effective_date
14335: ,p_datetrack_update_mode => p_datetrack_update_mode
14336: ,p_assignment_id => p_assignment_id
14596: end if;
14597: --
14598: -- Call update_emp_asg business process
14599: --
14600: hr_assignment_api.update_emp_asg
14601: (p_validate => p_validate
14602: ,p_effective_date => p_effective_date
14603: ,p_datetrack_update_mode => p_datetrack_update_mode
14604: ,p_assignment_id => p_assignment_id
14833: --
14834: -- Calling New Overloaded Procedure
14835: --
14836:
14837: hr_assignment_api.update_emp_asg_criteria
14838: (p_validate => p_validate
14839: ,p_effective_date => p_effective_date
14840: ,p_datetrack_update_mode => p_datetrack_update_mode
14841: ,p_called_from_mass_update => p_called_from_mass_update
15048: --
15049: -- Calling New Overloaded Procedure
15050: --
15051:
15052: hr_assignment_api.update_emp_asg_criteria
15053: (p_validate => p_validate
15054: ,p_effective_date => p_effective_date
15055: ,p_datetrack_update_mode => p_datetrack_update_mode
15056: ,p_called_from_mass_update => p_called_from_mass_update
15544: begin
15545: --
15546: -- Start of API User Hook for the before hook of update_emp_asg_criteria
15547: --
15548: hr_assignment_bk3.update_emp_asg_criteria_b
15549: (p_effective_date => l_effective_date
15550: ,p_datetrack_update_mode => l_dt_update_mode
15551: ,p_assignment_id => p_assignment_id
15552: ,p_object_version_number => p_object_version_number
16213: end if;
16214: --
16215: -- Maintain spinal point placements.
16216: --
16217: hr_assignment_internal.maintain_spp_asg
16218: (p_assignment_id => p_assignment_id
16219: ,p_datetrack_mode => l_new_dt_update_mode
16220: ,p_validation_start_date => l_validation_start_date
16221: ,p_validation_end_date => l_validation_end_date
16302: begin
16303: --
16304: -- Start of API User Hook for the after hook of update_emp_asg_criteria
16305: --
16306: hr_assignment_bk3.update_emp_asg_criteria_a
16307: (p_effective_date => l_effective_date
16308: ,p_datetrack_update_mode => l_dt_update_mode
16309: ,p_assignment_id => p_assignment_id
16310: ,p_object_version_number => p_object_version_number
17228: --
17229: -- Start of API User Hook for the before hook of update_apl_asg.
17230: --
17231: begin
17232: hr_assignment_bk5.update_apl_asg_b
17233: (p_effective_date => l_effective_date
17234: ,p_datetrack_update_mode => p_datetrack_update_mode
17235: ,p_assignment_id => p_assignment_id
17236: ,p_object_version_number => p_object_version_number
17945: --
17946: -- Start of API User Hook for the after hook of suspend_emp_asg.
17947: --
17948: begin
17949: hr_assignment_bk5.update_apl_asg_a
17950: (p_effective_date => l_effective_date
17951: ,p_datetrack_update_mode => p_datetrack_update_mode
17952: ,p_assignment_id => p_assignment_id
17953: ,p_object_version_number => l_object_version_number
18402: --
18403: -- Call the new code
18404: -- bug 944911
18405: -- made no changes to p_group_name as it is out , while in is
18406: hr_assignment_api.update_apl_asg(
18407: p_validate => p_validate
18408: ,p_effective_date => p_effective_date
18409: ,p_datetrack_update_mode => p_datetrack_update_mode
18410: ,p_assignment_id => p_assignment_id
19564: --
19565: -- Start of API User Hook for the before hook of create_secondary_apl_asg.
19566: --
19567: begin
19568: hr_assignment_bk8.create_secondary_apl_asg_b
19569: (p_effective_date => l_effective_date
19570: ,p_person_id => p_person_id
19571: ,p_organization_id => p_organization_id
19572: ,p_recruiter_id => p_recruiter_id
20085: else
20086: l_assignment_status_type_id := p_assignment_status_type_id;
20087: end if;
20088: --
20089: hr_assignment_api.update_apl_asg
20090: (p_validate => FALSE
20091: ,p_effective_date => l_effective_date
20092: ,p_datetrack_update_mode => hr_api.g_correction
20093: ,p_assignment_id => l_assignment_id
20272: else -- application is not end dated
20273: --
20274: -- Insert secondary assignment
20275: --
20276: hr_assignment_internal.create_apl_asg
20277: (p_effective_date => l_effective_date
20278: ,p_legislation_code => l_legislation_code
20279: ,p_business_group_id => l_business_group_id
20280: ,p_person_id => p_person_id
20385: --
20386: -- Start of API User Hook for the after hook of create_secondary_apl_asg.
20387: --
20388: begin
20389: hr_assignment_bk8.create_secondary_apl_asg_a
20390: (p_effective_date => l_effective_date
20391: ,p_person_id => p_person_id
20392: ,p_organization_id => p_organization_id
20393: ,p_recruiter_id => p_recruiter_id
20831: end if;
20832: -- Call the new code
20833: -- Bug 944911
20834: -- No change to call point as all outs are present while the ins have defaults
20835: hr_assignment_api.create_secondary_apl_asg(
20836: p_validate => p_validate
20837: ,p_effective_date => p_effective_date
20838: ,p_person_id => p_person_id
20839: ,p_organization_id => p_organization_id
21012: --
21013: -- Start of API User Hook for the before hook of offer_apl_asg.
21014: --
21015: begin
21016: hr_assignment_bk9.offer_apl_asg_b
21017: (p_effective_date => l_effective_date
21018: ,p_datetrack_update_mode => p_datetrack_update_mode
21019: ,p_assignment_id => p_assignment_id
21020: ,p_object_version_number => p_object_version_number
21028: p_hook_type => 'BP'
21029: );
21030: end;
21031: --
21032: hr_assignment_internal.update_status_type_apl_asg
21033: (p_effective_date => l_effective_date
21034: ,p_datetrack_update_mode => p_datetrack_update_mode
21035: ,p_assignment_id => p_assignment_id
21036: ,p_object_version_number => l_object_version_number
21047: --
21048: -- Start of API User Hook for the after hook of offer_apl_asg.
21049: --
21050: begin
21051: hr_assignment_bk9.offer_apl_asg_a
21052: (p_effective_date => l_effective_date
21053: ,p_datetrack_update_mode => p_datetrack_update_mode
21054: ,p_assignment_id => p_assignment_id
21055: ,p_object_version_number => l_object_version_number
21173: --
21174: -- Start of API User Hook for the before hook of accept_apl_asg.
21175: --
21176: begin
21177: hr_assignment_bkb.accept_apl_asg_b
21178: (p_effective_date => l_effective_date
21179: ,p_datetrack_update_mode => p_datetrack_update_mode
21180: ,p_assignment_id => p_assignment_id
21181: ,p_object_version_number => p_object_version_number
21191: end;
21192: -- End of API User Hook for the before hook of accept_apl_asg.
21193:
21194: --
21195: hr_assignment_internal.update_status_type_apl_asg
21196: (p_effective_date => l_effective_date
21197: ,p_datetrack_update_mode => p_datetrack_update_mode
21198: ,p_assignment_id => p_assignment_id
21199: ,p_object_version_number => l_object_version_number
21210: --
21211: -- Start of API User Hook for the after hook of accept_apl_asg.
21212: --
21213: begin
21214: hr_assignment_bkb.accept_apl_asg_a
21215: (p_effective_date => l_effective_date
21216: ,p_datetrack_update_mode => p_datetrack_update_mode
21217: ,p_assignment_id => p_assignment_id
21218: ,p_object_version_number => l_object_version_number
21326: --
21327: -- Call Before Process User Hook
21328: --
21329: BEGIN
21330: hr_assignment_bkc.activate_apl_asg_b
21331: (p_effective_date => l_effective_date
21332: ,p_datetrack_update_mode => p_datetrack_update_mode
21333: ,p_assignment_id => p_assignment_id
21334: ,p_object_version_number => p_object_version_number
21349: end if;
21350: --
21351: -- Call business support process to update status type
21352: --
21353: hr_assignment_internal.update_status_type_apl_asg
21354: (p_effective_date => l_effective_date
21355: ,p_datetrack_update_mode => p_datetrack_update_mode
21356: ,p_assignment_id => p_assignment_id
21357: ,p_object_version_number => p_object_version_number
21368: --
21369: -- Call After Process User Hook
21370: --
21371: BEGIN
21372: hr_assignment_bkc.activate_apl_asg_a
21373: (p_effective_date => l_effective_date
21374: ,p_datetrack_update_mode => p_datetrack_update_mode
21375: ,p_assignment_id => p_assignment_id
21376: ,p_object_version_number => p_object_version_number
21452: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
21453: )
21454: IS
21455: BEGIN
21456: hr_assignment_api.terminate_apl_asg
21457: (p_validate => p_validate
21458: ,p_effective_date => p_effective_date
21459: ,p_assignment_id => p_assignment_id
21460: ,p_assignment_status_type_id => p_assignment_status_type_id
21714: --
21715: -- Call Before Process User Hook
21716: --
21717: BEGIN
21718: hr_assignment_bkd.terminate_apl_asg_b
21719: (p_effective_date => l_effective_date
21720: ,p_assignment_id => p_assignment_id
21721: ,p_object_version_number => p_object_version_number
21722: );
22129: --
22130: -- Call After Process User Hook
22131: --
22132: BEGIN
22133: hr_assignment_bkd.terminate_apl_asg_a
22134: (p_effective_date => l_effective_date
22135: ,p_assignment_id => p_assignment_id
22136: ,p_object_version_number => p_object_version_number
22137: ,p_effective_start_date => l_effective_start_date
22312: --
22313: -- Call Before Process User Hook
22314: --
22315: BEGIN
22316: hr_assignment_bke.set_new_primary_asg_b
22317: (p_effective_date => l_effective_date
22318: ,p_person_id => p_person_id
22319: ,p_assignment_id => p_assignment_id
22320: ,p_object_version_number => p_object_version_number
22401: --
22402: -- # 2468916: This should be executed after creating NEW primary
22403: -- assignment. This call is replaced by do_primary_update proc.
22404: --
22405: -- hr_assignment.update_primary
22406: -- (p_assignment_id => l_old_assignment.assignment_id
22407: -- ,p_period_of_service_id => l_old_assignment.period_of_service_id
22408: -- ,p_new_primary_ass_id => p_assignment_id
22409: -- ,p_sdate => l_effective_date
22418: end if;
22419: --
22420: -- Start the new primary assignment
22421: --
22422: hr_assignment.update_primary
22423: (p_assignment_id => l_old_assignment.assignment_id -- #2468916:instead of p_assignment_id
22424: ,p_period_of_service_id => l_old_assignment.period_of_service_id -- #2468916:instead of new.
22425: ,p_new_primary_ass_id => p_assignment_id
22426: ,p_sdate => l_effective_date
22435: end if;
22436: --
22437: -- #2468916: End previous assignment
22438: --
22439: hr_assignment.do_primary_update(l_old_assignment.assignment_id --p_assignment_id
22440: ,l_effective_date -- p_sdate
22441: ,'N' -- primary flag
22442: ,'N' -- current asg
22443: ,TO_NUMBER(NULL) --p_last_updated_by
22470: --
22471: -- Call After Process User Hook
22472: --
22473: BEGIN
22474: hr_assignment_bke.set_new_primary_asg_a
22475: (p_effective_date => l_effective_date
22476: ,p_person_id => p_person_id
22477: ,p_assignment_id => p_assignment_id
22478: ,p_object_version_number => l_new_assignment.object_version_number
22654: -- Call Before Process User Hook
22655: --
22656: BEGIN
22657: --
22658: hr_assignment_bki.set_new_primary_cwk_asg_b
22659: (p_effective_date => l_effective_date
22660: ,p_person_id => p_person_id
22661: ,p_assignment_id => p_assignment_id
22662: ,p_object_version_number => p_object_version_number);
22758: end if;
22759: --
22760: -- End the previous primary assignment
22761: --
22762: hr_assignment.update_primary_cwk
22763: (p_assignment_id => l_old_assignment.assignment_id
22764: ,p_person_id => p_person_id
22765: ,p_pop_date_start => l_old_assignment.period_of_placement_date_start
22766: ,p_new_primary_ass_id => p_assignment_id
22776: end if;
22777: --
22778: -- Start the new primary assignment
22779: --
22780: hr_assignment.update_primary_cwk
22781: (p_assignment_id => p_assignment_id
22782: ,p_person_id => p_person_id
22783: ,p_pop_date_start => l_new_assignment.period_of_placement_date_start
22784: ,p_new_primary_ass_id => p_assignment_id
22819: -- Call After Process User Hook
22820: --
22821: BEGIN
22822: --
22823: hr_assignment_bki.set_new_primary_cwk_asg_a
22824: (p_effective_date => l_effective_date
22825: ,p_person_id => p_person_id
22826: ,p_assignment_id => p_assignment_id
22827: ,p_object_version_number => l_new_assignment.object_version_number
22943: --
22944: -- Call Before Process User Hook
22945: --
22946: BEGIN
22947: hr_assignment_bkf.interview1_apl_asg_b
22948: (p_effective_date => l_effective_date
22949: ,p_datetrack_update_mode => p_datetrack_update_mode
22950: ,p_assignment_id => p_assignment_id
22951: ,p_object_version_number => p_object_version_number
22966: end if;
22967: --
22968: -- Call business support process to update status type
22969: --
22970: hr_assignment_internal.update_status_type_apl_asg
22971: (p_effective_date => l_effective_date
22972: ,p_datetrack_update_mode => p_datetrack_update_mode
22973: ,p_assignment_id => p_assignment_id
22974: ,p_object_version_number => p_object_version_number
22985: --
22986: -- Call After Process User Hook
22987: --
22988: BEGIN
22989: hr_assignment_bkf.interview1_apl_asg_a
22990: (p_effective_date => l_effective_date
22991: ,p_datetrack_update_mode => p_datetrack_update_mode
22992: ,p_assignment_id => p_assignment_id
22993: ,p_object_version_number => p_object_version_number
23107: --
23108: -- Call Before Process User Hook
23109: --
23110: BEGIN
23111: hr_assignment_bkg.interview2_apl_asg_b
23112: (p_effective_date => l_effective_date
23113: ,p_datetrack_update_mode => p_datetrack_update_mode
23114: ,p_assignment_id => p_assignment_id
23115: ,p_object_version_number => p_object_version_number
23130: end if;
23131: --
23132: -- Call business support process to update status type
23133: --
23134: hr_assignment_internal.update_status_type_apl_asg
23135: (p_effective_date => l_effective_date
23136: ,p_datetrack_update_mode => p_datetrack_update_mode
23137: ,p_assignment_id => p_assignment_id
23138: ,p_object_version_number => p_object_version_number
23149: --
23150: -- Call After Process User Hook
23151: --
23152: BEGIN
23153: hr_assignment_bkg.interview2_apl_asg_a
23154: (p_effective_date => l_effective_date
23155: ,p_datetrack_update_mode => p_datetrack_update_mode
23156: ,p_assignment_id => p_assignment_id
23157: ,p_object_version_number => p_object_version_number
23295: begin
23296: --
23297: -- Start of API User Hook for the before hook of delete_assignment
23298: --
23299: hr_assignment_bkp.delete_assignment_b
23300: (p_effective_date => l_effective_date
23301: ,p_assignment_id => p_assignment_id
23302: ,p_datetrack_mode => p_datetrack_mode
23303: );
23335: begin
23336: --
23337: -- Start of API User Hook for the after hook of delete_assignment
23338: --
23339: hr_assignment_bkp.delete_assignment_a
23340: (p_effective_date => l_effective_date
23341: ,p_assignment_id => p_assignment_id
23342: ,p_datetrack_mode => p_datetrack_mode
23343: ,p_loc_change_tax_issues => p_loc_change_tax_issues
23408: raise;
23409: --
23410: END; -- End of delete_assignment Procedure
23411: --
23412: END hr_assignment_api;