1 PACKAGE hri_bpl_data_setup_dgnstc AS
2 /* $Header: hribdgdp.pkh 120.4.12000000.2 2007/04/12 12:04:41 smohapat noship $ */
3
4 TYPE data_cols_tab_type IS TABLE OF VARCHAR2(240)
5 INDEX BY BINARY_INTEGER;
6
7 TYPE data_results_tab_type IS TABLE OF data_cols_tab_type
8 INDEX BY BINARY_INTEGER;
9
10 TYPE loop_results_rec_type IS RECORD
11 (person_name per_all_people_f.full_name%TYPE,
12 person_number per_all_people_f.employee_number%TYPE,
13 supervisor_name per_all_people_f.full_name%TYPE,
14 supervisor_number per_all_people_f.employee_number%TYPE);
15
16 TYPE loop_results_tab_type IS TABLE OF loop_results_rec_type
17 INDEX BY BINARY_INTEGER;
18
19 PROCEDURE debug_sup_loop
20 (p_person_id IN NUMBER,
21 p_effective_date IN DATE,
22 p_loop_tab OUT NOCOPY loop_results_tab_type);
23
24 FUNCTION get_dynamic_sql(p_dyn_sql_type IN VARCHAR2,
25 p_dyn_sql IN VARCHAR2)
26 RETURN VARCHAR2;
27
28 PROCEDURE run_diagnostic
29 (p_object_name IN VARCHAR2,
30 p_object_type IN VARCHAR2,
31 p_mode IN VARCHAR2,
32 p_start_date IN DATE,
33 p_end_date IN DATE,
34 p_row_limit IN PLS_INTEGER,
35 p_results_tab OUT NOCOPY data_results_tab_type,
36 p_impact OUT NOCOPY BOOLEAN,
37 p_impact_msg OUT NOCOPY VARCHAR2,
38 p_doc_links_url OUT NOCOPY VARCHAR2,
39 p_sql_stmt OUT NOCOPY VARCHAR2);
40
41 END hri_bpl_data_setup_dgnstc;