PACKAGE: APPS.HXC_RDB_POST_RETRIEVAL

Source

1 PACKAGE HXC_RDB_POST_RETRIEVAL AUTHID CURRENT_USER AS
2 /* $Header: hxcrdbpostret.pkh 120.4.12020000.2 2013/03/26 13:14:36 jnerella ship $ */
3 
4 TYPE VARCHARTAB IS TABLE OF VARCHAR2(450);   /*Bug 16391367*/
5 TYPE NUMBERTAB IS TABLE OF NUMBER;
6 TYPE DATETAB IS TABLE OF DATE;
7 
8 
9 PROCEDURE go(p_application  IN VARCHAR2,
10              p_start_date   IN VARCHAR2 DEFAULT NULL,
11              p_end_date     IN VARCHAR2 DEFAULT NULL,
12              p_payroll_id   IN NUMBER   DEFAULT NULL,
13              p_org_id       IN NUMBER   DEFAULT NULL,
14              p_person_id    IN NUMBER   DEFAULT NULL,
15              p_batch_ref    IN VARCHAR2 DEFAULT NULL,
16              p_msg          OUT NOCOPY VARCHAR2,         -- Bug 9654164
17              p_level        OUT NOCOPY VARCHAR2          -- Bug 9654164
18             );
19 
20 PROCEDURE clear_old_data;
21 
22 PROCEDURE load_retrieved_details( p_application   IN   VARCHAR2,
23                                   p_timecard_id   IN   NUMBER);
24 
25 PROCEDURE generate_post_retrieval_xml(p_application_code 	IN VARCHAR2 DEFAULT 'PAY',
26 				     p_user_name         	IN VARCHAR2 DEFAULT 'ANONYMOUS',
27 				     p_batch_name 	 	IN VARCHAR2 DEFAULT NULL,
28 				     p_attribute_name 	 	IN VARCHAR2 DEFAULT NULL,
29 				     p_sup_name  	 	IN VARCHAR2 DEFAULT NULL,
30 				     p_payroll_name	 	IN VARCHAR2 DEFAULT NULL,
31 				     p_distinct_tc	 	IN VARCHAR2 DEFAULT NULL,
32 				     p_partial_tc	 	IN VARCHAR2 DEFAULT NULL,
33 				     p_organization	 	IN VARCHAR2 DEFAULT NULL,
34 				     p_dynamic_sql       	IN VARCHAR2,
35 				     p_post_xml          	OUT NOCOPY CLOB
36 				    );
37 
38 END HXC_RDB_POST_RETRIEVAL;
39