APPS.HR_ASSIGNMENT dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 147: per_assignment_extra_info exists on

143:
144: 70.50 18-Mar-98 fychu 642566 1) Removed code in del_ref_int_check
145: procedure. APP-07642 error message
146: is no longer issued if there is
147: per_assignment_extra_info exists on
148: a delete.
149: 2) Added code to del_ref_int_delete
150: procedure to remove
151: per_assignment_extra_info records

Line 151: per_assignment_extra_info records

147: per_assignment_extra_info exists on
148: a delete.
149: 2) Added code to del_ref_int_delete
150: procedure to remove
151: per_assignment_extra_info records
152: when an assignment is deleted.
153: 110.4 16-APR-1998 SASmith Due to date tracking of the per_assignment_budget_values_f
154: table the following changes have been made.
155: 1.load_budget_values parameters changed to include

Line 2373: PER_ASSIGNMENT_EXTRA_INFO

2369: For 'ZAP'
2370: PER_EVENTS
2371: PER_LETTER_REQUEST_LINES
2372: PAY_COST_ALLOCATIONS_F
2373: PER_ASSIGNMENT_EXTRA_INFO
2374: PAY_PERSONAL_PAYMENT_METHODS_F
2375: HR_ASSIGNMENT_SET_AMENDMENTS
2376: PAY_ASSIGNMENT_ACTIONS
2377: PER_COBRA_COV_ENROLLMENTS

Line 2536: -- Removed code to check for existence of per_assignment_extra_info on a delete

2532: END IF;
2533: --
2534: --
2535: -- 03/18/1998 Bug #642566
2536: -- Removed code to check for existence of per_assignment_extra_info on a delete
2537: -- as per_assignment_extra_info are now deleted along with other
2538: -- assignment related records.
2539: --
2540: --

Line 2537: -- as per_assignment_extra_info are now deleted along with other

2533: --
2534: --
2535: -- 03/18/1998 Bug #642566
2536: -- Removed code to check for existence of per_assignment_extra_info on a delete
2537: -- as per_assignment_extra_info are now deleted along with other
2538: -- assignment related records.
2539: --
2540: --
2541: hr_utility.set_location('hr_assignment.del_ref_int_check',5);

Line 3521: -- Remove per_assignment_extra_info records

3517: END IF;
3518: --
3519:
3520: -- 03/18/1998 Bug #642566
3521: -- Remove per_assignment_extra_info records
3522: hr_utility.set_location('hr_assignment.del_ref_int_delete',14);
3523: p_del_flag := 'N';
3524: --
3525: BEGIN

Line 3532: FROM PER_ASSIGNMENT_EXTRA_INFO

3528: into p_del_flag
3529: FROM SYS.DUAL
3530: WHERE EXISTS
3531: (SELECT NULL
3532: FROM PER_ASSIGNMENT_EXTRA_INFO
3533: WHERE ASSIGNMENT_ID = p_assignment_id);
3534: --
3535: EXCEPTION
3536: WHEN NO_DATA_FOUND THEN NULL;

Line 3542: DELETE FROM PER_ASSIGNMENT_EXTRA_INFO

3538: --
3539: IF p_del_flag = 'Y' THEN
3540: --
3541: hr_utility.set_location('hr_assignment.delete_ass_ref_int',16);
3542: DELETE FROM PER_ASSIGNMENT_EXTRA_INFO
3543: WHERE ASSIGNMENT_ID = p_assignment_id;
3544: END IF;
3545: -- 03/18/1998 Change Ends
3546: --