[Home] [Help]
PACKAGE: APPS.PAY_SG_SOE
Source
1 package pay_sg_soe AUTHID CURRENT_USER as
2 /* $Header: pysgsoe.pkh 120.1.12010000.1 2008/07/27 23:42:02 appldev ship $ */
3
4 function current_salary
5 (p_pay_basis_id in per_pay_bases.pay_basis_id%type,
6 p_assignment_id in pay_element_entries_f.assignment_id%type,
7 p_effective_date in date)
8 return varchar2;
9
10 function net_accrual
11 (p_assignment_id in pay_assignment_actions.assignment_id%type,
12 p_plan_id in pay_accrual_plans.accrual_plan_id%type,
13 p_payroll_id in pay_payroll_actions.payroll_id%type,
14 p_business_group_id in pay_accrual_plans.business_group_id%type,
15 p_effective_date in per_time_periods.end_date%type)
16 return number;
17
18 procedure current_and_ytd_balances
19 (p_prepaid_tag in varchar,
20 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
21 p_balance_name in pay_balance_types.balance_name%type,
22 p_person_id in per_all_people_f.person_id%type,
23 p_current_balance out nocopy number,
24 p_ytd_balance out nocopy number);
25
26 procedure current_and_ytd_balances
27 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
28 p_balance_name in pay_balance_types.balance_name%type,
29 p_person_id in per_all_people_f.person_id%type,
30 p_current_balance out nocopy number,
31 p_ytd_balance out nocopy number);
32
33 procedure balance_totals
34 (p_prepaid_tag varchar,
35 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
36 p_person_id in per_all_people_f.person_id%type,
37 p_gross_pay_current out nocopy number,
38 p_statutory_deductions_current out nocopy number,
39 p_other_deductions_current out nocopy number,
40 p_net_pay_current out nocopy number,
41 p_non_payroll_current out nocopy number,
42 p_gross_pay_ytd out nocopy number,
43 p_statutory_deductions_ytd out nocopy number,
44 p_other_deductions_ytd out nocopy number,
45 p_net_pay_ytd out nocopy number,
46 p_non_payroll_ytd out nocopy number,
47 p_employee_cpf_current out nocopy number,
48 p_employer_cpf_current out nocopy number,
49 p_cpf_total_current out nocopy number,
50 p_employee_cpf_ytd out nocopy number,
51 p_employer_cpf_ytd out nocopy number,
52 p_cpf_total_ytd out nocopy number);
53
54 procedure balance_totals
55 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
56 p_person_id in per_all_people_f.person_id%type,
57 p_gross_pay_current out nocopy number,
58 p_statutory_deductions_current out nocopy number,
59 p_other_deductions_current out nocopy number,
60 p_net_pay_current out nocopy number,
61 p_non_payroll_current out nocopy number,
62 p_gross_pay_ytd out nocopy number,
63 p_statutory_deductions_ytd out nocopy number,
64 p_other_deductions_ytd out nocopy number,
65 p_net_pay_ytd out nocopy number,
66 p_non_payroll_ytd out nocopy number,
67 p_employee_cpf_current out nocopy number,
68 p_employer_cpf_current out nocopy number,
69 p_cpf_total_current out nocopy number,
70 p_employee_cpf_ytd out nocopy number,
71 p_employer_cpf_ytd out nocopy number,
72 p_cpf_total_ytd out nocopy number);
73
74 function get_exchange_rate
75 (p_from_currency in gl_daily_rates.from_currency%type,
76 p_to_currency in gl_daily_rates.to_currency%type,
77 eff_date in gl_daily_rates.conversion_date%type,
78 p_business_group_id in pay_user_columns.business_group_id%type )
79 return number;
80 function get_tax_id
81 ( p_assignment_action_id number)
82 return number;
83
84 procedure get_home_address
85 (p_person_id in per_addresses.person_id%type,
86 p_address_line1 out nocopy per_addresses.address_line1%type,
87 p_address_line2 out nocopy per_addresses.address_line2%type,
88 p_address_line3 out nocopy per_addresses.address_line3%type,
89 p_town_city out nocopy per_addresses.town_or_city%type,
90 p_postal_code out nocopy per_addresses.postal_code%type,
91 p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92
93 procedure get_work_address
94 (p_location_id in hr_locations.location_id%type,
95 p_address_line1 out nocopy hr_locations.address_line_1%type,
96 p_address_line2 out nocopy hr_locations.address_line_2%type,
97 p_address_line3 out nocopy hr_locations.address_line_3%type,
98 p_town_city out nocopy hr_locations.town_or_city%type,
99 p_postal_code out nocopy hr_locations.postal_code%type,
100 p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
101 function business_currency_code
102 (p_business_group_id in hr_organization_units.business_group_id%type)
103 return fnd_currencies.currency_code%type;
104
105 function get_assignment_currency_code
106 (p_assignment_id in per_all_assignments_f.assignment_id%type,
107 p_effective_date in pay_payroll_actions.effective_date%type)
108 return fnd_currencies.currency_code%type;
109
110 function get_payroll_currency_code
111 (p_payroll_id in pay_payrolls_f.payroll_id%type,
112 p_effective_date in pay_payroll_actions.effective_date%type)
113 return fnd_currencies.currency_code%type;
114
115 end pay_sg_soe;