APPS.PAY_CNU_BUS1 dependencies on PAY_FR_CONTRIBUTION_USAGES

Line 13: p_element_name in pay_fr_contribution_usages.element_name%TYPE

9: -- ----------------------------------------------------------------------------
10: -- |---------------------------< chk_element_name >----------------------------|
11: -- ----------------------------------------------------------------------------
12: Procedure chk_element_name (
13: p_element_name in pay_fr_contribution_usages.element_name%TYPE
14: ) Is
15: --
16: l_proc varchar2(72) := g_package|| ' chk_element_name';
17: --

Line 35: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

31: -- |---------------------------< chk_contribution_usage_type >----------------|
32: -- ----------------------------------------------------------------------------
33: Procedure chk_contribution_usage_type (
34: p_effective_date in date
35: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
36: ) Is
37: --
38: l_proc varchar2(72) := g_package|| ' chk_contribution_usage_type';
39: --

Line 72: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

68: -- |---------------------------< chk_rate_type >-------------------------------|
69: -- ----------------------------------------------------------------------------
70: Procedure chk_rate_type (
71: p_effective_date in date
72: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
73: ) Is
74: --
75: l_proc varchar2(72) := g_package|| ' chk_rate_type';
76: --

Line 106: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

102: -- |---------------------------< chk_process_type >-----------------------------|
103: -- ----------------------------------------------------------------------------
104: Procedure chk_process_type (
105: p_effective_date in date
106: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
107: ) Is
108: --
109: l_proc varchar2(72) := g_package|| ' chk_process_type';
110: --

Line 143: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE

139: -- |---------------------------< chk_lu_group_code >--------------------------|
140: -- ----------------------------------------------------------------------------
141: Procedure chk_lu_group_code (
142: p_effective_date in date
143: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
144: ) Is
145: --
146: l_proc varchar2(72) := g_package|| ' chk_lu_group_code';
147: --

Line 187: p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

183: -- ----------------------------------------------------------------------------
184: -- |---------------------------< chk_business_group_id >----------------------|
185: -- ----------------------------------------------------------------------------
186: Procedure chk_business_group_id (
187: p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
188: ) Is
189: --
190: l_proc varchar2(72) := g_package|| ' chk_business_group_id';
191: l_leg_code varchar2(30);

Line 227: p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

223: -- ----------------------------------------------------------------------------
224: -- |---------------------------< chk_rate_category_type >---------------------|
225: -- ----------------------------------------------------------------------------
226: Procedure chk_rate_category_type (
227: p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
228: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
229: ) Is
230: --
231: l_proc varchar2(72) := g_package|| ' chk_rate_category_type';

Line 228: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

224: -- |---------------------------< chk_rate_category_type >---------------------|
225: -- ----------------------------------------------------------------------------
226: Procedure chk_rate_category_type (
227: p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
228: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
229: ) Is
230: --
231: l_proc varchar2(72) := g_package|| ' chk_rate_category_type';
232: --

Line 302: p_code in pay_fr_contribution_usages.contribution_code%TYPE

298: -- ----------------------------------------------------------------------------
299: -- |---------------------------< chk_validate_code >--------------------------|
300: -- ----------------------------------------------------------------------------
301: Procedure chk_validate_code (
302: p_code in pay_fr_contribution_usages.contribution_code%TYPE
303: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
304: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
305: ) Is
306: --

Line 303: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

299: -- |---------------------------< chk_validate_code >--------------------------|
300: -- ----------------------------------------------------------------------------
301: Procedure chk_validate_code (
302: p_code in pay_fr_contribution_usages.contribution_code%TYPE
303: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
304: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
305: ) Is
306: --
307: l_proc varchar2(72) := g_package|| ' chk_validate_code';

Line 304: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

300: -- ----------------------------------------------------------------------------
301: Procedure chk_validate_code (
302: p_code in pay_fr_contribution_usages.contribution_code%TYPE
303: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
304: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
305: ) Is
306: --
307: l_proc varchar2(72) := g_package|| ' chk_validate_code';
308: l_exists varchar2(1);

Line 395: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE

391: -- ----------------------------------------------------------------------------
392: -- |---------------------------< chk_contribution_codes >---------------------|
393: -- ----------------------------------------------------------------------------
394: Procedure chk_contribution_codes (
395: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
396: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
397: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
398: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
399: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE

Line 396: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE

392: -- |---------------------------< chk_contribution_codes >---------------------|
393: -- ----------------------------------------------------------------------------
394: Procedure chk_contribution_codes (
395: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
396: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
397: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
398: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
399: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
400: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

Line 397: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

393: -- ----------------------------------------------------------------------------
394: Procedure chk_contribution_codes (
395: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
396: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
397: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
398: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
399: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
400: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
401: ) Is

Line 398: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE

394: Procedure chk_contribution_codes (
395: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
396: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
397: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
398: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
399: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
400: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
401: ) Is
402: --

Line 399: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE

395: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
396: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
397: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
398: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
399: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
400: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
401: ) Is
402: --
403: l_proc varchar2(72) := g_package|| ' chk_contribution_codes';

Line 400: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

396: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
397: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
398: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
399: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
400: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
401: ) Is
402: --
403: l_proc varchar2(72) := g_package|| ' chk_contribution_codes';
404: l_exists varchar2(1);

Line 470: p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

466: -- ----------------------------------------------------------------------------
467: -- |---------------------------< chk_contribution_type >----------------------|
468: -- ----------------------------------------------------------------------------
469: Procedure chk_contribution_type (
470: p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
471: ) Is
472: --
473: l_proc varchar2(72) := g_package|| ' chk_contribution_type';
474: --

Line 503: p_group_code in pay_fr_contribution_usages.group_code%TYPE

499: -- ----------------------------------------------------------------------------
500: -- |---------------------------< chk_group_code >------------------------------|
501: -- ----------------------------------------------------------------------------
502: Procedure chk_group_code (
503: p_group_code in pay_fr_contribution_usages.group_code%TYPE
504: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
505: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
506: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
507: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

Line 504: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

500: -- |---------------------------< chk_group_code >------------------------------|
501: -- ----------------------------------------------------------------------------
502: Procedure chk_group_code (
503: p_group_code in pay_fr_contribution_usages.group_code%TYPE
504: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
505: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
506: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
507: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
508: ) Is

Line 505: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE

501: -- ----------------------------------------------------------------------------
502: Procedure chk_group_code (
503: p_group_code in pay_fr_contribution_usages.group_code%TYPE
504: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
505: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
506: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
507: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
508: ) Is
509: --

Line 506: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

502: Procedure chk_group_code (
503: p_group_code in pay_fr_contribution_usages.group_code%TYPE
504: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
505: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
506: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
507: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
508: ) Is
509: --
510: l_proc varchar2(72) := g_package|| ' chk_group_code';

Line 507: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

503: p_group_code in pay_fr_contribution_usages.group_code%TYPE
504: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
505: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
506: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
507: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
508: ) Is
509: --
510: l_proc varchar2(72) := g_package|| ' chk_group_code';
511: l_cu_id number;

Line 524: from pay_fr_contribution_usages cnu

520: -- is not required during update_validate.
521: --
522: cursor csr_unique is
523: select cnu.contribution_usage_id
524: from pay_fr_contribution_usages cnu
525: where cnu.group_code <> p_group_code
526: and cnu.process_type = p_process_type
527: and cnu.element_name = p_element_name
528: and cnu.contribution_usage_type = p_contribution_usage_type

Line 591: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE

587: -- ----------------------------------------------------------------------------
588: -- |---------------------------< chk_dates >----------------------------------|
589: -- ----------------------------------------------------------------------------
590: Procedure chk_dates (
591: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
592: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
593: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE

Line 592: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE

588: -- |---------------------------< chk_dates >----------------------------------|
589: -- ----------------------------------------------------------------------------
590: Procedure chk_dates (
591: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
592: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
593: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

Line 593: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE

589: -- ----------------------------------------------------------------------------
590: Procedure chk_dates (
591: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
592: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
593: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
597: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE

Line 594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE

590: Procedure chk_dates (
591: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
592: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
593: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
597: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
598: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

Line 595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE

591: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
592: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
593: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
597: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
598: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
599: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

Line 596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

592: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
593: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
597: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
598: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
599: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
600: ) Is

Line 597: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE

593: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
597: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
598: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
599: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
600: ) Is
601: --

Line 598: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

594: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
597: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
598: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
599: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
600: ) Is
601: --
602: l_proc varchar2(72) := g_package|| ' chk_dates';

Line 599: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

595: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
596: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
597: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
598: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
599: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
600: ) Is
601: --
602: l_proc varchar2(72) := g_package|| ' chk_dates';
603: l_exists varchar2(1);

Line 621: from pay_fr_contribution_usages cnu

617: -- Only test if new insert, or date_to is changing.
618: --
619: cursor csr_unique is
620: select cnu.contribution_usage_id
621: from pay_fr_contribution_usages cnu
622: where cnu.group_code = p_group_code
623: and cnu.process_type = p_process_type
624: and cnu.element_name = p_element_name
625: and cnu.contribution_usage_type = p_contribution_usage_type

Line 730: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE

726: -- ----------------------------------------------------------------------------
727: Procedure load_row (
728: p_date_from in varchar2
729: ,p_date_to in varchar2
730: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
731: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
732: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

Line 731: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

727: Procedure load_row (
728: p_date_from in varchar2
729: ,p_date_to in varchar2
730: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
731: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
732: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

Line 732: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE

728: p_date_from in varchar2
729: ,p_date_to in varchar2
730: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
731: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
732: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE

Line 733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

729: ,p_date_to in varchar2
730: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
731: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
732: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
737: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

Line 734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

730: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
731: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
732: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
737: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
738: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE

Line 735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

731: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
732: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
737: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
738: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
739: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE

Line 736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE

732: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
737: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
738: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
739: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE
740: ) is

Line 737: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

733: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
737: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
738: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
739: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE
740: ) is
741: --

Line 738: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE

734: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
737: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
738: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
739: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE
740: ) is
741: --
742: l_existing_cu_id number;

Line 739: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE

735: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
736: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
737: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
738: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
739: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE
740: ) is
741: --
742: l_existing_cu_id number;
743: l_existing_ovn_id number;

Line 752: from pay_fr_contribution_usages cnu

748: l_new_date_to date := to_date(p_date_to, 'DD/MM/YYYY');
749: --
750: cursor csr_existing is
751: select cnu.contribution_usage_id, cnu.object_version_number
752: from pay_fr_contribution_usages cnu
753: where cnu.group_code = p_group_code
754: and cnu.process_type = p_process_type
755: and cnu.element_name = p_element_name
756: and cnu.date_from = l_new_date_from

Line 810: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE

806: -- ----------------------------------------------------------------------------
807: -- |---------------------------< chk_code_rate_id >----------------------------|
808: -- ----------------------------------------------------------------------------
809: Procedure chk_code_rate_id (
810: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
811: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
812: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
813: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
814: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

Line 811: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE

807: -- |---------------------------< chk_code_rate_id >----------------------------|
808: -- ----------------------------------------------------------------------------
809: Procedure chk_code_rate_id (
810: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
811: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
812: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
813: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
814: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
815: ) Is

Line 812: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

808: -- ----------------------------------------------------------------------------
809: Procedure chk_code_rate_id (
810: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
811: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
812: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
813: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
814: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
815: ) Is
816: --

Line 813: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

809: Procedure chk_code_rate_id (
810: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
811: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
812: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
813: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
814: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
815: ) Is
816: --
817: l_proc varchar2(72) := g_package|| ' chk_code_rate_id';

Line 814: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

810: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
811: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
812: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
813: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
814: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
815: ) Is
816: --
817: l_proc varchar2(72) := g_package|| ' chk_code_rate_id';
818: l_exists varchar2(1);

Line 831: from pay_fr_contribution_usages cnu

827: -- is not required during update_validate.
828: --
829: cursor csr_chk_unique is
830: select null
831: from pay_fr_contribution_usages cnu
832: where cnu.contribution_code = p_contribution_code
833: and cnu.rate_type = p_rate_type
834: and cnu.code_rate_id <> p_code_rate_id
835: and nvl(cnu.business_group_id,0) = nvl(p_business_group_id,0)

Line 838: from pay_fr_contribution_usages cnu

834: and cnu.code_rate_id <> p_code_rate_id
835: and nvl(cnu.business_group_id,0) = nvl(p_business_group_id,0)
836: UNION
837: select null
838: from pay_fr_contribution_usages cnu
839: where cnu.code_rate_id = p_code_rate_id
840: and nvl(cnu.business_group_id,0) = nvl(p_business_group_id,0)
841: and cnu.contribution_code = p_contribution_code
842: and cnu.rate_type <> p_rate_type;

Line 846: from pay_fr_contribution_usages cnu

842: and cnu.rate_type <> p_rate_type;
843:
844: cursor csr_get_code_rate is
845: select code_rate_id
846: from pay_fr_contribution_usages cnu
847: where cnu.contribution_code = p_contribution_code
848: and cnu.rate_type = p_rate_type
849: and cnu.business_group_id = p_business_group_id;
850:

Line 853: from pay_fr_contribution_usages cnu

849: and cnu.business_group_id = p_business_group_id;
850:
851: cursor csr_new_code_rate is
852: select nvl(max(code_rate_id),29) +1
853: from pay_fr_contribution_usages cnu
854: where cnu.contribution_code = p_contribution_code
855: and cnu.business_group_id = p_business_group_id;
856:
857: --