1 PACKAGE HXC_RDB_PROCESS AUTHID CURRENT_USER AS
2 /* $Header: hxcrdbproc.pkh 120.0.12010000.4 2010/05/05 12:07:22 asrajago noship $ */
3
4
5 TYPE VARCHARTABLE IS TABLE OF NUMBER INDEX BY VARCHAR2(50);
6 g_conc_id VARCHARTABLE;
7
8 PROCEDURE SUBMIT_REQUEST ( p_application IN VARCHAR2,
9 p_ret_user_id IN NUMBER,
10 p_start_date IN VARCHAR2 DEFAULT NULL,
11 p_end_date IN VARCHAR2 DEFAULT NULL,
12 p_gre_id IN NUMBER DEFAULT NULL,
13 p_org_id IN NUMBER DEFAULT NULL,
14 p_loc_id IN NUMBER DEFAULT NULL,
15 p_payroll_id IN NUMBER DEFAULT NULL,
16 p_person_id IN NUMBER DEFAULT NULL,
17 p_trans_code IN VARCHAR2 DEFAULT NULL,
18 p_old_new IN VARCHAR2 DEFAULT NULL,
19 p_batch_ref IN VARCHAR2 DEFAULT NULL,
20 p_new_batch_ref IN VARCHAR2 DEFAULT NULL,
21 p_bee_status IN VARCHAR2 DEFAULT NULL,
22 p_changes_since IN VARCHAR2 DEFAULT NULL,
23 p_op_unit IN NUMBER DEFAULT NULL,
24 p_request_id OUT NOCOPY NUMBER ) ;
25
26 PROCEDURE load_conc_ids;
27
28 PROCEDURE refresh;
29
30
31 END HXC_RDB_PROCESS;
32