DBA Data[Home] [Help]

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.53.12020000.5 2012/07/27 09:54:22 vmididho ship $ */
3: --
4: --
5: -- ----------------------------------------------------------------------------

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

2: /* $Header: ghcorcan.pkb 120.53.12020000.5 2012/07/27 09:54:22 vmididho ship $ */
3: --
4: --
5: -- ----------------------------------------------------------------------------
6: -- |--------------------------< >--------------------------|
7: -- ----------------------------------------------------------------------------
8: --
9:
10: --

Line 1905: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);

1901: nvl(l_prior_asg_id,hr_api.g_number) <> l_sf52_data_rec.employee_assignment_id and --Bug# 5442674
1902: nvl(l_prior_noa_code,hr_api.g_varchar2) <> '002' then
1903:
1904: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1905: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);
1906: Else
1907: -- reinitialise session variables
1908: ghr_history_api.reinit_g_session_var;
1909: -- set values of session variables

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

5874: begin
5875: l_cursor := dbms_sql.open_cursor;
5876: dbms_sql.parse(l_cursor,
5877: 'begin ' ||
5878: ' ghr_corr_canc_sf52.l_date_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||
5879: 'end;', dbms_sql.v7);
5880: p_rows := dbms_sql.execute(l_cursor);
5881: dbms_sql.close_cursor(l_cursor);
5882: return l_date_result;

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

5888: begin
5889: l_cursor := dbms_sql.open_cursor;
5890: dbms_sql.parse(l_cursor,
5891: 'begin ' ||
5892: ' ghr_corr_canc_sf52.l_number_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||
5893: 'end;', dbms_sql.v7);
5894: p_rows := dbms_sql.execute(l_cursor);
5895: dbms_sql.close_cursor(l_cursor);
5896: return l_number_result;

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

5902: begin
5903: l_cursor := dbms_sql.open_cursor;
5904: dbms_sql.parse(l_cursor,
5905: 'begin ' ||
5906: ' ghr_corr_canc_sf52.l_varchar2_result := ghr_corr_canc_sf52.sf52_corr_rec.' || p_value || '; ' ||
5907: 'end;', dbms_sql.v7);
5908: p_rows := dbms_sql.execute(l_cursor);
5909: dbms_sql.close_cursor(l_cursor);
5910: return l_varchar2_result;

Line 6370: ghr_corr_canc_sf52.Cancel_Correction_SF52( p_sf52_data);

6366: hr_utility.set_location( l_proc, 30);
6367: if l_prev_sf52_data.first_noa_code = '002' then
6368: -- Cancellation of the correction
6369: hr_utility.set_location( l_proc, 40);
6370: ghr_corr_canc_sf52.Cancel_Correction_SF52( p_sf52_data);
6371: else
6372: -------------------------------------------------
6373: -- JH Bug 2983738 Position Hiring Status Changes Generic to All Cancellations.
6374: -------------------------------------------------

Line 6512: ghr_corr_canc_sf52.Cancel_Appt_SF52( p_sf52_data);

6508: if l_noa_family_code = 'APP' then
6509: -- must be checked for the appt. family
6510: -- Cancellation of an appointment
6511: hr_utility.set_location( l_proc, 60);
6512: ghr_corr_canc_sf52.Cancel_Appt_SF52( p_sf52_data);
6513: null;
6514: elsif l_noa_family_code = 'SEPARATION' then
6515: -- cancellation of termination
6516: hr_utility.set_location( l_proc, 70);

Line 6517: ghr_corr_canc_sf52.cancel_term_sf52( p_sf52_data);

6513: null;
6514: elsif l_noa_family_code = 'SEPARATION' then
6515: -- cancellation of termination
6516: hr_utility.set_location( l_proc, 70);
6517: ghr_corr_canc_sf52.cancel_term_sf52( p_sf52_data);
6518: -- elsif l_noa_code like '9%' then
6519: -- -- user defined families not supported by update to database
6520: -- -- should generate a message and raise_error here.
6521: -- hr_utility.set_location( l_proc, 80);

Line 6527: ghr_corr_canc_sf52.Cancel_Other_Family_Sf52( p_sf52_data);

6523: -- user defined NOA would be treated as any other family in cancel_other_family_sf52
6524: -- if these don't belong to special families (APP/SEPARATION)
6525: else
6526: hr_utility.set_location( l_proc, 90);
6527: ghr_corr_canc_sf52.Cancel_Other_Family_Sf52( p_sf52_data);
6528: end if;
6529:
6530:
6531: