[Home] [Help]
PACKAGE: APPS.HRI_OPL_JOBH
Source
1 PACKAGE hri_opl_jobh AUTHID CURRENT_USER AS
2 /* $Header: hripjobh.pkh 120.1.12000000.2 2007/04/12 13:26:59 smohapat noship $ */
3
4 FUNCTION get_flexfield_type(p_job_type IN VARCHAR2,
5 p_value_set_id IN NUMBER)
6 RETURN VARCHAR2;
7
8 PROCEDURE generate_lov_views;
9
10 PROCEDURE full_refresh;
11
12 PROCEDURE full_refresh(errbuf OUT NOCOPY VARCHAR2,
13 retcode OUT NOCOPY VARCHAR2);
14
15 PROCEDURE incr_refresh;
16
17 PROCEDURE incr_refresh(errbuf OUT NOCOPY VARCHAR2,
18 retcode OUT NOCOPY VARCHAR2);
19
20 PROCEDURE incr_refresh(p_refresh_flex IN VARCHAR2);
21
22 FUNCTION decode_keyflex_value
23 (p_id_flex_num NUMBER,
24 p_job_type VARCHAR2,
25 p_segment1 VARCHAR2,
26 p_segment2 VARCHAR2,
27 p_segment3 VARCHAR2,
28 p_segment4 VARCHAR2,
29 p_segment5 VARCHAR2,
30 p_segment6 VARCHAR2,
31 p_segment7 VARCHAR2,
32 p_segment8 VARCHAR2,
33 p_segment9 VARCHAR2,
34 p_segment10 VARCHAR2,
35 p_segment11 VARCHAR2,
36 p_segment12 VARCHAR2,
37 p_segment13 VARCHAR2,
38 p_segment14 VARCHAR2,
39 p_segment15 VARCHAR2,
40 p_segment16 VARCHAR2,
41 p_segment17 VARCHAR2,
42 p_segment18 VARCHAR2,
43 p_segment19 VARCHAR2,
44 p_segment20 VARCHAR2,
45 p_segment21 VARCHAR2,
46 p_segment22 VARCHAR2,
47 p_segment23 VARCHAR2,
48 p_segment24 VARCHAR2,
49 p_segment25 VARCHAR2,
50 p_segment26 VARCHAR2,
51 p_segment27 VARCHAR2,
52 p_segment28 VARCHAR2,
53 p_segment29 VARCHAR2,
54 p_segment30 VARCHAR2)
55 RETURN VARCHAR2;
56
57 FUNCTION decode_descr_flex_value
58 (p_attribute_category VARCHAR2,
59 p_job_type VARCHAR2,
60 p_attribute1 VARCHAR2,
61 p_attribute2 VARCHAR2,
62 p_attribute3 VARCHAR2,
63 p_attribute4 VARCHAR2,
64 p_attribute5 VARCHAR2,
65 p_attribute6 VARCHAR2,
66 p_attribute7 VARCHAR2,
67 p_attribute8 VARCHAR2,
68 p_attribute9 VARCHAR2,
69 p_attribute10 VARCHAR2,
70 p_attribute11 VARCHAR2,
71 p_attribute12 VARCHAR2,
72 p_attribute13 VARCHAR2,
73 p_attribute14 VARCHAR2,
74 p_attribute15 VARCHAR2,
75 p_attribute16 VARCHAR2,
76 p_attribute17 VARCHAR2,
77 p_attribute18 VARCHAR2,
78 p_attribute19 VARCHAR2,
79 p_attribute20 VARCHAR2)
80 RETURN VARCHAR2;
81
82 END hri_opl_jobh;