DBA Data[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;