[Home] [Help]
PACKAGE: APPS.PAY_KR_SAMPLE_SEP_PKG
Source
1 package pay_kr_sample_sep_pkg AUTHID CURRENT_USER as
2 /* $Header: pykrsepl.pkh 115.3 2003/05/30 07:45:29 nnaresh noship $ */
3 --------------------------------------------------------------------------------
4 function get_wkpd(p_start_date in date,
5 p_end_date in date) return varchar2;
6 --------------------------------------------------------------------------------
7 function get_wkpd_exclude(p_assignment_id in number,
8 p_start_date in date,
9 p_end_date in date,
10 p_exclude_flag in varchar2 default 'Y') return varchar2;
11 --------------------------------------------------------------------------------
12 function get_wkpd_for_calc(p_assignment_id in number,
13 p_working_period in varchar2,
14 p_wp_format_flag in varchar2, /* Y(YYMMDD), N(XXX) */
15 p_type in varchar2) /* EARNING, TAX */ return number;
16 --------------------------------------------------------------------------------
17 function get_avg_sal(p_assignment_id in number,
18 p_type in varchar2, /* MTH,BON,ALR */
19 p_effective_date in date,
20 p_base_action_sequence in number default null,
21 p_action_sequence4 in number,
22 p_target_start_date in date,
23 p_target_end_date in date,
24 p_balance_type_id in number) return number;
25 --------------------------------------------------------------------------------
26 function get_avg_val(p_business_group_id in number,
27 p_assignment_action_id in number,
28 p_performance_flag in varchar2 default 'N',
29 p_assignment_action_id1 out nocopy number,
30 p_avg_sal1 out nocopy number,
31 p_avg_sal1_std out nocopy date,
32 p_avg_sal1_edd out nocopy date,
33 p_avg_sal1_wkd out nocopy number,
34 p_assignment_action_id2 out nocopy number,
35 p_avg_sal2 out nocopy number,
36 p_avg_sal2_std out nocopy date,
37 p_avg_sal2_edd out nocopy date,
38 p_avg_sal2_wkd out nocopy number,
39 p_assignment_action_id3 out nocopy number,
40 p_avg_sal3 out nocopy number,
41 p_avg_sal3_std out nocopy date,
42 p_avg_sal3_edd out nocopy date,
43 p_avg_sal3_wkd out nocopy number,
44 p_assignment_action_id4 out nocopy number,
45 p_avg_sal4 out nocopy number,
46 p_avg_sal4_std out nocopy date,
47 p_avg_sal4_edd out nocopy date,
48 p_avg_sal4_wkd out nocopy number,
49 p_assignment_action_idb out nocopy number,
50 p_avg_bon out nocopy number,
51 p_assignment_action_ida out nocopy number,
52 p_avg_alr out nocopy number) return number;
53 --------------------------------------------------------------------------------
54 end pay_kr_sample_sep_pkg;