PACKAGE: APPS.HXC_RPT_TC_AUDIT_TRAIL

Source

1 PACKAGE HXC_RPT_TC_AUDIT_TRAIL AUTHID CURRENT_USER AS
2 /* $Header: hxcrptaudittrail.pkh 120.4.12010000.2 2008/10/30 17:07:11 asrajago ship $ */
3 
4 
5 TYPE NUMTABLE     IS TABLE OF NUMBER(15);
6 TYPE VARCHARTABLE IS TABLE OF VARCHAR2(2000);
7 TYPE DATETABLE    IS TABLE OF DATE;
8 TYPE FLOATTABLE   IS TABLE OF NUMBER(22,15);
9 
10 TYPE TIMEDETAILSTABLE IS TABLE OF hxc_rpt_tc_details_all%ROWTYPE;
11 TYPE AUDITTABLE       IS TABLE OF hxc_rpt_tc_audit%ROWTYPE;
12 
13 P_FROM_DATE     VARCHAR2(30);
14 P_TO_DATE       VARCHAR2(30);
15 P_DAT_REGEN     VARCHAR2(30);
16 P_RECORD_SAVE   VARCHAR2(30);
17 P_ORG_ID        NUMBER;
18 P_LOCN_ID       NUMBER;
19 P_PAYROLL_ID    NUMBER;
20 P_SUPERVISOR_ID NUMBER;
21 P_PERSON_ID     NUMBER;
22 
23 LP_FROM_DATE    VARCHAR2(30);
24 LP_TO_DATE      VARCHAR2(30);
25 LP_DAT_REGEN    VARCHAR2(30);
26 LP_RECORD_SAVE  VARCHAR2(30);
27 LP_ORG          VARCHAR2(150);
28 LP_LOCATION     VARCHAR2(150);
29 LP_PAYROLL      VARCHAR2(150);
30 LP_SUPERVISOR   VARCHAR2(250);
31 LP_PERSON       VARCHAR2(250);
32 LP_SYSDATE      VARCHAR2(50);
33 LP_NO_PARM      VARCHAR2(50);
34 LP_USER         VARCHAR2(500);
35 
36 FUNCTION afterpform RETURN BOOLEAN;
37 
38 FUNCTION beforereport RETURN BOOLEAN;
39 
40 FUNCTION afterreport RETURN BOOLEAN;
41 
42 PROCEDURE translate_parameters;
43 
44 
45 
46 PROCEDURE execute_audit_trail_reporting  (errbuf          OUT NOCOPY VARCHAR2,
47                                           retcode         OUT NOCOPY NUMBER,
48                                           p_date_from     IN  VARCHAR2 ,
49                                           p_date_to       IN  VARCHAR2 ,
50                                           p_data_regen    IN  VARCHAR2 ,
51                                           p_record_save   IN  VARCHAR2 ,
52                                           p_org_id        IN  NUMBER DEFAULT NULL,
53                                           p_locn_id       IN  NUMBER DEFAULT NULL,
54                                           p_payroll_id    IN  NUMBER DEFAULT NULL,
55                                           p_supervisor_id IN  NUMBER DEFAULT NULL,
56                                           p_person_id     IN  NUMBER DEFAULT NULL );
57 
58 
59 
60 END HXC_RPT_TC_AUDIT_TRAIL;
61