[Home] [Help]
PACKAGE: APPS.PAY_KW_GENERAL
Source
1 package pay_kw_general AUTHID CURRENT_USER as
2 /* $Header: pykwgenr.pkh 120.1.12010000.1 2008/07/27 23:07:28 appldev ship $ */
3 -- +********************************************************************+
4 -- | PUBLIC FUNCTIONS |
5 -- +********************************************************************+
6 ------------------------------------------------------------------------
7 -- Function LOCAL_NATIONALITY_NOT_DEFINED
8 ------------------------------------------------------------------------
9 function local_nationality_not_defined (p_business_group_id IN number) return varchar2;
10 ------------------------------------------------------------------------
11 -- Function LOCAL_NATNATIONALITY_MATCHES
12 ------------------------------------------------------------------------
13 function local_nationality_matches
14 (p_assignment_id IN per_all_assignments_f.assignment_id%type,
15 p_date_earned IN Date)
16 return varchar2;
17
18 ------------------------------------------------------------------------
19 -- Function GET_LOCAL_NATIONALITY
20 ------------------------------------------------------------------------
21 function get_local_nationality return varchar2;
22 ------------------------------------------------------------------------
23 -- Function GET_MESSAGE
24 ------------------------------------------------------------------------
25 function get_message
26 (p_product in varchar2
27 ,p_message_name in varchar2
28 ,p_token1 in varchar2 default null
29 ,p_token2 in varchar2 default null
30 ,p_token3 in varchar2 default null)
31 return varchar2;
32 ------------------------------------------------------------------------
33 -- Function GET_TABLE_BANDS
34 ------------------------------------------------------------------------
35 function get_table_bands
36 (p_Date_Earned IN DATE
37 ,p_table_name in varchar2
38 ,p_return_type in varchar2) return number;
39 -----------------------------------------------------------
40 -- Functions for EFT file
41 -----------------------------------------------------------
42 --
43 FUNCTION get_parameter (
44 p_parameter_string in varchar2
45 ,p_token in varchar2
46 ,p_segment_number in number default null) RETURN varchar2;
47 --
48 FUNCTION chk_multiple_assignments(p_effective_date IN DATE
49 ,p_person_id IN NUMBER) RETURN VARCHAR2;
50 --
51 function get_count RETURN NUMBER;
52 --
53 function get_sum RETURN NUMBER;
54 --
55 end pay_kw_general;