[Home] [Help]
525: --
526: hr_utility.set_location('hr_assignment.gen_new_ass_number',1);
527: select 'Y'
528: into duplicate
529: from sys.dual
530: where exists
531: ( select 'Y'
532: from per_all_assignments_f
533: -- from per_assignments_f commented for bug 4232539
1108: hr_utility.set_location('hr_assignment.warn_del_term',1);
1109: --
1110: select 'Y'
1111: into p_term_found
1112: from sys.dual
1113: where exists
1114: (select null
1115: from per_assignments_f a
1116: , per_assignment_status_types s
1170: hr_utility.set_location('hr_assignment.delete_ass_ref_int',1);
1171: --
1172: SELECT 'Y'
1173: into del_flag
1174: FROM SYS.DUAL
1175: WHERE EXISTS
1176: (SELECT NULL
1177: FROM PER_SPINAL_POINT_PLACEMENTS_F P
1178: WHERE P.business_group_id + 0 = p_business_group_id
1198: hr_utility.set_location('hr_assignment.delete_ass_ref_int',3);
1199: --
1200: SELECT 'Y'
1201: into del_flag
1202: from sys.dual
1203: WHERE EXISTS
1204: (SELECT NULL
1205: FROM PER_SECONDARY_ASS_STATUSES S
1206: WHERE S.business_group_id + 0 = p_business_group_id
1225: hr_utility.set_location('hr_assignment.delete_ass_ref_int',5);
1226: --
1227: SELECT 'Y'
1228: into del_flag
1229: from sys.dual
1230: WHERE EXISTS
1231: (SELECT NULL
1232: FROM PER_ASSIGNMENT_BUDGET_VALUES_F BV
1233: WHERE BV.business_group_id + 0 = p_business_group_id
1367: hr_utility.set_location('hr_assignment.check_future_primary',2);
1368: --
1369: select 'Y'
1370: into p_change_flag
1371: from sys.dual
1372: where exists
1373: (select null
1374: from per_assignments_f
1375: where assignment_id = p_assignment_id
1662: flag = 'N' and that all future changes are set to 'N'
1663: otherwise
1664: ensure that all future primary flags are set to 'N'.
1665: NB. This uses several calls to DO_PRIMARY_UPDATE which handles the
1666: date effective insert for an individual assignment row if one
1667: is required.
1668: PARAMETERS
1669: p_assignment_id - The current assignment
1670: p_period_of_service_id - The current Period of Service
2452: --
2453: BEGIN
2454: select 'Y'
2455: into p_del_flag
2456: from sys.dual
2457: where exists (
2458: select null
2459: from PER_ASSIGNMENTS_F A
2460: , FND_SESSIONS S
2485: --
2486: BEGIN
2487: select 'Y'
2488: into p_del_flag
2489: from sys.dual
2490: where exists (
2491: select null
2492: from PER_EVENTS
2493: where assignment_id = p_assignment_id
2517: --
2518: BEGIN
2519: select 'Y'
2520: into p_del_flag
2521: from sys.dual
2522: where exists (
2523: select null
2524: from PER_LETTER_REQUEST_LINES
2525: where assignment_id = p_assignment_id
2546: --
2547: BEGIN
2548: select 'Y'
2549: into p_del_flag
2550: from sys.dual
2551: where exists (
2552: select null
2553: from PAY_COST_ALLOCATIONS_F
2554: where assignment_id = p_assignment_id
2583: --
2584: BEGIN
2585: select 'Y'
2586: into p_del_flag
2587: from sys.dual
2588: where exists (
2589: select null
2590: from PER_SECONDARY_ASS_STATUSES
2591: where assignment_id = p_assignment_id
2613: --
2614: BEGIN
2615: select 'Y'
2616: into p_del_flag
2617: from sys.dual
2618: where exists (
2619: select null
2620: from PAY_PERSONAL_PAYMENT_METHODS_F
2621: where assignment_id = p_assignment_id
2643: --
2644: /* BEGIN
2645: select 'Y'
2646: into p_del_flag
2647: from sys.dual
2648: where exists
2649: (select null
2650: from pay_payroll_actions ps
2651: , pay_assignment_actions aa
2662: IF P_MODE = 'ZAP' then -- Added for Bug 4946199
2663: BEGIN
2664: select 'Y'
2665: into p_del_flag
2666: from dual
2667: where exists
2668: (select null
2669: from pay_payroll_actions ps
2670: , pay_assignment_actions aa
2678: ELSIF p_MODE = 'END' then
2679: BEGIN
2680: select 'Y'
2681: into p_del_flag
2682: from sys.dual
2683: where exists
2684: (select null
2685: from pay_payroll_actions ps
2686: , pay_assignment_actions aa
2710: --
2711: BEGIN
2712: select 'Y'
2713: into p_del_flag
2714: from sys.dual
2715: where exists (
2716: select null
2717: from hr_assignment_set_amendments asa
2718: where asa.assignment_id = p_assignment_id
2740: --
2741: BEGIN
2742: select 'Y'
2743: into p_del_flag
2744: from sys.dual
2745: where exists (
2746: select null
2747: from PER_COBRA_COV_ENROLLMENTS
2748: where assignment_id = p_assignment_id
2769: --
2770: BEGIN
2771: select 'Y'
2772: into p_del_flag
2773: from dual
2774: where exists
2775: (select null
2776: from per_cobra_cov_enrollments e
2777: , per_cobra_coverage_benefits_f b
2810: This has beeen changed for Bug# 787633 */
2811:
2812: select 'Y'
2813: into p_del_flag
2814: from sys.dual
2815: where exists (
2816: select null
2817: from PAY_US_EMP_FED_TAX_RULES_F pef,
2818: per_assignments_f paf
2984: BEGIN
2985: --
2986: SELECT 'Y'
2987: into p_del_flag
2988: FROM SYS.DUAL
2989: WHERE EXISTS
2990: (SELECT NULL
2991: FROM PER_SPINAL_POINT_PLACEMENTS_F P
2992: WHERE P.ASSIGNMENT_ID = p_assignment_id
3338: BEGIN
3339: --
3340: SELECT 'Y'
3341: into p_del_flag
3342: FROM SYS.DUAL
3343: WHERE EXISTS
3344: (SELECT NULL
3345: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3346: WHERE ABV.ASSIGNMENT_ID = p_assignment_id
3444: -- Just do a lookup without any complex where clause because the complex
3445: -- where clause has been done in PRE-DELETE triggers.
3446: SELECT 'Y'
3447: into p_del_flag
3448: FROM SYS.DUAL
3449: WHERE EXISTS
3450: (SELECT NULL
3451: FROM HR_ASSIGNMENT_SET_AMENDMENTS
3452: WHERE ASSIGNMENT_ID = p_assignment_id);
3470: BEGIN
3471: --
3472: SELECT 'Y'
3473: into p_del_flag
3474: FROM SYS.DUAL
3475: WHERE EXISTS
3476: (SELECT NULL
3477: FROM PER_SECONDARY_ASS_STATUSES
3478: WHERE ASSIGNMENT_ID = p_assignment_id);
3495: BEGIN
3496: --
3497: SELECT 'Y'
3498: into p_del_flag
3499: FROM SYS.DUAL
3500: WHERE EXISTS
3501: (SELECT NULL
3502: FROM PER_PAY_PROPOSALS
3503: WHERE ASSIGNMENT_ID = p_assignment_id);
3520:
3521: BEGIN
3522: select 'Y'
3523: into p_del_flag
3524: from sys.dual
3525: where exists (
3526: select null
3527: from PAY_US_EMP_FED_TAX_RULES_F pef
3528: where pef.assignment_id = p_assignment_id);
3565: BEGIN
3566: --
3567: SELECT 'Y'
3568: into p_del_flag
3569: FROM SYS.DUAL
3570: WHERE EXISTS
3571: (SELECT NULL
3572: FROM PER_ASSIGNMENT_EXTRA_INFO
3573: WHERE ASSIGNMENT_ID = p_assignment_id);
3723: p_cost_warning := FALSE;
3724: BEGIN
3725: select 'Y'
3726: into p_del_flag
3727: from sys.dual
3728: where exists (
3729: select null
3730: from per_secondary_ass_statuses
3731: where assignment_id = p_assignment_id
3768: --
3769: BEGIN
3770: select 'Y'
3771: into p_del_flag
3772: from sys.dual
3773: where exists (
3774: select null
3775: from per_secondary_ass_statuses
3776: where assignment_id = p_assignment_id
3796: --
3797: BEGIN
3798: select 'Y'
3799: into p_del_flag
3800: from sys.dual
3801: where exists (
3802: select null
3803: from pay_cost_allocations_f
3804: where assignment_id = p_assignment_id
3884: --
3885: BEGIN
3886: select 'Y'
3887: into p_del_flag
3888: from sys.dual
3889: where exists (
3890: select null
3891: from per_assignment_budget_values_f abv
3892: where abv.assignment_id = p_assignment_id
3913:
3914: BEGIN
3915: select 'Y'
3916: into p_del_flag
3917: from sys.dual
3918: where exists (
3919: select null
3920: from per_assignment_budget_values_f abv
3921: where abv.assignment_id = p_assignment_id
4083: call_terminate_entries
4084: DESCRIPTION
4085: This procedure determines the Actual Termination Date, Last Standard
4086: Processing Date and Final Process Date in order to terminate element
4087: entries and ALUs when an individual assignment is terminated or ended.
4088:
4089: There are several cases :-
4090:
4091: i. Status is END and there are no prior TERM_ASSIGNs
4144: --
4145: BEGIN
4146: select 'Y'
4147: into term_exists
4148: from sys.dual
4149: where exists
4150: (select null
4151: from per_assignments_f a
4152: , per_assignment_status_types s
4459: hr_utility.set_location('hr_assignment.check_for_cobra',1);
4460: BEGIN
4461: select 'Y'
4462: into l_cobra_term_exists
4463: from sys.dual
4464: where exists
4465: (select null
4466: from per_cobra_cov_enrollments e
4467: where e.assignment_id = p_assignment_id
5082: declare
5083: g_rec per_assignments_v%rowtype;
5084: begin
5085: HR_ASSIGNMENT.get_assgn_dff_value('||p_business_group_id||','||p_person_id||','||p_assignment_id||','||':1,g_rec);
5086: select g_rec.'||l_context_val||' into :2 from dual;
5087: end;';
5088:
5089: EXECUTE IMMEDIATE l_sql using
5090: in out l_effective_start_date,