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 GHR_PA_HISTORY

Line 29: p_hist_rec in ghr_pa_history%rowtype,

25: --
26:
27: -- Declaring local procedures and functions
28: Procedure delete_element_entry(
29: p_hist_rec in ghr_pa_history%rowtype,
30: p_del_mode in varchar2 default hr_api.g_delete_next_change,
31: p_cannot_cancel out nocopy Boolean) ;
32:
33: Procedure delete_eleentval( p_hist_rec in ghr_pa_history%rowtype) ;

Line 33: Procedure delete_eleentval( p_hist_rec in ghr_pa_history%rowtype) ;

29: p_hist_rec in ghr_pa_history%rowtype,
30: p_del_mode in varchar2 default hr_api.g_delete_next_change,
31: p_cannot_cancel out nocopy Boolean) ;
32:
33: Procedure delete_eleentval( p_hist_rec in ghr_pa_history%rowtype) ;
34: Procedure delete_peop_row(
35: p_person_id in varchar2,
36: p_dt_mode in varchar2,
37: p_date_effective in date) ;

Line 56: p_pa_history_id in ghr_pa_history.pa_history_id%type);

52: p_date_effective in date) ;
53: Procedure delete_hist_row (
54: p_row_id in rowid);
55: Procedure delete_hist_row (
56: p_pa_history_id in ghr_pa_history.pa_history_id%type);
57: Procedure apply_correction(
58: p_sf52rec_correct in ghr_pa_requests%rowtype,
59: p_corr_pa_request_id in ghr_pa_requests.pa_request_id%type,
60: p_sf52rec in out nocopy ghr_pa_requests%rowtype ) ;

Line 97: Procedure delete_other_pay_entries(p_hist_rec in ghr_pa_history%rowtype,

93:
94: -- Bug#2521744
95: -- This procedure will delete the first datetrack row for the
96: -- other pay elements/other elements whereever necessary.
97: Procedure delete_other_pay_entries(p_hist_rec in ghr_pa_history%rowtype,
98: p_element_name in varchar2);
99:
100: -- This procedure will get the other pay component values
101: -- at the time of intervening correction.

Line 144: -- this cursor gets the rowids from ghr_pa_history for the given pa_request_id.

140: -- ---------------------------------------------------------------------------
141:
142: Procedure cancel_term_SF52 ( p_sf52_data in out nocopy ghr_pa_requests%rowtype) is
143:
144: -- this cursor gets the rowids from ghr_pa_history for the given pa_request_id.
145: cursor c_hist ( c_pa_request_id number,
146: c_noa_id number) is
147: select
148: rowid row_id, table_name,pa_history_id,information5

Line 150: from ghr_pa_history

146: c_noa_id number) is
147: select
148: rowid row_id, table_name,pa_history_id,information5
149: ,information9, information10
150: from ghr_pa_history
151: where pa_request_id = c_pa_request_id
152: and nature_of_action_id = c_noa_id
153: for update of person_id
154: order by pa_history_id desc; -- Bug# 1316321

Line 157: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,

153: for update of person_id
154: order by pa_history_id desc; -- Bug# 1316321
155:
156:
157: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,
158: c_pk_id ghr_pa_history.information1%type,
159: c_pa_history_id ghr_pa_history.pa_history_id%type) is
160: select pa_history_id
161: from ghr_pa_history

Line 158: c_pk_id ghr_pa_history.information1%type,

154: order by pa_history_id desc; -- Bug# 1316321
155:
156:
157: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,
158: c_pk_id ghr_pa_history.information1%type,
159: c_pa_history_id ghr_pa_history.pa_history_id%type) is
160: select pa_history_id
161: from ghr_pa_history
162: where table_name = c_table_name

Line 159: c_pa_history_id ghr_pa_history.pa_history_id%type) is

155:
156:
157: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,
158: c_pk_id ghr_pa_history.information1%type,
159: c_pa_history_id ghr_pa_history.pa_history_id%type) is
160: select pa_history_id
161: from ghr_pa_history
162: where table_name = c_table_name
163: and information1 = c_pk_id

Line 161: from ghr_pa_history

157: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,
158: c_pk_id ghr_pa_history.information1%type,
159: c_pa_history_id ghr_pa_history.pa_history_id%type) is
160: select pa_history_id
161: from ghr_pa_history
162: where table_name = c_table_name
163: and information1 = c_pk_id
164: and pa_history_id > c_pa_history_id;
165:

Line 168: c_table_name ghr_pa_history.table_name%type) IS

164: and pa_history_id > c_pa_history_id;
165:
166:
167: cursor c_hist_sevpay ( c_pa_request_id number,
168: c_table_name ghr_pa_history.table_name%type) IS
169: select *
170: from ghr_pa_history
171: where pa_request_id = c_pa_request_id
172: and table_name = c_table_name;

Line 170: from ghr_pa_history

166:
167: cursor c_hist_sevpay ( c_pa_request_id number,
168: c_table_name ghr_pa_history.table_name%type) IS
169: select *
170: from ghr_pa_history
171: where pa_request_id = c_pa_request_id
172: and table_name = c_table_name;
173:
174:

Line 177: l_hist_pre ghr_pa_history%rowtype;

173:
174:
175: l_buf number;
176: l_follow_rec boolean;
177: l_hist_pre ghr_pa_history%rowtype;
178: l_hist_rec ghr_pa_history%rowtype;
179: l_hist_sevpay ghr_pa_history%rowtype;
180: l_cannot_cancel_sevpay boolean;
181: l_interv_on_table boolean;

Line 178: l_hist_rec ghr_pa_history%rowtype;

174:
175: l_buf number;
176: l_follow_rec boolean;
177: l_hist_pre ghr_pa_history%rowtype;
178: l_hist_rec ghr_pa_history%rowtype;
179: l_hist_sevpay ghr_pa_history%rowtype;
180: l_cannot_cancel_sevpay boolean;
181: l_interv_on_table boolean;
182: l_interv_on_eff_date boolean;

Line 179: l_hist_sevpay ghr_pa_history%rowtype;

175: l_buf number;
176: l_follow_rec boolean;
177: l_hist_pre ghr_pa_history%rowtype;
178: l_hist_rec ghr_pa_history%rowtype;
179: l_hist_sevpay ghr_pa_history%rowtype;
180: l_cannot_cancel_sevpay boolean;
181: l_interv_on_table boolean;
182: l_interv_on_eff_date boolean;
183: l_hist_data_as_of_date ghr_pa_history%rowtype;

Line 183: l_hist_data_as_of_date ghr_pa_history%rowtype;

179: l_hist_sevpay ghr_pa_history%rowtype;
180: l_cannot_cancel_sevpay boolean;
181: l_interv_on_table boolean;
182: l_interv_on_eff_date boolean;
183: l_hist_data_as_of_date ghr_pa_history%rowtype;
184: l_session_var ghr_history_api.g_session_var_type;
185: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
186: l_imm_asg_sf52 ghr_api.asg_sf52_type;
187: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;

Line 485: FROM ghr_pa_history

481: */
482:
483: SELECT *
484: INTO l_hist_rec
485: FROM ghr_pa_history
486: WHERE pa_request_id = p_sf52_data.altered_pa_request_id
487: AND information5 = 'GHR_US_PER_SEPARATE_RETIRE'
488: AND table_name = ghr_history_api.g_peopei_table
489: AND nature_of_action_id = (select nature_of_action_id from ghr_nature_of_actions where

Line 587: FROM ghr_pa_history

583: l_hist.information5 = 'GHR_US_ASG_NTE_DATES') THEN
584:
585: SELECT *
586: INTO l_hist_rec
587: FROM ghr_pa_history
588: WHERE pa_history_id = l_hist.pa_history_id;
589:
590: hr_utility.set_location('Non 352 and Address '||l_hist.table_name,26);
591: -- Bug#3780671 Passed the parameter l_hist.table_name instead of Address table

Line 780: l_hist_post ghr_pa_history%rowtype;

776:
777: Procedure Cancel_Appt_SF52( p_sf52_data in out nocopy ghr_pa_requests%rowtype) is
778:
779: l_session_var ghr_history_api.g_session_var_type;
780: l_hist_post ghr_pa_history%rowtype;
781: l_business_group_id number;
782: l_u_prh_object_version_number number;
783: l_i_pa_routing_history_id number;
784: l_i_prh_object_version_number number;

Line 877: -- this cursor gets the ghr_pa_history rows (with the rowid included) for the person_id specified and locks

873: from per_people_f
874: where person_id = c_person_id and
875: c_as_on_date between effective_start_date and effective_end_date;
876:
877: -- this cursor gets the ghr_pa_history rows (with the rowid included) for the person_id specified and locks
878: -- the rows for update.
879: -- note that it selects all the records that were effective on or after the effective_date passed.
880: -- also note that it orders by dml_operation, in order to ensure that updated rows are handled
881: -- before inserted rows. This is necessary for the way we are handling the setting of extra info tables

Line 890: from ghr_pa_history pah

886: c_eff_date date) is
887: select
888: pah.rowid row_id,
889: pah.*
890: from ghr_pa_history pah
891: where person_id = c_person_id and
892: (effective_date > c_eff_date or
893: (effective_date = c_eff_date and pa_request_id is not NULL))
894: for update of person_id

Line 1457: l_hist_dummy ghr_pa_history%rowtype;

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;
1461: l_hist_data_as_of_date ghr_pa_history%rowtype;

Line 1459: l_hist_address_rec ghr_pa_history%rowtype;

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;
1461: l_hist_data_as_of_date ghr_pa_history%rowtype;
1462: l_return_status varchar2(100);
1463: l_interv_on_table boolean;

Line 1460: l_hist_pre ghr_pa_history%rowtype;

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;
1461: l_hist_data_as_of_date ghr_pa_history%rowtype;
1462: l_return_status varchar2(100);
1463: l_interv_on_table boolean;
1464: l_interv_on_eff_date boolean;

Line 1461: l_hist_data_as_of_date ghr_pa_history%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;
1461: l_hist_data_as_of_date ghr_pa_history%rowtype;
1462: l_return_status varchar2(100);
1463: l_interv_on_table boolean;
1464: l_interv_on_eff_date boolean;
1465: l_pre_record boolean;

Line 1559: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.

1555: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1556: l_imm_retirement_info ghr_api.per_retirement_info_type;
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.

Line 1567: FROM GHR_PA_HISTORY

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
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,

Line 1614: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,

1610: and p_sf52_data.effective_date
1611: between nvl(fam.start_date_active,p_sf52_data.effective_date)
1612: and nvl(fam.end_date_active,p_sf52_data.effective_date);
1613:
1614: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,
1615: c_pk_id ghr_pa_history.information1%type,
1616: c_pa_history_id ghr_pa_history.pa_history_id%type) is
1617: select pa_history_id
1618: from ghr_pa_history

Line 1615: c_pk_id ghr_pa_history.information1%type,

1611: between nvl(fam.start_date_active,p_sf52_data.effective_date)
1612: and nvl(fam.end_date_active,p_sf52_data.effective_date);
1613:
1614: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,
1615: c_pk_id ghr_pa_history.information1%type,
1616: c_pa_history_id ghr_pa_history.pa_history_id%type) is
1617: select pa_history_id
1618: from ghr_pa_history
1619: where table_name = c_table_name

Line 1616: c_pa_history_id ghr_pa_history.pa_history_id%type) is

1612: and nvl(fam.end_date_active,p_sf52_data.effective_date);
1613:
1614: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,
1615: c_pk_id ghr_pa_history.information1%type,
1616: c_pa_history_id ghr_pa_history.pa_history_id%type) is
1617: select pa_history_id
1618: from ghr_pa_history
1619: where table_name = c_table_name
1620: and information1 = c_pk_id

Line 1618: from ghr_pa_history

1614: cursor c_follow_rec( c_table_name ghr_pa_history.table_name%type,
1615: c_pk_id ghr_pa_history.information1%type,
1616: c_pa_history_id ghr_pa_history.pa_history_id%type) is
1617: select pa_history_id
1618: from ghr_pa_history
1619: where table_name = c_table_name
1620: and information1 = c_pk_id
1621: and pa_history_id > c_pa_history_id;
1622:

Line 1629: from ghr_pa_history

1625: c_noa_id number) is
1626: select
1627: rowid row_id, table_name,pa_history_id,information5
1628: ,information9, information10
1629: from ghr_pa_history
1630: where pa_request_id = c_pa_request_id
1631: and table_name = ghr_history_api.g_addres_table
1632: and nature_of_action_id = c_noa_id
1633: for update of person_id

Line 1887: FROM ghr_pa_history

1883: FOR l_hist IN c_hist_address(p_sf52_data.altered_pa_request_id, p_sf52_data.second_noa_id)
1884: LOOP
1885: SELECT *
1886: INTO l_hist_address_rec
1887: FROM ghr_pa_history
1888: WHERE pa_history_id = l_hist.pa_history_id;
1889:
1890: ghr_history_api.fetch_history_info(
1891: p_table_name => ghr_history_api.g_addres_table,

Line 2416: from ghr_pa_history

2412:
2413: cursor c_get_hist_id (c_pa_request_id in number) is
2414: select
2415: min(pa_history_id)
2416: from ghr_pa_history
2417: where pa_request_id = c_pa_request_id;
2418:
2419: cursor get_shadow (c_pa_request_id in number) is
2420: select *

Line 2438: from ghr_pa_history

2434: l_capped_other_pay number := hr_api.g_number;
2435:
2436: cursor get_hist is
2437: select pa_history_id
2438: from ghr_pa_history
2439: where pa_request_id = p_sf52_rec.altered_pa_request_id and
2440: nature_of_action_id = p_sf52_rec.second_noa_id;
2441:
2442: l_sf52_rec ghr_pa_requests%rowtype;

Line 2674: -- This procedure deletes a row in ghr_pa_history for the rowid passed.

2670: -- ---------------------------------------------------------------------------
2671: -- {Start Of Comments}
2672: --
2673: -- Description:
2674: -- This procedure deletes a row in ghr_pa_history for the rowid passed.
2675: --
2676: -- Pre-Requisities:
2677: -- None.
2678: --

Line 2681: -- ghr_pa_history.

2677: -- None.
2678: --
2679: -- In Parameters:
2680: -- p_row_id -> rowid of the row to be deleted in
2681: -- ghr_pa_history.
2682: -- Post Success:
2683: -- The row will have been deleted.
2684: --
2685: -- Post Failure:

Line 2701: delete ghr_pa_history

2697: Procedure delete_hist_row ( p_row_id in rowid) is
2698: l_proc varchar2(30):='delete_hist_row';
2699: Begin
2700: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2701: delete ghr_pa_history
2702: where rowid = p_row_id;
2703: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2704: End delete_hist_row;
2705:

Line 2712: -- This procedure deletes a row in ghr_pa_history for the pa_history_id passed.

2708: -- ---------------------------------------------------------------------------
2709: -- {Start Of Comments}
2710: --
2711: -- Description:
2712: -- This procedure deletes a row in ghr_pa_history for the pa_history_id passed.
2713: --
2714: -- Pre-Requisities:
2715: -- None.
2716: --

Line 2719: -- of the row to be deleted in ghr_pa_history.

2715: -- None.
2716: --
2717: -- In Parameters:
2718: -- p_pa_history_id -> pa_history_id
2719: -- of the row to be deleted in ghr_pa_history.
2720: -- Post Success:
2721: -- The row will have been deleted.
2722: --
2723: -- Post Failure:

Line 2735: Procedure delete_hist_row ( p_pa_history_id in ghr_pa_history.pa_history_id%type) is

2731: --
2732: -- {End Of Comments}
2733: -- ---------------------------------------------------------------------------
2734:
2735: Procedure delete_hist_row ( p_pa_history_id in ghr_pa_history.pa_history_id%type) is
2736: l_proc varchar2(30):='delete_hist_row';
2737: Begin
2738: hr_utility.set_location( 'Entering : ' || l_proc, 30);
2739: delete ghr_pa_history

Line 2739: delete ghr_pa_history

2735: Procedure delete_hist_row ( p_pa_history_id in ghr_pa_history.pa_history_id%type) is
2736: l_proc varchar2(30):='delete_hist_row';
2737: Begin
2738: hr_utility.set_location( 'Entering : ' || l_proc, 30);
2739: delete ghr_pa_history
2740: where pa_history_id = p_pa_history_id;
2741: hr_utility.set_location( 'Leaving : ' || l_proc, 40);
2742: End delete_hist_row;
2743:

Line 3204: from ghr_pa_history

3200:
3201: cursor c_get_hist_id (c_pa_request_id in number) is
3202: select
3203: min(pa_history_id)
3204: from ghr_pa_history
3205: where pa_request_id = c_pa_request_id;
3206:
3207: -- Bug#5435374
3208: l_pos_ei_grade_data per_position_extra_info%rowtype;

Line 3227: from ghr_pa_history hist_1

3223: cursor core_chg_check(p_to_position_id in number,
3224: p_effective_date in date)
3225: is
3226: select 1
3227: from ghr_pa_history hist_1
3228: where pa_request_id is null
3229: and hist_1.pa_history_id > (select min(pa_history_id)
3230: from ghr_pa_history
3231: where pa_request_id = l_prev_request_id)

Line 3230: from ghr_pa_history

3226: select 1
3227: from ghr_pa_history hist_1
3228: where pa_request_id is null
3229: and hist_1.pa_history_id > (select min(pa_history_id)
3230: from ghr_pa_history
3231: where pa_request_id = l_prev_request_id)
3232: and hist_1.pa_history_id < nvl(l_curr_pa_history_id,999999999)
3233: and information1 in (select position_extra_info_id
3234: from per_position_extra_info

Line 3674: -- p_hist_rec -> element entry to be deleted (ghr_pa_history%rowtype).

3670: -- Pre-Requisities:
3671: -- None.
3672: --
3673: -- In Parameters:
3674: -- p_hist_rec -> element entry to be deleted (ghr_pa_history%rowtype).
3675: -- p_cannot_cancel -> boolean indicates if there is some problem with deleting this element (the action
3676: -- cannot be cancelled).
3677: --
3678: -- Post Success:

Line 3693: Procedure delete_element_entry( p_hist_rec in ghr_pa_history%rowtype,

3689: --
3690: -- {End Of Comments}
3691: -- ---------------------------------------------------------------------------
3692:
3693: Procedure delete_element_entry( p_hist_rec in ghr_pa_history%rowtype,
3694: p_del_mode in varchar2 default hr_api.g_delete_next_change,
3695: p_cannot_cancel out nocopy Boolean) is
3696: l_del_warning boolean;
3697: -- this cursor selects the element_entry_id and object_version_number from

Line 3766: -- p_hist_pre -> value to update element entry value to (ghr_pa_history%rowtype).

3762: -- Pre-Requisities:
3763: -- None.
3764: --
3765: -- In Parameters:
3766: -- p_hist_pre -> value to update element entry value to (ghr_pa_history%rowtype).
3767: --
3768: -- Post Success:
3769: -- element entry value will have been updated.
3770: --

Line 3785: PROCEDURE update_eleentval( p_hist_pre in ghr_pa_history%rowtype) IS

3781: --
3782: -- {End Of Comments}
3783: -- ---------------------------------------------------------------------------
3784:
3785: PROCEDURE update_eleentval( p_hist_pre in ghr_pa_history%rowtype) IS
3786: -- this cursor selects the input value name given the input_value_id and effective date.
3787:
3788: CURSOR c_input_value (cp_input_value_id in number
3789: ,cp_eff_date in date

Line 3820: -- table name. (ghr_pa_history views are structured such that ghr_pa_history.information1 is always the primary

3816: AND ELT.ELEMENT_TYPE_ID = ELL.ELEMENT_TYPE_ID
3817: AND (ELT.BUSINESS_GROUP_ID is null OR ELT.BUSINESS_GROUP_ID = p_bg_id);
3818:
3819: -- this cursor gets the assignment id given the primary key, efective_start_date, effective_end_date and
3820: -- table name. (ghr_pa_history views are structured such that ghr_pa_history.information1 is always the primary
3821: -- key, information2 is always the effective_start_date, and information3 is always the effective_end_date).
3822: cursor c_asgmt_id( cp_information1 in ghr_pa_history.information1%type,
3823: cp_information2 in ghr_pa_history.information2%type,
3824: cp_information3 in ghr_pa_history.information3%type,

Line 3822: cursor c_asgmt_id( cp_information1 in ghr_pa_history.information1%type,

3818:
3819: -- this cursor gets the assignment id given the primary key, efective_start_date, effective_end_date and
3820: -- table name. (ghr_pa_history views are structured such that ghr_pa_history.information1 is always the primary
3821: -- key, information2 is always the effective_start_date, and information3 is always the effective_end_date).
3822: cursor c_asgmt_id( cp_information1 in ghr_pa_history.information1%type,
3823: cp_information2 in ghr_pa_history.information2%type,
3824: cp_information3 in ghr_pa_history.information3%type,
3825: cp_table_name in ghr_pa_history.table_name%type) IS
3826: SELECT ASSIGNMENT_ID

Line 3823: cp_information2 in ghr_pa_history.information2%type,

3819: -- this cursor gets the assignment id given the primary key, efective_start_date, effective_end_date and
3820: -- table name. (ghr_pa_history views are structured such that ghr_pa_history.information1 is always the primary
3821: -- key, information2 is always the effective_start_date, and information3 is always the effective_end_date).
3822: cursor c_asgmt_id( cp_information1 in ghr_pa_history.information1%type,
3823: cp_information2 in ghr_pa_history.information2%type,
3824: cp_information3 in ghr_pa_history.information3%type,
3825: cp_table_name in ghr_pa_history.table_name%type) IS
3826: SELECT ASSIGNMENT_ID
3827: FROM GHR_PA_HISTORY

Line 3824: cp_information3 in ghr_pa_history.information3%type,

3820: -- table name. (ghr_pa_history views are structured such that ghr_pa_history.information1 is always the primary
3821: -- key, information2 is always the effective_start_date, and information3 is always the effective_end_date).
3822: cursor c_asgmt_id( cp_information1 in ghr_pa_history.information1%type,
3823: cp_information2 in ghr_pa_history.information2%type,
3824: cp_information3 in ghr_pa_history.information3%type,
3825: cp_table_name in ghr_pa_history.table_name%type) IS
3826: SELECT ASSIGNMENT_ID
3827: FROM GHR_PA_HISTORY
3828: WHERE INFORMATION1 = cp_information1

Line 3825: cp_table_name in ghr_pa_history.table_name%type) IS

3821: -- key, information2 is always the effective_start_date, and information3 is always the effective_end_date).
3822: cursor c_asgmt_id( cp_information1 in ghr_pa_history.information1%type,
3823: cp_information2 in ghr_pa_history.information2%type,
3824: cp_information3 in ghr_pa_history.information3%type,
3825: cp_table_name in ghr_pa_history.table_name%type) IS
3826: SELECT ASSIGNMENT_ID
3827: FROM GHR_PA_HISTORY
3828: WHERE INFORMATION1 = cp_information1
3829: AND INFORMATION2 = cp_information2

Line 3827: FROM GHR_PA_HISTORY

3823: cp_information2 in ghr_pa_history.information2%type,
3824: cp_information3 in ghr_pa_history.information3%type,
3825: cp_table_name in ghr_pa_history.table_name%type) IS
3826: SELECT ASSIGNMENT_ID
3827: FROM GHR_PA_HISTORY
3828: WHERE INFORMATION1 = cp_information1
3829: AND INFORMATION2 = cp_information2
3830: AND INFORMATION3 = cp_information3
3831: AND TABLE_NAME = cp_table_name

Line 4013: -- p_hist_rec -> element entry value to delete (ghr_pa_history%rowtype).

4009: -- Pre-Requisities:
4010: -- None.
4011: --
4012: -- In Parameters:
4013: -- p_hist_rec -> element entry value to delete (ghr_pa_history%rowtype).
4014: --
4015: -- Post Success:
4016: -- element entry value will have been deleted rom history.
4017: --

Line 4030: Procedure delete_eleentval( p_hist_rec in ghr_pa_history%rowtype) is

4026: --
4027: -- {End Of Comments}
4028: -- ---------------------------------------------------------------------------
4029:
4030: Procedure delete_eleentval( p_hist_rec in ghr_pa_history%rowtype) is
4031: -- this cursor gets the rowid of the history_rec for the ghr_pa_history row passed
4032: -- to us.
4033: cursor c_hist is
4034: select rowid row_id

Line 4031: -- this cursor gets the rowid of the history_rec for the ghr_pa_history row passed

4027: -- {End Of Comments}
4028: -- ---------------------------------------------------------------------------
4029:
4030: Procedure delete_eleentval( p_hist_rec in ghr_pa_history%rowtype) is
4031: -- this cursor gets the rowid of the history_rec for the ghr_pa_history row passed
4032: -- to us.
4033: cursor c_hist is
4034: select rowid row_id
4035: from ghr_pa_history

Line 4035: from ghr_pa_history

4031: -- this cursor gets the rowid of the history_rec for the ghr_pa_history row passed
4032: -- to us.
4033: cursor c_hist is
4034: select rowid row_id
4035: from ghr_pa_history
4036: where table_name = ghr_history_api.g_eleevl_table and
4037: pa_request_id = p_hist_rec.pa_request_id and
4038: nature_of_action_id = p_hist_rec.nature_of_action_id
4039: for update of table_name;

Line 5595: from ghr_pa_history

5591: cp_effective_start_date between pel.effective_start_date and pel.effective_end_date ;
5592:
5593: /* cursor get_root_min_hist_id (cp_pa_history_id in number) is
5594: select min(pa_history_id)
5595: from ghr_pa_history
5596: where pa_request_id = (select min(pa_request_id)
5597: from ghr_pa_requests
5598: start with pa_request_id = (select pa_request_id -- Bug# 1253981
5599: from ghr_pa_history

Line 5599: from ghr_pa_history

5595: from ghr_pa_history
5596: where pa_request_id = (select min(pa_request_id)
5597: from ghr_pa_requests
5598: start with pa_request_id = (select pa_request_id -- Bug# 1253981
5599: from ghr_pa_history
5600: where pa_history_id = cp_pa_history_id)
5601: connect by prior altered_pa_request_id = pa_request_id)
5602: -- connect by pa_request_id = altered_pa_request_id)
5603: and nature_of_action_id = (select nature_of_action_id

Line 5604: from ghr_pa_history

5600: where pa_history_id = cp_pa_history_id)
5601: connect by prior altered_pa_request_id = pa_request_id)
5602: -- connect by pa_request_id = altered_pa_request_id)
5603: and nature_of_action_id = (select nature_of_action_id
5604: from ghr_pa_history
5605: where pa_history_id = cp_pa_history_id); */
5606:
5607: -- Bug 3694358
5608: -- In the cursor get_root_min_hist_id, start with - connect by is removed as it always returns the original

Line 5613: from ghr_pa_history

5609: -- action as the min. and no need to loop through all the correction actions and find the min pa_request_id
5610: /*Bug 6868486 below cursor changed*/
5611: cursor get_root_min_hist_id (cp_pa_history_id in number) is
5612: select min(pa_history_id)
5613: from ghr_pa_history
5614: where pa_request_id = (select pa_request_id -- Bug# 1253981
5615: from ghr_pa_history
5616: where pa_history_id = cp_pa_history_id);
5617:

Line 5615: from ghr_pa_history

5611: cursor get_root_min_hist_id (cp_pa_history_id in number) is
5612: select min(pa_history_id)
5613: from ghr_pa_history
5614: where pa_request_id = (select pa_request_id -- Bug# 1253981
5615: from ghr_pa_history
5616: where pa_history_id = cp_pa_history_id);
5617:
5618: -- Bug 3694358
5619: -- Changed connect by pa_request_id = altered_pa_request_id

Line 5628: from ghr_pa_history pah

5624: c_information1 varchar2,
5625: c_effective_date date,
5626: c_root_hist_id number) is
5627: Select pa_history_id
5628: from ghr_pa_history pah
5629: where table_name = ghr_history_api.g_eleevl_table
5630: and information5 = c_information1
5631: and (effective_date > c_effective_date or
5632: (effective_date = c_effective_date and

Line 5635: from ghr_pa_history

5631: and (effective_date > c_effective_date or
5632: (effective_date = c_effective_date and
5633: c_root_hist_id <
5634: (select min(pa_history_id)
5635: from ghr_pa_history
5636: where pa_request_id =
5637: (select min(pa_request_id)
5638: from ghr_pa_requests
5639: connect by prior altered_pa_request_id = pa_request_id

Line 6363: Procedure delete_other_pay_entries(p_hist_rec in ghr_pa_history%rowtype,

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
6365:
6366: l_history_exists BOOLEAN := FALSE;
6367: l_hist_rec ghr_pa_history%rowtype;

Line 6367: l_hist_rec ghr_pa_history%rowtype;

6363: Procedure delete_other_pay_entries(p_hist_rec in ghr_pa_history%rowtype,
6364: p_element_name IN VARCHAR2 ) IS
6365:
6366: l_history_exists BOOLEAN := FALSE;
6367: l_hist_rec ghr_pa_history%rowtype;
6368: l_future_othpay_effective_date DATE;
6369: l_bus_group_id NUMBER;
6370: l_element_name VARCHAR2(80);
6371:

Line 6374: FROM ghr_pa_history

6370: l_element_name VARCHAR2(80);
6371:
6372: CURSOR c_history_record IS
6373: SELECT *
6374: FROM ghr_pa_history
6375: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F'
6376: AND information1 = p_hist_rec.information1
6377: AND information2 = p_hist_rec.information2
6378: AND nvl(pa_request_id,0) <> nvl(p_hist_rec.pa_request_id,0);

Line 6442: DELETE ghr_pa_history

6438: AND (l_future_othpay_effective_date - 1) ;
6439:
6440: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the current
6441: -- action and prior to the next other pay action.
6442: DELETE ghr_pa_history
6443: WHERE (information5 = p_hist_rec.information1
6444: OR information1 = p_hist_rec.information1)
6445: AND effective_date BETWEEN (fnd_date.canonical_to_date(p_hist_rec.information2) + 1)
6446: AND (l_future_othpay_effective_date - 1);

Line 6461: DELETE ghr_pa_history

6457: where element_entry_id = p_hist_rec.information1;
6458:
6459: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the
6460: -- current other pay action.
6461: DELETE ghr_pa_history
6462: WHERE (information5 = p_hist_rec.information1 OR information1 = p_hist_rec.information1)
6463: AND effective_date > (fnd_date.canonical_to_date(p_hist_rec.information2) + 1);
6464:
6465: END IF;