APPS.PAY_APM_INS dependencies on PAY_AU_PROCESS_MODULES

Line 91: -- Insert the row into: pay_au_process_modules

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

Line 93: insert into pay_au_process_modules

89: pay_apm_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: pay_au_process_modules
92: --
93: insert into pay_au_process_modules
94: (process_module_id
95: ,process_id
96: ,module_id
97: ,process_sequence

Line 175: Cursor C_Sel1 is select pay_au_process_modules_s.nextval from sys.dual;

171: Procedure pre_insert
172: (p_rec in out nocopy pay_apm_shd.g_rec_type
173: ) is
174: --
175: Cursor C_Sel1 is select pay_au_process_modules_s.nextval from sys.dual;
176: --
177: Cursor C_Sel2 is
178: Select null
179: from pay_au_process_modules

Line 179: from pay_au_process_modules

175: Cursor C_Sel1 is select pay_au_process_modules_s.nextval from sys.dual;
176: --
177: Cursor C_Sel2 is
178: Select null
179: from pay_au_process_modules
180: where process_module_id =
181: pay_apm_ins.g_process_module_id_i;
182: --
183: l_proc varchar2(72);

Line 203: fnd_message.set_token('TABLE_NAME','pay_au_process_modules');

199: --
200: -- The primary key values are already in use.
201: --
202: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
203: fnd_message.set_token('TABLE_NAME','pay_au_process_modules');
204: fnd_message.raise_error;
205: End If;
206: Close C_Sel2;
207: --