1 Package hr_dflex_utility as
2 /* $Header: hrdfutil.pkh 120.0.12000000.1 2007/01/22 14:46:18 appldev ship $ */
3 --
4 --
5 -- Package Variables
6 --
7 -- ----------------------------------------------------------------------------
8 -- | create varray for ignore descriptive flex field validation |
9 -- ----------------------------------------------------------------------------
10 --
11 type l_ignore_dfcode_varray is varray(30) of varchar2(40);
12 procedure create_ignore_df_validation(p_rec in out nocopy l_ignore_dfcode_varray);
13 --
14 -------------------------------------------------------------------------------
15 -- | check ignore array with descriptive flex currently being processed |
16 -------------------------------------------------------------------------------
17 --
18 function check_ignore_df_varray(p_structure in varchar2) return boolean;
19 --
20 -------------------------------------------------------------------------------
21 -- | clear varray |
22 -------------------------------------------------------------------------------
23 --
24 procedure remove_ignore_df_validation;
25 --
26 -- ----------------------------------------------------------------------------
27 -- |---------------------< ins_or_upd_descflex_attribs >----------------------|
28 -- ----------------------------------------------------------------------------
29 --
30 -- {Start Of Comments}
31 --
32 -- Description:
33 -- This procedure can be called by any row handler which involves the
34 -- insert/update of descriptive flexfield or developer descriptive attributes
35 -- for a given entity.
36 --
37 -- For each DF or DDF column both the column name and the value should be
38 -- provided. The order in which these columns are provided is not significant
39 -- and does not have to correspond to database table ordering.
40 --
41 -- Prerequisites:
42 -- A valid appl_short_name (application short name)
43 -- A valid desc_flex_name (a valid descriptive flexfield)
44 -- Valid descriptive flexfield structure information has been defined frozen and
45 -- compiled.
46 --
47 -- In Parameters:
48 -- Name Reqd Type Description
49 -- ==== ==== ==== ===========
50 -- p_appl_short_name Yes varchar2 Name of application descriptive flex structure
51 -- is linked to
52 -- p_descflex_name Yes varchar2 Descriptive flexfield name
53 -- p_attribute_category Yes varchar2 Context value for the DF Context field
54 -- p_attribute_name1-30 No varchar2 Descriptive flex attribute column names used
55 -- in selected structure
56 -- p_attribute_value1-30 No varchar2 Descriptive flex attribute values for selected
57 -- structure
58 --
59 -- Post Success:
60 -- The process succeeds. No parameters are returned.
61 --
62 -- Post Failure:
63 -- The process raises an error and stops execution.
64 --
65 -- Access Status:
66 -- Internal Development Use Only.
67 --
68 -- {End Of Comments}
69 --
70 procedure ins_or_upd_descflex_attribs
71 (p_appl_short_name in varchar2
72 ,p_descflex_name in varchar2
73 ,p_attribute_category in varchar2
74 ,p_attribute1_name in varchar2 default null
75 ,p_attribute1_value in varchar2 default null
76 ,p_attribute2_name in varchar2 default null
77 ,p_attribute2_value in varchar2 default null
78 ,p_attribute3_name in varchar2 default null
79 ,p_attribute3_value in varchar2 default null
80 ,p_attribute4_name in varchar2 default null
81 ,p_attribute4_value in varchar2 default null
82 ,p_attribute5_name in varchar2 default null
83 ,p_attribute5_value in varchar2 default null
84 ,p_attribute6_name in varchar2 default null
85 ,p_attribute6_value in varchar2 default null
86 ,p_attribute7_name in varchar2 default null
87 ,p_attribute7_value in varchar2 default null
88 ,p_attribute8_name in varchar2 default null
89 ,p_attribute8_value in varchar2 default null
90 ,p_attribute9_name in varchar2 default null
91 ,p_attribute9_value in varchar2 default null
92 ,p_attribute10_name in varchar2 default null
93 ,p_attribute10_value in varchar2 default null
94 ,p_attribute11_name in varchar2 default null
95 ,p_attribute11_value in varchar2 default null
96 ,p_attribute12_name in varchar2 default null
97 ,p_attribute12_value in varchar2 default null
98 ,p_attribute13_name in varchar2 default null
99 ,p_attribute13_value in varchar2 default null
100 ,p_attribute14_name in varchar2 default null
101 ,p_attribute14_value in varchar2 default null
102 ,p_attribute15_name in varchar2 default null
103 ,p_attribute15_value in varchar2 default null
104 ,p_attribute16_name in varchar2 default null
105 ,p_attribute16_value in varchar2 default null
106 ,p_attribute17_name in varchar2 default null
107 ,p_attribute17_value in varchar2 default null
108 ,p_attribute18_name in varchar2 default null
109 ,p_attribute18_value in varchar2 default null
110 ,p_attribute19_name in varchar2 default null
111 ,p_attribute19_value in varchar2 default null
112 ,p_attribute20_name in varchar2 default null
113 ,p_attribute20_value in varchar2 default null
114 ,p_attribute21_name in varchar2 default null
115 ,p_attribute21_value in varchar2 default null
116 ,p_attribute22_name in varchar2 default null
117 ,p_attribute22_value in varchar2 default null
118 ,p_attribute23_name in varchar2 default null
119 ,p_attribute23_value in varchar2 default null
120 ,p_attribute24_name in varchar2 default null
121 ,p_attribute24_value in varchar2 default null
122 ,p_attribute25_name in varchar2 default null
123 ,p_attribute25_value in varchar2 default null
124 ,p_attribute26_name in varchar2 default null
125 ,p_attribute26_value in varchar2 default null
126 ,p_attribute27_name in varchar2 default null
127 ,p_attribute27_value in varchar2 default null
128 ,p_attribute28_name in varchar2 default null
129 ,p_attribute28_value in varchar2 default null
130 ,p_attribute29_name in varchar2 default null
131 ,p_attribute29_value in varchar2 default null
132 ,p_attribute30_name in varchar2 default null
133 ,p_attribute30_value in varchar2 default null
134 );
135 end hr_dflex_utility;