DBA Data[Home] [Help]

APPS.PQH_TJR_INS dependencies on PQH_TXN_JOB_REQUIREMENTS

Line 65: -- Insert the row into: pqh_txn_job_requirements

61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --
65: -- Insert the row into: pqh_txn_job_requirements
66: --
67: insert into pqh_txn_job_requirements
68: (txn_job_requirement_id
69: ,position_transaction_id

Line 67: insert into pqh_txn_job_requirements

63: --
64: --
65: -- Insert the row into: pqh_txn_job_requirements
66: --
67: insert into pqh_txn_job_requirements
68: (txn_job_requirement_id
69: ,position_transaction_id
70: ,job_requirement_id
71: ,business_group_id

Line 211: Cursor C_Sel1 is select pqh_txn_job_requirements_s.nextval from sys.dual;

207: ) is
208: --
209: l_proc varchar2(72) := g_package||'pre_insert';
210: --
211: Cursor C_Sel1 is select pqh_txn_job_requirements_s.nextval from sys.dual;
212: --
213: Begin
214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --

Line 348: (p_module_name => 'PQH_TXN_JOB_REQUIREMENTS'

344: --
345: when hr_api.cannot_find_prog_unit then
346: --
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'PQH_TXN_JOB_REQUIREMENTS'
349: ,p_hook_type => 'AI');
350: --
351: end;
352: --