APPS.PQH_DOA_SHD dependencies on PQH_DOCUMENT_ATTRIBUTES_F

Line 71: from pqh_document_attributes_f

67: ,document_id
68: ,attribute_id
69: ,tag_name
70: ,object_version_number
71: from pqh_document_attributes_f
72: where document_attribute_id = p_document_attribute_id
73: and p_effective_date
74: between effective_start_date and effective_end_date;
75: --

Line 147: ,p_base_table_name => 'pqh_document_attributes_f'

143: -- Call the corresponding datetrack api
144: --
145: dt_api.find_dt_upd_modes
146: (p_effective_date => p_effective_date
147: ,p_base_table_name => 'pqh_document_attributes_f'
148: ,p_base_key_column => 'document_attribute_id'
149: ,p_base_key_value => p_base_key_value
150: ,p_correction => p_correction
151: ,p_update => p_update

Line 181: ,p_base_table_name => 'pqh_document_attributes_f'

177: -- Call the corresponding datetrack api
178: --
179: dt_api.find_dt_del_modes
180: (p_effective_date => p_effective_date
181: ,p_base_table_name => 'pqh_document_attributes_f'
182: ,p_base_key_column => 'document_attribute_id'
183: ,p_base_key_value => p_base_key_value
184: ,p_zap => p_zap
185: ,p_delete => p_delete

Line 216: (p_base_table_name => 'pqh_document_attributes_f'

212: -- version number.
213: --
214: l_object_version_number :=
215: dt_api.get_object_version_number
216: (p_base_table_name => 'pqh_document_attributes_f'
217: ,p_base_key_column => 'document_attribute_id'
218: ,p_base_key_value => p_base_key_value
219: );
220: --

Line 227: update pqh_document_attributes_f t

223: --
224: -- Update the specified datetrack row setting the effective
225: -- end date to the specified new effective end date.
226: --
227: update pqh_document_attributes_f t
228: set t.effective_end_date = p_new_effective_end_date
229: , t.object_version_number = l_object_version_number
230: where t.document_attribute_id = p_base_key_value
231: and p_effective_date

Line 274: from pqh_document_attributes_f

270: ,document_id
271: ,attribute_id
272: ,tag_name
273: ,object_version_number
274: from pqh_document_attributes_f
275: where document_attribute_id = p_document_attribute_id
276: and p_effective_date
277: between effective_start_date and effective_end_date
278: for update nowait;

Line 337: ,p_base_table_name => 'pqh_document_attributes_f'

333: --
334: dt_api.validate_dt_mode
335: (p_effective_date => p_effective_date
336: ,p_datetrack_mode => p_datetrack_mode
337: ,p_base_table_name => 'pqh_document_attributes_f'
338: ,p_base_key_column => 'document_attribute_id'
339: ,p_base_key_value => p_document_attribute_id
340: ,p_parent_table_name1 => 'pqh_documents_f'
341: ,p_parent_key_column1 => 'document_id'

Line 375: fnd_message.set_token('TABLE_NAME', 'pqh_document_attributes_f');

371: -- The object is locked therefore we need to supply a meaningful
372: -- error message.
373: --
374: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
375: fnd_message.set_token('TABLE_NAME', 'pqh_document_attributes_f');
376: fnd_message.raise_error;
377: End lck;
378: --
379: -- ----------------------------------------------------------------------------