APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on DT_API

Line 119: -- The funciton uses dt_api to get the updation_mode. --

115: -- Type : FUNCTION --
116: -- Access : Private --
117: -- Description : Function to update the details of SSCWT Information --
118: -- element. --
119: -- The funciton uses dt_api to get the updation_mode. --
120: -- --
121: -- Parameters : --
122: -- IN : p_sscwt_rate NUMBER --
123: -- p_sscwt_element_entry_id pay_element_entries_f.element_entry_id%TYPE --

Line 185: DT_Api.Find_DT_Upd_Modes

181: -- Determine the update mode to be used in element entry value updation.
182: -- This procedure will set updation mode either to one of these values as true:
183: -- Update, Correction, update Override or Update Change Imsert.
184: --
185: DT_Api.Find_DT_Upd_Modes
186: (p_effective_date => p_effective_date
187: ,p_base_table_name => 'pay_element_entries_f'
188: ,p_base_key_column => 'element_entry_id'
189: ,p_base_key_value => p_sscwt_element_entry_id

Line 197: hr_utility.set_location('After calling DT_Api.Find_DT_Upd_MOdes', 20);

193: ,p_update_change_insert=> l_update_change_insert);
194: --
195:
196: IF g_debug THEN
197: hr_utility.set_location('After calling DT_Api.Find_DT_Upd_MOdes', 20);
198: END IF;
199: --
200: --
201: -- Check which flag has been set by DT_API.Find_DT_Upd_Modes

Line 201: -- Check which flag has been set by DT_API.Find_DT_Upd_Modes

197: hr_utility.set_location('After calling DT_Api.Find_DT_Upd_MOdes', 20);
198: END IF;
199: --
200: --
201: -- Check which flag has been set by DT_API.Find_DT_Upd_Modes
202: -- Correction is always set to true hence check it's value at last as default.
203: -- If effective start date is not same as effective date, then
204: -- If any future row exists for element, then Update is false and Update override and
205: -- Update Change Insert is set to true.