eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 31: PER_ASSIGNMENT_BUDGET_VALUES_F

27: associated tables :
28:
29: PER_ASSIGNMENTS_F
30: PER_SECONDARY_ASSIGNMENT_STATUSES
31: PER_ASSIGNMENT_BUDGET_VALUES_F
32:
33:
34:
35: Change List

Line 153: 110.4 16-APR-1998 SASmith Due to date tracking of the per_assignment_budget_values_f

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
156: effective start and end dates and also changed to ensure these
157: are added when the row is inserted into the db.

Line 159: per_assignment_budget_values_f and include a delete,zap

155: 1.load_budget_values parameters changed to include
156: effective start and end dates and also changed to ensure these
157: are added when the row is inserted into the db.
158: 2.Procedure del_ref_int_delete. remove the current zap of
159: per_assignment_budget_values_f and include a delete,zap
160: and future logic instead. Also change to the '_F' table.
161: 3.delete_ass_ref_int - change to reference the '_F' per_assignment_
162: budget_values_f.
163: 4.tidy_up_ref_int - new logic to handle change in assignment

Line 289: PER_ASSIGNMENT_BUDGET_VALUES_F in the

285: 115.58 20-may-08 sathkris 8252045 Modified the cursor csr_dff_context
286: in the procedure update_assgn_context_value
287: 115.59 31-AUG-09 ktithy 8710298 Removed hr_utility.set_location calls.
288: 115.60 17-DEC-10 vepravee 9669561 Modified the update of
289: PER_ASSIGNMENT_BUDGET_VALUES_F in the
290: procedure del_ref_int_delete.
291: 115.61 19-JUL-11 vepravee 11078262 Modified the delete of
292: PER_ASSIGNMENT_BUDGET_VALUES_F in the
293: procedure del_ref_int_delete.

Line 292: PER_ASSIGNMENT_BUDGET_VALUES_F in the

288: 115.60 17-DEC-10 vepravee 9669561 Modified the update of
289: PER_ASSIGNMENT_BUDGET_VALUES_F in the
290: procedure del_ref_int_delete.
291: 115.61 19-JUL-11 vepravee 11078262 Modified the delete of
292: PER_ASSIGNMENT_BUDGET_VALUES_F in the
293: procedure del_ref_int_delete.
294: 115.62 10-OCT-11 srannama 12820636 Modified procedure do_primary_update
295: for Bug 12820636.
296: ================================================================= */

Line 1232: FROM PER_ASSIGNMENT_BUDGET_VALUES_F BV

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
1234: AND BV.ASSIGNMENT_ID = p_assignment_id);
1235: --
1236: EXCEPTION

Line 1243: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F BV

1239: --
1240: IF del_flag = 'Y' THEN
1241: hr_utility.set_location('hr_assignment.delete_ass_ref_int',6);
1242: --
1243: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F BV
1244: WHERE BV.business_group_id + 0 = p_business_group_id
1245: AND BV.ASSIGNMENT_ID = p_assignment_id;
1246: --
1247: END IF;

Line 2357: -- Also change of table from per_assignment_budget_values to per_assignment_budget_values_f.

2353: of an index
2354: */
2355: -- Change to include effective start and end dates in parameters and logic to check these and
2356: -- insert the assignment dates into the budget values table.
2357: -- Also change of table from per_assignment_budget_values to per_assignment_budget_values_f.
2358: -- This is required as per_assignment_budget_values_f is now a datetracked table.
2359: -- 16-APR-1998 : SASmith.
2360:
2361:

Line 2358: -- This is required as per_assignment_budget_values_f is now a datetracked table.

2354: */
2355: -- Change to include effective start and end dates in parameters and logic to check these and
2356: -- insert the assignment dates into the budget values table.
2357: -- Also change of table from per_assignment_budget_values to per_assignment_budget_values_f.
2358: -- This is required as per_assignment_budget_values_f is now a datetracked table.
2359: -- 16-APR-1998 : SASmith.
2360:
2361:
2362: insert into per_assignment_budget_values_f

Line 2362: insert into per_assignment_budget_values_f

2358: -- This is required as per_assignment_budget_values_f is now a datetracked table.
2359: -- 16-APR-1998 : SASmith.
2360:
2361:
2362: insert into per_assignment_budget_values_f
2363: (assignment_budget_value_id
2364: ,business_group_id
2365: ,assignment_id
2366: ,last_update_date

Line 2390: from per_assignment_budget_values_f pabv2

2386: , p_effective_end_date
2387: from per_default_budget_values pabv1
2388: where pabv1.business_group_id = p_business_group_id
2389: and not exists (select 'already there'
2390: from per_assignment_budget_values_f pabv2
2391: where pabv2.assignment_id = p_assignment_id
2392: and pabv2.unit = pabv1.unit );
2393: /* BDG 22/12/98 for Bug 679966
2394: and pabv2.value = pabv1.value */

Line 2862: PER_ASSIGNMENT_BUDGET_VALUES_F

2858: del_ref_in_check. Removes data from the following tables
2859:
2860: For 'ZAP'
2861: HR_ASSIGNMENT_SET_AMENDMENTS
2862: PER_ASSIGNMENT_BUDGET_VALUES_F
2863: PER_SPINAL_POINT_PLACEMENTS_F
2864: PER_PAY_PROPOSALS
2865:
2866: For 'END' (performs a date effective delete)

Line 2868: PER_ASSIGNMENT_BUDGET_VALUES_F

2864: PER_PAY_PROPOSALS
2865:
2866: For 'END' (performs a date effective delete)
2867: PER_SPINAL_POINT_PLACEMENTS_F
2868: PER_ASSIGNMENT_BUDGET_VALUES_F
2869:
2870: For 'FUTURE' (including FUTURE_CHANGES, DELETE_NEXT_CHANGE,
2871: UPDATE_OVERRIDE)
2872: PER_SPINAL_POINT_PLACEMENTS_F

Line 2873: PER_ASSIGNMENT_BUDGET_VALUES_F

2869:
2870: For 'FUTURE' (including FUTURE_CHANGES, DELETE_NEXT_CHANGE,
2871: UPDATE_OVERRIDE)
2872: PER_SPINAL_POINT_PLACEMENTS_F
2873: PER_ASSIGNMENT_BUDGET_VALUES_F
2874:
2875: PARAMETERS
2876: p_assignment_id - The current assignment
2877: p_grade_id - The current grade ('FUTURE' only')

Line 2885: -- Change to include table per_assignment_budget_values_f in END and FUTURE logic. Now

2881: For ZAP not required
2882: p_last_updated_by
2883: p_last_update_login
2884: */
2885: -- Change to include table per_assignment_budget_values_f in END and FUTURE logic. Now
2886: -- required as this table is datetracked.
2887: -- 16-APR-1998 : SASmith
2888:
2889: PROCEDURE del_ref_int_delete

Line 3345: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV

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
3347: AND (p_mode = 'ZAP'
3348: OR (p_mode = 'END'
3349: AND ABV.EFFECTIVE_END_DATE > p_end_date)

Line 3364: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV

3360: IF p_del_flag = 'Y' THEN
3361: --
3362: IF p_mode = 'ZAP' THEN
3363: hr_utility.set_location('hr_assignment.del_ref_int_delet',30);
3364: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3365: WHERE ABV.ASSIGNMENT_ID = p_assignment_id;
3366:
3367: --
3368: ELSE

Line 3375: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV

3371: -- from p_end_date.
3372: --
3373: hr_utility.set_location('hr_assignment.del_ref_int_delete',40);
3374:
3375: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3376: WHERE ABV.ASSIGNMENT_ID = p_assignment_id
3377: AND ABV.EFFECTIVE_START_DATE > p_end_date;
3378: --
3379: hr_utility.set_location('hr_assignment.del_ref_int_delete',45);

Line 3380: UPDATE PER_ASSIGNMENT_BUDGET_VALUES_F

3376: WHERE ABV.ASSIGNMENT_ID = p_assignment_id
3377: AND ABV.EFFECTIVE_START_DATE > p_end_date;
3378: --
3379: hr_utility.set_location('hr_assignment.del_ref_int_delete',45);
3380: UPDATE PER_ASSIGNMENT_BUDGET_VALUES_F
3381: SET EFFECTIVE_END_DATE = p_end_date
3382: , LAST_UPDATED_BY = p_last_updated_by
3383: , LAST_UPDATE_LOGIN = p_last_update_login
3384: , LAST_UPDATE_DATE = sysdate

Line 3399: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV

3395: --
3396: hr_utility.set_location('hr_assignment.del_ref_int_delete',46);
3397: hr_utility.set_location('p_end_date '||p_end_date, 47);
3398:
3399: DELETE FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV
3400: WHERE ABV.ASSIGNMENT_ID = p_assignment_id
3401: AND ABV.EFFECTIVE_START_DATE > p_end_date
3402: AND ABV.EFFECTIVE_END_DATE <> hr_api.g_eot;--Added as a part of fix for bug#11078262
3403: --

Line 3415: UPDATE PER_ASSIGNMENT_BUDGET_VALUES_F

3411:
3412: hr_utility.set_location('l_ass_end_date '||l_ass_end_date,50);
3413:
3414:
3415: UPDATE PER_ASSIGNMENT_BUDGET_VALUES_F
3416: SET EFFECTIVE_END_DATE = l_ass_end_date
3417: , LAST_UPDATED_BY = p_last_updated_by
3418: , LAST_UPDATE_LOGIN = p_last_update_login
3419: , LAST_UPDATE_DATE = sysdate

Line 3666: PER_ASSIGNMENT_BUDGET_VALUES_F

3662:
3663: PAY_COST_ALLOCATIONS_F
3664: PER_SECONDARY_ASS_STATUSES
3665: PAY_PERSONAL_PAYMENT_METHODS_F
3666: PER_ASSIGNMENT_BUDGET_VALUES_F
3667:
3668: PARAMETERS
3669: p_assignment_id - Assignment ID
3670: p_mode - 'END' or 'FUTURE'

Line 3865: -- New logic added to deal with per assignment_budget_values_f. Now required as this

3861: --
3862: END IF;
3863:
3864:
3865: -- New logic added to deal with per assignment_budget_values_f. Now required as this
3866: -- table is datetracked. The following code works when a mode of end is required (i.e. the
3867: -- user has requested a date effective delete which will terminate the row at a given point in time).
3868: --
3869: -- The first thing is to remove any rows which have a start date greater than the requested NEW

Line 3891: from per_assignment_budget_values_f abv

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
3893: and p_mode = 'END'
3894: and p_new_end_date < abv.effective_start_date);
3895: EXCEPTION

Line 3903: delete from per_assignment_budget_values_f abv

3899: IF p_del_flag = 'Y' THEN
3900: --
3901: hr_utility.set_location('hr_assignment.tidy_up_ref_int',20);
3902: --
3903: delete from per_assignment_budget_values_f abv
3904: where abv.assignment_id = p_assignment_id
3905: and p_mode = 'END'
3906: and p_new_end_date < abv.effective_start_date;
3907: END IF;

Line 3920: from per_assignment_budget_values_f abv

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
3922: and p_mode = 'END'
3923: and p_new_end_date between abv.effective_start_date and abv.effective_end_date);
3924:

Line 3933: update per_assignment_budget_values_f abv

3929: IF p_del_flag = 'Y' THEN
3930: --
3931: hr_utility.set_location('hr_assignment.tidy_up_ref_int',30);
3932: --
3933: update per_assignment_budget_values_f abv
3934: set abv.effective_end_date = p_new_end_date
3935: , abv.last_updated_by = P_LAST_UPDATED_BY
3936: , abv.last_update_login = P_LAST_UPDATE_LOGIN
3937: , abv.last_update_date = sysdate