1 PACKAGE PA_PAY_INTERFACE AUTHID CURRENT_USER AS
2 -- $Header: PAPAYIMPS.pls 120.12 2012/01/13 15:05:33 speddi ship $
3
4 G_ORG_ID NUMBER;
5 G_REQUEST_ID NUMBER;
6 G_USER_ID NUMBER;
7 G_RUN_DATE DATE;
8
9 G_PERSON_ID NUMBER ;
10 G_ASSIGNMENT_ID NUMBER ;
11 G_ORGANIZATION_ID NUMBER ;
12 G_INTERFACE_RUN_ID NUMBER ;
13 G_PAY_PERIOD_START DATE;
14 G_PAY_PERIOD_END DATE;
15 G_RETRO CHAR(1); --Bug 13412968
16 G_FUNC_CURR_CODE VARCHAR2(3);
17 G_PROGRAM_ID NUMBER ;
18 G_PROG_APPL_ID NUMBER;
19 G_LOGIN_ID NUMBER;
20 REJECT_EMP_PAY EXCEPTION;
21 G_DEBUG_MODE VARCHAR2(3);
22
23
24 /* TYPE OF MESSAGE */
25 LOG NUMBER := 1;
26 DEBUG NUMBER := 2;
27
28
29 PROCEDURE INTERFACE_PAY
30 ( errbuf OUT NOCOPY VARCHAR2
31 ,retcode OUT NOCOPY VARCHAR2
32 ,P_FROM_DATE IN VARCHAR2
33 , P_TO_DATE IN VARCHAR2
34 ,P_STREAMLINE IN VARCHAR2
35 , P_PAYROLL_ID IN NUMBER
36 , P_EMP_ORG_ID IN NUMBER
37 , P_PERSON_ID IN NUMBER
38 );
39
40 function get_cost_method(p_exp_item_id IN NUMBER,
41 p_exp_item_date IN DATE)
42 RETURN VARCHAR2;
43
44 /* Start changes for bug#12975007*/
45
46 function get_cost_method1(p_exp_id IN NUMBER,
47 p_job_id IN NUMBER,
48 p_org_id IN NUMBER,
49 p_organization_id IN NUMBER,
50 p_exp_item_id IN NUMBER,
51 p_exp_item_date IN DATE)
52 RETURN VARCHAR2;
53
54 /* End changes for bug#12975007*/
55
56 /* Returns the primary rejection code for the pay element
57 This is used in exception report*/
58 FUNCTION Primary_rejection ( p_interface_run_id IN NUMBER ,
59 p_int_ext_indicator VARCHAR,
60 p_person_id IN NUMBER ,
61 p_pay_element_type_id IN NUMBER,
62 p_pay_element_type_code IN VARCHAR)
63 RETURN varchar2;
64
65
66 /* Returns the additional rejection codes for the pay element
67 This is used in exception report*/
68 FUNCTION additional_rejections ( p_interface_run_id IN NUMBER ,
69 p_int_ext_indicator VARCHAR,
70 p_person_id IN NUMBER ,
71 p_pay_element_type_id IN NUMBER,
72 p_pay_element_type_code IN VARCHAR)
73 RETURN varchar2;
74
75
76
77
78 END;
79