DBA Data[Home] [Help]

APPS.SSP_PAB_PKG dependencies on SSP_SAP_PKG

Line 914: hr_utility.set_location ('ssp_sap_pkg.entitled_to_SaP',3);

910: p_reason => 'Late absence notification');
911: */
912: end if;
913: --
914: hr_utility.set_location ('ssp_sap_pkg.entitled_to_SaP',3);
915: --
916: -- Check for any work done during the APP.
917: --
918: -- Check if this is the first absence period in the APP

Line 1088: ssp_sap_pkg.c_week_commencing_name),

1084: -- if in future we get two different rates then a decode can be added here
1085: l_high_rate RATE,
1086: to_date (ssp_smp_support_pkg.value
1087: (entry.element_entry_id,
1088: ssp_sap_pkg.c_week_commencing_name),
1089: 'DD-MON-YYYY') WEEK_COMMENCING,
1090: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1091: ssp_sap_pkg.c_amount_name)) AMOUNT,
1092: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,

Line 1091: ssp_sap_pkg.c_amount_name)) AMOUNT,

1087: (entry.element_entry_id,
1088: ssp_sap_pkg.c_week_commencing_name),
1089: 'DD-MON-YYYY') WEEK_COMMENCING,
1090: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1091: ssp_sap_pkg.c_amount_name)) AMOUNT,
1092: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1093: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1094: from pay_element_entries_f ENTRY,
1095: per_all_assignments_f asg

Line 1093: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT

1089: 'DD-MON-YYYY') WEEK_COMMENCING,
1090: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1091: ssp_sap_pkg.c_amount_name)) AMOUNT,
1092: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1093: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1094: from pay_element_entries_f ENTRY,
1095: per_all_assignments_f asg
1096: where creator_type = c_PAB_creator_type
1097: and creator_id = p_maternity_id

Line 1440: hr_utility.set_location ('Entering: ssp_sap_pkg.derive_PAB_week',1);

1436: -- we are and finding the offset from the start date.
1437: --
1438: begin
1439: --
1440: hr_utility.set_location ('Entering: ssp_sap_pkg.derive_PAB_week',1);
1441: hr_utility.trace ('Entry number = '||to_char (p_week_number));
1442: --
1443: hypothetical_entry.week_commencing (p_week_number)
1444: := (person.APP_start_date + ((p_week_number -1) * 7));

Line 1454: hr_utility.set_location ('Leaving : ssp_sap_pkg.derive_PAB_week',100);

1450: --
1451: hr_utility.trace ('week_commencing = '
1452: ||to_char (hypothetical_entry.week_commencing (p_week_number)));
1453: --
1454: hr_utility.set_location ('Leaving : ssp_sap_pkg.derive_PAB_week',100);
1455: --
1456: end derive_PAB_week;
1457: --
1458: procedure Check_PAB_stoppages (p_week_number in integer) is

Line 1491: hr_utility.set_location ('ssp_sap_pkg.Check_PAB_stoppages',1);

1487: l_dummy integer (1);
1488: --
1489: begin
1490: --
1491: hr_utility.set_location ('ssp_sap_pkg.Check_PAB_stoppages',1);
1492: --
1493: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1494: --
1495: --

Line 1520: hr_utility.set_location ('ssp_sap_pkg.Check_PAB_stoppages',10);

1516: end if;
1517: --
1518: close csr_stoppages;
1519: --
1520: hr_utility.set_location ('ssp_sap_pkg.Check_PAB_stoppages',10);
1521: --
1522: end Check_PAB_stoppages;
1523: --
1524: procedure Calculate_correct_PAB_rate (p_week_number in number) is

Line 1538: hr_utility.set_location ('ssp_sap_pkg.Calculate_correct_PAB_rate',1);

1534: and lookup_code = p_rate_band;
1535: --
1536: begin
1537: --
1538: hr_utility.set_location ('ssp_sap_pkg.Calculate_correct_PAB_rate',1);
1539: --
1540: if l_high_rate is null then
1541: --
1542: -- Get the meanings for the rate bands

Line 1571: hr_utility.set_location ('ssp_sap_pkg.Calculate_correct_PAB_rate',10);

1567: --
1568: hr_utility.trace ('PAB Rate = '
1569: ||hypothetical_entry.rate (p_week_number));
1570: --
1571: hr_utility.set_location ('ssp_sap_pkg.Calculate_correct_PAB_rate',10);
1572: --
1573: end Calculate_correct_PAB_rate;
1574: --
1575: procedure Calculate_PAB_amounts (p_week_number in integer, p_APP_start_date in date) is

Line 1579: hr_utility.set_location('Entering: ssp_sAp_pkg.Calculate_SaP_amounts',1);

1575: procedure Calculate_PAB_amounts (p_week_number in integer, p_APP_start_date in date) is
1576: --
1577: begin
1578: --
1579: hr_utility.set_location('Entering: ssp_sAp_pkg.Calculate_SaP_amounts',1);
1580: --
1581: -- Get the SAP element for each week in case the SAP rate has changed
1582: --
1583: get_PAB_element (hypothetical_entry.week_commencing (p_week_number));

Line 1600: hr_utility.set_location('Leaving : ssp_sap_pkg.Calculate_PAB_amounts',100);

1596: ||to_char (hypothetical_entry.amount (p_week_number)));
1597: hr_utility.trace ('Recoverable amount = '
1598: ||to_char (hypothetical_entry.recoverable_amount (p_week_number)));
1599: --
1600: hr_utility.set_location('Leaving : ssp_sap_pkg.Calculate_PAB_amounts',100);
1601: --
1602: end calculate_PAB_amounts;
1603: --
1604: procedure check_parameters is

Line 1615: hr_utility.set_location ('ssp_sap_pkg.generate_payments',1);

1611: end check_parameters;
1612: --
1613: begin
1614: --
1615: hr_utility.set_location ('ssp_sap_pkg.generate_payments',1);
1616: --
1617: check_parameters;
1618: --
1619: <>