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 1625: l_date_eff_rec pay_element_entry_values_f%rowtype;

1621: PROCEDURE Cancel_Other_Family_Sf52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype) AS
1622: l_buf number;
1623: l_eff_date date;
1624: l_proc varchar2(72) := 'Cancel_Other_Family_Sf52' ;
1625: l_date_eff_rec pay_element_entry_values_f%rowtype;
1626: l_hist_dummy ghr_pa_history%rowtype;
1627: l_hist_rec ghr_pa_requests%rowtype;
1628: l_hist_address_rec ghr_pa_history%rowtype;
1629: l_hist_pre ghr_pa_history%rowtype;

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

1730:
1731:
1732: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.
1733: -- note that this cursor orders by table name, this is due to the fact that we need to
1734: -- handle PAY_ELEMENT_ENTRY_VALUES_F history records before PAY_ELEMENT_ENTRIES_F history
1735: -- records due to the parent-child relationship of these two tables. Fetch_history routine
1736: -- for elements relies on the parent record in history being intact.
1737: cursor c_history_info (cp_pa_request_id in ghr_pa_requests.pa_request_id%type,
1738: cp_noa_id in ghr_pa_requests.first_noa_id%type) is

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

1739: SELECT *
1740: FROM GHR_PA_HISTORY
1741: WHERE pa_request_id = cp_pa_request_id
1742: AND nature_of_action_id = cp_noa_id
1743: ORDER BY DECODE(table_name, 'PAY_ELEMENT_ENTRY_VALUES_F', -2,
1744: 'PAY_ELEMENT_ENTRIES_F', -1,
1745: pa_history_id) asc;
1746:
1747: --start of bug #5900178

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

2311: -- End of Bug#2521744
2312: else
2313: -- get date_effective row from table. See if it is different than the value of the
2314: -- action we are cancelling. If it is different, then there are intervening actions on
2315: -- the same date and the update should not be applied to pay_element_entry_values_f table.
2316: -- If it is the same, then there are no intervening actions on the same date and the
2317: -- update should be applied.
2318: ghr_history_fetch.get_date_eff_eleevl(p_element_entry_value_id => l_hist_pre.information1,
2319: p_date_effective => l_hist_rec.effective_date,

Line 4148: l_value1 pay_element_entry_values_f.screen_entry_value%type;

4144: l_proc_warn boolean;
4145: l_proc varchar2(30):='update_eleentval';
4146: l_eff_date date;
4147: l_asg_id number;
4148: l_value1 pay_element_entry_values_f.screen_entry_value%type;
4149:
4150: cursor c_ipv (ele_name in varchar2
4151: ,input_name in varchar2
4152: ,eff_date in date

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

6704: -- If element = 'OTHER PAY' THEN
6705: -- Check whether another other pay action processed on the same effective date;
6706: -- IF processed then
6707: -- fetch the other pay value using history id and element entry id.
6708: -- update the pay_element_entry_values_f table with the correct value.
6709: -- ELSE
6710: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6711: -- END If;
6712: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then

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

6706: -- IF processed then
6707: -- fetch the other pay value using history id and element entry id.
6708: -- update the pay_element_entry_values_f table with the correct value.
6709: -- ELSE
6710: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6711: -- END If;
6712: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6713: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6714: -- ELSE

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

6709: -- ELSE
6710: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6711: -- END If;
6712: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6713: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6714: -- ELSE
6715: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;
6716: -- END If;
6717:

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

6711: -- END If;
6712: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6713: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6714: -- ELSE
6715: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;
6716: -- END If;
6717:
6718: Procedure delete_other_pay_entries(p_hist_rec in ghr_pa_history%rowtype,
6719: p_element_name IN VARCHAR2 ) IS

Line 6782: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;

6778: -- Delete the Other Pay element with this element entry ID.
6779: -- End If;
6780: IF l_future_othpay_effective_date IS NOT NULL THEN
6781: hr_utility.set_location(' Inside Future Other Pay Exists',20);
6782: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6783: DELETE pay_element_entry_values_f
6784: where element_entry_id = p_hist_rec.information1
6785: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6786: AND (l_future_othpay_effective_date - 1) ;

Line 6783: DELETE pay_element_entry_values_f

6779: -- End If;
6780: IF l_future_othpay_effective_date IS NOT NULL THEN
6781: hr_utility.set_location(' Inside Future Other Pay Exists',20);
6782: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6783: DELETE pay_element_entry_values_f
6784: where element_entry_id = p_hist_rec.information1
6785: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6786: AND (l_future_othpay_effective_date - 1) ;
6787:

Line 6805: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;

6801: AND (l_future_othpay_effective_date - 1);
6802:
6803: ELSE
6804: hr_utility.set_location(' No Future Other Pay Action exists.',40);
6805: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6806: DELETE pay_element_entry_values_f
6807: where element_entry_id = p_hist_rec.information1;
6808:
6809:

Line 6806: DELETE pay_element_entry_values_f

6802:
6803: ELSE
6804: hr_utility.set_location(' No Future Other Pay Action exists.',40);
6805: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6806: DELETE pay_element_entry_values_f
6807: where element_entry_id = p_hist_rec.information1;
6808:
6809:
6810: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

Line 6824: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;

6820: END IF;
6821: END IF;
6822: ELSIF l_element_name IN ('Retention Allowance','Supervisory Differential','AUO',
6823: 'Availability Pay') THEN
6824: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6825:
6826: DELETE pay_element_entry_values_f
6827: where element_entry_id = p_hist_rec.information1;
6828: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

Line 6826: DELETE pay_element_entry_values_f

6822: ELSIF l_element_name IN ('Retention Allowance','Supervisory Differential','AUO',
6823: 'Availability Pay') THEN
6824: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6825:
6826: DELETE pay_element_entry_values_f
6827: where element_entry_id = p_hist_rec.information1;
6828: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6829:
6830: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

Line 6840: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;

6836: hr_utility.set_location('Leaving delete_other_pay_entries',170);
6837: ELSE
6838: hr_utility.set_location('Elements Other than OTHER PAY '||p_element_name,110);
6839:
6840: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6841:
6842: DELETE pay_element_entry_values_f
6843: where element_entry_id = p_hist_rec.information1
6844: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

Line 6842: DELETE pay_element_entry_values_f

6838: hr_utility.set_location('Elements Other than OTHER PAY '||p_element_name,110);
6839:
6840: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6841:
6842: DELETE pay_element_entry_values_f
6843: where element_entry_id = p_hist_rec.information1
6844: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6845:
6846: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;