APPS.PQH_TCD_INS dependencies on PQH_TXN_CATEGORY_DOCUMENTS

Line 90: -- Insert the row into: pqh_txn_category_documents

86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: --
89: --
90: -- Insert the row into: pqh_txn_category_documents
91: --
92: insert into pqh_txn_category_documents
93: (document_id
94: ,transaction_category_id

Line 92: insert into pqh_txn_category_documents

88: --
89: --
90: -- Insert the row into: pqh_txn_category_documents
91: --
92: insert into pqh_txn_category_documents
93: (document_id
94: ,transaction_category_id
95: ,type_code
96: ,object_version_number

Line 172: from pqh_txn_category_documents

168: ) is
169: --
170: Cursor C_Sel2 is
171: Select null
172: from pqh_txn_category_documents
173: where document_id =
174: pqh_tcd_ins.g_document_id_i
175: or transaction_category_id =
176: pqh_tcd_ins.g_transaction_category_id_i;

Line 197: fnd_message.set_token('TABLE_NAME','pqh_txn_category_documents');

193: --
194: -- The primary key values are already in use.
195: --
196: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
197: fnd_message.set_token('TABLE_NAME','pqh_txn_category_documents');
198: fnd_message.raise_error;
199: End If;
200: Close C_Sel2;
201: --

Line 275: (p_module_name => 'PQH_TXN_CATEGORY_DOCUMENTS'

271: --
272: when hr_api.cannot_find_prog_unit then
273: --
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'PQH_TXN_CATEGORY_DOCUMENTS'
276: ,p_hook_type => 'AI');
277: --
278: end;
279: --