APPS.PAY_PYR_INS dependencies on PAY_RATES

Line 87: -- Insert the row INTO: pay_rates

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: pay_pyr_shd.g_api_dml := TRUE; -- Set the api dml status
86: --
87: -- Insert the row INTO: pay_rates
88: --
89: insert INTO pay_rates
90: (rate_id
91: ,business_group_id

Line 89: insert INTO pay_rates

85: pay_pyr_shd.g_api_dml := TRUE; -- Set the api dml status
86: --
87: -- Insert the row INTO: pay_rates
88: --
89: insert INTO pay_rates
90: (rate_id
91: ,business_group_id
92: ,parent_spine_id
93: ,name

Line 229: CURSOR C_Sel1 IS SELECT pay_rates_s.nextval FROM sys.dual;

225: PROCEDURE pre_insert
226: (p_rec IN OUT NOCOPY pay_pyr_shd.g_rec_type
227: ) IS
228: --
229: CURSOR C_Sel1 IS SELECT pay_rates_s.nextval FROM sys.dual;
230: --
231: CURSOR C_Sel2 IS
232: Select NULL
233: FROM pay_rates

Line 233: FROM pay_rates

229: CURSOR C_Sel1 IS SELECT pay_rates_s.nextval FROM sys.dual;
230: --
231: CURSOR C_Sel2 IS
232: Select NULL
233: FROM pay_rates
234: WHERE rate_id =
235: pay_pyr_ins.g_rate_id_i;
236: --
237: l_proc VARCHAR2(72) := g_package||'pre_insert';

Line 255: fnd_message.set_token('TABLE_NAME','pay_rates');

251: --
252: -- The primary key values are already IN use.
253: --
254: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
255: fnd_message.set_token('TABLE_NAME','pay_rates');
256: fnd_message.raise_error;
257: END IF;
258: CLOSE C_Sel2;
259: --

Line 402: (p_module_name => 'PAY_RATES'

398: --
399: when hr_api.cannot_find_prog_unit THEN
400: --
401: hr_api.cannot_find_prog_unit_error
402: (p_module_name => 'PAY_RATES'
403: ,p_hook_type => 'AI');
404: --
405: END;
406: --