APPS.PAY_PBD_INS dependencies on PAY_BAL_ATTRIBUTE_DEFAULTS

Line 134: -- Insert the row into: pay_bal_attribute_defaults

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

Line 136: insert into pay_bal_attribute_defaults

132: --
133: --
134: -- Insert the row into: pay_bal_attribute_defaults
135: --
136: insert into pay_bal_attribute_defaults
137: (bal_attribute_default_id
138: ,attribute_id
139: ,balance_dimension_id
140: ,balance_category_id

Line 218: Cursor C_Sel1 is select pay_bal_attribute_defaults_s.nextval from sys.dual;

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

Line 222: from pay_bal_attribute_defaults

218: Cursor C_Sel1 is select pay_bal_attribute_defaults_s.nextval from sys.dual;
219: --
220: Cursor C_Sel2 is
221: Select null
222: from pay_bal_attribute_defaults
223: where bal_attribute_default_id =
224: pay_pbd_ins.g_bal_attribute_default_id_i;
225: --
226: l_proc varchar2(72) := g_package||'pre_insert';

Line 244: fnd_message.set_token('TABLE_NAME','pay_bal_attribute_defaults');

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

Line 337: (p_module_name => 'PAY_BAL_ATTRIBUTE_DEFAULTS'

333: --
334: when hr_api.cannot_find_prog_unit then
335: --
336: hr_api.cannot_find_prog_unit_error
337: (p_module_name => 'PAY_BAL_ATTRIBUTE_DEFAULTS'
338: ,p_hook_type => 'AI');
339: --
340: end;
341: --