PACKAGE: APPS.HR_DU_UTILITY

Source

1 PACKAGE hr_du_utility AUTHID CURRENT_USER AS
2 /* $Header: perdutil.pkh 115.5 2002/11/28 17:09:21 apholt noship $ */
3 
4 
5 -- 11i / 11.0 specific code
6 -- start
7 FUNCTION local_chr(p_char_code IN NUMBER) RETURN VARCHAR2;
8 
9 PROCEDURE dynamic_sql(p_string IN VARCHAR2);
10 
11 PROCEDURE dynamic_sql_num(p_string IN VARCHAR2,
12                           p_return_value IN OUT NOCOPY NUMBER);
13 
14 PROCEDURE dynamic_sql_num_user_key(
15                           p_string IN VARCHAR2,
16 		          p_api_module_id IN NUMBER,
17         		  p_column_id IN NUMBER,
18                           p_return_value IN OUT NOCOPY NUMBER);
19 
20 PROCEDURE dynamic_sql_str(p_string IN VARCHAR2,
21                           p_return_value IN OUT NOCOPY VARCHAR2,
22                           p_string_length IN NUMBER);
23 
24 FUNCTION chunk_size RETURN NUMBER;
25 
26 -- 11i / 11.0 specific code
27 -- end
28 
29 
30 
31 
32 -- error procedures
33 -- start
34 PROCEDURE error (p_sqlcode IN NUMBER, p_procedure IN VARCHAR2,
35                  p_extra IN VARCHAR2, p_rollback IN VARCHAR2 DEFAULT 'R');
36 -- error procedures
37 -- end
38 
39 
40 -- message procedures
41 -- start
42 PROCEDURE message (p_type IN VARCHAR2, p_message IN VARCHAR2,
43                    p_position IN NUMBER);
44 PROCEDURE message_init;
45 -- message procedures
46 --end
47 
48 
49 
50 -- update status procedures
51 -- start
52 PROCEDURE update_uploads (p_new_status IN VARCHAR2, p_id IN NUMBER);
53 PROCEDURE update_upload_lines (p_new_status IN VARCHAR2, p_id IN NUMBER);
54 PROCEDURE update_upload_headers (p_new_status IN VARCHAR2, p_id IN NUMBER);
55 -- update status procedures
56 -- end
57 
58 
59 
60 -- general purpose procedures
61 -- start
62 FUNCTION get_uploads_status(p_upload_id IN NUMBER)
63          RETURN VARCHAR2;
64 FUNCTION get_upload_headers_status(p_upload_header_id IN NUMBER)
65          RETURN VARCHAR2;
66 FUNCTION get_upload_lines_status(p_upload_lines_id IN NUMBER)
67          RETURN VARCHAR2;
68 -- general purpose procedures
69 -- end
70 
71 FUNCTION Return_Spreadsheet_row(p_row_number IN NUMBER) RETURN VARCHAR2;
72 
73 
74 end hr_du_utility;