DBA Data[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;