APPS.PAY_PBA_INS dependencies on PAY_BALANCE_ATTRIBUTES

Line 132: -- Insert the row into: pay_balance_attributes

128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: -- Insert the row into: pay_balance_attributes
133: --
134: insert into pay_balance_attributes
135: (balance_attribute_id
136: ,attribute_id

Line 134: insert into pay_balance_attributes

130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: -- Insert the row into: pay_balance_attributes
133: --
134: insert into pay_balance_attributes
135: (balance_attribute_id
136: ,attribute_id
137: ,defined_balance_id
138: ,legislation_code

Line 214: Cursor C_Sel1 is select pay_balance_attributes_s.nextval from sys.dual;

210: Procedure pre_insert
211: (p_rec in out nocopy pay_pba_shd.g_rec_type
212: ) is
213: --
214: Cursor C_Sel1 is select pay_balance_attributes_s.nextval from sys.dual;
215: --
216: Cursor C_Sel2 is
217: Select null
218: from pay_balance_attributes

Line 218: from pay_balance_attributes

214: Cursor C_Sel1 is select pay_balance_attributes_s.nextval from sys.dual;
215: --
216: Cursor C_Sel2 is
217: Select null
218: from pay_balance_attributes
219: where balance_attribute_id =
220: pay_pba_ins.g_balance_attribute_id_i;
221: --
222: l_proc varchar2(72) := g_package||'pre_insert';

Line 240: fnd_message.set_token('TABLE_NAME','pay_balance_attributes');

236: --
237: -- The primary key values are already in use.
238: --
239: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
240: fnd_message.set_token('TABLE_NAME','pay_balance_attributes');
241: fnd_message.raise_error;
242: End If;
243: Close C_Sel2;
244: --

Line 331: (p_module_name => 'PAY_BALANCE_ATTRIBUTES'

327: --
328: when hr_api.cannot_find_prog_unit then
329: --
330: hr_api.cannot_find_prog_unit_error
331: (p_module_name => 'PAY_BALANCE_ATTRIBUTES'
332: ,p_hook_type => 'AI');
333: --
334: end;
335: --