DBA Data[Home] [Help]

APPS.PQP_ABSVAL_PKG dependencies on PQP_GB_OSP_FUNCTIONS

Line 1365: pqp_gb_osp_functions.pqp_get_plan_extra_info

1361: debug('Before:'||'Absence Entitlement Sick Leave'||':'||
1362: p_plan_information.entitlement_parameters_UDT_id);
1363: END IF;
1364: l_error_code:=
1365: pqp_gb_osp_functions.pqp_get_plan_extra_info
1366: (p_pl_id => p_pl_id
1367: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1368: ,p_segment_name => 'Absence Entitlement Sick Leave'
1369: ,p_value => p_plan_information.entitlement_parameters_UDT_id

Line 1394: pqp_gb_osp_functions.pqp_get_plan_extra_info

1390: debug('Before:'||'Absence Days'||':'||
1391: p_plan_information.absence_days_type);
1392: END IF;
1393: l_error_code:=
1394: pqp_gb_osp_functions.pqp_get_plan_extra_info
1395: (p_pl_id => p_pl_id
1396: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1397: ,p_segment_name => 'Absence Days'
1398: ,p_value => p_plan_information.absence_days_type

Line 1423: pqp_gb_osp_functions.pqp_get_plan_extra_info

1419: debug('Before:'||'Scheme Calendar Type'||':'||
1420: p_plan_information.scheme_period_type);
1421: END IF;
1422: l_error_code:=
1423: pqp_gb_osp_functions.pqp_get_plan_extra_info
1424: (p_pl_id => p_pl_id
1425: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1426: ,p_segment_name => 'Scheme Calendar Type'
1427: ,p_value => p_plan_information.scheme_period_type

Line 1453: pqp_gb_osp_functions.pqp_get_plan_extra_info

1449: debug('Before:'||'Scheme Calendar Duration'||':'||
1450: p_plan_information.scheme_period_duration);
1451: END IF;
1452: l_error_code :=
1453: pqp_gb_osp_functions.pqp_get_plan_extra_info
1454: (p_pl_id => p_pl_id
1455: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1456: ,p_segment_name => 'Scheme Calendar Duration'
1457: ,p_value => p_plan_information.scheme_period_duration

Line 1483: pqp_gb_osp_functions.pqp_get_plan_extra_info

1479: debug('Before:'||'Scheme Calendar UOM'||':'||
1480: p_plan_information.scheme_period_uom);
1481: END IF;
1482: l_error_code:=
1483: pqp_gb_osp_functions.pqp_get_plan_extra_info
1484: (p_pl_id => p_pl_id
1485: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1486: ,p_segment_name => 'Scheme Calendar UOM'
1487: ,p_value => p_plan_information.scheme_period_uom

Line 1512: -- pqp_gb_osp_functions.pqp_get_plan_extra_info

1508: -- debug('Before:'||'Absence Entitlement Sick Leave'||':'||
1509: -- p_plan_information.entitlement_parameters_UDT_id);
1510: -- END IF;
1511: -- l_error_code:=
1512: -- pqp_gb_osp_functions.pqp_get_plan_extra_info
1513: -- (p_pl_id => p_pl_id
1514: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1515: -- ,p_segment_name => 'Absence Entitlement Sick Leave'
1516: -- ,p_value => p_plan_information.entitlement_parameters_UDT_id

Line 1542: pqp_gb_osp_functions.pqp_get_plan_extra_info

1538: debug('Before:'||'Scheme Start Date'||':'||
1539: p_plan_information.scheme_period_start);
1540: END IF;
1541: l_error_code:=
1542: pqp_gb_osp_functions.pqp_get_plan_extra_info
1543: (p_pl_id => p_pl_id
1544: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1545: ,p_segment_name => 'Scheme Start Date'
1546: ,p_value => p_plan_information.scheme_period_start

Line 1571: -- pqp_gb_osp_functions.pqp_get_plan_extra_info

1567: -- debug('Before:'||'Absence Types List Name'||':'||
1568: --- p_plan_information.absence_types_list_name);
1569: -- END IF;
1570: -- l_error_code:=
1571: -- pqp_gb_osp_functions.pqp_get_plan_extra_info
1572: -- (p_pl_id => p_pl_id
1573: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1574: -- ,p_segment_name => 'Absence Types List Name'
1575: -- ,p_value => p_plan_information.absence_types_list_name

Line 1599: pqp_gb_osp_functions.pqp_get_plan_extra_info

1595: debug('Before:'||'Absence Default Work Pattern'||':'||
1596: p_plan_information.default_work_pattern_name);
1597: END IF;
1598: l_error_code:=
1599: pqp_gb_osp_functions.pqp_get_plan_extra_info
1600: (p_pl_id => p_pl_id
1601: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1602: ,p_segment_name => 'Absence Default Work Pattern'
1603: ,p_value => p_plan_information.default_work_pattern_name

Line 1658: pqp_gb_osp_functions.pqp_get_plan_extra_info

1654: debug('Before:'||'Absence Entitlement Holidays'||':'||
1655: p_plan_information.entitlement_calendar_UDT_id);
1656: END IF;
1657: l_error_code:=
1658: pqp_gb_osp_functions.pqp_get_plan_extra_info
1659: (p_pl_id => p_pl_id
1660: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1661: ,p_segment_name => 'Absence Entitlement Holidays'
1662: ,p_value => p_plan_information.entitlement_calendar_UDT_id

Line 1687: pqp_gb_osp_functions.pqp_get_plan_extra_info

1683: debug('Before:'||'Absence Daily Rate Calculation'||':'||
1684: p_plan_information.daily_rate_UOM);
1685: END IF;
1686: l_error_code:=
1687: pqp_gb_osp_functions.pqp_get_plan_extra_info
1688: (p_pl_id => p_pl_id
1689: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1690: ,p_segment_name => 'Absence Daily Rate Calculation'
1691: ,p_value => p_plan_information.daily_rate_UOM

Line 1715: -- pqp_gb_osp_functions.pqp_get_plan_extra_info

1711: -- IF g_debug THEN
1712: -- debug('Before:'||'Plan Name'||':'||p_plan_information.plan_name);
1713: -- END IF;
1714: -- l_error_code:=
1715: -- pqp_gb_osp_functions.pqp_get_plan_extra_info
1716: -- (p_pl_id => p_pl_id
1717: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1718: -- ,p_segment_name => 'Plan Name'
1719: -- ,p_value => p_plan_information.plan_name

Line 1743: pqp_gb_osp_functions.pqp_get_plan_extra_info

1739: debug('Before:'||'Absence Overlap Rule'||':'||
1740: p_plan_information.absence_overlap_rule);
1741: END IF;
1742: l_error_code:=
1743: pqp_gb_osp_functions.pqp_get_plan_extra_info
1744: (p_pl_id => p_pl_id
1745: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1746: ,p_segment_name => 'Absence Overlap Rule'
1747: ,p_value => p_plan_information.absence_overlap_rule

Line 1772: pqp_gb_osp_functions.pqp_get_plan_extra_info

1768: debug('Before:'||'Absence Pay Plan Category'||':'||
1769: p_plan_information.absence_pay_plan_category);
1770: END IF;
1771: l_error_code:=
1772: pqp_gb_osp_functions.pqp_get_plan_extra_info
1773: (p_pl_id => p_pl_id
1774: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1775: ,p_segment_name => 'Absence Pay Plan Category'
1776: ,p_value => p_plan_information.absence_pay_plan_category

Line 1795: -- pqp_gb_osp_functions.pqp_get_plan_extra_info

1791: -- IF g_debug THEN
1792: -- debug('Before:'||'Absence Entitlement List Name'||':'||p_plan_information.entitlement_band_names_list);
1793: -- END IF;
1794: -- l_error_code:=
1795: -- pqp_gb_osp_functions.pqp_get_plan_extra_info
1796: -- (p_pl_id => p_pl_id
1797: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1798: -- ,p_segment_name => 'Absence Entitlement List Name'
1799: -- ,p_value => p_plan_information.entitlement_band_names_list

Line 1818: pqp_gb_osp_functions.pqp_get_plan_extra_info

1814: debug('Before:'||'Absence Entitlement Cal Rules'||':'||
1815: p_plan_information.calendar_rule_names_list);
1816: END IF;
1817: l_error_code:=
1818: pqp_gb_osp_functions.pqp_get_plan_extra_info
1819: (p_pl_id => p_pl_id
1820: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1821: ,p_segment_name => 'Absence Entitlement Cal Rules'
1822: ,p_value => p_plan_information.calendar_rule_names_list

Line 1844: pqp_gb_osp_functions.pqp_get_plan_extra_info

1840: debug('Before:'||'Dual Rolling Period Duration:'||
1841: p_plan_information.dual_rolling_period_duration);
1842: END IF;
1843: l_error_code:=
1844: pqp_gb_osp_functions.pqp_get_plan_extra_info
1845: (p_pl_id => p_pl_id
1846: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1847: ,p_segment_name => 'Dual Rolling Period Duration'
1848: ,p_value => p_plan_information.dual_rolling_period_duration

Line 1869: pqp_gb_osp_functions.pqp_get_plan_extra_info

1865: debug('Before:'||'Dual Rolling Period UOM:'||
1866: p_plan_information.dual_rolling_period_uom);
1867: END IF;
1868: l_error_code:=
1869: pqp_gb_osp_functions.pqp_get_plan_extra_info
1870: (p_pl_id => p_pl_id
1871: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1872: ,p_segment_name => 'Dual Rolling Period UOM'
1873: ,p_value => p_plan_information.dual_rolling_period_uom

Line 1895: pqp_gb_osp_functions.pqp_get_plan_extra_info

1891: debug('Before:'||'Enable Entitlement Proration:'||
1892: p_plan_information.track_part_timers);
1893: END IF;
1894: l_error_code:=
1895: pqp_gb_osp_functions.pqp_get_plan_extra_info
1896: (p_pl_id => p_pl_id
1897: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1898: ,p_segment_name => 'Enable Entitlement Proration'
1899: ,p_value => p_plan_information.track_part_timers

Line 1920: pqp_gb_osp_functions.pqp_get_plan_extra_info

1916: debug('Before:'||'Absence Schedule Work Pattern:'||
1917: p_plan_information.absence_schedule_work_pattern);
1918: END IF;
1919: l_error_code:=
1920: pqp_gb_osp_functions.pqp_get_plan_extra_info
1921: (p_pl_id => p_pl_id
1922: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1923: ,p_segment_name => 'Absence Schedule Work Pattern'
1924: ,p_value => p_plan_information.absence_schedule_work_pattern

Line 1977: pqp_gb_osp_functions.pqp_get_plan_extra_info

1973: debug('Before:'||'Plan Types to extend Rolling Period'||
1974: p_plan_information.plan_types_to_extend_period);
1975: END IF;
1976: l_error_code:=
1977: pqp_gb_osp_functions.pqp_get_plan_extra_info
1978: (p_pl_id => p_pl_id
1979: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1980: ,p_segment_name => 'Plan Types to Extend Period'
1981: ,p_value => p_plan_information.plan_types_to_extend_period

Line 3860: pqp_gb_osp_functions.get_minimum_pay_info

3856: debug(l_proc_name, 20);
3857: END IF;
3858: ----Added by akarmaka to process minband pay
3859: l_minimum_pay_defined :=
3860: pqp_gb_osp_functions.get_minimum_pay_info
3861: (p_assignment_id => p_assignment_id
3862: ,p_business_group_id => p_business_group_id
3863: ,p_absence_id => p_absence_attendance_id
3864: ,p_minpay_start_date => l_minpay_start_date

Line 3958: pqp_gb_osp_functions.chk_calendar_occurance

3954:
3955: -- 1. check if the day is marked in the calendar
3956: -- and if so under what rule of pay is it marked.
3957: IF p_calendar_user_table_id IS NOT NULL AND
3958: pqp_gb_osp_functions.chk_calendar_occurance
3959: (p_date => l_current_date
3960: ,p_calendar_table_id => p_calendar_user_table_id
3961: ,p_calendar_rules_list => 'PQP_GB_OSP_CALENDAR_RULES'
3962: ,p_cal_rul_name => l_calendar_rule_name -- column name (level of pay)

Line 3977: pqp_gb_osp_functions.get_lookup_code

3973: debug(l_proc_name, l_proc_step);
3974: END IF;
3975: l_calendar_exclusion := TRUE;
3976: l_calendar_rule_code :=
3977: pqp_gb_osp_functions.get_lookup_code
3978: (p_lookup_type => 'PQP_GB_OSP_CALENDAR_RULES'
3979: ,p_lookup_meaning => l_calendar_rule_name
3980: ,p_message => l_error_message
3981: );

Line 5435: PQP_GB_OSP_FUNCTIONS.set_osp_omp_rounding_factors

5431:
5432: --Set the global rounding factor cache if the values are not already set
5433:
5434: IF g_ft_entitl_rounding_type is null OR g_round_cache_plan_id <> p_pl_id THEN
5435: PQP_GB_OSP_FUNCTIONS.set_osp_omp_rounding_factors
5436: (p_pl_id => p_pl_id
5437: ,p_pt_entitl_rounding_type => g_pt_entitl_rounding_type
5438: ,p_pt_rounding_precision => g_pt_rounding_precision
5439: ,p_ft_entitl_rounding_type => g_ft_entitl_rounding_type

Line 5692: -- pqp_gb_osp_functions.get_los_based_entitlements -- ppq_get_los_based_entitlements

5688:
5689: -- 1c) Retrieve the entitlements from the UDT using the LOS
5690: -- multiply FTE in here.
5691: -- l_error_code:=
5692: -- pqp_gb_osp_functions.get_los_based_entitlements -- ppq_get_los_based_entitlements
5693: -- (p_business_group_id => p_business_group_id
5694: -- ,p_effective_date => p_absence_date_start -- business rule hard coded
5695: -- ,p_assignment_id => p_assignment_id
5696: -- ,p_pl_id => p_pl_id

Line 5706: pqp_gb_osp_functions.get_entitlements

5702: -- ,p_entitlement_bands_list_name => 'PQP_GAP_ENTITLEMENT_BANDS'
5703: -- default
5704: -- );
5705:
5706: pqp_gb_osp_functions.get_entitlements
5707: (p_assignment_id => p_assignment_id
5708: ,p_business_group_id => p_business_group_id
5709: ,p_effective_date => p_absence_date_start
5710: ,p_pl_id => p_pl_id