APPS.PAY_APR_INS dependencies on PAY_AU_PROCESSES

Line 141: -- Insert the row into: pay_au_processes

137: p_rec.object_version_number := 1; -- Initialise the object version
138: --
139: pay_apr_shd.g_api_dml := true; -- Set the api dml status
140: --
141: -- Insert the row into: pay_au_processes
142: --
143: insert into pay_au_processes
144: (process_id
145: ,short_name

Line 143: insert into pay_au_processes

139: pay_apr_shd.g_api_dml := true; -- Set the api dml status
140: --
141: -- Insert the row into: pay_au_processes
142: --
143: insert into pay_au_processes
144: (process_id
145: ,short_name
146: ,name
147: ,enabled_flag

Line 231: Cursor C_Sel1 is select pay_au_processes_s.nextval from sys.dual;

227: Procedure pre_insert
228: (p_rec in out nocopy pay_apr_shd.g_rec_type
229: ) is
230: --
231: Cursor C_Sel1 is select pay_au_processes_s.nextval from sys.dual;
232: --
233: Cursor C_Sel2 is
234: Select null
235: from pay_au_processes

Line 235: from pay_au_processes

231: Cursor C_Sel1 is select pay_au_processes_s.nextval from sys.dual;
232: --
233: Cursor C_Sel2 is
234: Select null
235: from pay_au_processes
236: where process_id =
237: pay_apr_ins.g_process_id_i;
238: --
239: l_proc varchar2(72);

Line 260: fnd_message.set_token('TABLE_NAME','pay_au_processes');

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