APPS.PAY_EGU_INS dependencies on PAY_EVENT_GROUP_USAGES

Line 135: -- Insert the row into: pay_event_group_usages

131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: --
134: --
135: -- Insert the row into: pay_event_group_usages
136: --
137: insert into pay_event_group_usages
138: (event_group_usage_id
139: ,event_group_id

Line 137: insert into pay_event_group_usages

133: --
134: --
135: -- Insert the row into: pay_event_group_usages
136: --
137: insert into pay_event_group_usages
138: (event_group_usage_id
139: ,event_group_id
140: ,element_set_id
141: ,business_group_id

Line 219: Cursor C_Sel1 is select pay_event_group_usages_s.nextval from sys.dual;

215: Procedure pre_insert
216: (p_rec in out nocopy pay_egu_shd.g_rec_type
217: ) is
218: --
219: Cursor C_Sel1 is select pay_event_group_usages_s.nextval from sys.dual;
220: --
221: Cursor C_Sel2 is
222: Select null
223: from pay_event_group_usages

Line 223: from pay_event_group_usages

219: Cursor C_Sel1 is select pay_event_group_usages_s.nextval from sys.dual;
220: --
221: Cursor C_Sel2 is
222: Select null
223: from pay_event_group_usages
224: where event_group_usage_id =
225: pay_egu_ins.g_event_group_usage_id_i;
226: --
227: l_proc varchar2(72) := g_package||'pre_insert';

Line 245: fnd_message.set_token('TABLE_NAME','pay_event_group_usages');

241: --
242: -- The primary key values are already in use.
243: --
244: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
245: fnd_message.set_token('TABLE_NAME','pay_event_group_usages');
246: fnd_message.raise_error;
247: End If;
248: Close C_Sel2;
249: --