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_PAY_ELEMENT_ENTRS_AFIUD dependencies on GHR_HISTORY_API

Line 4: l_session_var ghr_history_api.g_session_var_type;

1: TRIGGER "APPS"."GHR_PAY_ELEMENT_ENTRS_AFIUD" AFTER INSERT OR UPDATE OR DELETE
2: ON "APPS"."PAY_ELEMENT_ENTRIES_F" FOR EACH ROW
3: DECLARE
4: l_session_var ghr_history_api.g_session_var_type;
5: l_session_date date;
6: l_old_elmten_data pay_element_entries_f%rowtype;
7: l_old_elmten_hist_data ghr_pa_history%rowtype;
8: l_proc varchar2(30):='pay_element_entries_f_afiud';

Line 56: ghr_history_api.get_g_session_var( l_session_var);

52: END get_old_elmten_data;
53:
54: BEGIN
55: hr_utility.set_location('Entering:'|| l_proc , 1);
56: ghr_history_api.get_g_session_var( l_session_var);
57:
58: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
59: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
60:

Line 67: ghr_history_api.set_g_session_var( l_session_var);

63: IF l_session_var.fire_trigger = 'Y' THEN
64: if l_session_var.assignment_id is null then
65: l_session_var.assignment_id := :new.assignment_id;
66: end if;
67: ghr_history_api.set_g_session_var( l_session_var);
68:
69: IF lower(l_session_var.program_name) = 'core' THEN
70: hr_utility.set_location( l_proc , 180);
71: ghr_history_api.get_session_date( l_session_date);

Line 71: ghr_history_api.get_session_date( l_session_date);

67: ghr_history_api.set_g_session_var( l_session_var);
68:
69: IF lower(l_session_var.program_name) = 'core' THEN
70: hr_utility.set_location( l_proc , 180);
71: ghr_history_api.get_session_date( l_session_date);
72:
73: IF inserting THEN
74: hr_utility.set_location( l_proc , 170);
75: IF :new.effective_start_date >= l_session_date THEN

Line 81: ghr_history_api.set_g_session_var( l_session_var);

77: -- For core forms effective date must be set to effective start date.
78: -- Currently this is not set correctly thru core form. As it sets the
79: -- effective date to session date.
80: l_session_var.date_effective := :new.effective_start_date;
81: ghr_history_api.set_g_session_var( l_session_var);
82:
83: ghr_history_api.set_operation_info(
84: p_table_name => lower(ghr_history_api.g_eleent_table),
85: p_program_name => l_session_var.program_name,

Line 83: ghr_history_api.set_operation_info(

79: -- effective date to session date.
80: l_session_var.date_effective := :new.effective_start_date;
81: ghr_history_api.set_g_session_var( l_session_var);
82:
83: ghr_history_api.set_operation_info(
84: p_table_name => lower(ghr_history_api.g_eleent_table),
85: p_program_name => l_session_var.program_name,
86: p_date_effective => l_session_var.date_effective,
87: p_table_pk_id => :new.element_entry_id,

Line 84: p_table_name => lower(ghr_history_api.g_eleent_table),

80: l_session_var.date_effective := :new.effective_start_date;
81: ghr_history_api.set_g_session_var( l_session_var);
82:
83: ghr_history_api.set_operation_info(
84: p_table_name => lower(ghr_history_api.g_eleent_table),
85: p_program_name => l_session_var.program_name,
86: p_date_effective => l_session_var.date_effective,
87: p_table_pk_id => :new.element_entry_id,
88: p_operation => 'insert',

Line 113: ghr_history_api.set_g_session_var( l_session_var);

109: -- For core forms effective date must be set to effective start date.
110: -- Currently this is not set correctly thru core form. As it sets the
111: -- effective date to session date.
112: l_session_var.date_effective := :new.effective_start_date;
113: ghr_history_api.set_g_session_var( l_session_var);
114: ghr_history_api.set_operation_info(
115: p_table_name => lower(ghr_history_api.g_eleent_table),
116: p_program_name => l_session_var.program_name,
117: p_date_Effective => l_session_var.date_effective,

Line 114: ghr_history_api.set_operation_info(

110: -- Currently this is not set correctly thru core form. As it sets the
111: -- effective date to session date.
112: l_session_var.date_effective := :new.effective_start_date;
113: ghr_history_api.set_g_session_var( l_session_var);
114: ghr_history_api.set_operation_info(
115: p_table_name => lower(ghr_history_api.g_eleent_table),
116: p_program_name => l_session_var.program_name,
117: p_date_Effective => l_session_var.date_effective,
118: p_table_pk_id => :new.element_entry_id,

Line 115: p_table_name => lower(ghr_history_api.g_eleent_table),

111: -- effective date to session date.
112: l_session_var.date_effective := :new.effective_start_date;
113: ghr_history_api.set_g_session_var( l_session_var);
114: ghr_history_api.set_operation_info(
115: p_table_name => lower(ghr_history_api.g_eleent_table),
116: p_program_name => l_session_var.program_name,
117: p_date_Effective => l_session_var.date_effective,
118: p_table_pk_id => :new.element_entry_id,
119: p_operation => 'update',

Line 132: ghr_history_api.get_g_session_var( l_session_var);

128: NULL;
129: END IF;
130: ELSE /* ie deleting */
131: hr_utility.set_location( l_proc , 120);
132: ghr_history_api.get_g_session_var( l_session_var);
133: /* Should we allow deletes from core. How should it be handled?? */
134: NULL;
135: END IF;
136: ELSIF lower(l_session_var.program_name) = 'sf50' THEN

Line 139: ghr_history_api.set_operation_info(

135: END IF;
136: ELSIF lower(l_session_var.program_name) = 'sf50' THEN
137: IF inserting THEN
138: hr_utility.set_location( l_proc , 110);
139: ghr_history_api.set_operation_info(
140: p_program_name => l_session_var.program_name,
141: p_date_effective => l_session_var.date_effective,
142: p_table_name => lower(ghr_history_api.g_eleent_table),
143: p_table_pk_id => :new.element_entry_id,

Line 142: p_table_name => lower(ghr_history_api.g_eleent_table),

138: hr_utility.set_location( l_proc , 110);
139: ghr_history_api.set_operation_info(
140: p_program_name => l_session_var.program_name,
141: p_date_effective => l_session_var.date_effective,
142: p_table_name => lower(ghr_history_api.g_eleent_table),
143: p_table_pk_id => :new.element_entry_id,
144: p_operation => 'insert',
145: p_old_record_data => l_old_elmten_hist_data,
146: p_row_id => :new.rowid);

Line 157: ghr_history_api.set_operation_info(

153: get_old_elmten_data ( l_old_elmten_data);
154: ghr_history_conv_rg.conv_element_entry_rg_to_hist(
155: p_element_entries_data => l_old_elmten_data,
156: p_history_data => l_old_elmten_hist_data);
157: ghr_history_api.set_operation_info(
158: p_program_name => l_session_var.program_name,
159: p_date_effective => l_session_var.date_effective,
160: p_table_name => lower(ghr_history_api.g_eleent_table),
161: p_table_pk_id => :new.element_entry_id,

Line 160: p_table_name => lower(ghr_history_api.g_eleent_table),

156: p_history_data => l_old_elmten_hist_data);
157: ghr_history_api.set_operation_info(
158: p_program_name => l_session_var.program_name,
159: p_date_effective => l_session_var.date_effective,
160: p_table_name => lower(ghr_history_api.g_eleent_table),
161: p_table_pk_id => :new.element_entry_id,
162: p_operation => 'update',
163: p_old_record_data => l_old_elmten_hist_data,
164: p_row_id => :new.rowid);