[Home] [Help]
PACKAGE: APPS.PA_EX_PAY_UTILS
Source
1 PACKAGE PA_EX_PAY_UTILS AUTHID CURRENT_USER AS
2 -- $Header: PAEXPYTS.pls 120.3 2011/04/08 09:40:57 speddi noship $
3 ------------------------------------------------------------------------
4 -- PROCEDURE : INSERT_ROW
5 -- HISTORY : Created asahoo 05-Apr-2011
6 ------------------------------------------------------------------------
7 PROCEDURE Insert_Row
8 (
9 x_rowid IN OUT NOCOPY VARCHAR2,
10 x_business_group_id IN NUMBER,
11 x_payroll_id IN OUT NOCOPY NUMBER,
12 x_payroll_name IN VARCHAR2,
13 x_effective_start_date IN DATE,
14 x_effective_end_date IN DATE,
15 x_payroll_provider_name IN VARCHAR2,
16 x_active_flag IN VARCHAR2,
17 x_priority IN NUMBER,
18 x_description IN VARCHAR2,
19 x_creation_date IN DATE,
20 x_created_by IN NUMBER,
21 x_last_update_date IN DATE,
22 x_last_updated_by IN NUMBER,
23 x_last_update_login IN NUMBER
24 );
25
26 ------------------------------------------------------------------------
27 -- PROCEDURE : LOCK_ROW
28 -- HISTORY : Created asahoo 05-Apr-2011
29 ------------------------------------------------------------------------
30 PROCEDURE Lock_Row
31 (
32 x_business_group_id IN NUMBER,
33 x_payroll_id IN NUMBER,
34 x_payroll_name IN VARCHAR2,
35 x_effective_start_date IN DATE,
36 x_effective_end_date IN DATE,
37 x_payroll_provider_name IN VARCHAR2,
38 x_active_flag IN VARCHAR2,
39 x_priority IN NUMBER,
40 x_description IN VARCHAR2
41 );
42
43
44 -------------------------------------------------------------------------------
45 -- PROCEDURE : UPDATE_ROW
46 -- HISTORY : Created asahoo 05-Apr-2011
47 -------------------------------------------------------------------------------
48 PROCEDURE Update_Row
49 (
50 x_business_group_id IN NUMBER,
51 x_payroll_id IN NUMBER,
52 x_payroll_name IN VARCHAR2,
53 x_effective_start_date IN DATE,
54 x_effective_end_date IN DATE,
55 x_payroll_provider_name IN VARCHAR2,
56 x_active_flag IN VARCHAR2,
57 x_priority IN NUMBER,
58 x_description IN VARCHAR2,
59 x_creation_date IN DATE,
60 x_created_by IN NUMBER,
61 x_last_update_date IN DATE,
62 x_last_updated_by IN NUMBER,
63 x_last_update_login IN NUMBER
64 );
65
66 ------------------------------------------------------------------------
67 -- PROCEDURE : DELETE_ROW
68 -- HISTORY : Created asahoo 05-Apr-2011
69 ------------------------------------------------------------------------
70 PROCEDURE Delete_Row
71 (
72 x_payroll_id IN NUMBER
73 );
74
75 END PA_EX_PAY_UTILS;