APPS.PQP_AAT_SHD dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 32: If (p_constraint_name = 'PQP_ASSIGNMENT_ATTRIBUTES_F_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PQP_ASSIGNMENT_ATTRIBUTES_F_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 144: from pqp_assignment_attributes_f

140: ,lgps_exclusion_type
141: ,lgps_pensionable_pay
142: ,lgps_trans_arrang_flag
143: ,lgps_membership_number
144: from pqp_assignment_attributes_f
145: where assignment_attribute_id = p_assignment_attribute_id
146: and p_effective_date
147: between effective_start_date and effective_end_date;
148: --

Line 219: ,p_base_table_name => 'pqp_assignment_attributes_f'

215: -- Call the corresponding datetrack api
216: --
217: dt_api.find_dt_upd_modes
218: (p_effective_date => p_effective_date
219: ,p_base_table_name => 'pqp_assignment_attributes_f'
220: ,p_base_key_column => 'assignment_attribute_id'
221: ,p_base_key_value => p_base_key_value
222: ,p_correction => p_correction
223: ,p_update => p_update

Line 253: ,p_base_table_name => 'pqp_assignment_attributes_f'

249: -- Call the corresponding datetrack api
250: --
251: dt_api.find_dt_del_modes
252: (p_effective_date => p_effective_date
253: ,p_base_table_name => 'pqp_assignment_attributes_f'
254: ,p_base_key_column => 'assignment_attribute_id'
255: ,p_base_key_value => p_base_key_value
256: ,p_zap => p_zap
257: ,p_delete => p_delete

Line 288: (p_base_table_name => 'pqp_assignment_attributes_f'

284: -- version number.
285: --
286: l_object_version_number :=
287: dt_api.get_object_version_number
288: (p_base_table_name => 'pqp_assignment_attributes_f'
289: ,p_base_key_column => 'assignment_attribute_id'
290: ,p_base_key_value => p_base_key_value
291: );
292: --

Line 299: update pqp_assignment_attributes_f t

295: --
296: -- Update the specified datetrack row setting the effective
297: -- end date to the specified new effective end date.
298: --
299: update pqp_assignment_attributes_f t
300: set t.effective_end_date = p_new_effective_end_date
301: , t.object_version_number = l_object_version_number
302: where t.assignment_attribute_id = p_base_key_value
303: and p_effective_date

Line 421: from pqp_assignment_attributes_f

417: ,lgps_exclusion_type
418: ,lgps_pensionable_pay
419: ,lgps_trans_arrang_flag
420: ,lgps_membership_number
421: from pqp_assignment_attributes_f
422: where assignment_attribute_id = p_assignment_attribute_id
423: and p_effective_date
424: between effective_start_date and effective_end_date
425: for update nowait;

Line 484: ,p_base_table_name => 'pqp_assignment_attributes_f'

480: --
481: dt_api.validate_dt_mode
482: (p_effective_date => p_effective_date
483: ,p_datetrack_mode => p_datetrack_mode
484: ,p_base_table_name => 'pqp_assignment_attributes_f'
485: ,p_base_key_column => 'assignment_attribute_id'
486: ,p_base_key_value => p_assignment_attribute_id
487: ,p_enforce_foreign_locking => true
488: ,p_validation_start_date => l_validation_start_date

Line 519: fnd_message.set_token('TABLE_NAME', 'pqp_assignment_attributes_f');

515: -- The object is locked therefore we need to supply a meaningful
516: -- error message.
517: --
518: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
519: fnd_message.set_token('TABLE_NAME', 'pqp_assignment_attributes_f');
520: fnd_message.raise_error;
521: End lck;
522: --
523: -- ---------------------------------------------------------------------------+