APPS.PQH_DOC_SHD dependencies on PQH_DOCUMENTS_F

Line 74: from pqh_documents_f

70: /* Added for XDO changes */
71: ,lob_code
72: ,language
73: ,territory
74: from pqh_documents_f
75: where document_id = p_document_id
76: and p_effective_date
77: between effective_start_date and effective_end_date;
78: --

Line 150: ,p_base_table_name => 'pqh_documents_f'

146: -- Call the corresponding datetrack api
147: --
148: dt_api.find_dt_upd_modes
149: (p_effective_date => p_effective_date
150: ,p_base_table_name => 'pqh_documents_f'
151: ,p_base_key_column => 'document_id'
152: ,p_base_key_value => p_base_key_value
153: ,p_correction => p_correction
154: ,p_update => p_update

Line 184: ,p_base_table_name => 'pqh_documents_f'

180: -- Call the corresponding datetrack api
181: --
182: dt_api.find_dt_del_modes
183: (p_effective_date => p_effective_date
184: ,p_base_table_name => 'pqh_documents_f'
185: ,p_base_key_column => 'document_id'
186: ,p_base_key_value => p_base_key_value
187: ,p_zap => p_zap
188: ,p_delete => p_delete

Line 219: (p_base_table_name => 'pqh_documents_f'

215: -- version number.
216: --
217: l_object_version_number :=
218: dt_api.get_object_version_number
219: (p_base_table_name => 'pqh_documents_f'
220: ,p_base_key_column => 'document_id'
221: ,p_base_key_value => p_base_key_value
222: );
223: --

Line 230: update pqh_documents_f t

226: --
227: -- Update the specified datetrack row setting the effective
228: -- end date to the specified new effective end date.
229: --
230: update pqh_documents_f t
231: set t.effective_end_date = p_new_effective_end_date
232: , t.object_version_number = l_object_version_number
233: where t.document_id = p_base_key_value
234: and p_effective_date

Line 285: from pqh_documents_f

281: /* Added for XDO changes */
282: ,lob_code
283: ,language
284: ,territory
285: from pqh_documents_f
286: where document_id = p_document_id
287: and p_effective_date
288: between effective_start_date and effective_end_date
289: for update nowait;

Line 349: ,p_base_table_name => 'pqh_documents_f'

345: --
346: dt_api.validate_dt_mode
347: (p_effective_date => p_effective_date
348: ,p_datetrack_mode => p_datetrack_mode
349: ,p_base_table_name => 'pqh_documents_f'
350: ,p_base_key_column => 'document_id'
351: ,p_base_key_value => p_document_id
352: ,p_child_table_name1 => 'pqh_document_attributes_f'
353: ,p_child_key_column1 => 'document_attribute_id'

Line 387: fnd_message.set_token('TABLE_NAME', 'pqh_documents_f');

383: -- The object is locked therefore we need to supply a meaningful
384: -- error message.
385: --
386: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
387: fnd_message.set_token('TABLE_NAME', 'pqh_documents_f');
388: fnd_message.raise_error;
389: End lck;
390: --
391: -- ----------------------------------------------------------------------------