eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CLE_BUS dependencies on HR_DE_SOC_INS_CONTR_LVLS_F

Line 29: , hr_de_soc_ins_contr_lvls_f cle

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , hr_de_soc_ins_contr_lvls_f cle
30: , hr_organization_units hou
31: where cle.soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
32: and pbg.business_group_id = hou.business_group_id
33: and hou.organization_id = cle.organization_id;

Line 94: , hr_de_soc_ins_contr_lvls_f cle

90:
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , hr_de_soc_ins_contr_lvls_f cle
95: , hr_organization_units hou
96: where cle.soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
97: and cle.organization_id = hou.organization_id
98: and pbg.business_group_id = hou.business_group_id;

Line 437: ,p_organization_id in hr_de_soc_ins_contr_lvls_f.organization_id%type

433: Procedure chk_organization_id
434: (p_effective_date in date
435: ,p_validation_start_date in date
436: ,p_validation_end_date in date
437: ,p_organization_id in hr_de_soc_ins_contr_lvls_f.organization_id%type
438: ,p_soc_ins_contr_lvls_id in hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type
439:
440: ) IS
441:

Line 438: ,p_soc_ins_contr_lvls_id in hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type

434: (p_effective_date in date
435: ,p_validation_start_date in date
436: ,p_validation_end_date in date
437: ,p_organization_id in hr_de_soc_ins_contr_lvls_f.organization_id%type
438: ,p_soc_ins_contr_lvls_id in hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type
439:
440: ) IS
441:
442: CURSOR csr_chk_organization_id1 IS

Line 456: FROM hr_DE_SOC_INS_CONTR_LVLS_F hsi

452: and p_validation_end_date between hou.date_from and nvl(hou.date_to,p_validation_end_date);
453:
454: CURSOR csr_chk_organization_id3 IS
455: SELECT 'Y'
456: FROM hr_DE_SOC_INS_CONTR_LVLS_F hsi
457: WHERE hsi.organization_id = p_organization_id
458: and p_validation_end_date between hsi.effective_start_date and nvl(hsi.effective_end_date,p_validation_end_date);
459:
460: CURSOR csr_chk_organization_id4 IS

Line 462: FROM hr_DE_SOC_INS_CONTR_LVLS_F hsi

458: and p_validation_end_date between hsi.effective_start_date and nvl(hsi.effective_end_date,p_validation_end_date);
459:
460: CURSOR csr_chk_organization_id4 IS
461: SELECT 'Y'
462: FROM hr_DE_SOC_INS_CONTR_LVLS_F hsi
463: WHERE hsi.organization_id = p_organization_id
464: and p_validation_start_date between hsi.effective_start_date and nvl(hsi.effective_end_date,p_validation_end_date);
465:
466: CURSOR csr_chk_org_class IS

Line 605: ( p_normal_amount IN hr_de_soc_ins_contr_lvls_f.normal_amount%type

601: --
602: -- ---------------------------------------------------------------------------
603: --
604: PROCEDURE chk_normal_amount
605: ( p_normal_amount IN hr_de_soc_ins_contr_lvls_f.normal_amount%type
606: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
607:
608: --
609: l_proc VARCHAR2(72) := g_package || 'chk_normal_amount';

Line 606: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

602: -- ---------------------------------------------------------------------------
603: --
604: PROCEDURE chk_normal_amount
605: ( p_normal_amount IN hr_de_soc_ins_contr_lvls_f.normal_amount%type
606: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
607:
608: --
609: l_proc VARCHAR2(72) := g_package || 'chk_normal_amount';
610: l_dummy VARCHAR2(1);

Line 679: ( p_increased_amount IN hr_de_soc_ins_contr_lvls_f.increased_amount%type

675: --
676: -- ---------------------------------------------------------------------------
677: --
678: PROCEDURE chk_increased_amount
679: ( p_increased_amount IN hr_de_soc_ins_contr_lvls_f.increased_amount%type
680: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
681:
682: --
683: l_proc VARCHAR2(72) := g_package || 'chk_increased_amount';

Line 680: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

676: -- ---------------------------------------------------------------------------
677: --
678: PROCEDURE chk_increased_amount
679: ( p_increased_amount IN hr_de_soc_ins_contr_lvls_f.increased_amount%type
680: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
681:
682: --
683: l_proc VARCHAR2(72) := g_package || 'chk_increased_amount';
684: l_dummy VARCHAR2(1);

Line 752: ( p_reduced_amount IN hr_de_soc_ins_contr_lvls_f.reduced_amount%type

748: --
749: -- ---------------------------------------------------------------------------
750: --
751: PROCEDURE chk_reduced_amount
752: ( p_reduced_amount IN hr_de_soc_ins_contr_lvls_f.reduced_amount%type
753: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
754:
755: --
756: l_proc VARCHAR2(72) := g_package || 'chk_reduced_amount';

Line 753: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

749: -- ---------------------------------------------------------------------------
750: --
751: PROCEDURE chk_reduced_amount
752: ( p_reduced_amount IN hr_de_soc_ins_contr_lvls_f.reduced_amount%type
753: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
754:
755: --
756: l_proc VARCHAR2(72) := g_package || 'chk_reduced_amount';
757: l_dummy VARCHAR2(1);

Line 825: ( p_normal_percentage IN hr_de_soc_ins_contr_lvls_f.normal_percentage%type

821: --
822: -- ---------------------------------------------------------------------------
823: --
824: PROCEDURE chk_normal_percentage
825: ( p_normal_percentage IN hr_de_soc_ins_contr_lvls_f.normal_percentage%type
826: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
827:
828: --
829: l_proc VARCHAR2(72) := g_package || 'chk_normal_percentage';

Line 826: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

822: -- ---------------------------------------------------------------------------
823: --
824: PROCEDURE chk_normal_percentage
825: ( p_normal_percentage IN hr_de_soc_ins_contr_lvls_f.normal_percentage%type
826: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
827:
828: --
829: l_proc VARCHAR2(72) := g_package || 'chk_normal_percentage';
830: l_dummy VARCHAR2(1);

Line 897: ( p_increased_percentage IN hr_de_soc_ins_contr_lvls_f.increased_percentage%type

893: --
894: -- ---------------------------------------------------------------------------
895: --
896: PROCEDURE chk_increased_percentage
897: ( p_increased_percentage IN hr_de_soc_ins_contr_lvls_f.increased_percentage%type
898: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
899:
900: --
901: l_proc VARCHAR2(72) := g_package || 'chk_increased_percentage';

Line 898: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

894: -- ---------------------------------------------------------------------------
895: --
896: PROCEDURE chk_increased_percentage
897: ( p_increased_percentage IN hr_de_soc_ins_contr_lvls_f.increased_percentage%type
898: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
899:
900: --
901: l_proc VARCHAR2(72) := g_package || 'chk_increased_percentage';
902: l_dummy VARCHAR2(1);

Line 968: ( p_reduced_percentage IN hr_de_soc_ins_contr_lvls_f.reduced_percentage%type

964: --
965: -- ---------------------------------------------------------------------------
966: --
967: PROCEDURE chk_reduced_percentage
968: ( p_reduced_percentage IN hr_de_soc_ins_contr_lvls_f.reduced_percentage%type
969: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
970:
971: --
972: l_proc VARCHAR2(72) := g_package || 'chk_reduced_percentage';

Line 969: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

965: -- ---------------------------------------------------------------------------
966: --
967: PROCEDURE chk_reduced_percentage
968: ( p_reduced_percentage IN hr_de_soc_ins_contr_lvls_f.reduced_percentage%type
969: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
970:
971: --
972: l_proc VARCHAR2(72) := g_package || 'chk_reduced_percentage';
973: l_dummy VARCHAR2(1);

Line 1038: ( p_normal_percentage IN hr_de_soc_ins_contr_lvls_f.normal_percentage%type

1034: --
1035: -- ---------------------------------------------------------------------------
1036: --
1037: PROCEDURE chk_normal_percent_null
1038: ( p_normal_percentage IN hr_de_soc_ins_contr_lvls_f.normal_percentage%type
1039: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1040:
1041: --
1042: l_proc VARCHAR2(72) := g_package || 'chk_normal_percent_null';

Line 1039: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1035: -- ---------------------------------------------------------------------------
1036: --
1037: PROCEDURE chk_normal_percent_null
1038: ( p_normal_percentage IN hr_de_soc_ins_contr_lvls_f.normal_percentage%type
1039: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1040:
1041: --
1042: l_proc VARCHAR2(72) := g_package || 'chk_normal_percent_null';
1043: l_dummy VARCHAR2(1);

Line 1112: ( p_increased_percentage IN hr_de_soc_ins_contr_lvls_f.increased_percentage%type

1108: --
1109: -- ---------------------------------------------------------------------------
1110: --
1111: PROCEDURE chk_increased_percent_null
1112: ( p_increased_percentage IN hr_de_soc_ins_contr_lvls_f.increased_percentage%type
1113: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1114:
1115: --
1116: l_proc VARCHAR2(72) := g_package || 'chk_increased_percent_null';

Line 1113: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1109: -- ---------------------------------------------------------------------------
1110: --
1111: PROCEDURE chk_increased_percent_null
1112: ( p_increased_percentage IN hr_de_soc_ins_contr_lvls_f.increased_percentage%type
1113: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1114:
1115: --
1116: l_proc VARCHAR2(72) := g_package || 'chk_increased_percent_null';
1117: l_dummy VARCHAR2(1);

Line 1184: ( p_reduced_percentage IN hr_de_soc_ins_contr_lvls_f.reduced_percentage%type

1180: --
1181: -- ---------------------------------------------------------------------------
1182: --
1183: PROCEDURE chk_reduced_percent_null
1184: ( p_reduced_percentage IN hr_de_soc_ins_contr_lvls_f.reduced_percentage%type
1185: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1186:
1187: --
1188: l_proc VARCHAR2(72) := g_package || 'chk_reduced_percent_null';

Line 1185: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1181: -- ---------------------------------------------------------------------------
1182: --
1183: PROCEDURE chk_reduced_percent_null
1184: ( p_reduced_percentage IN hr_de_soc_ins_contr_lvls_f.reduced_percentage%type
1185: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1186:
1187: --
1188: l_proc VARCHAR2(72) := g_package || 'chk_reduced_percent_null';
1189: l_dummy VARCHAR2(1);

Line 1254: ( p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type

1250: --
1251: -- ---------------------------------------------------------------------------
1252: --
1253: PROCEDURE chk_max_inc_contr_null
1254: ( p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
1255: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1256:
1257: --
1258: l_proc VARCHAR2(72) := g_package || 'chk_max_inc_contr_null';

Line 1255: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1251: -- ---------------------------------------------------------------------------
1252: --
1253: PROCEDURE chk_max_inc_contr_null
1254: ( p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
1255: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1256:
1257: --
1258: l_proc VARCHAR2(72) := g_package || 'chk_max_inc_contr_null';
1259: l_dummy VARCHAR2(1);

Line 1334: ( p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type

1330: --
1331: -- ---------------------------------------------------------------------------
1332: --
1333: PROCEDURE chk_min_inc_contr_null
1334: ( p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
1335: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1336:
1337: --
1338: l_proc VARCHAR2(72) := g_package || 'chk_min_inc_contr_null';

Line 1335: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1331: -- ---------------------------------------------------------------------------
1332: --
1333: PROCEDURE chk_min_inc_contr_null
1334: ( p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
1335: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1336:
1337: --
1338: l_proc VARCHAR2(72) := g_package || 'chk_min_inc_contr_null';
1339: l_dummy VARCHAR2(1);

Line 1415: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type

1411: --
1412: -- ---------------------------------------------------------------------------
1413: --
1414: PROCEDURE chk_month1_min_contr_null
1415: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type
1416: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1417:
1418: --
1419: l_proc VARCHAR2(72) := g_package || 'chk_month1_min_contr_null';

Line 1416: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1412: -- ---------------------------------------------------------------------------
1413: --
1414: PROCEDURE chk_month1_min_contr_null
1415: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type
1416: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1417:
1418: --
1419: l_proc VARCHAR2(72) := g_package || 'chk_month1_min_contr_null';
1420: l_dummy VARCHAR2(1);

Line 1495: ( p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type

1491: --
1492: -- ---------------------------------------------------------------------------
1493: --
1494: PROCEDURE chk_month1_max_contr_null
1495: ( p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type
1496: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1497:
1498: --
1499: l_proc VARCHAR2(72) := g_package || 'chk_month1_max_contr_null';

Line 1496: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1492: -- ---------------------------------------------------------------------------
1493: --
1494: PROCEDURE chk_month1_max_contr_null
1495: ( p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type
1496: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1497:
1498: --
1499: l_proc VARCHAR2(72) := g_package || 'chk_month1_max_contr_null';
1500: l_dummy VARCHAR2(1);

Line 1576: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type

1572: --
1573: -- ---------------------------------------------------------------------------
1574: --
1575: PROCEDURE chk_month2_min_contr_null
1576: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type
1577: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1578:
1579: --
1580: l_proc VARCHAR2(72) := g_package || 'chk_month2_min_contr_null';

Line 1577: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1573: -- ---------------------------------------------------------------------------
1574: --
1575: PROCEDURE chk_month2_min_contr_null
1576: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type
1577: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1578:
1579: --
1580: l_proc VARCHAR2(72) := g_package || 'chk_month2_min_contr_null';
1581: l_dummy VARCHAR2(1);

Line 1656: ( p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type

1652: --
1653: -- ---------------------------------------------------------------------------
1654: --
1655: PROCEDURE chk_month2_max_contr_null
1656: ( p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type
1657: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1658:
1659: --
1660: l_proc VARCHAR2(72) := g_package || 'chk_month2_max_contr_null';

Line 1657: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1653: -- ---------------------------------------------------------------------------
1654: --
1655: PROCEDURE chk_month2_max_contr_null
1656: ( p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type
1657: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1658:
1659: --
1660: l_proc VARCHAR2(72) := g_package || 'chk_month2_max_contr_null';
1661: l_dummy VARCHAR2(1);

Line 1736: ( p_employee_contribution IN hr_de_soc_ins_contr_lvls_f.employee_contribution%type

1732: --
1733: -- ---------------------------------------------------------------------------
1734: --
1735: PROCEDURE chk_employee_contribution
1736: ( p_employee_contribution IN hr_de_soc_ins_contr_lvls_f.employee_contribution%type
1737: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1738:
1739: --
1740: l_proc VARCHAR2(72) := g_package || 'chk_employee_contribution';

Line 1737: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1733: -- ---------------------------------------------------------------------------
1734: --
1735: PROCEDURE chk_employee_contribution
1736: ( p_employee_contribution IN hr_de_soc_ins_contr_lvls_f.employee_contribution%type
1737: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1738:
1739: --
1740: l_proc VARCHAR2(72) := g_package || 'chk_employee_contribution';
1741: l_dummy VARCHAR2(1);

Line 1806: ( p_month1 IN hr_de_soc_ins_contr_lvls_f.month1%type

1802: --
1803: -- ---------------------------------------------------------------------------
1804: --
1805: PROCEDURE chk_month1
1806: ( p_month1 IN hr_de_soc_ins_contr_lvls_f.month1%type
1807: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1808:
1809: --
1810: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month1%type) IS

Line 1807: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1803: -- ---------------------------------------------------------------------------
1804: --
1805: PROCEDURE chk_month1
1806: ( p_month1 IN hr_de_soc_ins_contr_lvls_f.month1%type
1807: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1808:
1809: --
1810: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month1%type) IS
1811: Select 1 From(

Line 1810: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month1%type) IS

1806: ( p_month1 IN hr_de_soc_ins_contr_lvls_f.month1%type
1807: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1808:
1809: --
1810: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month1%type) IS
1811: Select 1 From(
1812: select lookup_code code
1813: from hr_lookups
1814: where lookup_type LIKE 'MONTH_CODE')

Line 1893: ( p_month2 IN hr_de_soc_ins_contr_lvls_f.month2%type

1889: --
1890: -- ---------------------------------------------------------------------------
1891: --
1892: PROCEDURE chk_month2
1893: ( p_month2 IN hr_de_soc_ins_contr_lvls_f.month2%type
1894: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1895:
1896: --
1897: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month2%type) IS

Line 1894: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1890: -- ---------------------------------------------------------------------------
1891: --
1892: PROCEDURE chk_month2
1893: ( p_month2 IN hr_de_soc_ins_contr_lvls_f.month2%type
1894: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1895:
1896: --
1897: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month2%type) IS
1898: Select 1 From(

Line 1897: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month2%type) IS

1893: ( p_month2 IN hr_de_soc_ins_contr_lvls_f.month2%type
1894: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1895:
1896: --
1897: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month2%type) IS
1898: Select 1 From(
1899: select lookup_code code
1900: from hr_lookups
1901: where lookup_type LIKE 'MONTH_CODE')

Line 1978: ( p_flat_tax_limit_per_month IN hr_de_soc_ins_contr_lvls_f.flat_tax_limit_per_month%type

1974: --
1975: -- ---------------------------------------------------------------------------
1976: --
1977: PROCEDURE chk_flat_tax_month_val
1978: ( p_flat_tax_limit_per_month IN hr_de_soc_ins_contr_lvls_f.flat_tax_limit_per_month%type
1979: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1980:
1981: --
1982: l_proc VARCHAR2(72) := g_package || 'chk_flat_tax_month_val';

Line 1979: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

1975: -- ---------------------------------------------------------------------------
1976: --
1977: PROCEDURE chk_flat_tax_month_val
1978: ( p_flat_tax_limit_per_month IN hr_de_soc_ins_contr_lvls_f.flat_tax_limit_per_month%type
1979: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
1980:
1981: --
1982: l_proc VARCHAR2(72) := g_package || 'chk_flat_tax_month_val';
1983: l_dummy VARCHAR2(1);

Line 2050: ( p_flat_tax_limit_per_year IN hr_de_soc_ins_contr_lvls_f.flat_tax_limit_per_year%type

2046: --
2047: -- ---------------------------------------------------------------------------
2048: --
2049: PROCEDURE chk_flat_tax_year_val
2050: ( p_flat_tax_limit_per_year IN hr_de_soc_ins_contr_lvls_f.flat_tax_limit_per_year%type
2051: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2052:
2053: --
2054: l_proc VARCHAR2(72) := g_package || 'chk_flat_tax_year_val';

Line 2051: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

2047: -- ---------------------------------------------------------------------------
2048: --
2049: PROCEDURE chk_flat_tax_year_val
2050: ( p_flat_tax_limit_per_year IN hr_de_soc_ins_contr_lvls_f.flat_tax_limit_per_year%type
2051: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2052:
2053: --
2054: l_proc VARCHAR2(72) := g_package || 'chk_flat_tax_year_val';
2055: l_dummy VARCHAR2(1);

Line 2124: ( p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type

2120: --
2121: -- ---------------------------------------------------------------------------
2122: --
2123: PROCEDURE chk_min_max_inc_contr
2124: ( p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2125: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2126: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2127:
2128: --

Line 2125: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type

2121: -- ---------------------------------------------------------------------------
2122: --
2123: PROCEDURE chk_min_max_inc_contr
2124: ( p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2125: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2126: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2127:
2128: --
2129: l_proc VARCHAR2(72) := g_package || 'chk_min_max_inc_contr';

Line 2126: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

2122: --
2123: PROCEDURE chk_min_max_inc_contr
2124: ( p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2125: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2126: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2127:
2128: --
2129: l_proc VARCHAR2(72) := g_package || 'chk_min_max_inc_contr';
2130: l_dummy VARCHAR2(1);

Line 2202: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type

2198: --
2199: -- ---------------------------------------------------------------------------
2200: --
2201: PROCEDURE chk_mon1_min_max_contr
2202: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type
2203: ,p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type
2204: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2205: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2206: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

Line 2203: ,p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type

2199: -- ---------------------------------------------------------------------------
2200: --
2201: PROCEDURE chk_mon1_min_max_contr
2202: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type
2203: ,p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type
2204: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2205: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2206: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2207:

Line 2204: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type

2200: --
2201: PROCEDURE chk_mon1_min_max_contr
2202: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type
2203: ,p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type
2204: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2205: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2206: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2207:
2208: --

Line 2205: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type

2201: PROCEDURE chk_mon1_min_max_contr
2202: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type
2203: ,p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type
2204: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2205: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2206: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2207:
2208: --
2209: l_proc VARCHAR2(72) := g_package || 'chk_mon1_min_max_contr';

Line 2206: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

2202: ( p_month1_min_contribution IN hr_de_soc_ins_contr_lvls_f.month1_min_contribution%type
2203: ,p_month1_max_contribution IN hr_de_soc_ins_contr_lvls_f.month1_max_contribution%type
2204: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2205: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2206: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2207:
2208: --
2209: l_proc VARCHAR2(72) := g_package || 'chk_mon1_min_max_contr';
2210: l_dummy VARCHAR2(1);

Line 2296: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type

2292: --
2293: -- ---------------------------------------------------------------------------
2294: --
2295: PROCEDURE chk_mon2_min_max_contr
2296: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type
2297: ,p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type
2298: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2299: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2300: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

Line 2297: ,p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type

2293: -- ---------------------------------------------------------------------------
2294: --
2295: PROCEDURE chk_mon2_min_max_contr
2296: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type
2297: ,p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type
2298: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2299: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2300: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2301:

Line 2298: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type

2294: --
2295: PROCEDURE chk_mon2_min_max_contr
2296: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type
2297: ,p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type
2298: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2299: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2300: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2301:
2302: --

Line 2299: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type

2295: PROCEDURE chk_mon2_min_max_contr
2296: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type
2297: ,p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type
2298: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2299: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2300: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2301:
2302: --
2303: l_proc VARCHAR2(72) := g_package || 'chk_mon2_min_max_contr';

Line 2300: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS

2296: ( p_month2_min_contribution IN hr_de_soc_ins_contr_lvls_f.month2_min_contribution%type
2297: ,p_month2_max_contribution IN hr_de_soc_ins_contr_lvls_f.month2_max_contribution%type
2298: ,p_min_increased_contribution IN hr_de_soc_ins_contr_lvls_f.min_increased_contribution%type
2299: ,p_max_increased_contribution IN hr_de_soc_ins_contr_lvls_f.max_increased_contribution%type
2300: ,p_soc_ins_contr_lvls_id IN hr_de_soc_ins_contr_lvls_f.soc_ins_contr_lvls_id%type) IS
2301:
2302: --
2303: l_proc VARCHAR2(72) := g_package || 'chk_mon2_min_max_contr';
2304: l_dummy VARCHAR2(1);

Line 2387: p_object_version_number in hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE

2383: --
2384: -- ---------------------------------------------------------------------------
2385: procedure chk_object_version_number
2386: (
2387: p_object_version_number in hr_de_soc_ins_contr_lvls_f.object_version_number%TYPE
2388: ) is
2389: --
2390: l_proc varchar2(72) := g_package||'chk_object_version_number';
2391: --