DBA Data[Home] [Help]

APPS.PAY_AMP_INS dependencies on PAY_AU_MODULE_PARAMETERS

Line 91: -- Insert the row into: pay_au_module_parameters

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

Line 93: insert into pay_au_module_parameters

89: pay_amp_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: pay_au_module_parameters
92: --
93: insert into pay_au_module_parameters
94: (module_parameter_id
95: ,module_id
96: ,internal_name
97: ,data_type

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

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

Line 197: from pay_au_module_parameters

193: Cursor C_Sel1 is select pay_au_module_parameters_s.nextval from sys.dual;
194: --
195: Cursor C_Sel2 is
196: Select null
197: from pay_au_module_parameters
198: where module_parameter_id =
199: pay_amp_ins.g_module_parameter_id_i;
200: --
201: l_proc varchar2(72);

Line 221: fnd_message.set_token('TABLE_NAME','pay_au_module_parameters');

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