APPS.PAY_AMT_INS dependencies on PAY_AU_MODULE_TYPES

Line 91: -- Insert the row into: pay_au_module_types

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

Line 93: insert into pay_au_module_types

89: pay_amt_shd.g_api_dml := true; -- Set the api dml status
90: --
91: -- Insert the row into: pay_au_module_types
92: --
93: insert into pay_au_module_types
94: (module_type_id
95: ,name
96: ,enabled_flag
97: ,description

Line 173: Cursor C_Sel1 is select pay_au_module_types_s.nextval from sys.dual;

169: Procedure pre_insert
170: (p_rec in out nocopy pay_amt_shd.g_rec_type
171: ) is
172: --
173: Cursor C_Sel1 is select pay_au_module_types_s.nextval from sys.dual;
174: --
175: Cursor C_Sel2 is
176: Select null
177: from pay_au_module_types

Line 177: from pay_au_module_types

173: Cursor C_Sel1 is select pay_au_module_types_s.nextval from sys.dual;
174: --
175: Cursor C_Sel2 is
176: Select null
177: from pay_au_module_types
178: where module_type_id =
179: pay_amt_ins.g_module_type_id_i;
180: --
181: l_proc varchar2(72);

Line 201: fnd_message.set_token('TABLE_NAME','pay_au_module_types');

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