APPS.PQH_RMR_SHD dependencies on PQH_RATE_MATRIX_RATES_F

Line 21: If (p_constraint_name = 'PQH_RATE_MATRIX_RATES_F_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_RATE_MATRIX_RATES_F_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 60: from pqh_rate_matrix_rates_f

56: ,rate_value
57: ,business_group_id
58: ,legislation_code
59: ,object_version_number
60: from pqh_rate_matrix_rates_f
61: where rate_matrix_rate_id = p_rate_matrix_rate_id
62: and p_effective_date
63: between effective_start_date and effective_end_date;
64: --

Line 136: ,p_base_table_name => 'pqh_rate_matrix_rates_f'

132: -- Call the corresponding datetrack api
133: --
134: dt_api.find_dt_upd_modes
135: (p_effective_date => p_effective_date
136: ,p_base_table_name => 'pqh_rate_matrix_rates_f'
137: ,p_base_key_column => 'rate_matrix_rate_id'
138: ,p_base_key_value => p_base_key_value
139: ,p_correction => p_correction
140: ,p_update => p_update

Line 170: ,p_base_table_name => 'pqh_rate_matrix_rates_f'

166: -- Call the corresponding datetrack api
167: --
168: dt_api.find_dt_del_modes
169: (p_effective_date => p_effective_date
170: ,p_base_table_name => 'pqh_rate_matrix_rates_f'
171: ,p_base_key_column => 'rate_matrix_rate_id'
172: ,p_base_key_value => p_base_key_value
173: ,p_zap => p_zap
174: ,p_delete => p_delete

Line 205: (p_base_table_name => 'pqh_rate_matrix_rates_f'

201: -- version number.
202: --
203: l_object_version_number :=
204: dt_api.get_object_version_number
205: (p_base_table_name => 'pqh_rate_matrix_rates_f'
206: ,p_base_key_column => 'rate_matrix_rate_id'
207: ,p_base_key_value => p_base_key_value
208: );
209: --

Line 216: update pqh_rate_matrix_rates_f t

212: --
213: -- Update the specified datetrack row setting the effective
214: -- end date to the specified new effective end date.
215: --
216: update pqh_rate_matrix_rates_f t
217: set t.effective_end_date = p_new_effective_end_date
218: , t.object_version_number = l_object_version_number
219: where t.rate_matrix_rate_id = p_base_key_value
220: and p_effective_date

Line 263: from pqh_rate_matrix_rates_f

259: ,rate_value
260: ,business_group_id
261: ,legislation_code
262: ,object_version_number
263: from pqh_rate_matrix_rates_f
264: where rate_matrix_rate_id = p_rate_matrix_rate_id
265: and p_effective_date
266: between effective_start_date and effective_end_date
267: for update nowait;

Line 326: ,p_base_table_name => 'pqh_rate_matrix_rates_f'

322: --
323: dt_api.validate_dt_mode
324: (p_effective_date => p_effective_date
325: ,p_datetrack_mode => p_datetrack_mode
326: ,p_base_table_name => 'pqh_rate_matrix_rates_f'
327: ,p_base_key_column => 'rate_matrix_rate_id'
328: ,p_base_key_value => p_rate_matrix_rate_id
329: ,p_enforce_foreign_locking => true
330: ,p_validation_start_date => l_validation_start_date

Line 361: fnd_message.set_token('TABLE_NAME', 'pqh_rate_matrix_rates_f');

357: -- The object is locked therefore we need to supply a meaningful
358: -- error message.
359: --
360: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
361: fnd_message.set_token('TABLE_NAME', 'pqh_rate_matrix_rates_f');
362: fnd_message.raise_error;
363: End lck;
364: --
365: -- ----------------------------------------------------------------------------