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.GHR_CORR_CANC_SF52 dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1456: l_date_eff_rec pay_element_entry_values_f%rowtype;

1452: PROCEDURE Cancel_Other_Family_Sf52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype) AS
1453: l_buf number;
1454: l_eff_date date;
1455: l_proc varchar2(72) := 'Cancel_Other_Family_Sf52' ;
1456: l_date_eff_rec pay_element_entry_values_f%rowtype;
1457: l_hist_dummy ghr_pa_history%rowtype;
1458: l_hist_rec ghr_pa_requests%rowtype;
1459: l_hist_address_rec ghr_pa_history%rowtype;
1460: l_hist_pre ghr_pa_history%rowtype;

Line 1561: -- handle PAY_ELEMENT_ENTRY_VALUES_F history records before PAY_ELEMENT_ENTRIES_F history

1557:
1558:
1559: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.
1560: -- note that this cursor orders by table name, this is due to the fact that we need to
1561: -- handle PAY_ELEMENT_ENTRY_VALUES_F history records before PAY_ELEMENT_ENTRIES_F history
1562: -- records due to the parent-child relationship of these two tables. Fetch_history routine
1563: -- for elements relies on the parent record in history being intact.
1564: cursor c_history_info (cp_pa_request_id in ghr_pa_requests.pa_request_id%type,
1565: cp_noa_id in ghr_pa_requests.first_noa_id%type) is

Line 1570: ORDER BY DECODE(table_name, 'PAY_ELEMENT_ENTRY_VALUES_F', -2,

1566: SELECT *
1567: FROM GHR_PA_HISTORY
1568: WHERE pa_request_id = cp_pa_request_id
1569: AND nature_of_action_id = cp_noa_id
1570: ORDER BY DECODE(table_name, 'PAY_ELEMENT_ENTRY_VALUES_F', -2,
1571: 'PAY_ELEMENT_ENTRIES_F', -1,
1572: pa_history_id) asc;
1573:
1574: --start of bug #5900178

Line 2093: -- the same date and the update should not be applied to pay_element_entry_values_f table.

2089: -- End of Bug#2521744
2090: else
2091: -- get date_effective row from table. See if it is different than the value of the
2092: -- action we are cancelling. If it is different, then there are intervening actions on
2093: -- the same date and the update should not be applied to pay_element_entry_values_f table.
2094: -- If it is the same, then there are no intervening actions on the same date and the
2095: -- update should be applied.
2096: ghr_history_fetch.get_date_eff_eleevl(p_element_entry_value_id => l_hist_pre.information1,
2097: p_date_effective => l_hist_rec.effective_date,

Line 3840: l_value1 pay_element_entry_values_f.screen_entry_value%type;

3836: l_proc_warn boolean;
3837: l_proc varchar2(30):='update_eleentval';
3838: l_eff_date date;
3839: l_asg_id number;
3840: l_value1 pay_element_entry_values_f.screen_entry_value%type;
3841:
3842: cursor c_ipv (ele_name in varchar2
3843: ,input_name in varchar2
3844: ,eff_date in date

Line 6353: -- update the pay_element_entry_values_f table with the correct value.

6349: -- If element = 'OTHER PAY' THEN
6350: -- Check whether another other pay action processed on the same effective date;
6351: -- IF processed then
6352: -- fetch the other pay value using history id and element entry id.
6353: -- update the pay_element_entry_values_f table with the correct value.
6354: -- ELSE
6355: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6356: -- END If;
6357: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then

Line 6355: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;

6351: -- IF processed then
6352: -- fetch the other pay value using history id and element entry id.
6353: -- update the pay_element_entry_values_f table with the correct value.
6354: -- ELSE
6355: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6356: -- END If;
6357: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6358: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6359: -- ELSE

Line 6358: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;

6354: -- ELSE
6355: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6356: -- END If;
6357: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6358: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6359: -- ELSE
6360: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;
6361: -- END If;
6362:

Line 6360: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;

6356: -- END If;
6357: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6358: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6359: -- ELSE
6360: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;
6361: -- END If;
6362:
6363: Procedure delete_other_pay_entries(p_hist_rec in ghr_pa_history%rowtype,
6364: p_element_name IN VARCHAR2 ) IS

Line 6427: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;

6423: -- Delete the Other Pay element with this element entry ID.
6424: -- End If;
6425: IF l_future_othpay_effective_date IS NOT NULL THEN
6426: hr_utility.set_location(' Inside Future Other Pay Exists',20);
6427: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6428: DELETE pay_element_entry_values_f
6429: where element_entry_id = p_hist_rec.information1
6430: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6431: AND (l_future_othpay_effective_date - 1) ;

Line 6428: DELETE pay_element_entry_values_f

6424: -- End If;
6425: IF l_future_othpay_effective_date IS NOT NULL THEN
6426: hr_utility.set_location(' Inside Future Other Pay Exists',20);
6427: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6428: DELETE pay_element_entry_values_f
6429: where element_entry_id = p_hist_rec.information1
6430: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6431: AND (l_future_othpay_effective_date - 1) ;
6432:

Line 6450: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;

6446: AND (l_future_othpay_effective_date - 1);
6447:
6448: ELSE
6449: hr_utility.set_location(' No Future Other Pay Action exists.',40);
6450: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6451: DELETE pay_element_entry_values_f
6452: where element_entry_id = p_hist_rec.information1;
6453:
6454:

Line 6451: DELETE pay_element_entry_values_f

6447:
6448: ELSE
6449: hr_utility.set_location(' No Future Other Pay Action exists.',40);
6450: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6451: DELETE pay_element_entry_values_f
6452: where element_entry_id = p_hist_rec.information1;
6453:
6454:
6455: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

Line 6469: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;

6465: END IF;
6466: END IF;
6467: ELSIF l_element_name IN ('Retention Allowance','Supervisory Differential','AUO',
6468: 'Availability Pay') THEN
6469: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6470:
6471: DELETE pay_element_entry_values_f
6472: where element_entry_id = p_hist_rec.information1;
6473: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

Line 6471: DELETE pay_element_entry_values_f

6467: ELSIF l_element_name IN ('Retention Allowance','Supervisory Differential','AUO',
6468: 'Availability Pay') THEN
6469: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6470:
6471: DELETE pay_element_entry_values_f
6472: where element_entry_id = p_hist_rec.information1;
6473: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6474:
6475: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

Line 6485: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;

6481: hr_utility.set_location('Leaving delete_other_pay_entries',170);
6482: ELSE
6483: hr_utility.set_location('Elements Other than OTHER PAY '||p_element_name,110);
6484:
6485: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6486:
6487: DELETE pay_element_entry_values_f
6488: where element_entry_id = p_hist_rec.information1
6489: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

Line 6487: DELETE pay_element_entry_values_f

6483: hr_utility.set_location('Elements Other than OTHER PAY '||p_element_name,110);
6484:
6485: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6486:
6487: DELETE pay_element_entry_values_f
6488: where element_entry_id = p_hist_rec.information1
6489: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6490:
6491: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;