DBA Data[Home] [Help]

APPS.PER_FDL_INS dependencies on PER_FND_DOC_LINKS

Line 91: -- Insert the row into: per_fnd_doc_links

87: p_rec.object_version_number := 1; -- Initialise the object version
88: --
89: per_fdl_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: per_fnd_doc_links
92: --
93: insert into per_fnd_doc_links
94: (fnd_doc_link_id
95: ,entity_name

Line 93: insert into per_fnd_doc_links

89: per_fdl_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: per_fnd_doc_links
92: --
93: insert into per_fnd_doc_links
94: (fnd_doc_link_id
95: ,entity_name
96: ,sub_entity_name
97: ,entity_doc_id

Line 217: Cursor C_Sel1 is select per_fnd_doc_links_s.nextval from sys.dual;

213: Procedure pre_insert
214: (p_rec in out nocopy per_fdl_shd.g_rec_type
215: ) is
216: --
217: Cursor C_Sel1 is select per_fnd_doc_links_s.nextval from sys.dual;
218: --
219: Cursor C_Sel2 is
220: Select null
221: from per_fnd_doc_links

Line 221: from per_fnd_doc_links

217: Cursor C_Sel1 is select per_fnd_doc_links_s.nextval from sys.dual;
218: --
219: Cursor C_Sel2 is
220: Select null
221: from per_fnd_doc_links
222: where fnd_doc_link_id =
223: per_fdl_ins.g_fnd_doc_link_id_i;
224: --
225: l_proc varchar2(72) := g_package||'pre_insert';

Line 243: fnd_message.set_token('TABLE_NAME','per_fnd_doc_links');

239: --
240: -- The primary key values are already in use.
241: --
242: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
243: fnd_message.set_token('TABLE_NAME','per_fnd_doc_links');
244: fnd_message.raise_error;
245: End If;
246: Close C_Sel2;
247: --

Line 371: (p_module_name => 'PER_FND_DOC_LINKS'

367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'PER_FND_DOC_LINKS'
372: ,p_hook_type => 'AI');
373: --
374: end;
375: