APPS.PQH_VER_INS dependencies on PQH_DE_WRKPLC_VLDTN_VERS

Line 87: -- Insert the row into: pqh_de_wrkplc_vldtn_vers

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: pqh_de_wrkplc_vldtn_vers
88: --
89: insert into pqh_de_wrkplc_vldtn_vers
90: (wrkplc_vldtn_ver_id
91: ,wrkplc_vldtn_id

Line 89: insert into pqh_de_wrkplc_vldtn_vers

85: --
86: --
87: -- Insert the row into: pqh_de_wrkplc_vldtn_vers
88: --
89: insert into pqh_de_wrkplc_vldtn_vers
90: (wrkplc_vldtn_ver_id
91: ,wrkplc_vldtn_id
92: ,version_number
93: ,business_group_id

Line 193: Cursor C_Sel1 is select pqh_de_wrkplc_vldtn_vers_s.nextval from sys.dual;

189: Procedure pre_insert
190: (p_rec in out nocopy pqh_ver_shd.g_rec_type
191: ) is
192: --
193: Cursor C_Sel1 is select pqh_de_wrkplc_vldtn_vers_s.nextval from sys.dual;
194: --
195: Cursor C_Sel2 is
196: Select null
197: from pqh_de_wrkplc_vldtn_vers

Line 197: from pqh_de_wrkplc_vldtn_vers

193: Cursor C_Sel1 is select pqh_de_wrkplc_vldtn_vers_s.nextval from sys.dual;
194: --
195: Cursor C_Sel2 is
196: Select null
197: from pqh_de_wrkplc_vldtn_vers
198: where wrkplc_vldtn_ver_id =
199: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i;
200: --
201: l_proc varchar2(72) := g_package||'pre_insert';

Line 219: fnd_message.set_token('TABLE_NAME','pqh_de_wrkplc_vldtn_vers');

215: --
216: -- The primary key values are already in use.
217: --
218: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
219: fnd_message.set_token('TABLE_NAME','pqh_de_wrkplc_vldtn_vers');
220: fnd_message.raise_error;
221: End If;
222: Close C_Sel2;
223: --

Line 330: (p_module_name => 'PQH_DE_WRKPLC_VLDTN_VERS'

326: --
327: when hr_api.cannot_find_prog_unit then
328: --
329: hr_api.cannot_find_prog_unit_error
330: (p_module_name => 'PQH_DE_WRKPLC_VLDTN_VERS'
331: ,p_hook_type => 'AI');
332: --
333: end;
334: --