[Home] [Help]
PACKAGE: APPS.PAY_SA_GENERAL
Source
1 package pay_sa_general AUTHID CURRENT_USER as
2 /* $Header: pysagenr.pkh 120.2.12010000.1 2008/07/27 23:35:38 appldev ship $ */
3
4 -- +********************************************************************+
5 -- | PUBLIC FUNCTIONS |
6 -- +********************************************************************+
7 ------------------------------------------------------------------------
8 -- Function LOCAL_NATNATIONALITY_NOT_DEFINED
9 ------------------------------------------------------------------------
10
11 function local_nationality_not_defined return varchar2;
12
13 ------------------------------------------------------------------------
14 -- Function LOCAL_NATIONALITY_MATCHES
15 ------------------------------------------------------------------------
16
17 function local_nationality_matches
18 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
19 p_date_earned IN Date)
20 return varchar2;
21
22 ------------------------------------------------------------------------
23
24
25 ------------------------------------------------------------------------
26 -- Function GET_MESSAGE
27 ------------------------------------------------------------------------
28
29 function get_message
30 (p_product in varchar2
31 ,p_message_name in varchar2
32 ,p_token1 in varchar2 default null
33 ,p_token2 in varchar2 default null
34 ,p_token3 in varchar2 default null)
35 return varchar2;
36
37 ------------------------------------------------------------------------
38 -- Functions for EFT
39 ------------------------------------------------------------------------
40 FUNCTION get_parameter (
41 p_parameter_string in varchar2
42 ,p_token in varchar2
43 ,p_segment_number in number default null) RETURN varchar2;
44 --
45 FUNCTION chk_multiple_assignments(p_effective_date IN DATE
46 ,p_person_id IN NUMBER) RETURN VARCHAR2;
47 --
48 function get_sum return number;
49 --
50 function get_count RETURN NUMBER;
51 --
52
53 ------------------------------------------------------------------------
54 -- Function for returning contributory wage of employees over 50 years
55 ------------------------------------------------------------------------
56 FUNCTION get_cont_wage_emp_50 (
57 p_assignment_action_id IN NUMBER
58 ,p_assignment_id IN NUMBER
59 ,p_date_earned IN DATE
60 ,p_pct_value IN NUMBER
61 ,p_subject_to_gosi IN NUMBER)
62 RETURN NUMBER;
63 end pay_sa_general;
64