APPS.PAY_SPR_INS dependencies on PAY_SECURITY_PAYROLLS

Line 90: -- Insert the row into: pay_security_payrolls

86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: pay_spr_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: pay_security_payrolls
91: --
92: hr_utility.set_location(to_char(p_rec.payroll_id),10);
93: insert into pay_security_payrolls
94: (business_group_id

Line 93: insert into pay_security_payrolls

89: --
90: -- Insert the row into: pay_security_payrolls
91: --
92: hr_utility.set_location(to_char(p_rec.payroll_id),10);
93: insert into pay_security_payrolls
94: (business_group_id
95: ,security_profile_id
96: ,payroll_id
97: ,request_id

Line 182: from pay_security_payrolls

178: --
179: --
180: Cursor C_Sel2 is
181: Select null
182: from pay_security_payrolls
183: where security_profile_id =
184: pay_spr_ins.g_security_profile_id_i
185: and payroll_id =
186: pay_spr_ins.g_payroll_id_i;

Line 207: fnd_message.set_token('TABLE_NAME','pay_security_payrolls');

203: --
204: -- The primary key values are already in use.
205: --
206: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
207: fnd_message.set_token('TABLE_NAME','pay_security_payrolls');
208: fnd_message.raise_error;
209: End If;
210: Close C_Sel2;
211: --

Line 286: (p_module_name => 'PAY_SECURITY_PAYROLLS'

282: --
283: when hr_api.cannot_find_prog_unit then
284: --
285: hr_api.cannot_find_prog_unit_error
286: (p_module_name => 'PAY_SECURITY_PAYROLLS'
287: ,p_hook_type => 'AI');
288: --
289: end;
290: --