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_CORR_CANC_SF52

Line 1: Package Body GHR_CORR_CANC_SF52 as

1: Package Body GHR_CORR_CANC_SF52 as
2: /* $Header: ghcorcan.pkb 120.17.12010000.5 2008/10/21 09:11:04 vmididho ship $ */
3: --
4: --
5: -- ----------------------------------------------------------------------------

Line 6: -- |--------------------------< >--------------------------|

2: /* $Header: ghcorcan.pkb 120.17.12010000.5 2008/10/21 09:11:04 vmididho ship $ */
3: --
4: --
5: -- ----------------------------------------------------------------------------
6: -- |--------------------------< >--------------------------|
7: -- ----------------------------------------------------------------------------
8: --
9:
10: --

Line 1712: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);

1708: nvl(l_prior_asg_id,hr_api.g_number) <> l_sf52_data_rec.employee_assignment_id and --Bug# 5442674
1709: nvl(l_prior_noa_code,hr_api.g_varchar2) <> '002' then
1710:
1711: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1712: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);
1713: Else
1714: -- reinitialise session variables
1715: ghr_history_api.reinit_g_session_var;
1716: -- set values of session variables

Line 5527: ' ghr_corr_canc_sf52.l_date_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||

5523: begin
5524: l_cursor := dbms_sql.open_cursor;
5525: dbms_sql.parse(l_cursor,
5526: 'begin ' ||
5527: ' ghr_corr_canc_sf52.l_date_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||
5528: 'end;', dbms_sql.v7);
5529: p_rows := dbms_sql.execute(l_cursor);
5530: dbms_sql.close_cursor(l_cursor);
5531: return l_date_result;

Line 5541: ' ghr_corr_canc_sf52.l_number_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||

5537: begin
5538: l_cursor := dbms_sql.open_cursor;
5539: dbms_sql.parse(l_cursor,
5540: 'begin ' ||
5541: ' ghr_corr_canc_sf52.l_number_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||
5542: 'end;', dbms_sql.v7);
5543: p_rows := dbms_sql.execute(l_cursor);
5544: dbms_sql.close_cursor(l_cursor);
5545: return l_number_result;

Line 5555: ' ghr_corr_canc_sf52.l_varchar2_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||

5551: begin
5552: l_cursor := dbms_sql.open_cursor;
5553: dbms_sql.parse(l_cursor,
5554: 'begin ' ||
5555: ' ghr_corr_canc_sf52.l_varchar2_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||
5556: 'end;', dbms_sql.v7);
5557: p_rows := dbms_sql.execute(l_cursor);
5558: dbms_sql.close_cursor(l_cursor);
5559: return l_varchar2_result;

Line 6017: ghr_corr_canc_sf52.Cancel_Correction_SF52( p_sf52_data);

6013: hr_utility.set_location( l_proc, 30);
6014: if l_prev_sf52_data.first_noa_code = '002' then
6015: -- Cancellation of the correction
6016: hr_utility.set_location( l_proc, 40);
6017: ghr_corr_canc_sf52.Cancel_Correction_SF52( p_sf52_data);
6018: else
6019: -------------------------------------------------
6020: -- JH Bug 2983738 Position Hiring Status Changes Generic to All Cancellations.
6021: -------------------------------------------------

Line 6158: ghr_corr_canc_sf52.Cancel_Appt_SF52( p_sf52_data);

6154: if l_noa_family_code = 'APP' then
6155: -- must be checked for the appt. family
6156: -- Cancellation of an appointment
6157: hr_utility.set_location( l_proc, 60);
6158: ghr_corr_canc_sf52.Cancel_Appt_SF52( p_sf52_data);
6159: null;
6160: elsif l_noa_family_code = 'SEPARATION' then
6161: -- cancellation of termination
6162: hr_utility.set_location( l_proc, 70);

Line 6163: ghr_corr_canc_sf52.cancel_term_sf52( p_sf52_data);

6159: null;
6160: elsif l_noa_family_code = 'SEPARATION' then
6161: -- cancellation of termination
6162: hr_utility.set_location( l_proc, 70);
6163: ghr_corr_canc_sf52.cancel_term_sf52( p_sf52_data);
6164: -- elsif l_noa_code like '9%' then
6165: -- -- user defined families not supported by update to database
6166: -- -- should generate a message and raise_error here.
6167: -- hr_utility.set_location( l_proc, 80);

Line 6173: ghr_corr_canc_sf52.Cancel_Other_Family_Sf52( p_sf52_data);

6169: -- user defined NOA would be treated as any other family in cancel_other_family_sf52
6170: -- if these don't belong to special families (APP/SEPARATION)
6171: else
6172: hr_utility.set_location( l_proc, 90);
6173: ghr_corr_canc_sf52.Cancel_Other_Family_Sf52( p_sf52_data);
6174: end if;
6175:
6176:
6177: