1 PACKAGE PSP_PAYTRN AUTHID CURRENT_USER AS
2 /* $Header: PSPPIPLS.pls 120.3.12010000.1 2008/07/28 08:09:26 appldev ship $ */
3 --
4 --
5 --
6 TYPE work_calendar_tab IS TABLE OF CHAR(1)
7 INDEX BY BINARY_INTEGER;
8
9 TYPE daily_calendar_tab IS TABLE OF NUMBER
10 INDEX BY BINARY_INTEGER; -- Corrected the dataype to NUMBER from NUMBER(22, 4) for bug fix 2916848
11
12 work_calendar work_calendar_tab;
13 daily_calendar daily_calendar_tab;
14 g_start_date date;
15 g_end_date date;
16 g_no_of_days number(9);
17 g_no_of_work_days number(9);
18 g_no_of_person_work_days number(9);
19
20 --Bug 1994421 - Zero Work Days Build : Added new variables -lveerubh
21 g_non_active_flag VARCHAR2(1);
22 g_hire_zero_work_days VARCHAR2(1);
23 g_all_holiday_zero_work_days VARCHAR2(1);
24
25
26 PROCEDURE import_paytrans ( errbuf out NOCOPY varchar2,
27 retcode out NOCOPY varchar2,
28 p_period_type in varchar2,
29 p_time_period_id in number,
30 p_business_group_id IN NUMBER, -- Introduced for bug fix 3098050
31 p_set_of_books_id IN NUMBER); -- Introduced for bug fix 3098050
32
33 PROCEDURE create_working_calendar(p_assignment_id IN NUMBER);
34
35 PROCEDURE update_wcal_asg_end_date(x_assignment_id in number,
36 x_return_status out NOCOPY varchar2);
37
38 --The following procedure added by PVELAMUR 02/07/199
39
40 PROCEDURE update_wcal_asg_begin_date(x_assignment_id in number,
41 x_return_status out NOCOPY varchar2);
42 PROCEDURE update_wcal_asg_status(x_assignment_id in number,
43 x_return_status out NOCOPY varchar2);
44
45 PROCEDURE create_daily_rate_calendar(x_assignment_id in number,
46 x_time_period_id in number,
47 x_element_type_id in number,
48 x_return_status out NOCOPY varchar2);
49
50 PROCEDURE CALCULATE_BALANCE_AMOUNT(x_pay_amount in number,
51 x_balance_amount out NOCOPY number,
52 x_return_status OUT NOCOPY VARCHAR2);
53
54 /*Bug 5642002: Added parameters x_start_date and x_end_date */
55 PROCEDURE CREATE_SLINE_SALARY_CHANGE (x_payroll_line_id IN NUMBER,
56 x_start_date IN DATE,
57 x_end_date IN DATE,
58 x_return_status OUT NOCOPY VARCHAR2);
59
60
61 PROCEDURE CREATE_SLINE_ASG_CHANGE (x_payroll_line_id IN NUMBER,
62 x_assignment_id IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65 PROCEDURE CREATE_SLINE_ASG_STATUS_CHANGE (x_payroll_line_id IN NUMBER,
66 x_assignment_id IN NUMBER,
67 x_balance_amount IN NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2);
69
70 PROCEDURE CREATE_SLINE_EMP_END_DATE (x_payroll_line_id IN NUMBER,
71 x_person_id IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2);
73
74
75 PROCEDURE CREATE_SLINE_ORG_CHANGE(x_payroll_line_id IN NUMBER,
76 x_assignment_id IN NUMBER,
77 X_BALANCE_AMOUNT IN NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2);
79
80 PROCEDURE CREATE_SLINE_JOB_CHANGE(x_payroll_line_id IN NUMBER,
81 X_ASSIGNMENT_ID IN NUMBER,
82 X_BALANCE_AMOUNT IN NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2);
84
85 PROCEDURE CREATE_SLINE_POSITION_CHANGE(x_payroll_line_id IN NUMBER,
86 X_ASSIGNMENT_ID IN NUMBER,
87 X_BALANCE_AMOUNT IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2);
89
90 PROCEDURE CREATE_SLINE_GRADE_CHANGE(x_payroll_line_id IN NUMBER,
91 X_ASSIGNMENT_ID IN NUMBER,
92 X_BALANCE_AMOUNT IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2);
94
95 PROCEDURE CREATE_SLINE_PPGROUP_CHANGE(x_payroll_line_id IN NUMBER,
96 X_ASSIGNMENT_ID IN NUMBER,
97 X_BALANCE_AMOUNT IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2);
99
100 PROCEDURE CREATE_SLINE_FTE_CHANGE(x_payroll_line_id IN NUMBER,
101 X_ASSIGNMENT_ID IN NUMBER,
102 X_BALANCE_AMOUNT IN NUMBER,
103 x_return_status OUT NOCOPY VARCHAR2);
104
105 PROCEDURE CREATE_SLINE_BUDGET_CHANGE(x_payroll_line_id IN NUMBER,
106 X_ASSIGNMENT_ID IN NUMBER,
107 X_BALANCE_AMOUNT IN NUMBER,
108 x_return_status OUT NOCOPY VARCHAR2);
109 --
110
111 PROCEDURE CHECK_ZERO_WORK_DAYS(x_assignment_id IN NUMBER,
112 x_costed_value IN NUMBER,
113 x_start_date IN DATE, -- Bug 5642002: Added parameter
114 x_end_date IN DATE, -- Bug 5642002: Added parameter
115 x_return_status OUT NOCOPY varchar2);
116
117 --Bug 1994421 - Zero Work Days Build : Added the new procedure :lveerubh
118 PROCEDURE CREATE_SLINE_TERM_EMP( x_payroll_line_id IN NUMBER,
119 x_reason IN VARCHAR2,
120 x_return_status OUT NOCOPY VARCHAR2);
121
122
123 -- Introduced the following for bug fix 2916848
124 PROCEDURE create_prorate_calendar
125 (
126 p_start_date IN DATE,
127 p_end_date IN DATE,
128 p_pay_amount IN NUMBER,
129 p_payroll_line_id IN NUMBER,
130 p_balance_amount OUT NOCOPY NUMBER,
131 p_return_status OUT NOCOPY VARCHAR2);
132 -- End of bug fix 2916848
133
134 END PSP_PAYTRN;