[Home] [Help]
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;