DBA Data[Home] [Help]

APPS.PQP_ABSVAL_PKG dependencies on PQP_GB_OSP_FUNCTIONS

Line 1344: pqp_gb_osp_functions.pqp_get_plan_extra_info

1340: debug('Before:'||'Absence Entitlement Sick Leave'||':'||
1341: p_plan_information.entitlement_parameters_UDT_id);
1342: END IF;
1343: l_error_code:=
1344: pqp_gb_osp_functions.pqp_get_plan_extra_info
1345: (p_pl_id => p_pl_id
1346: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1347: ,p_segment_name => 'Absence Entitlement Sick Leave'
1348: ,p_value => p_plan_information.entitlement_parameters_UDT_id

Line 1373: pqp_gb_osp_functions.pqp_get_plan_extra_info

1369: debug('Before:'||'Absence Days'||':'||
1370: p_plan_information.absence_days_type);
1371: END IF;
1372: l_error_code:=
1373: pqp_gb_osp_functions.pqp_get_plan_extra_info
1374: (p_pl_id => p_pl_id
1375: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1376: ,p_segment_name => 'Absence Days'
1377: ,p_value => p_plan_information.absence_days_type

Line 1402: pqp_gb_osp_functions.pqp_get_plan_extra_info

1398: debug('Before:'||'Scheme Calendar Type'||':'||
1399: p_plan_information.scheme_period_type);
1400: END IF;
1401: l_error_code:=
1402: pqp_gb_osp_functions.pqp_get_plan_extra_info
1403: (p_pl_id => p_pl_id
1404: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1405: ,p_segment_name => 'Scheme Calendar Type'
1406: ,p_value => p_plan_information.scheme_period_type

Line 1432: pqp_gb_osp_functions.pqp_get_plan_extra_info

1428: debug('Before:'||'Scheme Calendar Duration'||':'||
1429: p_plan_information.scheme_period_duration);
1430: END IF;
1431: l_error_code :=
1432: pqp_gb_osp_functions.pqp_get_plan_extra_info
1433: (p_pl_id => p_pl_id
1434: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1435: ,p_segment_name => 'Scheme Calendar Duration'
1436: ,p_value => p_plan_information.scheme_period_duration

Line 1462: pqp_gb_osp_functions.pqp_get_plan_extra_info

1458: debug('Before:'||'Scheme Calendar UOM'||':'||
1459: p_plan_information.scheme_period_uom);
1460: END IF;
1461: l_error_code:=
1462: pqp_gb_osp_functions.pqp_get_plan_extra_info
1463: (p_pl_id => p_pl_id
1464: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1465: ,p_segment_name => 'Scheme Calendar UOM'
1466: ,p_value => p_plan_information.scheme_period_uom

Line 1491: -- pqp_gb_osp_functions.pqp_get_plan_extra_info

1487: -- debug('Before:'||'Absence Entitlement Sick Leave'||':'||
1488: -- p_plan_information.entitlement_parameters_UDT_id);
1489: -- END IF;
1490: -- l_error_code:=
1491: -- pqp_gb_osp_functions.pqp_get_plan_extra_info
1492: -- (p_pl_id => p_pl_id
1493: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1494: -- ,p_segment_name => 'Absence Entitlement Sick Leave'
1495: -- ,p_value => p_plan_information.entitlement_parameters_UDT_id

Line 1521: pqp_gb_osp_functions.pqp_get_plan_extra_info

1517: debug('Before:'||'Scheme Start Date'||':'||
1518: p_plan_information.scheme_period_start);
1519: END IF;
1520: l_error_code:=
1521: pqp_gb_osp_functions.pqp_get_plan_extra_info
1522: (p_pl_id => p_pl_id
1523: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1524: ,p_segment_name => 'Scheme Start Date'
1525: ,p_value => p_plan_information.scheme_period_start

Line 1550: -- pqp_gb_osp_functions.pqp_get_plan_extra_info

1546: -- debug('Before:'||'Absence Types List Name'||':'||
1547: --- p_plan_information.absence_types_list_name);
1548: -- END IF;
1549: -- l_error_code:=
1550: -- pqp_gb_osp_functions.pqp_get_plan_extra_info
1551: -- (p_pl_id => p_pl_id
1552: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1553: -- ,p_segment_name => 'Absence Types List Name'
1554: -- ,p_value => p_plan_information.absence_types_list_name

Line 1578: pqp_gb_osp_functions.pqp_get_plan_extra_info

1574: debug('Before:'||'Absence Default Work Pattern'||':'||
1575: p_plan_information.default_work_pattern_name);
1576: END IF;
1577: l_error_code:=
1578: pqp_gb_osp_functions.pqp_get_plan_extra_info
1579: (p_pl_id => p_pl_id
1580: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1581: ,p_segment_name => 'Absence Default Work Pattern'
1582: ,p_value => p_plan_information.default_work_pattern_name

Line 1637: pqp_gb_osp_functions.pqp_get_plan_extra_info

1633: debug('Before:'||'Absence Entitlement Holidays'||':'||
1634: p_plan_information.entitlement_calendar_UDT_id);
1635: END IF;
1636: l_error_code:=
1637: pqp_gb_osp_functions.pqp_get_plan_extra_info
1638: (p_pl_id => p_pl_id
1639: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1640: ,p_segment_name => 'Absence Entitlement Holidays'
1641: ,p_value => p_plan_information.entitlement_calendar_UDT_id

Line 1666: pqp_gb_osp_functions.pqp_get_plan_extra_info

1662: debug('Before:'||'Absence Daily Rate Calculation'||':'||
1663: p_plan_information.daily_rate_UOM);
1664: END IF;
1665: l_error_code:=
1666: pqp_gb_osp_functions.pqp_get_plan_extra_info
1667: (p_pl_id => p_pl_id
1668: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1669: ,p_segment_name => 'Absence Daily Rate Calculation'
1670: ,p_value => p_plan_information.daily_rate_UOM

Line 1694: -- pqp_gb_osp_functions.pqp_get_plan_extra_info

1690: -- IF g_debug THEN
1691: -- debug('Before:'||'Plan Name'||':'||p_plan_information.plan_name);
1692: -- END IF;
1693: -- l_error_code:=
1694: -- pqp_gb_osp_functions.pqp_get_plan_extra_info
1695: -- (p_pl_id => p_pl_id
1696: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1697: -- ,p_segment_name => 'Plan Name'
1698: -- ,p_value => p_plan_information.plan_name

Line 1722: pqp_gb_osp_functions.pqp_get_plan_extra_info

1718: debug('Before:'||'Absence Overlap Rule'||':'||
1719: p_plan_information.absence_overlap_rule);
1720: END IF;
1721: l_error_code:=
1722: pqp_gb_osp_functions.pqp_get_plan_extra_info
1723: (p_pl_id => p_pl_id
1724: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1725: ,p_segment_name => 'Absence Overlap Rule'
1726: ,p_value => p_plan_information.absence_overlap_rule

Line 1751: pqp_gb_osp_functions.pqp_get_plan_extra_info

1747: debug('Before:'||'Absence Pay Plan Category'||':'||
1748: p_plan_information.absence_pay_plan_category);
1749: END IF;
1750: l_error_code:=
1751: pqp_gb_osp_functions.pqp_get_plan_extra_info
1752: (p_pl_id => p_pl_id
1753: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1754: ,p_segment_name => 'Absence Pay Plan Category'
1755: ,p_value => p_plan_information.absence_pay_plan_category

Line 1774: -- pqp_gb_osp_functions.pqp_get_plan_extra_info

1770: -- IF g_debug THEN
1771: -- debug('Before:'||'Absence Entitlement List Name'||':'||p_plan_information.entitlement_band_names_list);
1772: -- END IF;
1773: -- l_error_code:=
1774: -- pqp_gb_osp_functions.pqp_get_plan_extra_info
1775: -- (p_pl_id => p_pl_id
1776: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1777: -- ,p_segment_name => 'Absence Entitlement List Name'
1778: -- ,p_value => p_plan_information.entitlement_band_names_list

Line 1797: pqp_gb_osp_functions.pqp_get_plan_extra_info

1793: debug('Before:'||'Absence Entitlement Cal Rules'||':'||
1794: p_plan_information.calendar_rule_names_list);
1795: END IF;
1796: l_error_code:=
1797: pqp_gb_osp_functions.pqp_get_plan_extra_info
1798: (p_pl_id => p_pl_id
1799: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1800: ,p_segment_name => 'Absence Entitlement Cal Rules'
1801: ,p_value => p_plan_information.calendar_rule_names_list

Line 1823: pqp_gb_osp_functions.pqp_get_plan_extra_info

1819: debug('Before:'||'Dual Rolling Period Duration:'||
1820: p_plan_information.dual_rolling_period_duration);
1821: END IF;
1822: l_error_code:=
1823: pqp_gb_osp_functions.pqp_get_plan_extra_info
1824: (p_pl_id => p_pl_id
1825: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1826: ,p_segment_name => 'Dual Rolling Period Duration'
1827: ,p_value => p_plan_information.dual_rolling_period_duration

Line 1848: pqp_gb_osp_functions.pqp_get_plan_extra_info

1844: debug('Before:'||'Dual Rolling Period UOM:'||
1845: p_plan_information.dual_rolling_period_uom);
1846: END IF;
1847: l_error_code:=
1848: pqp_gb_osp_functions.pqp_get_plan_extra_info
1849: (p_pl_id => p_pl_id
1850: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1851: ,p_segment_name => 'Dual Rolling Period UOM'
1852: ,p_value => p_plan_information.dual_rolling_period_uom

Line 1874: pqp_gb_osp_functions.pqp_get_plan_extra_info

1870: debug('Before:'||'Enable Entitlement Proration:'||
1871: p_plan_information.track_part_timers);
1872: END IF;
1873: l_error_code:=
1874: pqp_gb_osp_functions.pqp_get_plan_extra_info
1875: (p_pl_id => p_pl_id
1876: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1877: ,p_segment_name => 'Enable Entitlement Proration'
1878: ,p_value => p_plan_information.track_part_timers

Line 1899: pqp_gb_osp_functions.pqp_get_plan_extra_info

1895: debug('Before:'||'Absence Schedule Work Pattern:'||
1896: p_plan_information.absence_schedule_work_pattern);
1897: END IF;
1898: l_error_code:=
1899: pqp_gb_osp_functions.pqp_get_plan_extra_info
1900: (p_pl_id => p_pl_id
1901: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1902: ,p_segment_name => 'Absence Schedule Work Pattern'
1903: ,p_value => p_plan_information.absence_schedule_work_pattern

Line 1956: pqp_gb_osp_functions.pqp_get_plan_extra_info

1952: debug('Before:'||'Plan Types to extend Rolling Period'||
1953: p_plan_information.plan_types_to_extend_period);
1954: END IF;
1955: l_error_code:=
1956: pqp_gb_osp_functions.pqp_get_plan_extra_info
1957: (p_pl_id => p_pl_id
1958: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1959: ,p_segment_name => 'Plan Types to Extend Period'
1960: ,p_value => p_plan_information.plan_types_to_extend_period

Line 3838: pqp_gb_osp_functions.get_minimum_pay_info

3834: debug(l_proc_name, 20);
3835: END IF;
3836: ----Added by akarmaka to process minband pay
3837: l_minimum_pay_defined :=
3838: pqp_gb_osp_functions.get_minimum_pay_info
3839: (p_assignment_id => p_assignment_id
3840: ,p_business_group_id => p_business_group_id
3841: ,p_absence_id => p_absence_attendance_id
3842: ,p_minpay_start_date => l_minpay_start_date

Line 3936: pqp_gb_osp_functions.chk_calendar_occurance

3932:
3933: -- 1. check if the day is marked in the calendar
3934: -- and if so under what rule of pay is it marked.
3935: IF p_calendar_user_table_id IS NOT NULL AND
3936: pqp_gb_osp_functions.chk_calendar_occurance
3937: (p_date => l_current_date
3938: ,p_calendar_table_id => p_calendar_user_table_id
3939: ,p_calendar_rules_list => 'PQP_GB_OSP_CALENDAR_RULES'
3940: ,p_cal_rul_name => l_calendar_rule_name -- column name (level of pay)

Line 3955: pqp_gb_osp_functions.get_lookup_code

3951: debug(l_proc_name, l_proc_step);
3952: END IF;
3953: l_calendar_exclusion := TRUE;
3954: l_calendar_rule_code :=
3955: pqp_gb_osp_functions.get_lookup_code
3956: (p_lookup_type => 'PQP_GB_OSP_CALENDAR_RULES'
3957: ,p_lookup_meaning => l_calendar_rule_name
3958: ,p_message => l_error_message
3959: );

Line 5407: PQP_GB_OSP_FUNCTIONS.set_osp_omp_rounding_factors

5403:
5404: --Set the global rounding factor cache if the values are not already set
5405:
5406: IF g_ft_entitl_rounding_type is null OR g_round_cache_plan_id <> p_pl_id THEN
5407: PQP_GB_OSP_FUNCTIONS.set_osp_omp_rounding_factors
5408: (p_pl_id => p_pl_id
5409: ,p_pt_entitl_rounding_type => g_pt_entitl_rounding_type
5410: ,p_pt_rounding_precision => g_pt_rounding_precision
5411: ,p_ft_entitl_rounding_type => g_ft_entitl_rounding_type

Line 5664: -- pqp_gb_osp_functions.get_los_based_entitlements -- ppq_get_los_based_entitlements

5660:
5661: -- 1c) Retrieve the entitlements from the UDT using the LOS
5662: -- multiply FTE in here.
5663: -- l_error_code:=
5664: -- pqp_gb_osp_functions.get_los_based_entitlements -- ppq_get_los_based_entitlements
5665: -- (p_business_group_id => p_business_group_id
5666: -- ,p_effective_date => p_absence_date_start -- business rule hard coded
5667: -- ,p_assignment_id => p_assignment_id
5668: -- ,p_pl_id => p_pl_id

Line 5678: pqp_gb_osp_functions.get_entitlements

5674: -- ,p_entitlement_bands_list_name => 'PQP_GAP_ENTITLEMENT_BANDS'
5675: -- default
5676: -- );
5677:
5678: pqp_gb_osp_functions.get_entitlements
5679: (p_assignment_id => p_assignment_id
5680: ,p_business_group_id => p_business_group_id
5681: ,p_effective_date => p_absence_date_start
5682: ,p_pl_id => p_pl_id