[Home] [Help]
1: Package Body hr_assignment_api as
2: /* $Header: peasgapi.pkb 120.37.12020000.11 2013/02/28 09:37:22 lbodired ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: peasgapi.pkb 120.37.12020000.11 2013/02/28 09:37:22 lbodired 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 >------------------------|
405: -- make the data in the other tables ( namely tax records , secondary assignments statuses , letter requests )
406: --to be in sync with the assignments data
407:
408: hr_utility.set_location('Entering:'|| l_proc, 50);
409: hr_assignment.tidy_up_ref_int ( p_assignment_id,
410: 'FUTURE',
411: null,
412: l_asg_end_date,
413: null,
557: hr_utility.set_location('At reverse_term_apln_fut',170);
558: -- make the data in the other tables ( namely tax records , secondary assignments statuses , letter requests )
559: --to be in sync with the assignments data
560:
561: hr_assignment.tidy_up_ref_int ( p_assignment_id,
562: 'FUTURE',
563: null,
564: l_asg_end_date,
565: null,
869: -- make the data in the other tables ( namely tax records , secondary assignments statuses , letter requests )
870: --to be in sync with the assignments data
871:
872: hr_utility.set_location('Entering:'|| l_proc, 50);
873: hr_assignment.tidy_up_ref_int ( p_assignment_id,
874: 'FUTURE',
875: null,
876: l_asg_end_date,
877: null,
1011:
1012: -- make the data in the other tables ( namely tax records , secondary assignments statuses , letter requests )
1013: --to be in sync with the assignments data
1014:
1015: hr_assignment.tidy_up_ref_int ( p_assignment_id,
1016: 'FUTURE',
1017: null,
1018: l_asg_end_date,
1019: null,
1844: --
1845: -- Start of API User Hook for the before hook of activate_emp_asg.
1846: --
1847: begin
1848: hr_assignment_bk6.activate_emp_asg_b
1849: (p_effective_date => l_effective_date
1850: ,p_datetrack_update_mode => p_datetrack_update_mode
1851: ,p_assignment_id => p_assignment_id
1852: ,p_change_reason => p_change_reason
1862: end;
1863: --
1864: -- Update employee assignment.
1865: --
1866: hr_assignment_internal.update_status_type_emp_asg
1867: (p_effective_date => l_effective_date
1868: ,p_datetrack_update_mode => p_datetrack_update_mode
1869: ,p_assignment_id => p_assignment_id
1870: ,p_change_reason => p_change_reason
1881: --
1882: -- Start of API User Hook for the after hook of activate_emp_asg.
1883: --
1884: begin
1885: hr_assignment_bk6.activate_emp_asg_a
1886: (p_effective_date => l_effective_date
1887: ,p_datetrack_update_mode => p_datetrack_update_mode
1888: ,p_assignment_id => p_assignment_id
1889: ,p_change_reason => p_change_reason
2012: --
2013: -- Start of API User Hook for the before hook of activate_cwk_asg.
2014: --
2015: begin
2016: hr_assignment_bkj.activate_cwk_asg_b
2017: (p_effective_date => l_effective_date
2018: ,p_datetrack_update_mode => p_datetrack_update_mode
2019: ,p_assignment_id => p_assignment_id
2020: ,p_change_reason => p_change_reason
2030: end;
2031: --
2032: -- Update contingent worker assignment.
2033: --
2034: hr_assignment_internal.update_status_type_cwk_asg
2035: (p_effective_date => l_effective_date
2036: ,p_datetrack_update_mode => p_datetrack_update_mode
2037: ,p_assignment_id => p_assignment_id
2038: ,p_change_reason => p_change_reason
2049: --
2050: -- Start of API User Hook for the after hook of activate_cwk_asg.
2051: --
2052: begin
2053: hr_assignment_bkj.activate_cwk_asg_a
2054: (p_effective_date => l_effective_date
2055: ,p_datetrack_update_mode => p_datetrack_update_mode
2056: ,p_assignment_id => p_assignment_id
2057: ,p_change_reason => p_change_reason
2256: --
2257: -- Start of API User Hook for the before hook of actual_termination_cwk_asg.
2258: --
2259: begin
2260: hr_assignment_bkk.actual_termination_cwk_asg_b
2261: (p_assignment_id => p_assignment_id
2262: ,p_object_version_number => p_object_version_number
2263: ,p_actual_termination_date => l_actual_termination_date
2264: ,p_assignment_status_type_id => p_assignment_status_type_id
2427: -- Call the business support process to update assignment and maintain the
2428: -- element entries. We call this procedure for contingent workers
2429: -- because they are processed in the same way as employees.
2430: --
2431: hr_assignment_internal.actual_term_cwk_asg
2432: (p_assignment_id => p_assignment_id
2433: ,p_object_version_number => l_object_version_number
2434: ,p_actual_termination_date => l_actual_termination_date
2435: ,p_last_standard_process_date => l_last_standard_process_date
2453: -- be placed before the validate check and therefore before the code that
2454: -- sets all out parms.
2455: --
2456: begin
2457: hr_assignment_bkk.actual_termination_cwk_asg_a
2458: (p_assignment_id => p_assignment_id
2459: ,p_object_version_number => l_object_version_number
2460: ,p_actual_termination_date => l_actual_termination_date
2461: ,p_assignment_status_type_id => p_assignment_status_type_id
2654: --
2655: -- Start of API User Hook for the before hook of final_process_cwk_asg.
2656: --
2657: begin
2658: hr_assignment_bkh.final_process_cwk_asg_b
2659: (p_assignment_id => p_assignment_id
2660: ,p_object_version_number => p_object_version_number
2661: ,p_final_process_date => l_final_process_date
2662: );
2776: -- Call the business support process to update assignment and maintain the
2777: -- element entries. Here we call the emp procedure because processing
2778: -- for a contingent worker is identical from this point.
2779: --
2780: hr_assignment_internal.final_process_cwk_asg
2781: (p_assignment_id => p_assignment_id
2782: ,p_object_version_number => l_object_version_number
2783: ,p_final_process_date => l_final_process_date
2784: ,p_actual_termination_date => l_actual_termination_date
2795: --
2796: -- Start of API User Hook for the after hook of final_process_cwk_asg.
2797: --
2798: begin
2799: hr_assignment_bkh.final_process_cwk_asg_a
2800: (p_assignment_id => p_assignment_id
2801: ,p_object_version_number => l_object_version_number
2802: ,p_final_process_date => p_final_process_date
2803: ,p_effective_start_date => l_effective_start_date
2931: --
2932: -- Start of API User Hook for the before hook of suspend_cwk_asg.
2933: --
2934: begin
2935: hr_assignment_bkl.suspend_cwk_asg_b
2936: (p_effective_date => l_effective_date
2937: ,p_datetrack_update_mode => p_datetrack_update_mode
2938: ,p_assignment_id => p_assignment_id
2939: ,p_change_reason => p_change_reason
2950: --
2951: --
2952: -- Update contingent worker assignment.
2953: --
2954: hr_assignment_internal.update_status_type_cwk_asg
2955: (p_effective_date => l_effective_date
2956: ,p_datetrack_update_mode => p_datetrack_update_mode
2957: ,p_assignment_id => p_assignment_id
2958: ,p_change_reason => p_change_reason
2969: --
2970: -- Start of API User Hook for the after hook of suspend_cwk_asg.
2971: --
2972: begin
2973: hr_assignment_bkl.suspend_cwk_asg_a
2974: (p_effective_date => l_effective_date
2975: ,p_datetrack_update_mode => p_datetrack_update_mode
2976: ,p_assignment_id => p_assignment_id
2977: ,p_change_reason => p_change_reason
3172: --
3173: -- Start of API User Hook for the before hook of actual_termination_emp_asg.
3174: --
3175: begin
3176: hr_assignment_bk4.actual_termination_emp_asg_b
3177: (p_assignment_id => p_assignment_id
3178: ,p_object_version_number => p_object_version_number
3179: ,p_actual_termination_date => l_actual_termination_date
3180: ,p_assignment_status_type_id => p_assignment_status_type_id
3342: --
3343: -- Call the business support process to update assignment and maintain the
3344: -- element entries.
3345: --
3346: hr_assignment_internal.actual_term_emp_asg_sup
3347: (p_assignment_id => p_assignment_id
3348: ,p_object_version_number => l_object_version_number
3349: ,p_actual_termination_date => l_actual_termination_date
3350: ,p_last_standard_process_date => l_last_standard_process_date
3368: -- be placed before the validate check and therefore before the code that
3369: -- sets all out parms.
3370: --
3371: begin
3372: hr_assignment_bk4.actual_termination_emp_asg_a
3373: (p_assignment_id => p_assignment_id
3374: ,p_object_version_number => l_object_version_number
3375: ,p_actual_termination_date => l_actual_termination_date
3376: ,p_assignment_status_type_id => p_assignment_status_type_id
3658: l_assignment_number := p_assignment_number;
3659: --
3660: -- Call the new code
3661: --
3662: hr_assignment_api.create_secondary_emp_asg(
3663: p_validate => p_validate
3664: ,p_effective_date => p_effective_date
3665: ,p_person_id => p_person_id
3666: ,p_organization_id => p_organization_id
4088: l_assignment_number := p_assignment_number;
4089: --
4090: -- Call the new code
4091: --
4092: hr_assignment_api.create_secondary_emp_asg(
4093: p_validate => p_validate
4094: ,p_effective_date => p_effective_date
4095: ,p_person_id => p_person_id
4096: ,p_organization_id => p_organization_id
4532: l_assignment_number := p_assignment_number;
4533: --
4534: -- Call the new code
4535: --
4536: hr_assignment_api.create_secondary_emp_asg(
4537: p_validate => p_validate
4538: ,p_effective_date => p_effective_date
4539: ,p_person_id => p_person_id
4540: ,p_organization_id => p_organization_id
5381: --
5382: --
5383: -- Start of API User Hook for the before hook of create_secondary_emp_asg
5384: --
5385: hr_assignment_bk1.create_secondary_emp_asg_b
5386: (p_effective_date => l_effective_date
5387: ,p_person_id => p_person_id
5388: ,p_organization_id => p_organization_id
5389: ,p_grade_id => p_grade_id
5884: --
5885: --
5886: -- Insert secondary assignment
5887: --
5888: hr_assignment_internal.create_emp_asg
5889: (p_effective_date => l_effective_date
5890: ,p_legislation_code => l_legislation_code
5891: ,p_business_group_id => l_business_group_id
5892: ,p_person_id => p_person_id
5998: -- Bug 944911
5999: -- No amendments required for outs as the values carried forward
6000: -- Adding the 2 additional ins - p_concat_segments and p_pgp_concat_segments
6001: -- Both with the same value as passed to _b proc
6002: hr_assignment_bk1.create_secondary_emp_asg_a
6003: (p_effective_date => l_effective_date
6004: ,p_person_id => p_person_id
6005: ,p_organization_id => p_organization_id
6006: ,p_grade_id => p_grade_id
6581: BEGIN
6582: --
6583: -- Start of API User Hook for the before hook of create_secondary_emp_asg
6584: --
6585: hr_assignment_bkn.create_secondary_cwk_asg_b
6586: (p_effective_date => l_effective_date
6587: ,p_business_group_id => p_business_group_id
6588: ,p_person_id => p_person_id
6589: ,p_organization_id => p_organization_id
7074: */
7075: --
7076: -- Insert secondary assignment
7077: --
7078: hr_assignment_internal.create_cwk_asg
7079: (p_validate => p_validate
7080: ,p_effective_date => l_effective_date
7081: ,p_business_group_id => l_business_group_id
7082: ,p_legislation_code => l_legislation_code
7179: -- No amendments required for outs as the values carried forward
7180: -- Adding the 2 additional ins - p_concat_segments and p_pgp_concat_segments
7181: -- Both with the same value as passed to _b proc
7182: --
7183: hr_assignment_bkn.create_secondary_cwk_asg_a
7184: (p_effective_date => l_effective_date
7185: ,p_business_group_id => p_business_group_id
7186: ,p_person_id => p_person_id
7187: ,p_organization_id => p_organization_id
7789: -- Call create_secondary_emp_asg
7790: --
7791: -- Bug 944911
7792: -- Amended param p_scl_concatenated_segments to p_concatenated_segments
7793: hr_assignment_api.create_secondary_emp_asg
7794: (p_validate => p_validate
7795: ,p_effective_date => l_effective_date
7796: ,p_person_id => p_person_id
7797: ,p_organization_id => p_organization_id
8098: -- Call create_secondary_emp_asg
8099: --
8100: -- Bug 944911
8101: -- Amended param p_scl_concatenated_segments to p_concatenated_segments
8102: hr_assignment_api.create_secondary_emp_asg
8103: (p_validate => p_validate
8104: ,p_effective_date => l_effective_date
8105: ,p_person_id => p_person_id
8106: ,p_organization_id => p_organization_id
8420: -- Added new param p_concat_segments in
8421: -- made p_concatenated_segments to be out only
8422: -- Amended p_scl_concatenated_segments to be p_concatenated_segments
8423:
8424: hr_assignment_api.create_secondary_emp_asg
8425: (p_validate => p_validate
8426: ,p_effective_date => l_effective_date
8427: ,p_person_id => p_person_id
8428: ,p_organization_id => p_organization_id
8753: -- Added new param p_concat_segments in
8754: -- made p_concatenated_segments to be out only
8755: -- Amended p_scl_concatenated_segments to be p_concatenated_segments
8756:
8757: hr_assignment_api.create_secondary_emp_asg
8758: (p_validate => p_validate
8759: ,p_effective_date => l_effective_date
8760: ,p_person_id => p_person_id
8761: ,p_organization_id => p_organization_id
9018: --
9019: -- Start of API User Hook for the before hook of final_process_emp_asg.
9020: --
9021: begin
9022: hr_assignment_bka.final_process_emp_asg_b
9023: (p_assignment_id => p_assignment_id
9024: ,p_object_version_number => p_object_version_number
9025: ,p_final_process_date => l_final_process_date
9026: );
9133: --
9134: -- Call the business support process to update assignment and maintain the
9135: -- element entries.
9136: --
9137: hr_assignment_internal.final_process_emp_asg_sup
9138: (p_assignment_id => p_assignment_id
9139: ,p_object_version_number => l_object_version_number
9140: ,p_final_process_date => l_final_process_date
9141: ,p_actual_termination_date => l_actual_termination_date
9152: --
9153: -- Start of API User Hook for the after hook of final_process_emp_asg.
9154: --
9155: begin
9156: hr_assignment_bka.final_process_emp_asg_a
9157: (p_assignment_id => p_assignment_id
9158: ,p_object_version_number => l_object_version_number
9159: ,p_final_process_date => p_final_process_date
9160: ,p_effective_start_date => l_effective_start_date
9293: --
9294: -- Start of API User Hook for the before hook of suspend_emp_asg.
9295: --
9296: begin
9297: hr_assignment_bk7.suspend_emp_asg_b
9298: (p_effective_date => l_effective_date
9299: ,p_datetrack_update_mode => p_datetrack_update_mode
9300: ,p_assignment_id => p_assignment_id
9301: ,p_change_reason => p_change_reason
9312: --
9313: --
9314: -- Update employee assignment.
9315: --
9316: hr_assignment_internal.update_status_type_emp_asg
9317: (p_effective_date => l_effective_date
9318: ,p_datetrack_update_mode => p_datetrack_update_mode
9319: ,p_assignment_id => p_assignment_id
9320: ,p_change_reason => p_change_reason
9331: --
9332: -- Start of API User Hook for the after hook of suspend_emp_asg.
9333: --
9334: begin
9335: hr_assignment_bk7.suspend_emp_asg_a
9336: (p_effective_date => l_effective_date
9337: ,p_datetrack_update_mode => p_datetrack_update_mode
9338: ,p_assignment_id => p_assignment_id
9339: ,p_change_reason => p_change_reason
9544: l_proc := g_package||'update_emp_asg';
9545: hr_utility.set_location('Entering:'|| l_proc, 5);
9546: end if;
9547: ---- Call the new code
9548: hr_assignment_api.update_emp_asg
9549: (p_validate => p_validate
9550: ,p_effective_date => p_effective_date
9551: ,p_datetrack_update_mode => p_datetrack_update_mode
9552: ,p_assignment_id => p_assignment_id
9873: -- Added notice_period through to job_post_source_name in this call as they
9874: -- were missing
9875: -- see bug 2122535 for details
9876: --
9877: hr_assignment_api.update_emp_asg
9878: (p_validate => p_validate
9879: ,p_effective_date => p_effective_date
9880: ,p_datetrack_update_mode => p_datetrack_update_mode
9881: ,p_assignment_id => p_assignment_id
10223: --
10224: -- Call the new code
10225: -- Added p_gsp_post_process_warning
10226: --
10227: hr_assignment_api.update_emp_asg
10228: (p_validate => p_validate
10229: ,p_effective_date => p_effective_date
10230: ,p_datetrack_update_mode => p_datetrack_update_mode
10231: ,p_assignment_id => p_assignment_id
10860: begin
10861: --
10862: -- Start of API User Hook for the before hook of update_emp_asg
10863: --
10864: hr_assignment_bk2.update_emp_asg_b
10865: (p_effective_date => l_effective_date
10866: ,p_datetrack_update_mode => p_datetrack_update_mode
10867: ,p_assignment_id => p_assignment_id
10868: ,p_object_version_number => p_object_version_number
11501: end if;
11502: --
11503: /* auto fte calculation bug#14700032 code changes starts */
11504:
11505: hr_assignment_internal.auto_calc_fte
11506: (p_assignment_id => p_assignment_id,
11507: p_effective_start_date => l_effective_start_date
11508: );
11509: hr_utility.set_location(l_proc|| ' passed hr_assignment_internal.auto_calc_fte ', 281);
11505: hr_assignment_internal.auto_calc_fte
11506: (p_assignment_id => p_assignment_id,
11507: p_effective_start_date => l_effective_start_date
11508: );
11509: hr_utility.set_location(l_proc|| ' passed hr_assignment_internal.auto_calc_fte ', 281);
11510:
11511: /* auto fte calculation bug#14700032 code changes ends */
11512: --
11513: begin
11513: begin
11514: --
11515: -- Start of API User Hook for the after hook of update_emp_asg
11516: --
11517: hr_assignment_bk2.update_emp_asg_a
11518: (p_effective_date => l_effective_date
11519: ,p_datetrack_update_mode => p_datetrack_update_mode
11520: ,p_assignment_id => p_assignment_id
11521: ,p_object_version_number => p_object_version_number
12002: BEGIN
12003: --
12004: -- Start of API User Hook for the before hook of update_emp_asg
12005: --
12006: hr_assignment_bkm.update_cwk_asg_b
12007: (p_effective_date => l_effective_date
12008: ,p_datetrack_update_mode => p_datetrack_update_mode
12009: ,p_assignment_id => p_assignment_id
12010: ,p_object_version_number => p_object_version_number
12563: BEGIN
12564: --
12565: -- Start of API User Hook for the after hook of update_cwk_asg
12566: --
12567: hr_assignment_bkm.update_cwk_asg_a
12568: (p_effective_date => l_effective_date
12569: ,p_datetrack_update_mode => p_datetrack_update_mode
12570: ,p_assignment_id => p_assignment_id
12571: ,p_object_version_number => p_object_version_number
12993: BEGIN
12994: --
12995: -- Start of API User Hook for the before hook of update_emp_asg_criteria
12996: --
12997: hr_assignment_bko.update_cwk_asg_criteria_b
12998: (p_effective_date => l_effective_date
12999: ,p_datetrack_update_mode => l_dt_update_mode
13000: ,p_assignment_id => p_assignment_id
13001: ,p_object_version_number => p_object_version_number
13434: end if;
13435: --
13436: -- Maintain spinal point placements.
13437: --
13438: hr_assignment_internal.maintain_spp_asg
13439: (p_assignment_id => p_assignment_id
13440: ,p_datetrack_mode => l_new_dt_update_mode
13441: ,p_validation_start_date => l_validation_start_date
13442: ,p_validation_end_date => l_validation_end_date
13524: BEGIN
13525: --
13526: -- Start of API User Hook for the after hook of update_emp_asg_criteria
13527: --
13528: hr_assignment_bko.update_cwk_asg_criteria_a
13529: (p_effective_date => l_effective_date
13530: ,p_datetrack_update_mode => l_dt_update_mode
13531: ,p_assignment_id => p_assignment_id
13532: ,p_object_version_number => p_object_version_number
13752: end if;
13753: --
13754: -- Call the overloaded procedure
13755: --
13756: hr_assignment_api.update_gb_emp_asg
13757: (p_validate => p_validate
13758: ,p_effective_date => p_effective_date
13759: ,p_datetrack_update_mode => p_datetrack_update_mode
13760: ,p_assignment_id => p_assignment_id
13978: end if;
13979: --
13980: -- Call update_emp_asg business process
13981: --
13982: hr_assignment_api.update_emp_asg
13983: (p_validate => p_validate
13984: ,p_effective_date => p_effective_date
13985: ,p_datetrack_update_mode => p_datetrack_update_mode
13986: ,p_assignment_id => p_assignment_id
14215: end if;
14216: --
14217: -- Call update_emp_asg business process
14218: --
14219: hr_assignment_api.update_emp_asg
14220: (p_validate => p_validate
14221: ,p_effective_date => p_effective_date
14222: ,p_datetrack_update_mode => p_datetrack_update_mode
14223: ,p_assignment_id => p_assignment_id
14409: end if;
14410: --
14411: -- Call the overloaded procedure update_us_emp_asg
14412: --
14413: hr_assignment_api.update_emp_asg
14414: (p_validate => p_validate
14415: ,p_effective_date => p_effective_date
14416: ,p_datetrack_update_mode => p_datetrack_update_mode
14417: ,p_assignment_id => p_assignment_id
14663: end if;
14664: --
14665: -- Call update_emp_asg business process
14666: --
14667: hr_assignment_api.update_emp_asg
14668: (p_validate => p_validate
14669: ,p_effective_date => p_effective_date
14670: ,p_datetrack_update_mode => p_datetrack_update_mode
14671: ,p_assignment_id => p_assignment_id
14929: end if;
14930: --
14931: -- Call update_emp_asg business process
14932: --
14933: hr_assignment_api.update_emp_asg
14934: (p_validate => p_validate
14935: ,p_effective_date => p_effective_date
14936: ,p_datetrack_update_mode => p_datetrack_update_mode
14937: ,p_assignment_id => p_assignment_id
15197: end if;
15198: --
15199: -- Call update_emp_asg business process
15200: --
15201: hr_assignment_api.update_emp_asg
15202: (p_validate => p_validate
15203: ,p_effective_date => p_effective_date
15204: ,p_datetrack_update_mode => p_datetrack_update_mode
15205: ,p_assignment_id => p_assignment_id
15434: --
15435: -- Calling New Overloaded Procedure
15436: --
15437:
15438: hr_assignment_api.update_emp_asg_criteria
15439: (p_validate => p_validate
15440: ,p_effective_date => p_effective_date
15441: ,p_datetrack_update_mode => p_datetrack_update_mode
15442: ,p_called_from_mass_update => p_called_from_mass_update
15649: --
15650: -- Calling New Overloaded Procedure
15651: --
15652:
15653: hr_assignment_api.update_emp_asg_criteria
15654: (p_validate => p_validate
15655: ,p_effective_date => p_effective_date
15656: ,p_datetrack_update_mode => p_datetrack_update_mode
15657: ,p_called_from_mass_update => p_called_from_mass_update
16201: begin
16202: --
16203: -- Start of API User Hook for the before hook of update_emp_asg_criteria
16204: --
16205: hr_assignment_bk3.update_emp_asg_criteria_b
16206: (p_effective_date => l_effective_date
16207: ,p_datetrack_update_mode => l_dt_update_mode
16208: ,p_assignment_id => p_assignment_id
16209: ,p_object_version_number => p_object_version_number
17059: end if;
17060: --
17061: -- Maintain spinal point placements.
17062: --
17063: hr_assignment_internal.maintain_spp_asg
17064: (p_assignment_id => p_assignment_id
17065: ,p_datetrack_mode => l_new_dt_update_mode
17066: ,p_validation_start_date => l_validation_start_date
17067: ,p_validation_end_date => l_validation_end_date
17148: begin
17149: --
17150: -- Start of API User Hook for the after hook of update_emp_asg_criteria
17151: --
17152: hr_assignment_bk3.update_emp_asg_criteria_a
17153: (p_effective_date => l_effective_date
17154: ,p_datetrack_update_mode => l_dt_update_mode
17155: ,p_assignment_id => p_assignment_id
17156: ,p_object_version_number => p_object_version_number
18075: --
18076: -- Start of API User Hook for the before hook of update_apl_asg.
18077: --
18078: begin
18079: hr_assignment_bk5.update_apl_asg_b
18080: (p_effective_date => l_effective_date
18081: ,p_datetrack_update_mode => p_datetrack_update_mode
18082: ,p_assignment_id => p_assignment_id
18083: ,p_object_version_number => p_object_version_number
18808: --
18809: -- Start of API User Hook for the after hook of suspend_emp_asg.
18810: --
18811: begin
18812: hr_assignment_bk5.update_apl_asg_a
18813: (p_effective_date => l_effective_date
18814: ,p_datetrack_update_mode => p_datetrack_update_mode
18815: ,p_assignment_id => p_assignment_id
18816: ,p_object_version_number => l_object_version_number
19265: --
19266: -- Call the new code
19267: -- bug 944911
19268: -- made no changes to p_group_name as it is out , while in is
19269: hr_assignment_api.update_apl_asg(
19270: p_validate => p_validate
19271: ,p_effective_date => p_effective_date
19272: ,p_datetrack_update_mode => p_datetrack_update_mode
19273: ,p_assignment_id => p_assignment_id
20427: --
20428: -- Start of API User Hook for the before hook of create_secondary_apl_asg.
20429: --
20430: begin
20431: hr_assignment_bk8.create_secondary_apl_asg_b
20432: (p_effective_date => l_effective_date
20433: ,p_person_id => p_person_id
20434: ,p_organization_id => p_organization_id
20435: ,p_recruiter_id => p_recruiter_id
20948: else
20949: l_assignment_status_type_id := p_assignment_status_type_id;
20950: end if;
20951: --
20952: hr_assignment_api.update_apl_asg
20953: (p_validate => FALSE
20954: ,p_effective_date => l_effective_date
20955: ,p_datetrack_update_mode => hr_api.g_correction
20956: ,p_assignment_id => l_assignment_id
21135: else -- application is not end dated
21136: --
21137: -- Insert secondary assignment
21138: --
21139: hr_assignment_internal.create_apl_asg
21140: (p_effective_date => l_effective_date
21141: ,p_legislation_code => l_legislation_code
21142: ,p_business_group_id => l_business_group_id
21143: ,p_person_id => p_person_id
21248: --
21249: -- Start of API User Hook for the after hook of create_secondary_apl_asg.
21250: --
21251: begin
21252: hr_assignment_bk8.create_secondary_apl_asg_a
21253: (p_effective_date => l_effective_date
21254: ,p_person_id => p_person_id
21255: ,p_organization_id => p_organization_id
21256: ,p_recruiter_id => p_recruiter_id
21694: end if;
21695: -- Call the new code
21696: -- Bug 944911
21697: -- No change to call point as all outs are present while the ins have defaults
21698: hr_assignment_api.create_secondary_apl_asg(
21699: p_validate => p_validate
21700: ,p_effective_date => p_effective_date
21701: ,p_person_id => p_person_id
21702: ,p_organization_id => p_organization_id
21875: --
21876: -- Start of API User Hook for the before hook of offer_apl_asg.
21877: --
21878: begin
21879: hr_assignment_bk9.offer_apl_asg_b
21880: (p_effective_date => l_effective_date
21881: ,p_datetrack_update_mode => p_datetrack_update_mode
21882: ,p_assignment_id => p_assignment_id
21883: ,p_object_version_number => p_object_version_number
21891: p_hook_type => 'BP'
21892: );
21893: end;
21894: --
21895: hr_assignment_internal.update_status_type_apl_asg
21896: (p_effective_date => l_effective_date
21897: ,p_datetrack_update_mode => p_datetrack_update_mode
21898: ,p_assignment_id => p_assignment_id
21899: ,p_object_version_number => l_object_version_number
21910: --
21911: -- Start of API User Hook for the after hook of offer_apl_asg.
21912: --
21913: begin
21914: hr_assignment_bk9.offer_apl_asg_a
21915: (p_effective_date => l_effective_date
21916: ,p_datetrack_update_mode => p_datetrack_update_mode
21917: ,p_assignment_id => p_assignment_id
21918: ,p_object_version_number => l_object_version_number
22036: --
22037: -- Start of API User Hook for the before hook of accept_apl_asg.
22038: --
22039: begin
22040: hr_assignment_bkb.accept_apl_asg_b
22041: (p_effective_date => l_effective_date
22042: ,p_datetrack_update_mode => p_datetrack_update_mode
22043: ,p_assignment_id => p_assignment_id
22044: ,p_object_version_number => p_object_version_number
22054: end;
22055: -- End of API User Hook for the before hook of accept_apl_asg.
22056:
22057: --
22058: hr_assignment_internal.update_status_type_apl_asg
22059: (p_effective_date => l_effective_date
22060: ,p_datetrack_update_mode => p_datetrack_update_mode
22061: ,p_assignment_id => p_assignment_id
22062: ,p_object_version_number => l_object_version_number
22073: --
22074: -- Start of API User Hook for the after hook of accept_apl_asg.
22075: --
22076: begin
22077: hr_assignment_bkb.accept_apl_asg_a
22078: (p_effective_date => l_effective_date
22079: ,p_datetrack_update_mode => p_datetrack_update_mode
22080: ,p_assignment_id => p_assignment_id
22081: ,p_object_version_number => l_object_version_number
22189: --
22190: -- Call Before Process User Hook
22191: --
22192: BEGIN
22193: hr_assignment_bkc.activate_apl_asg_b
22194: (p_effective_date => l_effective_date
22195: ,p_datetrack_update_mode => p_datetrack_update_mode
22196: ,p_assignment_id => p_assignment_id
22197: ,p_object_version_number => p_object_version_number
22212: end if;
22213: --
22214: -- Call business support process to update status type
22215: --
22216: hr_assignment_internal.update_status_type_apl_asg
22217: (p_effective_date => l_effective_date
22218: ,p_datetrack_update_mode => p_datetrack_update_mode
22219: ,p_assignment_id => p_assignment_id
22220: ,p_object_version_number => p_object_version_number
22231: --
22232: -- Call After Process User Hook
22233: --
22234: BEGIN
22235: hr_assignment_bkc.activate_apl_asg_a
22236: (p_effective_date => l_effective_date
22237: ,p_datetrack_update_mode => p_datetrack_update_mode
22238: ,p_assignment_id => p_assignment_id
22239: ,p_object_version_number => p_object_version_number
22315: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22316: )
22317: IS
22318: BEGIN
22319: hr_assignment_api.terminate_apl_asg
22320: (p_validate => p_validate
22321: ,p_effective_date => p_effective_date
22322: ,p_assignment_id => p_assignment_id
22323: ,p_assignment_status_type_id => p_assignment_status_type_id
22690: --
22691: -- Call Before Process User Hook
22692: --
22693: BEGIN
22694: hr_assignment_bkd.terminate_apl_asg_b
22695: (p_effective_date => l_effective_date
22696: ,p_assignment_id => p_assignment_id
22697: ,p_object_version_number => p_object_version_number
22698: );
23177: --
23178: -- Call After Process User Hook
23179: --
23180: BEGIN
23181: hr_assignment_bkd.terminate_apl_asg_a
23182: (p_effective_date => l_effective_date
23183: ,p_assignment_id => p_assignment_id
23184: ,p_object_version_number => p_object_version_number
23185: ,p_effective_start_date => l_effective_start_date
23360: --
23361: -- Call Before Process User Hook
23362: --
23363: BEGIN
23364: hr_assignment_bke.set_new_primary_asg_b
23365: (p_effective_date => l_effective_date
23366: ,p_person_id => p_person_id
23367: ,p_assignment_id => p_assignment_id
23368: ,p_object_version_number => p_object_version_number
23449: --
23450: -- # 2468916: This should be executed after creating NEW primary
23451: -- assignment. This call is replaced by do_primary_update proc.
23452: --
23453: -- hr_assignment.update_primary
23454: -- (p_assignment_id => l_old_assignment.assignment_id
23455: -- ,p_period_of_service_id => l_old_assignment.period_of_service_id
23456: -- ,p_new_primary_ass_id => p_assignment_id
23457: -- ,p_sdate => l_effective_date
23466: end if;
23467: --
23468: -- Start the new primary assignment
23469: --
23470: hr_assignment.update_primary
23471: (p_assignment_id => l_old_assignment.assignment_id -- #2468916:instead of p_assignment_id
23472: ,p_period_of_service_id => l_old_assignment.period_of_service_id -- #2468916:instead of new.
23473: ,p_new_primary_ass_id => p_assignment_id
23474: ,p_sdate => l_effective_date
23483: end if;
23484: --
23485: -- #2468916: End previous assignment
23486: --
23487: hr_assignment.do_primary_update(l_old_assignment.assignment_id --p_assignment_id
23488: ,l_effective_date -- p_sdate
23489: ,'N' -- primary flag
23490: ,'N' -- current asg
23491: ,TO_NUMBER(NULL) --p_last_updated_by
23518: --
23519: -- Call After Process User Hook
23520: --
23521: BEGIN
23522: hr_assignment_bke.set_new_primary_asg_a
23523: (p_effective_date => l_effective_date
23524: ,p_person_id => p_person_id
23525: ,p_assignment_id => p_assignment_id
23526: ,p_object_version_number => l_new_assignment.object_version_number
23702: -- Call Before Process User Hook
23703: --
23704: BEGIN
23705: --
23706: hr_assignment_bki.set_new_primary_cwk_asg_b
23707: (p_effective_date => l_effective_date
23708: ,p_person_id => p_person_id
23709: ,p_assignment_id => p_assignment_id
23710: ,p_object_version_number => p_object_version_number);
23806: end if;
23807: --
23808: -- End the previous primary assignment
23809: --
23810: hr_assignment.update_primary_cwk
23811: (p_assignment_id => l_old_assignment.assignment_id
23812: ,p_person_id => p_person_id
23813: ,p_pop_date_start => l_old_assignment.period_of_placement_date_start
23814: ,p_new_primary_ass_id => p_assignment_id
23824: end if;
23825: --
23826: -- Start the new primary assignment
23827: --
23828: hr_assignment.update_primary_cwk
23829: (p_assignment_id => p_assignment_id
23830: ,p_person_id => p_person_id
23831: ,p_pop_date_start => l_new_assignment.period_of_placement_date_start
23832: ,p_new_primary_ass_id => p_assignment_id
23867: -- Call After Process User Hook
23868: --
23869: BEGIN
23870: --
23871: hr_assignment_bki.set_new_primary_cwk_asg_a
23872: (p_effective_date => l_effective_date
23873: ,p_person_id => p_person_id
23874: ,p_assignment_id => p_assignment_id
23875: ,p_object_version_number => l_new_assignment.object_version_number
23991: --
23992: -- Call Before Process User Hook
23993: --
23994: BEGIN
23995: hr_assignment_bkf.interview1_apl_asg_b
23996: (p_effective_date => l_effective_date
23997: ,p_datetrack_update_mode => p_datetrack_update_mode
23998: ,p_assignment_id => p_assignment_id
23999: ,p_object_version_number => p_object_version_number
24014: end if;
24015: --
24016: -- Call business support process to update status type
24017: --
24018: hr_assignment_internal.update_status_type_apl_asg
24019: (p_effective_date => l_effective_date
24020: ,p_datetrack_update_mode => p_datetrack_update_mode
24021: ,p_assignment_id => p_assignment_id
24022: ,p_object_version_number => p_object_version_number
24033: --
24034: -- Call After Process User Hook
24035: --
24036: BEGIN
24037: hr_assignment_bkf.interview1_apl_asg_a
24038: (p_effective_date => l_effective_date
24039: ,p_datetrack_update_mode => p_datetrack_update_mode
24040: ,p_assignment_id => p_assignment_id
24041: ,p_object_version_number => p_object_version_number
24155: --
24156: -- Call Before Process User Hook
24157: --
24158: BEGIN
24159: hr_assignment_bkg.interview2_apl_asg_b
24160: (p_effective_date => l_effective_date
24161: ,p_datetrack_update_mode => p_datetrack_update_mode
24162: ,p_assignment_id => p_assignment_id
24163: ,p_object_version_number => p_object_version_number
24178: end if;
24179: --
24180: -- Call business support process to update status type
24181: --
24182: hr_assignment_internal.update_status_type_apl_asg
24183: (p_effective_date => l_effective_date
24184: ,p_datetrack_update_mode => p_datetrack_update_mode
24185: ,p_assignment_id => p_assignment_id
24186: ,p_object_version_number => p_object_version_number
24197: --
24198: -- Call After Process User Hook
24199: --
24200: BEGIN
24201: hr_assignment_bkg.interview2_apl_asg_a
24202: (p_effective_date => l_effective_date
24203: ,p_datetrack_update_mode => p_datetrack_update_mode
24204: ,p_assignment_id => p_assignment_id
24205: ,p_object_version_number => p_object_version_number
24343: begin
24344: --
24345: -- Start of API User Hook for the before hook of delete_assignment
24346: --
24347: hr_assignment_bkp.delete_assignment_b
24348: (p_effective_date => l_effective_date
24349: ,p_assignment_id => p_assignment_id
24350: ,p_datetrack_mode => p_datetrack_mode
24351: );
24383: begin
24384: --
24385: -- Start of API User Hook for the after hook of delete_assignment
24386: --
24387: hr_assignment_bkp.delete_assignment_a
24388: (p_effective_date => l_effective_date
24389: ,p_assignment_id => p_assignment_id
24390: ,p_datetrack_mode => p_datetrack_mode
24391: ,p_loc_change_tax_issues => p_loc_change_tax_issues
24456: raise;
24457: --
24458: END; -- End of delete_assignment Procedure
24459: --
24460: END hr_assignment_api;