1 PACKAGE AP_WEB_AUDIT_LIST_PUB AUTHID CURRENT_USER AS
2 /* $Header: apwpalas.pls 115.2 2004/07/01 07:47:48 jrautiai noship $ */
3
4 TYPE Employee_Rec_Type IS RECORD
5 (business_group_id per_all_people_f.business_group_id%TYPE,
6 person_id per_all_people_f.person_id%TYPE,
7 employee_number per_all_people_f.employee_number%TYPE,
8 national_identifier per_all_people_f.national_identifier%TYPE,
9 email_address per_all_people_f.email_address%TYPE
10 );
11
12 TYPE Audit_Rec_Type IS RECORD
13 (audit_reason_code ap_aud_auto_audits.audit_reason_code%TYPE,
14 start_date DATE,
15 end_date DATE
16 );
17
18 TYPE Date_Range_Type IS RECORD
19 (start_date DATE,
20 end_date DATE
21 );
22
23 /*========================================================================
24 | PUBLIC PROCEDUDE Audit_Employee
25 |
26 | DESCRIPTION
27 | This procedure adds a employee to the Internet Expenses automated
28 | audit list.
29 |
30 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
31 | Public API
32 |
33 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
34 |
35 | RETURNS
36 | Standard API parameters
37 |
38 | PARAMETERS
39 | p_api_version IN Standard API paramater
40 | p_init_msg_list IN Standard API paramater
41 | p_commit IN Standard API paramater
42 | p_validation_level IN Standard API paramater
43 | x_return_status OUT Standard API paramater
44 | x_msg_count OUT Standard API paramater
45 | x_msg_data OUT Standard API paramater
46 | p_emp_rec IN Employee record containg criteria used to find a given employee
47 | p_audit_rec IN Audit record containg information about the record to be created
48 | x_auto_audit_id OUT Identifier of the new record created, if multiple created returns -1.
49 |
50 | MODIFICATION HISTORY
51 | Date Author Description of Changes
52 | 05-Dec-2002 J Rautiainen Created
53 |
54 *=======================================================================*/
55 PROCEDURE Audit_Employee(p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_emp_rec IN Employee_Rec_Type,
63 p_audit_rec IN Audit_Rec_Type,
64 x_auto_audit_id OUT NOCOPY NUMBER);
65
66 /*========================================================================
67 | PUBLIC PROCEDUDE Deaudit_Employee
68 |
69 | DESCRIPTION
70 | This procedure removes a employee from the Internet Expenses automated
71 | audit list.
72 |
73 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
74 | Public API
75 |
76 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
77 |
78 | RETURNS
79 | Standard API parameters
80 |
81 | PARAMETERS
82 | p_api_version IN Standard API paramater
83 | p_init_msg_list IN Standard API paramater
84 | p_commit IN Standard API paramater
85 | p_validation_level IN Standard API paramater
86 | x_return_status OUT Standard API paramater
87 | x_msg_count OUT Standard API paramater
88 | x_msg_data OUT Standard API paramater
89 | p_emp_rec IN Employee record containg criteria used to find a given employee
90 | p_date_range_rec IN Record containg date range
91 |
92 | MODIFICATION HISTORY
93 | Date Author Description of Changes
94 | 29-Jun-2004 J Rautiainen Created
95 |
96 *=======================================================================*/
97 PROCEDURE Deaudit_Employee(p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99 p_commit IN VARCHAR2 := FND_API.G_FALSE,
100 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_emp_rec IN Employee_Rec_Type,
105 p_date_range_rec IN Date_Range_Type);
106
107 END AP_WEB_AUDIT_LIST_PUB;
108