PACKAGE: APPS.HXC_RDB_PRE_RETRIEVAL

Source

1 PACKAGE HXC_RDB_PRE_RETRIEVAL AUTHID CURRENT_USER AS
2 /* $Header: hxcrdbpreret.pkh 120.4.12020000.2 2013/03/26 13:25:06 jnerella ship $ */
3 
4 
5 
6 TYPE VARCHARTAB IS TABLE OF VARCHAR2(450);   /*Bug 16391367*/
7 TYPE NUMBERTAB IS TABLE OF NUMBER;
8 TYPE DATETAB IS TABLE OF DATE;
9 
10 PROCEDURE go(p_application   IN VARCHAR2,
11              p_start_date    IN VARCHAR2 DEFAULT NULL,
12              p_end_date      IN VARCHAR2 DEFAULT NULL,
13              p_payroll_id    IN NUMBER   DEFAULT NULL,
14              p_gre_id        IN NUMBER   DEFAULT NULL,
15              p_org_id        IN NUMBER   DEFAULT NULL,
16              p_person_id     IN NUMBER   DEFAULT NULL,
17              p_cutoff        IN VARCHAR2 DEFAULT NULL,
18              p_changes_since IN VARCHAR2 DEFAULT NULL,
19              p_msg           OUT NOCOPY VARCHAR2,  -- Bug 9654164
20              p_level         OUT NOCOPY VARCHAR2   -- Bug 9654164
21              );
22 
23 PROCEDURE unlock;
24 
25 PROCEDURE clear_old_data;
26 
27 
28 PROCEDURE generate_pre_retrieval_xml(p_application_code IN VARCHAR2 DEFAULT 'PAY',
29 				     p_user_name        IN VARCHAR2 DEFAULT 'ANONYMOUS',
30 				     p_timecard_status 	IN VARCHAR2 DEFAULT NULL,
31 				     p_attribute_name 	IN VARCHAR2 DEFAULT NULL,
32 				     p_sup_name  	IN VARCHAR2 DEFAULT NULL,
33 				     p_delegated_person	IN VARCHAR2 DEFAULT NULL,
34 				     p_dynamic_sql      IN VARCHAR2,
35 				     p_pre_xml          OUT NOCOPY CLOB
36 				    );
37 
38 PROCEDURE load_unretrieved_details( p_application   IN   VARCHAR2,
39                                     p_timecard_id   IN   NUMBER);
40 
41 
42 PROCEDURE release_timecard_lock ( p_resource_id IN VARCHAR2,
43                                   p_start_time  IN VARCHAR2,
44                                   p_stop_time   IN VARCHAR2 );
45 
46 
47 
48 -- Bug 9654164
49 -- Added the below functions.
50 FUNCTION validate_login
51 RETURN VARCHAR2;
52 
53 
54 FUNCTION validate_current_session
55 RETURN VARCHAR2;
56 
57 END HXC_RDB_PRE_RETRIEVAL;
58