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.SSP_PAD_PKG dependencies on SSP_PAD_PKG

Line 1: package body SSP_PAD_PKG as

1: package body SSP_PAD_PKG as
2: /*$Header: sppadapi.pkb 120.2.12000000.3 2007/03/12 13:54:33 kthampan noship $
3: +==============================================================================+
4: | Copyright (c) 1994 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 47: use ssp_pad_pkg.c_week_commencing_name

43: also change csr_check_if_existing_entries
44: not to reference from per_absence_attendances
45: table
46: 12 Mar 07 Kthampan 5925760 Amend the cursor csr_existing_entries to
47: use ssp_pad_pkg.c_week_commencing_name
48: */
49: --------------------------------------------------------------------------------
50: g_package varchar2(33) := ' ssp_pad_pkg.'; -- Global package name
51: --

Line 50: g_package varchar2(33) := ' ssp_pad_pkg.'; -- Global package name

46: 12 Mar 07 Kthampan 5925760 Amend the cursor csr_existing_entries to
47: use ssp_pad_pkg.c_week_commencing_name
48: */
49: --------------------------------------------------------------------------------
50: g_package varchar2(33) := ' ssp_pad_pkg.'; -- Global package name
51: --
52:
53: --------------------------------------------------------------------------------
54: -- Get details of initial paternity leave for a paternity

Line 75: ssp_pad_pkg.MATCHING_WEEK_OF_ADOPTION (MATCHING_DATE) MW,

71: --
72: cursor csr_personal_details (p_maternity_id in number) is
73: select maternity.person_id,
74: maternity.due_date,
75: ssp_pad_pkg.MATCHING_WEEK_OF_ADOPTION (MATCHING_DATE) MW,
76: MATCHING_DATE MATCHING_DATE,
77: PLACEMENT_DATE PLACEMENT_DATE,
78: DISRUPTED_PLACEMENT_DATE DISRUPTED_PLACEMENT_DATE,
79: maternity.maternity_id,

Line 508: and date_start <= ssp_pad_pkg.continuous_employment_date

504: --
505: select 1
506: from per_periods_of_service
507: where person_id = person.person_id
508: and date_start <= ssp_pad_pkg.continuous_employment_date
509: (person.matching_date)
510: and nvl (actual_termination_date, hr_general.end_of_time)
511: >= person.MW;
512: --

Line 824: hr_utility.set_location ('ssp_pad_pkg.entitled_to_PAD',3);

820: p_reason => 'Late absence notification');
821: */
822: end if;
823: --
824: hr_utility.set_location ('ssp_pad_pkg.entitled_to_PAD',3);
825: --
826: -- Check for any work done during the APP.
827: --
828: -- if this is the first absence period in the APP

Line 1003: ssp_pad_pkg.c_week_commencing_name),

999: -- if in future we get two different rates then a decode can be added here
1000: l_high_rate RATE,
1001: /*to_date (ssp_smp_support_pkg.value
1002: (entry.element_entry_id,
1003: ssp_pad_pkg.c_week_commencing_name),
1004: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1005: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1006: (entry.element_entry_id,
1007: ssp_pad_pkg.c_week_commencing_name)) WEEK_COMMENCING,

Line 1007: ssp_pad_pkg.c_week_commencing_name)) WEEK_COMMENCING,

1003: ssp_pad_pkg.c_week_commencing_name),
1004: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1005: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1006: (entry.element_entry_id,
1007: ssp_pad_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1008: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1009: ssp_pad_pkg.c_amount_name)) AMOUNT,
1010: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1011: ssp_pad_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT

Line 1009: ssp_pad_pkg.c_amount_name)) AMOUNT,

1005: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1006: (entry.element_entry_id,
1007: ssp_pad_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1008: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1009: ssp_pad_pkg.c_amount_name)) AMOUNT,
1010: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1011: ssp_pad_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1012: from pay_element_entries_f ENTRY,
1013: per_all_assignments_f asg

Line 1011: ssp_pad_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT

1007: ssp_pad_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1008: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1009: ssp_pad_pkg.c_amount_name)) AMOUNT,
1010: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1011: ssp_pad_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1012: from pay_element_entries_f ENTRY,
1013: per_all_assignments_f asg
1014: where creator_type = c_PAD_creator_type
1015: and creator_id = p_maternity_id

Line 1353: hr_utility.set_location ('Entering: ssp_pad_pkg.derive_PAD_week',1);

1349: -- we are and finding the offset from the start date.
1350: --
1351: begin
1352: --
1353: hr_utility.set_location ('Entering: ssp_pad_pkg.derive_PAD_week',1);
1354: hr_utility.trace ('Entry number = '||to_char (p_week_number));
1355: --
1356: hypothetical_entry.week_commencing (p_week_number)
1357: := (person.APP_start_date + ((p_week_number -1) * 7));

Line 1367: hr_utility.set_location ('Leaving : ssp_pad_pkg.derive_PAD_week',100);

1363: --
1364: hr_utility.trace ('week_commencing = '
1365: ||to_char (hypothetical_entry.week_commencing (p_week_number)));
1366: --
1367: hr_utility.set_location ('Leaving : ssp_pad_pkg.derive_PAD_week',100);
1368: --
1369: end derive_PAD_week;
1370: --
1371: procedure Check_PAD_stoppages (p_week_number in integer) is

Line 1404: hr_utility.set_location ('ssp_pad_pkg.Check_PAD_stoppages',1);

1400: l_dummy integer (1);
1401: --
1402: begin
1403: --
1404: hr_utility.set_location ('ssp_pad_pkg.Check_PAD_stoppages',1);
1405: --
1406: hypothetical_entry.stopped (p_week_number) := 'FALSE';
1407: --
1408: open csr_stoppages (

Line 1432: hr_utility.set_location ('ssp_pad_pkg.Check_PAD_stoppages',10);

1428: end if;
1429: --
1430: close csr_stoppages;
1431: --
1432: hr_utility.set_location ('ssp_pad_pkg.Check_PAD_stoppages',10);
1433: --
1434: end Check_PAD_stoppages;
1435: --
1436: procedure Calculate_correct_PAD_rate (p_week_number in number) is

Line 1450: hr_utility.set_location ('ssp_pad_pkg.Calculate_correct_PAD_rate',1);

1446: and lookup_code = p_rate_band;
1447: --
1448: begin
1449: --
1450: hr_utility.set_location ('ssp_pad_pkg.Calculate_correct_PAD_rate',1);
1451: --
1452: if l_high_rate is null then
1453: --
1454: -- Get the meanings for the rate bands

Line 1483: hr_utility.set_location ('ssp_pad_pkg.Calculate_correct_PAD_rate',10);

1479: --
1480: hr_utility.trace ('PAD Rate = '
1481: ||hypothetical_entry.rate (p_week_number));
1482: --
1483: hr_utility.set_location ('ssp_pad_pkg.Calculate_correct_PAD_rate',10);
1484: --
1485: end Calculate_correct_PAD_rate;
1486: --
1487: procedure Calculate_PAD_amounts (p_week_number in integer, p_APP_start_date in date) is

Line 1512: hr_utility.set_location('Leaving : ssp_pad_pkg.Calculate_PAD_amounts',100);

1508: ||to_char (hypothetical_entry.amount (p_week_number)));
1509: hr_utility.trace ('Recoverable amount = '
1510: ||to_char (hypothetical_entry.recoverable_amount (p_week_number)));
1511: --
1512: hr_utility.set_location('Leaving : ssp_pad_pkg.Calculate_PAD_amounts',100);
1513: --
1514: end calculate_PAD_amounts;
1515: --
1516: procedure check_parameters is

Line 1527: hr_utility.set_location ('ssp_pad_pkg.generate_payments',1);

1523: end check_parameters;
1524: --
1525: begin
1526: --
1527: hr_utility.set_location ('ssp_pad_pkg.generate_payments',1);
1528: --
1529: check_parameters;
1530: --
1531: <>

Line 1663: end ssp_PAD_pkg;

1659: hr_utility.set_location (l_proc,100);
1660: --
1661: end PAD_control;
1662: --------------------------------------------------------------------------------
1663: end ssp_PAD_pkg;