[Home] [Help]
1: PACKAGE BODY pqp_gb_osp_functions AS
2: /* $Header: pqpospfn.pkb 120.23.12010000.7 2008/08/25 06:54:05 bachakra ship $ */
3: --
4: g_package_name VARCHAR2(31) := 'pqp_gb_osp_functions.';
5: g_debug BOOLEAN:= hr_utility.debug_enabled;
1: PACKAGE BODY pqp_gb_osp_functions AS
2: /* $Header: pqpospfn.pkb 120.23.12010000.7 2008/08/25 06:54:05 bachakra ship $ */
3: --
4: g_package_name VARCHAR2(31) := 'pqp_gb_osp_functions.';
5: g_debug BOOLEAN:= hr_utility.debug_enabled;
6:
7:
8: g_udt_name VARCHAR2(80):=
529: END IF;
530: --
531: debug(l_proc_name, 10);
532: l_medical_id :=
533: pqp_gb_osp_functions.pqp_get_medical_id(p_absence_id => p_absence_attendance_id
534: ,p_message => p_message);
535:
536: IF p_message IS NOT NULL
537: THEN
606: --
607: debug(l_proc_name, 10);
608:
609: l_medical_id :=
610: pqp_gb_osp_functions.pqp_get_medical_id(p_absence_id => p_absence_attendance_id
611: ,p_message => p_message);
612:
613: IF p_message IS NOT NULL
614: THEN
712: END IF;
713: --
714: debug(l_proc_name, 10);
715: l_maternity_id :=
716: pqp_gb_osp_functions.pqp_get_maternity_id(p_absence_id => p_absence_attendance_id
717: ,p_message => p_message);
718:
719: IF p_message IS NOT NULL
720: THEN
790: END IF;
791: --
792: debug(l_proc_name, 10);
793: l_maternity_id :=
794: pqp_gb_osp_functions.pqp_get_maternity_id(p_absence_id => p_absence_attendance_id
795: ,p_message => p_message);
796:
797: IF p_message IS NOT NULL
798: THEN
1005: END IF;
1006:
1007: debug(l_proc_name, 10);
1008: l_retval :=
1009: pqp_gb_osp_functions.pqp_get_plan_extra_info(
1010: p_pl_id => l_pl_id
1011: ,p_information_type => p_information_type
1012: ,p_segment_name => p_segment_name
1013: ,p_value => p_value
1058: debug('p_segment_name:'||p_segment_name);
1059:
1060: END IF;
1061: l_retval :=
1062: pqp_gb_osp_functions.pqp_get_plan_extra_info(
1063: p_pl_id => p_pl_id
1064: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1065: ,p_segment_name => p_segment_name
1066: ,p_value => p_value
1118: debug('p_segment_name'||p_segment_name);
1119:
1120: END IF;
1121: l_retval :=
1122: pqp_gb_osp_functions.pqp_get_other_plan_extra_info(
1123: p_business_group_id => p_business_group_id
1124: ,p_effective_date => p_effective_date
1125: ,p_pl_name => p_pl_name
1126: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1224: debug('p_col_name'|| p_col_name);
1225:
1226: END IF;
1227: l_absence_id :=
1228: pqp_gb_osp_functions.ben_get_absence_id(
1229: p_assignment_id => p_assignment_id
1230: ,p_effective_date => p_effective_date
1231: );
1232: debug(l_proc_name, 20);
1230: ,p_effective_date => p_effective_date
1231: );
1232: debug(l_proc_name, 20);
1233: l_val :=
1234: pqp_gb_osp_functions.pqp_get_absence_attendances(
1235: p_absence_attendance_id => l_absence_id
1236: ,p_col_name => p_col_name
1237: ,p_error_code => p_error_code
1238: ,p_message => p_message
1288: debug('p_segment_name'||p_segment_name);
1289:
1290: END IF;
1291: l_absence_id :=
1292: pqp_gb_osp_functions.ben_get_absence_id(
1293: p_assignment_id => p_assignment_id
1294: ,p_effective_date => p_effective_date
1295: );
1296: debug(l_proc_name, 20);
1294: ,p_effective_date => p_effective_date
1295: );
1296: debug(l_proc_name, 20);
1297: l_val :=
1298: pqp_gb_osp_functions.pqp_get_absence_further_info(
1299: p_business_group_id => p_business_group_id
1300: ,p_effective_date => p_effective_date
1301: ,p_absence_attendance_id => l_absence_id
1302: ,p_segment_name => p_segment_name
1354: debug('p_segment_name'||p_segment_name);
1355:
1356: END IF;
1357: l_absence_id :=
1358: pqp_gb_osp_functions.ben_get_absence_id(
1359: p_assignment_id => p_assignment_id
1360: ,p_effective_date => p_effective_date
1361: );
1362: debug(l_proc_name, 20);
1360: ,p_effective_date => p_effective_date
1361: );
1362: debug(l_proc_name, 20);
1363: l_val :=
1364: pqp_gb_osp_functions.pqp_get_absence_addnl_attr(
1365: p_business_group_id => p_business_group_id
1366: ,p_effective_date => p_effective_date
1367: ,p_absence_attendance_id => l_absence_id
1368: ,p_segment_name => p_segment_name
1417: debug(p_effective_date);
1418: debug('p_col_name'||p_col_name);
1419: END IF;
1420: l_absence_id :=
1421: pqp_gb_osp_functions.ben_get_absence_id(
1422: p_assignment_id => p_assignment_id
1423: ,p_effective_date => p_effective_date
1424: );
1425: debug(l_proc_name, 20);
1423: ,p_effective_date => p_effective_date
1424: );
1425: debug(l_proc_name, 20);
1426: l_val :=
1427: pqp_gb_osp_functions.pqp_get_ssp_medicals_details(
1428: p_absence_attendance_id => l_absence_id
1429: ,p_col_name => p_col_name
1430: ,p_error_code => p_error_code
1431: ,p_message => p_message
1479: debug('p_assignment_id:'||p_assignment_id);
1480: debug('p_segment_name'||p_segment_name);
1481: END IF;
1482: l_absence_id :=
1483: pqp_gb_osp_functions.ben_get_absence_id(
1484: p_assignment_id => p_assignment_id
1485: ,p_effective_date => p_effective_date
1486: );
1487: debug(l_proc_name, 20);
1485: ,p_effective_date => p_effective_date
1486: );
1487: debug(l_proc_name, 20);
1488: l_val :=
1489: pqp_gb_osp_functions.pqp_get_ssp_medical_addnl_attr(
1490: p_business_group_id => p_business_group_id
1491: ,p_effective_date => p_effective_date
1492: ,p_absence_attendance_id => l_absence_id
1493: ,p_segment_name => p_segment_name
1541: debug(p_effective_date);
1542: debug('p_col_name'|| p_col_name);
1543: END IF;
1544: l_absence_id :=
1545: pqp_gb_osp_functions.ben_get_absence_id(
1546: p_assignment_id => p_assignment_id
1547: ,p_effective_date => p_effective_date
1548: );
1549: debug(l_proc_name, 20);
1547: ,p_effective_date => p_effective_date
1548: );
1549: debug(l_proc_name, 20);
1550: l_val :=
1551: pqp_gb_osp_functions.pqp_get_ssp_matrnty_details(
1552: p_absence_attendance_id => l_absence_id
1553: ,p_col_name => p_col_name
1554: ,p_error_code => p_error_code
1555: ,p_message => p_message
1601: debug('p_assignment_id:'||p_assignment_id);
1602: debug('p_segment_name'|| p_segment_name);
1603: END IF;
1604: l_absence_id :=
1605: pqp_gb_osp_functions.ben_get_absence_id(
1606: p_assignment_id => p_assignment_id
1607: ,p_effective_date => p_effective_date
1608: );
1609: debug(l_proc_name, 20);
1607: ,p_effective_date => p_effective_date
1608: );
1609: debug(l_proc_name, 20);
1610: l_val :=
1611: pqp_gb_osp_functions.pqp_get_ssp_matrnty_addnl_attr(
1612: p_business_group_id => p_business_group_id
1613: ,p_effective_date => p_effective_date
1614: ,p_absence_attendance_id => l_absence_id
1615: ,p_segment_name => p_segment_name
1726: debug('p_title:'|| p_title);
1727: END IF;
1728: -- Call get_lookup_code to get the Database column name.
1729: l_col_name :=
1730: pqp_gb_osp_functions.get_lookup_code(
1731: p_lookup_type => 'PQP_GET_ABSENCE_DETAILS'
1732: ,p_lookup_meaning => p_title
1733: ,p_message => p_message
1734: );
1768: IF l_col_name LIKE 'AUTH%'
1769: THEN
1770: debug(l_proc_name, 40);
1771: l_person_det :=
1772: pqp_gb_osp_functions.pqp_get_absence_attendances(
1773: p_absence_attendance_id => p_absence_attendance_id
1774: ,p_col_name => 'AUTHORISING_PERSON_ID'
1775: ,p_error_code => p_error_code
1776: ,p_message => p_message
1777: );
1778: ELSE
1779: debug(l_proc_name, 50);
1780: l_person_det :=
1781: pqp_gb_osp_functions.pqp_get_absence_attendances(
1782: p_absence_attendance_id => p_absence_attendance_id
1783: ,p_col_name => 'REPLACEMENT_PERSON_ID'
1784: ,p_error_code => p_error_code
1785: ,p_message => p_message
1822: --
1823: -- Call pqp_get_absence_details to get the value of the column.
1824: debug(l_proc_name, 80);
1825: l_val :=
1826: pqp_gb_osp_functions.pqp_get_absence_attendances(
1827: p_absence_attendance_id => p_absence_attendance_id
1828: ,p_col_name => l_col_name
1829: ,p_error_code => p_error_code
1830: ,p_message => p_message
1884: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1885: debug('p_title:'||p_title);
1886: END IF;
1887: l_absence_id :=
1888: pqp_gb_osp_functions.ben_get_absence_id(
1889: p_assignment_id => p_assignment_id
1890: ,p_effective_date => p_effective_date
1891: );
1892: debug(l_proc_name, 20);
1890: ,p_effective_date => p_effective_date
1891: );
1892: debug(l_proc_name, 20);
1893: l_val :=
1894: pqp_gb_osp_functions.get_absence_details(
1895: p_absence_attendance_id => l_absence_id
1896: ,p_title => p_title
1897: ,p_error_code => p_error_code
1898: ,p_message => p_message
1952: END IF;
1953: -- Call get_lookup_code to get the Database column name.
1954: debug(l_proc_name, 10);
1955: l_col_name :=
1956: pqp_gb_osp_functions.get_lookup_code(
1957: p_lookup_type => 'PQP_GET_ABSENCE_EVIDENCE'
1958: ,p_lookup_meaning => p_title
1959: ,p_message => p_message
1960: );
1968: --
1969: debug(l_proc_name, 20);
1970: -- Call pqp_get_absence_details to get the value of the column.
1971: l_val :=
1972: pqp_gb_osp_functions.pqp_get_ssp_medicals_details(
1973: p_absence_attendance_id => p_absence_attendance_id
1974: ,p_col_name => l_col_name
1975: ,p_error_code => p_error_code
1976: ,p_message => p_message
2025: END IF;
2026: -- Call get_lookup_code to get the Database column name.
2027: debug(l_proc_name, 10);
2028: l_col_name :=
2029: pqp_gb_osp_functions.get_lookup_code(
2030: p_lookup_type => 'PQP_GET_MATERNITY'
2031: ,p_lookup_meaning => p_title
2032: ,p_message => p_message
2033: );
2043: -- SMP Qualifying Date is Derived Based on Due_Date. First Due_Date is
2044: -- Fetched and Qualifying Date is Derived.
2045: debug(l_proc_name, 20);
2046: l_due_date :=
2047: pqp_gb_osp_functions.pqp_get_ssp_matrnty_details(
2048: p_absence_attendance_id => p_absence_attendance_id
2049: ,p_col_name => 'DUE_DATE'
2050: ,p_error_code => p_error_code
2051: ,p_message => p_message
2074: -- Derive EWC.
2075: debug(l_proc_name, 30);
2076: debug(l_proc_name, 40);
2077: l_due_date :=
2078: pqp_gb_osp_functions.pqp_get_ssp_matrnty_details(
2079: p_absence_attendance_id => p_absence_attendance_id
2080: ,p_col_name => 'DUE_DATE'
2081: ,p_error_code => p_error_code
2082: ,p_message => p_message
2102: --
2103: -- Call pqp_get_absence_details to get the value of the column.
2104: debug(l_proc_name, 50);
2105: l_val :=
2106: pqp_gb_osp_functions.pqp_get_ssp_matrnty_details(
2107: p_absence_attendance_id => p_absence_attendance_id
2108: ,p_col_name => l_col_name
2109: ,p_error_code => p_error_code
2110: ,p_message => p_message
3122: l_pl_id := fnd_number.canonical_to_number(l_pl_id_txt);
3123:
3124: --Set the global rounding factor cache if the values are not already set
3125: IF g_ft_entitl_rounding_type is null OR g_round_cache_plan_id <> l_pl_id THEN
3126: PQP_GB_OSP_FUNCTIONS.set_osp_omp_rounding_factors
3127: (p_pl_id => l_pl_id
3128: ,p_pt_entitl_rounding_type => g_pt_entitl_rounding_type
3129: ,p_pt_rounding_precision => g_pt_rounding_precision
3130: ,p_ft_entitl_rounding_type => g_ft_entitl_rounding_type
3697:
3698: -- Get the Number of Calendar Days.
3699: debug(l_proc_name, 10);
3700: l_cal_days :=
3701: pqp_gb_osp_functions.pqp_gb_get_calendar_days(p_start_date => p_abs_start_date
3702: ,p_end_date => p_abs_end_date);
3703: -- Get the Number of Holidays in the absence period.
3704: debug(l_proc_name, 20);
3705: l_hol_days :=
3702: ,p_end_date => p_abs_end_date);
3703: -- Get the Number of Holidays in the absence period.
3704: debug(l_proc_name, 20);
3705: l_hol_days :=
3706: pqp_gb_osp_functions.pqp_gb_get_no_of_holidays(
3707: p_business_group_id => p_business_group_id
3708: ,p_abs_start_date => p_abs_start_date
3709: ,p_abs_end_date => p_abs_end_date
3710: ,p_table_id => p_table_id
3768: THEN
3769: -- Get the number of days in the period .
3770: debug(l_proc_name, 10);
3771: l_count :=
3772: pqp_gb_osp_functions.pqp_gb_get_calendar_days(p_start_date => p_abs_start_date
3773: ,p_end_date => p_abs_end_date);
3774: ELSE
3775: -- when UDT is passed Get the Calendar Days minus no of holidays in the
3776: -- absence period declared in UDT.
3775: -- when UDT is passed Get the Calendar Days minus no of holidays in the
3776: -- absence period declared in UDT.
3777: debug(l_proc_name, 20);
3778: l_count :=
3779: pqp_gb_osp_functions.pqp_gb_get_cal_abs_hol_days(
3780: p_business_group_id => p_business_group_id
3781: ,p_abs_start_date => p_abs_start_date
3782: ,p_abs_end_date => p_abs_end_date
3783: ,p_holidays => p_holidays
3941: ,p_error_message => p_error_message
3942: );
3943: debug(l_proc_name, 20);
3944: l_work_holidays :=
3945: pqp_gb_osp_functions.pqp_gb_get_no_of_work_holidays(
3946: p_business_group_id => p_business_group_id
3947: ,p_work_dates => l_working_dates
3948: ,p_table_id => p_table_id
3949: ,p_column_name => p_column_name
4021: );
4022: ELSE -- If UDT is Passed
4023: debug(l_proc_name, 20);
4024: l_count :=
4025: pqp_gb_osp_functions.pqp_gb_get_work_abs_days_udt(
4026: p_assignment_id => p_assignment_id
4027: ,p_business_group_id => p_business_group_id
4028: ,p_start_date => p_start_date
4029: ,p_end_date => p_end_date
4775: debug('p_segment_name:'||p_segment_name);
4776: END IF;
4777:
4778: l_retval :=
4779: pqp_gb_osp_functions.pqp_get_plan_extra_info(
4780: p_pl_id => p_pl_id
4781: ,p_information_type => 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
4782: ,p_segment_name => p_segment_name
4783: ,p_value => p_value
4831: debug('p_pl_name:'||p_pl_name);
4832: debug('p_segment_name:'||p_segment_name);
4833: END IF;
4834: l_retval :=
4835: pqp_gb_osp_functions.pqp_get_other_plan_extra_info(
4836: p_business_group_id => p_business_group_id
4837: ,p_effective_date => p_effective_date
4838: ,p_pl_name => p_pl_name
4839: ,p_information_type => 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
4893: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
4894: debug('p_title:'||p_title);
4895: END IF;
4896: l_absence_id :=
4897: pqp_gb_osp_functions.ben_get_absence_id(
4898: p_assignment_id => p_assignment_id
4899: ,p_effective_date => p_effective_date
4900: );
4901: debug(l_proc_name, 20);
4899: ,p_effective_date => p_effective_date
4900: );
4901: debug(l_proc_name, 20);
4902: l_val :=
4903: pqp_gb_osp_functions.get_matrnty_details(
4904: p_absence_attendance_id => l_absence_id
4905: ,p_title => p_title
4906: ,p_error_code => p_error_code
4907: ,p_message => p_message
4964: debug('p_title:'||p_title);
4965:
4966: END IF;
4967: l_absence_id :=
4968: pqp_gb_osp_functions.ben_get_absence_id(
4969: p_assignment_id => p_assignment_id
4970: ,p_effective_date => p_effective_date
4971: );
4972: debug(l_proc_name, 20);
4970: ,p_effective_date => p_effective_date
4971: );
4972: debug(l_proc_name, 20);
4973: l_val :=
4974: pqp_gb_osp_functions.get_medical_details(
4975: p_absence_attendance_id => l_absence_id
4976: ,p_title => p_title
4977: ,p_error_code => p_error_code
4978: ,p_message => p_message
5285:
5286: p_error_code := 0;
5287: -- With the above column name get entitlement days for BAND1.
5288: p_band1_entitled :=
5289: pqp_gb_osp_functions.get_abs_plan_ent_days_info(
5290: p_absence_attendance_id => p_absence_attendance_id
5291: ,p_pl_id => p_pl_id
5292: ,p_error_code => l_error_code
5293: ,p_error_message => p_error_message
5296: ,p_level_of_entitlement => 'BAND1'
5297: );
5298: -- With the above column name get Paid days for BAND1.
5299: p_band1_paid :=
5300: pqp_gb_osp_functions.get_abs_plan_paid_days_info(
5301: p_absence_attendance_id => p_absence_attendance_id
5302: ,p_pl_id => p_pl_id
5303: ,p_error_code => l_error_code
5304: ,p_error_message => p_error_message
5308: );
5309: -- Ended Calls for BAND1.
5310: -- With the above column name get entitlement days for BAND2.
5311: p_band2_entitled :=
5312: pqp_gb_osp_functions.get_abs_plan_ent_days_info(
5313: p_absence_attendance_id => p_absence_attendance_id
5314: ,p_pl_id => p_pl_id
5315: ,p_error_code => l_error_code
5316: ,p_error_message => p_error_message
5319: ,p_level_of_entitlement => 'BAND2'
5320: );
5321: -- With the above column name get Paid days for BAND2.
5322: p_band2_paid :=
5323: pqp_gb_osp_functions.get_abs_plan_paid_days_info(
5324: p_absence_attendance_id => p_absence_attendance_id
5325: ,p_pl_id => p_pl_id
5326: ,p_error_code => l_error_code
5327: ,p_error_message => p_error_message
5331: );
5332: -- Ended Calls for BAND2.
5333: -- With the above column name get entitlement days for BAND3.
5334: p_band3_entitled :=
5335: pqp_gb_osp_functions.get_abs_plan_ent_days_info(
5336: p_absence_attendance_id => p_absence_attendance_id
5337: ,p_pl_id => p_pl_id
5338: ,p_error_code => l_error_code
5339: ,p_error_message => p_error_message
5342: ,p_level_of_entitlement => 'BAND3'
5343: );
5344: -- With the above column name get Paid days for BAND2.
5345: p_band3_paid :=
5346: pqp_gb_osp_functions.get_abs_plan_paid_days_info(
5347: p_absence_attendance_id => p_absence_attendance_id
5348: ,p_pl_id => p_pl_id
5349: ,p_error_code => l_error_code
5350: ,p_error_message => p_error_message
5354: );
5355: -- Ended Calls for BAND3.
5356: -- With the above column name get entitlement days for BAND4.
5357: p_band4_entitled :=
5358: pqp_gb_osp_functions.get_abs_plan_ent_days_info(
5359: p_absence_attendance_id => p_absence_attendance_id
5360: ,p_pl_id => p_pl_id
5361: ,p_error_code => l_error_code
5362: ,p_error_message => p_error_message
5365: ,p_level_of_entitlement => 'BAND4'
5366: );
5367: -- With the above column name get Paid days for BAND2.
5368: p_band4_paid :=
5369: pqp_gb_osp_functions.get_abs_plan_paid_days_info(
5370: p_absence_attendance_id => p_absence_attendance_id
5371: ,p_pl_id => p_pl_id
5372: ,p_error_code => l_error_code
5373: ,p_error_message => p_error_message
5377: );
5378: -- Ended Calls for BAND4.
5379: -- With the above column name get entitlement days for NOBAND.
5380: p_noband_entitled :=
5381: pqp_gb_osp_functions.get_abs_plan_ent_days_info(
5382: p_absence_attendance_id => p_absence_attendance_id
5383: ,p_pl_id => p_pl_id
5384: ,p_error_code => l_error_code
5385: ,p_error_message => p_error_message
5390:
5391: --We need to add up the rows with WAITINGDAY to p_noband_entitled for the
5392: --payroll calculation as WAITINGDAY is treated as NOBAND entitlement in payroll.
5393: p_noband_entitled := NVL(p_noband_entitled,0) +
5394: pqp_gb_osp_functions.get_abs_plan_ent_days_info(
5395: p_absence_attendance_id => p_absence_attendance_id
5396: ,p_pl_id => p_pl_id
5397: ,p_error_code => l_error_code
5398: ,p_error_message => p_error_message
5403:
5404:
5405: -- With the above column name get Paid days for BAND2.
5406: p_noband_paid :=
5407: pqp_gb_osp_functions.get_abs_plan_paid_days_info(
5408: p_absence_attendance_id => p_absence_attendance_id
5409: ,p_pl_id => p_pl_id
5410: ,p_error_code => l_error_code
5411: ,p_error_message => p_error_message
6025: END IF ;
6026: --
6027: -- Call get_band_entitlement_balance to get the entitlements.
6028: l_retval :=
6029: pqp_gb_osp_functions.get_band_entitlement_balance(
6030: p_business_group_id => p_business_group_id
6031: ,p_effective_date => p_effective_date
6032: ,p_assignment_id => p_assignment_id
6033: ,p_pl_typ_id => l_scheme_det.pl_typ_id
6748: debug('p_business_group_id:'||p_business_group_id);
6749: debug('p_assignment_id:'||p_assignment_id);
6750: debug('p_element_type_id:'||p_element_type_id);
6751: p_band1_ent_bal :=
6752: pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ(
6753: p_business_group_id => p_business_group_id
6754: ,p_effective_date => p_effective_date
6755: ,p_assignment_id => p_assignment_id
6756: ,p_element_type_id => p_element_type_id
6764: RETURN -1;
6765: END IF; -- End if of check for error code ...
6766:
6767: p_band2_ent_bal :=
6768: pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ(
6769: p_business_group_id => p_business_group_id
6770: ,p_effective_date => p_effective_date
6771: ,p_assignment_id => p_assignment_id
6772: ,p_element_type_id => p_element_type_id
6780: RETURN -1;
6781: END IF; -- End if of check for error code ...
6782:
6783: p_band3_ent_bal :=
6784: pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ(
6785: p_business_group_id => p_business_group_id
6786: ,p_effective_date => p_effective_date
6787: ,p_assignment_id => p_assignment_id
6788: ,p_element_type_id => p_element_type_id
6796: RETURN -1;
6797: END IF; -- End if of check for error code ...
6798:
6799: p_band4_ent_bal :=
6800: pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ(
6801: p_business_group_id => p_business_group_id
6802: ,p_effective_date => p_effective_date
6803: ,p_assignment_id => p_assignment_id
6804: ,p_element_type_id => p_element_type_id
6812: RETURN -1;
6813: END IF; -- End if of check for error code ...
6814:
6815: p_noband_ent_bal :=
6816: pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ(
6817: p_business_group_id => p_business_group_id
6818: ,p_effective_date => p_effective_date
6819: ,p_assignment_id => p_assignment_id
6820: ,p_element_type_id => p_element_type_id
6893: FETCH csr_osp_scheme_det INTO l_scheme_det;
6894: CLOSE csr_osp_scheme_det;
6895: -- Call get_band_entitlement_balance to get the entitlements.
6896: l_retval :=
6897: pqp_gb_osp_functions.get_omp_band_ent_bal_pl_typ(
6898: p_business_group_id => p_business_group_id
6899: ,p_effective_date => p_effective_date
6900: ,p_assignment_id => p_assignment_id
6901: ,p_pl_typ_id => l_scheme_det.pl_typ_id
7186: -- Do the Search Start Date <= Search End Date Validation Here.
7187:
7188: p_error_code := 0 ;
7189: -- With the above column name get entitlement days for BAND1.
7190: p_band1_entitled := pqp_gb_osp_functions.get_abs_plan_ent_hours_info
7191: ( p_absence_attendance_id => p_absence_attendance_id,
7192: p_pl_id => p_pl_id,
7193: p_error_code => l_error_code,
7194: p_error_message => p_error_message,
7197: p_level_of_entitlement => 'BAND1') ;
7198:
7199: -- Ended Calls for BAND1.
7200: -- With the above column name get entitlement days for BAND2.
7201: p_band2_entitled := pqp_gb_osp_functions.get_abs_plan_ent_hours_info
7202: ( p_absence_attendance_id => p_absence_attendance_id,
7203: p_pl_id => p_pl_id,
7204: p_error_code => l_error_code,
7205: p_error_message => p_error_message,
7208: p_level_of_entitlement => 'BAND2') ;
7209:
7210: -- Ended Calls for BAND2.
7211: -- With the above column name get entitlement days for BAND3.
7212: p_band3_entitled := pqp_gb_osp_functions.get_abs_plan_ent_hours_info
7213: ( p_absence_attendance_id => p_absence_attendance_id,
7214: p_pl_id => p_pl_id,
7215: p_error_code => l_error_code,
7216: p_error_message => p_error_message,
7219: p_level_of_entitlement => 'BAND3') ;
7220:
7221: -- Ended Calls for BAND3.
7222: -- With the above column name get entitlement days for BAND4.
7223: p_band4_entitled := pqp_gb_osp_functions.get_abs_plan_ent_hours_info
7224: ( p_absence_attendance_id => p_absence_attendance_id,
7225: p_pl_id => p_pl_id,
7226: p_error_code => l_error_code,
7227: p_error_message => p_error_message,
7230: p_level_of_entitlement => 'BAND4') ;
7231:
7232: -- Ended Calls for BAND4.
7233: -- With the above column name get entitlement days for NOBAND.
7234: p_noband_entitled := pqp_gb_osp_functions.get_abs_plan_ent_hours_info
7235: ( p_absence_attendance_id => p_absence_attendance_id,
7236: p_pl_id => p_pl_id,
7237: p_error_code => l_error_code,
7238: p_error_message => p_error_message,
7243: --We need to add up the rows with WAITINGDAY to p_noband_entitled for the
7244: --payroll calculation as WAITINGDAY is treated as NOBAND entitlement in payroll.
7245:
7246: p_noband_entitled := NVL(p_noband_entitled,0) +
7247: pqp_gb_osp_functions.get_abs_plan_ent_days_info(
7248: p_absence_attendance_id => p_absence_attendance_id
7249: ,p_pl_id => p_pl_id
7250: ,p_error_code => l_error_code
7251: ,p_error_message => p_error_message
7425: BEGIN
7426:
7427: debug_enter(l_proc_name);
7428:
7429: p_band1_ent_bal := pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ
7430: ( p_business_group_id => p_business_group_id
7431: ,p_effective_date => p_effective_date
7432: ,p_assignment_id => p_assignment_id
7433: ,p_element_type_id => p_element_type_id
7440: IF p_error_code = -1 THEN
7441: RETURN -1;
7442: END IF; -- End if of check for error code ...
7443:
7444: p_band2_ent_bal := pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ
7445: ( p_business_group_id => p_business_group_id
7446: ,p_effective_date => p_effective_date
7447: ,p_assignment_id => p_assignment_id
7448: ,p_element_type_id => p_element_type_id
7455: IF p_error_code = -1 THEN
7456: RETURN -1;
7457: END IF; -- End if of check for error code ...
7458:
7459: p_band3_ent_bal := pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ
7460: ( p_business_group_id => p_business_group_id
7461: ,p_effective_date => p_effective_date
7462: ,p_assignment_id => p_assignment_id
7463: ,p_element_type_id => p_element_type_id
7470: IF p_error_code = -1 THEN
7471: RETURN -1;
7472: END IF; -- End if of check for error code ...
7473:
7474: p_band4_ent_bal := pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ
7475: ( p_business_group_id => p_business_group_id
7476: ,p_effective_date => p_effective_date
7477: ,p_assignment_id => p_assignment_id
7478: ,p_element_type_id => p_element_type_id
7485: IF p_error_code = -1 THEN
7486: RETURN -1;
7487: END IF; -- End if of check for error code ...
7488:
7489: p_noband_ent_bal := pqp_gb_osp_functions.get_omp_band_ent_bal_ele_typ
7490: ( p_business_group_id => p_business_group_id
7491: ,p_effective_date => p_effective_date
7492: ,p_assignment_id => p_assignment_id
7493: ,p_element_type_id => p_element_type_id
11069:
11070:
11071: --Get Part-Timer rounding config value from EIT in coded form.
11072: l_ret_num:=
11073: pqp_gb_osp_functions.pqp_get_plan_extra_info(
11074: p_pl_id => p_pl_id
11075: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
11076: ,p_segment_name => 'Part Timer Rounding Values'
11077: ,p_value => l_pt_val
11093: END IF;
11094:
11095: --Get Full-Timer rounding config value from EIT in coded form.
11096: l_ret_num:=
11097: pqp_gb_osp_functions.pqp_get_plan_extra_info(
11098: p_pl_id => p_pl_id
11099: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
11100: ,p_segment_name => 'Full Timer Rounding Values'
11101: ,p_value => l_ft_val
11118:
11119:
11120: --Get Enable Proration value from EIT
11121: l_ret_num:=
11122: pqp_gb_osp_functions.pqp_get_plan_extra_info(
11123: p_pl_id => p_pl_id
11124: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
11125: ,p_segment_name => 'Enable Entitlement Proration'
11126: ,p_value => l_enb_prorat
11143:
11144:
11145: --Pass the coded value to the decode procedure for part-timers and
11146: --get the return values in to the out parameters.
11147: pqp_gb_osp_functions.decode_round_config(
11148: p_code => l_pt_val
11149: ,p_rounding_type => p_pt_entitl_rounding_type
11150: ,p_rounding_precision => p_pt_rounding_precision
11151: ,p_enb_prorat => l_enb_prorat
11158: END IF;
11159:
11160: --Pass the coded value to the decode procedure for full-timers and
11161: --get the return values in to the out parameters.
11162: pqp_gb_osp_functions.decode_round_config(
11163: p_code => l_ft_val
11164: ,p_rounding_type => p_ft_entitl_rounding_type
11165: ,p_rounding_precision => p_ft_rounding_precision
11166: ,p_enb_prorat => l_enb_prorat
12202: -- END IF;
12203: END get_ssp_smp_paid_days;
12204:
12205:
12206: END pqp_gb_osp_functions;