APPS.PAY_AMO_INS dependencies on PAY_AU_MODULES

Line 139: -- Insert the row into: pay_au_modules

135: p_rec.object_version_number := 1; -- Initialise the object version
136: --
137: pay_amo_shd.g_api_dml := true; -- Set the api dml status
138: --
139: -- Insert the row into: pay_au_modules
140: --
141: insert into pay_au_modules
142: (module_id
143: ,name

Line 141: insert into pay_au_modules

137: pay_amo_shd.g_api_dml := true; -- Set the api dml status
138: --
139: -- Insert the row into: pay_au_modules
140: --
141: insert into pay_au_modules
142: (module_id
143: ,name
144: ,enabled_flag
145: ,module_type_id

Line 233: Cursor C_Sel1 is select pay_au_modules_s.nextval from sys.dual;

229: Procedure pre_insert
230: (p_rec in out nocopy pay_amo_shd.g_rec_type
231: ) is
232: --
233: Cursor C_Sel1 is select pay_au_modules_s.nextval from sys.dual;
234: --
235: Cursor C_Sel2 is
236: Select null
237: from pay_au_modules

Line 237: from pay_au_modules

233: Cursor C_Sel1 is select pay_au_modules_s.nextval from sys.dual;
234: --
235: Cursor C_Sel2 is
236: Select null
237: from pay_au_modules
238: where module_id =
239: pay_amo_ins.g_module_id_i;
240: --
241: l_proc varchar2(72);

Line 261: fnd_message.set_token('TABLE_NAME','pay_au_modules');

257: --
258: -- The primary key values are already in use.
259: --
260: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
261: fnd_message.set_token('TABLE_NAME','pay_au_modules');
262: fnd_message.raise_error;
263: End If;
264: Close C_Sel2;
265: --