APPS.GHR_PAY_ELEMENT_ENTVAL_F_AFIUD dependencies on GHR_HISTORY_API

Line 5: l_session_var ghr_history_api.g_session_var_type;

1: TRIGGER "APPS"."GHR_PAY_ELEMENT_ENTVAL_F_AFIUD" AFTER INSERT OR UPDATE OR DELETE
2: ON "APPS"."PAY_ELEMENT_ENTRY_VALUES_F" FOR EACH ROW
3: DECLARE
4:
5: l_session_var ghr_history_api.g_session_var_type;
6: l_session_date date;
7: l_old_element_entvl_data pay_element_entry_values_f%rowtype;
8: l_old_element_entvl_hist_data ghr_pa_history%rowtype;
9: l_proc varchar2(50):='pay_element_entry_values_f_Afiud';

Line 27: ghr_history_api.get_g_session_var( l_session_var);

23: END get_old_elmtenvl_data;
24:
25: BEGIN
26: hr_utility.set_location('Entering:'|| l_proc , 1);
27: ghr_history_api.get_g_session_var( l_session_var);
28: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
29: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
30:
31: IF l_session_var.fire_trigger = 'Y' THEN

Line 38: ghr_history_api.get_session_date( l_session_date);

34: end if;
35:
36: IF lower(l_session_var.program_name) = 'core' THEN
37: hr_utility.set_location( l_proc , 180);
38: ghr_history_api.get_session_date( l_session_date);
39: IF inserting THEN
40: hr_utility.set_location( l_proc , 170);
41: IF :new.effective_start_date >= l_session_date THEN
42: hr_utility.set_location( l_proc , 160);

Line 48: ghr_history_api.set_g_session_var( l_session_var);

44: -- For core forms effective date must be set to effective start date.
45: -- Currently this is not set correctly thru core form. As it sets the
46: -- effective date to session date.
47: l_session_var.date_effective := :new.effective_start_date;
48: ghr_history_api.set_g_session_var( l_session_var);
49:
50: ghr_history_api.set_operation_info(
51: p_table_name => lower(ghr_history_api.g_eleevl_table),
52: p_program_name => l_session_var.program_name,

Line 50: ghr_history_api.set_operation_info(

46: -- effective date to session date.
47: l_session_var.date_effective := :new.effective_start_date;
48: ghr_history_api.set_g_session_var( l_session_var);
49:
50: ghr_history_api.set_operation_info(
51: p_table_name => lower(ghr_history_api.g_eleevl_table),
52: p_program_name => l_session_var.program_name,
53: p_date_effective => l_session_var.date_effective,
54: p_table_pk_id => :new.element_entry_value_id,

Line 51: p_table_name => lower(ghr_history_api.g_eleevl_table),

47: l_session_var.date_effective := :new.effective_start_date;
48: ghr_history_api.set_g_session_var( l_session_var);
49:
50: ghr_history_api.set_operation_info(
51: p_table_name => lower(ghr_history_api.g_eleevl_table),
52: p_program_name => l_session_var.program_name,
53: p_date_effective => l_session_var.date_effective,
54: p_table_pk_id => :new.element_entry_value_id,
55: p_operation => 'insert',

Line 69: ghr_history_api.get_g_session_var( l_session_var);

65: */
66: NULL;
67: END IF;
68: ELSIF updating THEN
69: ghr_history_api.get_g_session_var( l_session_var);
70: IF l_session_date between :new.effective_start_date and
71: :new.effective_end_date THEN
72: hr_utility.set_location( l_proc , 140);
73: get_old_elmtenvl_data( l_old_element_entvl_data);

Line 82: ghr_history_api.set_g_session_var( l_session_var);

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

Line 84: ghr_history_api.set_operation_info(

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

Line 85: p_table_name => lower(ghr_history_api.g_eleevl_table),

81: l_session_var.date_effective := :new.effective_start_date;
82: ghr_history_api.set_g_session_var( l_session_var);
83:
84: ghr_history_api.set_operation_info(
85: p_table_name => lower(ghr_history_api.g_eleevl_table),
86: p_program_name => l_session_var.program_name,
87: p_date_Effective => l_session_var.date_effective,
88: p_table_pk_id => :new.element_entry_value_id,
89: p_operation => 'update',

Line 102: ghr_history_api.get_g_session_var( l_session_var);

98: NULL;
99: END IF;
100: ELSE /* ie deleting */
101: hr_utility.set_location( l_proc , 120);
102: ghr_history_api.get_g_session_var( l_session_var);
103: /* Should we allow deletes from core. How should it be handled?? */
104: NULL;
105: END IF;
106: ELSIF lower(l_session_var.program_name) = 'sf50' THEN

Line 109: ghr_history_api.set_operation_info(

105: END IF;
106: ELSIF lower(l_session_var.program_name) = 'sf50' THEN
107: IF inserting THEN
108: hr_utility.set_location( l_proc , 110);
109: ghr_history_api.set_operation_info(
110: p_program_name => l_session_var.program_name,
111: p_date_effective => l_session_var.date_effective,
112: p_table_name => lower(ghr_history_api.g_eleevl_table),
113: p_table_pk_id => :new.element_entry_value_id,

Line 112: p_table_name => lower(ghr_history_api.g_eleevl_table),

108: hr_utility.set_location( l_proc , 110);
109: ghr_history_api.set_operation_info(
110: p_program_name => l_session_var.program_name,
111: p_date_effective => l_session_var.date_effective,
112: p_table_name => lower(ghr_history_api.g_eleevl_table),
113: p_table_pk_id => :new.element_entry_value_id,
114: p_operation => 'insert',
115: p_old_record_data => l_old_element_entvl_hist_data,
116: p_row_id => :new.rowid);

Line 127: ghr_history_api.set_operation_info(

123: get_old_elmtenvl_data ( l_old_element_entvl_data);
124: ghr_history_conv_rg.conv_element_entval_rg_to_hist(
125: p_element_entval_data => l_old_element_entvl_data,
126: p_history_data => l_old_element_entvl_hist_data);
127: ghr_history_api.set_operation_info(
128: p_program_name => l_session_var.program_name,
129: p_date_effective => l_session_var.date_effective,
130: p_table_name => lower(ghr_history_api.g_eleevl_table),
131: p_table_pk_id => :new.element_entry_value_id,

Line 130: p_table_name => lower(ghr_history_api.g_eleevl_table),

126: p_history_data => l_old_element_entvl_hist_data);
127: ghr_history_api.set_operation_info(
128: p_program_name => l_session_var.program_name,
129: p_date_effective => l_session_var.date_effective,
130: p_table_name => lower(ghr_history_api.g_eleevl_table),
131: p_table_pk_id => :new.element_entry_value_id,
132: p_operation => 'update',
133: p_old_record_data => l_old_element_entvl_hist_data,
134: p_row_id => :new.rowid);

Line 144: -- ghr_history_api.set_operation_info(

140: -- get_old_elmtevl_data(l_old_elmtevl_date);
141: -- ghr_history_conv_rg.conv_element_entval_rg_to_hist(
142: -- p_element_entvl_data => l_old_element_entvl_data,
143: -- p_history_data => l_old_element_entvl_hist_data);
144: -- ghr_history_api.set_operation_info(
145: -- p_program_name => l_session_var.program_name,
146: -- p_date_effective => l_session_var.date_effective,
147: -- p_table_name => lower(ghr_history_api.g_eleevl_table),
148: -- p_table_pk_id => :new.element_entry_value_id,

Line 147: -- p_table_name => lower(ghr_history_api.g_eleevl_table),

143: -- p_history_data => l_old_element_entvl_hist_data);
144: -- ghr_history_api.set_operation_info(
145: -- p_program_name => l_session_var.program_name,
146: -- p_date_effective => l_session_var.date_effective,
147: -- p_table_name => lower(ghr_history_api.g_eleevl_table),
148: -- p_table_pk_id => :new.element_entry_value_id,
149: -- p_operation => 'delete',
150: -- p_old_record_data => l_old_element_entvl_data,
151: -- p_row_id => :new.rowid);