APPS.GHR_PER_ADDRESSES_AFIUD dependencies on GHR_HISTORY_API

Line 5: l_session_var ghr_history_api.g_session_var_type;

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

Line 73: ghr_history_api.get_g_session_var( l_session_var);

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

Line 80: ghr_history_api.set_g_session_var( l_session_var);

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

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

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

Line 84: ghr_history_api.set_g_session_var (l_session_var);

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

Line 91: ghr_history_api.set_operation_info

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

Line 93: p_table_name => ghr_history_api.g_addres_table,

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

Line 110: ghr_history_api.set_operation_info

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

Line 112: p_table_name => ghr_history_api.g_addres_table,

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

Line 122: ghr_history_api.get_g_session_var( l_session_var);

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