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
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: );
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:
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
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,