1 PACKAGE PAY_SE_TAX_DECL AUTHID CURRENT_USER AS
2 /* $Header: pysetada.pkh 120.0.12000000.1 2007/04/24 07:04:19 rsahai noship $ */
3
4 /* GET PARAMETER */
5 FUNCTION GET_PARAMETER(
6 p_parameter_string IN VARCHAR2
7 ,p_token IN VARCHAR2
8 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2 ;
9
10
11 /* GET ALL PARAMETERS */
12 PROCEDURE GET_ALL_PARAMETERS(
13 p_payroll_action_id IN NUMBER
14 ,p_business_group_id OUT NOCOPY NUMBER
15 ,p_effective_date OUT NOCOPY DATE
16 ,p_archive OUT NOCOPY VARCHAR2
17 ,p_legal_employer_id OUT NOCOPY NUMBER
18 ,p_month OUT NOCOPY VARCHAR2
19 ,p_year OUT NOCOPY NUMBER
20 ,p_administrative_code OUT NOCOPY VARCHAR2
21 ,p_information OUT NOCOPY VARCHAR2
22 ,p_declaration_due_date OUT NOCOPY DATE
23 ) ;
24
25 /*GET DEFINED BALANCE ID*/
26 FUNCTION GET_DEFINED_BALANCE_ID
27 (p_balance_name IN VARCHAR2
28 ,p_dbi_suffix IN VARCHAR2 )
29 RETURN NUMBER;
30
31
32 /*GET BALANCE NAME*/
33 FUNCTION GET_BALANCE_NAME
34 (p_input_value_id IN VARCHAR2)
35 RETURN VARCHAR2 ;
36
37
38 /*Funtion to get the costed value*/
39 /*FUNCTION COSTED_VALUE
40 (p_run_result_id IN NUMBER
41 ,p_input_value_id IN NUMBER)
42 RETURN NUMBER;*/
43
44
45 /* RANGE CODE */
46 PROCEDURE RANGE_CODE (pactid IN NUMBER
47 ,sqlstr OUT NOCOPY VARCHAR2) ;
48
49
50 /* INITIALIZATION CODE */
51 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER) ;
52
53
54 /* ASSIGNMENT ACTION CODE */
55 PROCEDURE ASSIGNMENT_ACTION_CODE
56 (p_payroll_action_id IN NUMBER
57 ,p_start_person IN NUMBER
58 ,p_end_person IN NUMBER
59 ,p_chunk IN NUMBER) ;
60
61
62 /* ARCHIVE CODE */
63 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
64 ,p_effective_date IN DATE) ;
65 end PAY_SE_TAX_DECL;