APPS.GHR_PER_ADDRESSES_AFIUD dependencies on GHR_HISTORY_API

Line 4: l_session_var ghr_history_api.g_session_var_type;

1: TRIGGER GHR_PER_ADDRESSES_AFIUD
2: AFTER INSERT OR UPDATE OR DELETE ON PER_ADDRESSES FOR EACH ROW
3: DECLARE
4: l_session_var ghr_history_api.g_session_var_type;
5: l_old_address_data per_addresses%rowtype;
6: l_old_address_hist_data ghr_pa_history%rowtype;
7: l_proc varchar2(40):='per_addresses_afiud';
8:

Line 72: ghr_history_api.get_g_session_var( l_session_var);

68:
69: BEGIN
70: if hr_general.g_data_migrator_mode <> 'Y' then
71: hr_utility.set_location('Entering:'|| l_proc , 1);
72: ghr_history_api.get_g_session_var( l_session_var);
73: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
74: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
75:
76: if l_session_var.fire_trigger = 'Y' THEN

Line 79: ghr_history_api.set_g_session_var( l_session_var);

75:
76: if l_session_var.fire_trigger = 'Y' THEN
77: if l_session_var.person_id is null then
78: l_session_var.person_id := :new.person_id;
79: ghr_history_api.set_g_session_var( l_session_var);
80: end if;
81: if lower(l_session_var.program_name) = 'core' then
82: ghr_history_api.get_session_date( l_session_var.date_effective);
83: ghr_history_api.set_g_session_var (l_session_var);

Line 82: ghr_history_api.get_session_date( l_session_var.date_effective);

78: l_session_var.person_id := :new.person_id;
79: ghr_history_api.set_g_session_var( l_session_var);
80: end if;
81: if lower(l_session_var.program_name) = 'core' then
82: ghr_history_api.get_session_date( l_session_var.date_effective);
83: ghr_history_api.set_g_session_var (l_session_var);
84: end if;
85:
86: if (lower(l_session_var.program_name) = 'sf50' or lower(l_session_var.program_name) = 'core') then

Line 83: ghr_history_api.set_g_session_var (l_session_var);

79: ghr_history_api.set_g_session_var( l_session_var);
80: end if;
81: if lower(l_session_var.program_name) = 'core' then
82: ghr_history_api.get_session_date( l_session_var.date_effective);
83: ghr_history_api.set_g_session_var (l_session_var);
84: end if;
85:
86: if (lower(l_session_var.program_name) = 'sf50' or lower(l_session_var.program_name) = 'core') then
87: if inserting THEN

Line 90: ghr_history_api.set_operation_info

86: if (lower(l_session_var.program_name) = 'sf50' or lower(l_session_var.program_name) = 'core') then
87: if inserting THEN
88: hr_utility.set_location( l_proc , 170);
89: hr_utility.set_location( l_proc , 160);
90: ghr_history_api.set_operation_info
91: (
92: p_table_name => ghr_history_api.g_addres_table,
93: p_program_name => l_session_var.program_name,
94: p_date_effective => l_session_var.date_effective,

Line 92: p_table_name => ghr_history_api.g_addres_table,

88: hr_utility.set_location( l_proc , 170);
89: hr_utility.set_location( l_proc , 160);
90: ghr_history_api.set_operation_info
91: (
92: p_table_name => ghr_history_api.g_addres_table,
93: p_program_name => l_session_var.program_name,
94: p_date_effective => l_session_var.date_effective,
95: p_table_pk_id => :new.address_id,
96: p_operation => 'insert',

Line 109: ghr_history_api.set_operation_info

105: p_addresses_data => l_old_address_data,
106: p_history_data => l_old_address_hist_data
107: );
108:
109: ghr_history_api.set_operation_info
110: (
111: p_table_name => ghr_history_api.g_addres_table,
112: p_program_name => l_session_var.program_name,
113: p_date_Effective => l_session_var.date_effective,

Line 111: p_table_name => ghr_history_api.g_addres_table,

107: );
108:
109: ghr_history_api.set_operation_info
110: (
111: p_table_name => ghr_history_api.g_addres_table,
112: p_program_name => l_session_var.program_name,
113: p_date_Effective => l_session_var.date_effective,
114: p_table_pk_id => :new.address_id,
115: p_operation => 'update',

Line 121: ghr_history_api.get_g_session_var( l_session_var);

117: p_row_id => :new.rowid
118: );
119: else -- ie deleting
120: hr_utility.set_location( l_proc , 120);
121: ghr_history_api.get_g_session_var( l_session_var);
122: NULL;
123: end if;
124: else -- Not a known type
125: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);