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 2410: PER_ASSIGNMENT_EXTRA_INFO

2406: For 'ZAP'
2407: PER_EVENTS
2408: PER_LETTER_REQUEST_LINES
2409: PAY_COST_ALLOCATIONS_F
2410: PER_ASSIGNMENT_EXTRA_INFO
2411: PAY_PERSONAL_PAYMENT_METHODS_F
2412: HR_ASSIGNMENT_SET_AMENDMENTS
2413: PAY_ASSIGNMENT_ACTIONS
2414: PER_COBRA_COV_ENROLLMENTS

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

2569: END IF;
2570: --
2571: --
2572: -- 03/18/1998 Bug #642566
2573: -- Removed code to check for existence of per_assignment_extra_info on a delete
2574: -- as per_assignment_extra_info are now deleted along with other
2575: -- assignment related records.
2576: --
2577: --

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

2570: --
2571: --
2572: -- 03/18/1998 Bug #642566
2573: -- Removed code to check for existence of per_assignment_extra_info on a delete
2574: -- as per_assignment_extra_info are now deleted along with other
2575: -- assignment related records.
2576: --
2577: --
2578: hr_utility.set_location('hr_assignment.del_ref_int_check',5);

Line 3561: -- Remove per_assignment_extra_info records

3557: END IF;
3558: --
3559:
3560: -- 03/18/1998 Bug #642566
3561: -- Remove per_assignment_extra_info records
3562: hr_utility.set_location('hr_assignment.del_ref_int_delete',14);
3563: p_del_flag := 'N';
3564: --
3565: BEGIN

Line 3572: FROM PER_ASSIGNMENT_EXTRA_INFO

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);
3574: --
3575: EXCEPTION
3576: WHEN NO_DATA_FOUND THEN NULL;

Line 3582: DELETE FROM PER_ASSIGNMENT_EXTRA_INFO

3578: --
3579: IF p_del_flag = 'Y' THEN
3580: --
3581: hr_utility.set_location('hr_assignment.delete_ass_ref_int',16);
3582: DELETE FROM PER_ASSIGNMENT_EXTRA_INFO
3583: WHERE ASSIGNMENT_ID = p_assignment_id;
3584: END IF;
3585: -- 03/18/1998 Change Ends
3586: --