APPS.PQH_DOC_INS dependencies on PQH_DOCUMENTS_F

Line 91: from pqh_documents_f t

87: --
88: Cursor C_Sel1 Is
89: select t.created_by,
90: t.creation_date
91: from pqh_documents_f t
92: where t.document_id = p_rec.document_id
93: and t.effective_start_date =
94: pqh_doc_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);

Line 98: l_created_by pqh_documents_f.created_by%TYPE;

94: pqh_doc_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pqh_documents_f.created_by%TYPE;
99: l_creation_date pqh_documents_f.creation_date%TYPE;
100: l_last_update_date pqh_documents_f.last_update_date%TYPE;
101: l_last_updated_by pqh_documents_f.last_updated_by%TYPE;
102: l_last_update_login pqh_documents_f.last_update_login%TYPE;

Line 99: l_creation_date pqh_documents_f.creation_date%TYPE;

95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pqh_documents_f.created_by%TYPE;
99: l_creation_date pqh_documents_f.creation_date%TYPE;
100: l_last_update_date pqh_documents_f.last_update_date%TYPE;
101: l_last_updated_by pqh_documents_f.last_updated_by%TYPE;
102: l_last_update_login pqh_documents_f.last_update_login%TYPE;
103: --

Line 100: l_last_update_date pqh_documents_f.last_update_date%TYPE;

96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pqh_documents_f.created_by%TYPE;
99: l_creation_date pqh_documents_f.creation_date%TYPE;
100: l_last_update_date pqh_documents_f.last_update_date%TYPE;
101: l_last_updated_by pqh_documents_f.last_updated_by%TYPE;
102: l_last_update_login pqh_documents_f.last_update_login%TYPE;
103: --
104: Begin

Line 101: l_last_updated_by pqh_documents_f.last_updated_by%TYPE;

97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pqh_documents_f.created_by%TYPE;
99: l_creation_date pqh_documents_f.creation_date%TYPE;
100: l_last_update_date pqh_documents_f.last_update_date%TYPE;
101: l_last_updated_by pqh_documents_f.last_updated_by%TYPE;
102: l_last_update_login pqh_documents_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);

Line 102: l_last_update_login pqh_documents_f.last_update_login%TYPE;

98: l_created_by pqh_documents_f.created_by%TYPE;
99: l_creation_date pqh_documents_f.creation_date%TYPE;
100: l_last_update_date pqh_documents_f.last_update_date%TYPE;
101: l_last_updated_by pqh_documents_f.last_updated_by%TYPE;
102: l_last_update_login pqh_documents_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --

Line 111: (p_base_table_name => 'pqh_documents_f'

107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=
110: dt_api.get_object_version_number
111: (p_base_table_name => 'pqh_documents_f'
112: ,p_base_key_column => 'document_id'
113: ,p_base_key_value => p_rec.document_id
114: );
115: --

Line 154: -- Insert the row into: pqh_documents_f

150: End If;
151: --
152: pqh_doc_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pqh_documents_f
155: --
156: insert into pqh_documents_f
157: (document_id
158: ,effective_start_date

Line 156: insert into pqh_documents_f

152: pqh_doc_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pqh_documents_f
155: --
156: insert into pqh_documents_f
157: (document_id
158: ,effective_start_date
159: ,effective_end_date
160: ,short_name

Line 296: from pqh_documents_f

292: Cursor C_Sel1 is select pqh_documents_s.nextval from sys.dual;
293: --
294: Cursor C_Sel2 is
295: Select null
296: from pqh_documents_f
297: where document_id =
298: pqh_doc_ins.g_document_id_i;
299: --
300: l_proc varchar2(72) := g_package||'pre_insert';

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

314: --
315: -- The primary key values are already in use.
316: --
317: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
318: fnd_message.set_token('TABLE_NAME','pqh_documents_f');
319: fnd_message.raise_error;
320: End If;
321: Close C_Sel2;
322: --

Line 433: (p_module_name => 'PQH_DOCUMENTS_F'

429: --
430: when hr_api.cannot_find_prog_unit then
431: --
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'PQH_DOCUMENTS_F'
434: ,p_hook_type => 'AI');
435: --
436: end;
437: --

Line 498: ,p_base_table_name => 'pqh_documents_f'

494: --
495: dt_api.validate_dt_mode
496: (p_effective_date => p_effective_date
497: ,p_datetrack_mode => p_datetrack_mode
498: ,p_base_table_name => 'pqh_documents_f'
499: ,p_base_key_column => 'document_id'
500: ,p_base_key_value => p_rec.document_id
501: ,p_enforce_foreign_locking => true
502: ,p_validation_start_date => l_validation_start_date