1 PACKAGE AP_WEB_AUDIT_LIST_VAL_PVT AS
2 /* $Header: apwvalvs.pls 120.3 2006/05/04 07:49:30 sbalaji noship $ */
3
4 /*========================================================================
5 | PUBLIC PROCEDUDE Validate_Employee_Info
6 |
7 | DESCRIPTION
8 | This procedure validates that a single employee exists for the given
9 | parameter and returns the identifier for the match.
10 |
11 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
12 | AP_WEB_AUDIT_LIST_PUB.Audit_Employee
13 |
14 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
15 |
16 | RETURNS
17 | Employee identifier matching the given parameters.
18 | Status whether the validation was succesful or not
19 |
20 | PARAMETERS
21 | p_emp_rec IN OUT Employee record containg criteria used to find a given employee
22 | x_return_status OUT Status whether the validation was succesful or not
23 |
24 | MODIFICATION HISTORY
25 | Date Author Description of Changes
26 | 05-Dec-2002 J Rautiainen Created
27 |
28 *=======================================================================*/
29 PROCEDURE Validate_Employee_Info(p_emp_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
30 x_return_status OUT NOCOPY VARCHAR2);
31
32
33 /*========================================================================
34 | PUBLIC PROCEDUDE Validate_Audit_Info
35 |
36 | DESCRIPTION
37 | This procedure validates that the audit information used to create
38 | the new record is valid.
39 |
40 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
41 | AP_WEB_AUDIT_LIST_PUB.Audit_Employee
42 |
43 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
44 |
45 | RETURNS
46 | Status whether the validation was succesful or not
47 |
48 | PARAMETERS
49 | p_emp_rec IN Employee record containg criteria used to find a given employee
50 | p_audit_rec IN OUT Audit record containg information about the record to be created
51 | x_return_status OUT Status whether the validation was succesful or not
52 |
53 | MODIFICATION HISTORY
54 | Date Author Description of Changes
55 | 05-Dec-2002 J Rautiainen Created
56 |
57 *=======================================================================*/
58 PROCEDURE Validate_Audit_Info(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
59 p_audit_rec IN OUT NOCOPY AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
60 x_return_status OUT NOCOPY VARCHAR2);
61
62 /*========================================================================
63 | PUBLIC PROCEDUDE Validate_Required_Input
64 |
65 | DESCRIPTION
66 | This procedure validates that the required parameters are passed to the api.
67 |
68 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
69 | AP_WEB_AUDIT_LIST_PUB.Audit_Employee
70 |
71 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
72 |
73 | RETURNS
74 | Status whether the validation was succesful or not
75 |
76 | PARAMETERS
77 | p_emp_rec IN Employee record containg criteria used to find a given employee
78 | p_audit_rec IN Audit record containg information about the record to be created
79 | x_return_status OUT Status whether the validation was succesful or not
80 |
81 | MODIFICATION HISTORY
82 | Date Author Description of Changes
83 | 05-Dec-2002 J Rautiainen Created
84 |
85 *=======================================================================*/
86 PROCEDURE Validate_Required_Input(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
87 p_audit_rec IN AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type,
88 x_return_status OUT NOCOPY VARCHAR2);
89
90 /*========================================================================
91 | PUBLIC PROCEDUDE Validate_Required_Input
92 |
93 | DESCRIPTION
94 | This procedure validates that the required parameters are passed to the api.
95 |
96 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
97 | AP_WEB_AUDIT_LIST_PUB.Deaudit_Employee
98 |
99 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
100 |
101 | RETURNS
102 | Status whether the validation was succesful or not
103 |
104 | PARAMETERS
105 | p_emp_rec IN Employee record containg criteria used to find a given employee
106 | p_date_range_rec IN Record containg date range
107 | x_return_status OUT Status whether the validation was succesful or not
108 |
109 | MODIFICATION HISTORY
110 | Date Author Description of Changes
111 | 29-Jun-2002 J Rautiainen Created
112 |
113 *=======================================================================*/
114 PROCEDURE Validate_Required_Input(p_emp_rec IN AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type,
115 p_date_range_rec IN AP_WEB_AUDIT_LIST_PUB.Date_Range_Type,
116 x_return_status OUT NOCOPY VARCHAR2);
117
118 END AP_WEB_AUDIT_LIST_VAL_PVT;
119