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_HISTORY_API dependencies on GHR_PA_HISTORY

Line 251: -- it can subsequently be stored in GHR_PA_HISTORY when this action is complete (see

247: -- as it should already have been added.
248: -- Inserts are handled differently than updates as we are also tracking the pre-values
249: -- for the row in the case of update.
250: -- Note that this information is being stored in global session variables so that
251: -- it can subsequently be stored in GHR_PA_HISTORY when this action is complete (see
252: -- procedure post_update_process).
253: --
254: -- Pre-Requisities:
255: -- None.

Line 284: p_table_name in ghr_pa_history.table_name%type ,

280: -- ---------------------------------------------------------------------------
281: Procedure set_operation_info(
282: p_program_name in varchar2 ,
283: p_date_Effective in date ,
284: p_table_name in ghr_pa_history.table_name%type ,
285: p_table_pk_id in ghr_pa_history.information1%type ,
286: p_operation in varchar2 ,
287: p_old_record_data in ghr_pa_history%rowtype ,
288: p_row_id in rowid

Line 285: p_table_pk_id in ghr_pa_history.information1%type ,

281: Procedure set_operation_info(
282: p_program_name in varchar2 ,
283: p_date_Effective in date ,
284: p_table_name in ghr_pa_history.table_name%type ,
285: p_table_pk_id in ghr_pa_history.information1%type ,
286: p_operation in varchar2 ,
287: p_old_record_data in ghr_pa_history%rowtype ,
288: p_row_id in rowid
289: ) is

Line 287: p_old_record_data in ghr_pa_history%rowtype ,

283: p_date_Effective in date ,
284: p_table_name in ghr_pa_history.table_name%type ,
285: p_table_pk_id in ghr_pa_history.information1%type ,
286: p_operation in varchar2 ,
287: p_old_record_data in ghr_pa_history%rowtype ,
288: p_row_id in rowid
289: ) is
290:
291: l_proc varchar2(30):='set_operation_info';

Line 383: Function add_row_operation_info_rg ( p_table_name in ghr_pa_history.table_name%type,

379: -- Internal Development Use Only.
380: --
381: -- {End Of Comments}
382: -- ---------------------------------------------------------------------------
383: Function add_row_operation_info_rg ( p_table_name in ghr_pa_history.table_name%type,
384: p_table_pk_id in ghr_pa_history.information1%type,
385: p_operation in varchar2,
386: p_row_id in rowid) return binary_integer is
387:

Line 384: p_table_pk_id in ghr_pa_history.information1%type,

380: --
381: -- {End Of Comments}
382: -- ---------------------------------------------------------------------------
383: Function add_row_operation_info_rg ( p_table_name in ghr_pa_history.table_name%type,
384: p_table_pk_id in ghr_pa_history.information1%type,
385: p_operation in varchar2,
386: p_row_id in rowid) return binary_integer is
387:
388: indx binary_integer;

Line 432: Procedure add_row_pre_update_record_rg ( p_pre_update_rg in ghr_pa_history%rowtype,

428: -- Internal Development Use Only.
429: --
430: -- {End Of Comments}
431: -- ---------------------------------------------------------------------------
432: Procedure add_row_pre_update_record_rg ( p_pre_update_rg in ghr_pa_history%rowtype,
433: p_ind in binary_integer) is
434: l_proc varchar2(30) := 'add_row_pre_update_record_rg';
435: l_hist_data ghr_pa_history%rowtype;
436: begin

Line 435: l_hist_data ghr_pa_history%rowtype;

431: -- ---------------------------------------------------------------------------
432: Procedure add_row_pre_update_record_rg ( p_pre_update_rg in ghr_pa_history%rowtype,
433: p_ind in binary_integer) is
434: l_proc varchar2(30) := 'add_row_pre_update_record_rg';
435: l_hist_data ghr_pa_history%rowtype;
436: begin
437: hr_utility.set_location('Entering:'|| l_proc, 5);
438: -- local variable is used to temporarily hold the data because the
439: -- assignment did not work for some unknown reason (a bug in PL/SQL??)

Line 609: p_hist_data in out nocopy ghr_pa_history%rowtype,

605: p_date_effective in date default null,
606: p_altered_pa_request_id in number default null,
607: p_noa_id_corrected in number default null,
608: p_pa_history_id in number default null,
609: p_hist_data in out nocopy ghr_pa_history%rowtype,
610: p_result_code out nocopy varchar2) is
611:
612: l_people_data per_all_people_f%rowtype;
613: l_asgei_data per_assignment_extra_info%rowtype;

Line 622: l_hist_data ghr_pa_history%rowtype;

618: l_posnei_data per_position_extra_info%rowtype;
619: l_peranalyses_data per_person_analyses%rowtype;
620: l_address_data per_addresses%rowtype;
621: l_position_data hr_all_positions_f%rowtype;
622: l_hist_data ghr_pa_history%rowtype;
623: l_proc varchar2(30) := 'fetch_history_info';
624:
625: begin
626: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 809: -- information into ghr_pa_history table.

805: -- {Start Of Comments}
806: --
807: -- Description:
808: -- Takes information from session global variables and inserts appropriate tracking
809: -- information into ghr_pa_history table.
810: --
811: -- Pre-Requisities:
812: -- None.
813: --

Line 818: -- ghr_pa_history will have been populated with all history information for the

814: -- In Parameters:
815: -- None.
816: --
817: -- Post Success:
818: -- ghr_pa_history will have been populated with all history information for the
819: -- database rows that were changed in this session.
820: --
821: -- Post Failure:
822: -- An exception will be generated if there were no records found in history for an

Line 838: l_hist_data ghr_pa_history%rowtype;

834: indx binary_integer:=1;
835: l_return_status varchar2(10);
836: l_pre_mode varchar2(10):='PRE';
837: l_post_mode varchar2(10):='POST';
838: l_hist_data ghr_pa_history%rowtype;
839: l_eleevl_hist_data ghr_pa_history%rowtype;
840: l_eleevl_data pay_element_entry_values_f%rowtype;
841: l_pre_record ghr_pa_history%rowtype;
842: l_post_data ghr_pa_history%rowtype;

Line 839: l_eleevl_hist_data ghr_pa_history%rowtype;

835: l_return_status varchar2(10);
836: l_pre_mode varchar2(10):='PRE';
837: l_post_mode varchar2(10):='POST';
838: l_hist_data ghr_pa_history%rowtype;
839: l_eleevl_hist_data ghr_pa_history%rowtype;
840: l_eleevl_data pay_element_entry_values_f%rowtype;
841: l_pre_record ghr_pa_history%rowtype;
842: l_post_data ghr_pa_history%rowtype;
843: l_session_var g_session_var_type;

Line 841: l_pre_record ghr_pa_history%rowtype;

837: l_post_mode varchar2(10):='POST';
838: l_hist_data ghr_pa_history%rowtype;
839: l_eleevl_hist_data ghr_pa_history%rowtype;
840: l_eleevl_data pay_element_entry_values_f%rowtype;
841: l_pre_record ghr_pa_history%rowtype;
842: l_post_data ghr_pa_history%rowtype;
843: l_session_var g_session_var_type;
844: pa_history_id ghr_pa_history.pa_history_id%type;
845: l_interv_on_table Boolean;

Line 842: l_post_data ghr_pa_history%rowtype;

838: l_hist_data ghr_pa_history%rowtype;
839: l_eleevl_hist_data ghr_pa_history%rowtype;
840: l_eleevl_data pay_element_entry_values_f%rowtype;
841: l_pre_record ghr_pa_history%rowtype;
842: l_post_data ghr_pa_history%rowtype;
843: l_session_var g_session_var_type;
844: pa_history_id ghr_pa_history.pa_history_id%type;
845: l_interv_on_table Boolean;
846: l_interv_on_eff_date Boolean;

Line 844: pa_history_id ghr_pa_history.pa_history_id%type;

840: l_eleevl_data pay_element_entry_values_f%rowtype;
841: l_pre_record ghr_pa_history%rowtype;
842: l_post_data ghr_pa_history%rowtype;
843: l_session_var g_session_var_type;
844: pa_history_id ghr_pa_history.pa_history_id%type;
845: l_interv_on_table Boolean;
846: l_interv_on_eff_date Boolean;
847: l_rec_avl Boolean;
848: l_pre_effective_end_date date;

Line 849: l_dummy_hist_data ghr_pa_history%rowtype := null;

845: l_interv_on_table Boolean;
846: l_interv_on_eff_date Boolean;
847: l_rec_avl Boolean;
848: l_pre_effective_end_date date;
849: l_dummy_hist_data ghr_pa_history%rowtype := null;
850: l_hist_data_as_of_date ghr_pa_history%rowtype;
851: l_dml_operation ghr_pa_history.dml_operation%type;
852: l_pre_values_flag ghr_pa_history.pre_values_flag%type;
853: l_pa_history_id number;

Line 850: l_hist_data_as_of_date ghr_pa_history%rowtype;

846: l_interv_on_eff_date Boolean;
847: l_rec_avl Boolean;
848: l_pre_effective_end_date date;
849: l_dummy_hist_data ghr_pa_history%rowtype := null;
850: l_hist_data_as_of_date ghr_pa_history%rowtype;
851: l_dml_operation ghr_pa_history.dml_operation%type;
852: l_pre_values_flag ghr_pa_history.pre_values_flag%type;
853: l_pa_history_id number;
854: l_error_message varchar2(1000);

Line 851: l_dml_operation ghr_pa_history.dml_operation%type;

847: l_rec_avl Boolean;
848: l_pre_effective_end_date date;
849: l_dummy_hist_data ghr_pa_history%rowtype := null;
850: l_hist_data_as_of_date ghr_pa_history%rowtype;
851: l_dml_operation ghr_pa_history.dml_operation%type;
852: l_pre_values_flag ghr_pa_history.pre_values_flag%type;
853: l_pa_history_id number;
854: l_error_message varchar2(1000);
855: l_proc varchar2(30) := 'post_update_process';

Line 852: l_pre_values_flag ghr_pa_history.pre_values_flag%type;

848: l_pre_effective_end_date date;
849: l_dummy_hist_data ghr_pa_history%rowtype := null;
850: l_hist_data_as_of_date ghr_pa_history%rowtype;
851: l_dml_operation ghr_pa_history.dml_operation%type;
852: l_pre_values_flag ghr_pa_history.pre_values_flag%type;
853: l_pa_history_id number;
854: l_error_message varchar2(1000);
855: l_proc varchar2(30) := 'post_update_process';
856:

Line 859: l_hist_data in out nocopy ghr_pa_history%rowtype,

855: l_proc varchar2(30) := 'post_update_process';
856:
857: -- initializes l_hist_data with session variable information.
858: PROCEDURE init_record_data(l_session_var in g_session_var_type,
859: l_hist_data in out nocopy ghr_pa_history%rowtype,
860: indx in binary_integer) IS
861: l_dummy VARCHAR2(1);
862: l_i_hist_data ghr_pa_history%rowtype;
863: cursor c_noa_sep_family is

Line 862: l_i_hist_data ghr_pa_history%rowtype;

858: PROCEDURE init_record_data(l_session_var in g_session_var_type,
859: l_hist_data in out nocopy ghr_pa_history%rowtype,
860: indx in binary_integer) IS
861: l_dummy VARCHAR2(1);
862: l_i_hist_data ghr_pa_history%rowtype;
863: cursor c_noa_sep_family is
864: select 'X' from ghr_nature_of_actions
865: where code in ('300','301','302','303','304','312','317',
866: '330','350','351','353','355','356','357','385')

Line 994: -- ghr_pa_history.

990: hr_utility.set_location(l_proc, 10);
991:
992: -- The following loop will loop thru all database rows that were touched in this session (everything in
993: -- g_operation_info rg). For every row, the corresponding history information will be inserted into
994: -- ghr_pa_history.
995: WHILE indx <= g_operation_info.COUNT
996: LOOP
997: hr_utility.set_location(l_proc || 'in post process' || to_char(indx) || g_operation_info(indx).operation, 10);
998: l_hist_data := l_dummy_hist_data;

Line 1360: -- get the row from ghr_pa_history for this element_entry_value given the effective date

1356:
1357: -- retrieve the currently effective eleevl row from history and re-apply it to the
1358: -- core table if necessary.
1359:
1360: -- get the row from ghr_pa_history for this element_entry_value given the effective date
1361: -- of this action.
1362: ghr_history_fetch.get_date_eff_eleevl(
1363: p_element_entry_value_id => to_number(l_post_data.information1) ,
1364: p_date_effective => l_post_data.effective_date ,