APPS.PQP_VRI_INS dependencies on PQP_VEH_REPOS_EXTRA_INFO

Line 87: -- Insert the row into: pqp_veh_repos_extra_info

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: pqp_vri_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: pqp_veh_repos_extra_info
88: --
89: insert into pqp_veh_repos_extra_info
90: (veh_repos_extra_info_id
91: ,vehicle_repository_id

Line 89: insert into pqp_veh_repos_extra_info

85: pqp_vri_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: pqp_veh_repos_extra_info
88: --
89: insert into pqp_veh_repos_extra_info
90: (veh_repos_extra_info_id
91: ,vehicle_repository_id
92: ,information_type
93: ,vrei_attribute_category

Line 279: Cursor C_Sel1 is select pqp_veh_repos_extra_info_s.nextval from sys.dual;

275: Procedure pre_insert
276: (p_rec in out nocopy pqp_vri_shd.g_rec_type
277: ) is
278: --
279: Cursor C_Sel1 is select pqp_veh_repos_extra_info_s.nextval from sys.dual;
280: --
281: Cursor C_Sel2 is
282: Select null
283: from pqp_veh_repos_extra_info

Line 283: from pqp_veh_repos_extra_info

279: Cursor C_Sel1 is select pqp_veh_repos_extra_info_s.nextval from sys.dual;
280: --
281: Cursor C_Sel2 is
282: Select null
283: from pqp_veh_repos_extra_info
284: where veh_repos_extra_info_id =
285: pqp_vri_ins.g_veh_repos_extra_info_id_i;
286: --
287: l_proc varchar2(72) := g_package||'pre_insert';

Line 305: fnd_message.set_token('TABLE_NAME','pqp_veh_repos_extra_info');

301: --
302: -- The primary key values are already in use.
303: --
304: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
305: fnd_message.set_token('TABLE_NAME','pqp_veh_repos_extra_info');
306: fnd_message.raise_error;
307: End If;
308: Close C_Sel2;
309: --

Line 500: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO'

496: --
497: when hr_api.cannot_find_prog_unit then
498: --
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO'
501: ,p_hook_type => 'AI');
502: --
503: end;
504: --