DBA Data[Home] [Help]

APPS.PAY_AIF_INS dependencies on PAY_ACTION_INFORMATION

Line 86: -- Insert the row into: pay_action_information

82: p_rec.object_version_number := 1; -- Initialise the object version
83: --
84: --
85: --
86: -- Insert the row into: pay_action_information
87: --
88: insert into pay_action_information
89: (action_information_id
90: ,action_context_id

Line 88: insert into pay_action_information

84: --
85: --
86: -- Insert the row into: pay_action_information
87: --
88: insert into pay_action_information
89: (action_information_id
90: ,action_context_id
91: ,action_context_type
92: ,tax_unit_id

Line 245: Cursor C_Sel1 is select pay_action_information_s.nextval from sys.dual;

241: --
242: l_proc varchar2(72) := g_package||'pre_insert';
243: l_exists varchar2(1);
244: --
245: Cursor C_Sel1 is select pay_action_information_s.nextval from sys.dual;
246: --
247: Cursor C_Sel2 is
248: Select null
249: from pay_action_information

Line 249: from pay_action_information

245: Cursor C_Sel1 is select pay_action_information_s.nextval from sys.dual;
246: --
247: Cursor C_Sel2 is
248: Select null
249: from pay_action_information
250: where action_information_id =
251: pay_aif_ins.g_action_information_id_i;
252: --
253: Begin

Line 268: fnd_message.set_token('TABLE_NAME','pay_action_information');

264: --
265: -- The primary key values are already in use.
266: --
267: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
268: fnd_message.set_token('TABLE_NAME','pay_action_information');
269: fnd_message.raise_error;
270: End If;
271: Close C_Sel2;
272: --

Line 426: (p_module_name => 'PAY_ACTION_INFORMATION'

422: --
423: when hr_api.cannot_find_prog_unit then
424: --
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'PAY_ACTION_INFORMATION'
427: ,p_hook_type => 'AI');
428: --
429: end;
430: --