[Home] [Help]
235: -- |---------------------------< chk_rate_id >-------------------------------|
236: -- ---------------------------------------------------------------------------
237: --
238: -- Description:
239: -- Validates that the rate id exists in the table pay_rates
240: --
241: -- Validates that the business group of the grade rule is the same as
242: -- the business group of the rate.
243: --
248: -- p_rate_id
249: -- p_business_group_id
250: --
251: -- Post Success:
252: -- If the rate_id refers to a valid rate on the table pay_rates
253: -- then processing continues
254: --
255: -- If the business group of the grade rule is the same as the
256: -- business group of the rate.
255: -- If the business group of the grade rule is the same as the
256: -- business group of the rate.
257: --
258: -- Post Failure:
259: -- If the rate_id does not exist on the table pay_rates then an
260: -- application error is raised and processing is terminated
261: --
262: -- If the business group of the grade rule is not the same as the
263: -- business group of the rate.
278: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;
279: --
280: cursor csr_rate_exists is
281: select business_group_id
282: from pay_rates pr
283: where pr.rate_id = p_rate_id;
284: --
285: begin
286: hr_utility.set_location('Entering:'|| l_proc, 10);
295: --
296: hr_utility.set_location(l_proc, 20);
297: --
298: -- Check that p_rate_id exists on table
299: -- pay_rates
300: --
301: open csr_rate_exists;
302: fetch csr_rate_exists into l_business_group_id;
303: if csr_rate_exists%notfound then
328: -- Validates that the value entered for rate_type exists on
329: -- the table hr_lookups
330: --
331: -- Validates that the combination of the rate type and the
332: -- rate id exists on the table pay_rates
333: --
334: -- Pre-conditions:
335: -- A valid value for p_rate_id
336: --
342: -- If the rate type exists on hr_lookups then processing
343: -- continues
344: --
345: -- If the combination of the rate type and the rate id exists
346: -- on the table pay_rates then processing continues
347: --
348: -- Post Failure:
349: -- If the rate type does not exist on hr_lookups, a constraint
350: -- error is raised and processing is terminated
349: -- If the rate type does not exist on hr_lookups, a constraint
350: -- error is raised and processing is terminated
351: --
352: -- If the combination of rate id and rate type does not exist
353: -- on the table pay_rates then an application error is raised
354: -- and processing is terminated
355: --
356: -- Access Status:
357: -- Internal Table Handler Use Only.
367: l_proc varchar2(72) := g_package||'chk_rate_type';
368: --
369: cursor csr_valid_comb is
370: select null
371: from pay_rates pr
372: where pr.rate_id = p_rate_id
373: and pr.rate_type = p_rate_type;
374: --
375: begin
400: --
401: hr_utility.set_location(l_proc, 3);
402: --
403: -- Check that the combination of rate id and
404: -- rate_type is valid on the table pay_rates
405: --
406: open csr_valid_comb;
407: fetch csr_valid_comb into l_exists;
408: if csr_valid_comb%notfound then
467: l_value pay_grade_rules_f.value%TYPE;
468: l_maximum pay_grade_rules_f.maximum%TYPE;
469: l_dummy_return_value pay_grade_rules_f.value%TYPE;
470: l_min_max_status varchar2(30);
471: l_uom pay_rates.rate_uom%TYPE;
472: l_currency_code per_business_groups.currency_code%TYPE;
473: --
474: cursor csel1 is
475: select pr.rate_uom
474: cursor csel1 is
475: select pr.rate_uom
476: , pbg.currency_code
477: from per_business_groups pbg
478: , pay_rates pr
479: where pr.rate_id = p_rate_id
480: and pbg.business_group_id = pr.business_group_id;
481: --
482: begin
641: l_api_updating boolean;
642: l_mid_value pay_grade_rules_f.mid_value%TYPE;
643: l_dummy_return_value pay_grade_rules_f.value%TYPE;
644: l_min_max_status varchar2(30);
645: l_uom pay_rates.rate_uom%TYPE;
646: l_currency_code per_business_groups.currency_code%TYPE;
647: --
648: cursor csel1 is
649: select pr.rate_uom
648: cursor csel1 is
649: select pr.rate_uom
650: , pbg.currency_code
651: from per_business_groups pbg
652: , pay_rates pr
653: where pr.rate_id = p_rate_id
654: and pbg.business_group_id = pr.business_group_id;
655: --
656: begin
806: l_minimum pay_grade_rules_f.minimum%TYPE;
807: l_value pay_grade_rules_f.value%TYPE;
808: l_dummy_return_value pay_grade_rules_f.value%TYPE;
809: l_min_max_status varchar2(30);
810: l_uom pay_rates.rate_uom%TYPE;
811: l_currency_code per_business_groups.currency_code%TYPE;
812: --
813: cursor csel1 is
814: select pr.rate_uom
813: cursor csel1 is
814: select pr.rate_uom
815: , pbg.currency_code
816: from per_business_groups pbg
817: , pay_rates pr
818: where pr.rate_id = p_rate_id
819: and pbg.business_group_id = pr.business_group_id;
820: --
821: begin
1110: l_api_updating boolean;
1111: l_value pay_grade_rules_f.value%TYPE;
1112: l_dummy_return_value pay_grade_rules_f.value%TYPE;
1113: l_min_max_status varchar2(30);
1114: l_uom pay_rates.rate_uom%TYPE;
1115: l_currency_code per_business_groups.currency_code%TYPE;
1116: --
1117: cursor csel1 is
1118: select pr.rate_uom
1117: cursor csel1 is
1118: select pr.rate_uom
1119: , pbg.currency_code
1120: from per_business_groups pbg
1121: , pay_rates pr
1122: where pr.rate_id = p_rate_id
1123: and pbg.business_group_id = pr.business_group_id;
1124: --
1125: begin