1 Package IRC_PROF_AREA_CRITERIA_VAL_API as
2 /* $Header: irpcvapi.pkh 120.4 2008/02/21 14:34:22 viviswan noship $ */
3 /*#
4 * This package contains APIs for creating and deleting professional area
5 * value for a given search criteria.
6 * @rep:scope public
7 * @rep:product irc
8 * @rep:displayname Professional Area Criteria
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------< create_prof_area_criteria >---------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a new professional area value for a given search
18 * criteria.
19 *
20 * You can use this API to add multiple professional area values to a
21 * specific search criteria ID.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with iRecruitment.
25 *
26 * <p><b>Prerequisites</b><br>
27 * A valid search criteria should be present.
28 *
29 * <p><b>Post Success</b><br>
30 * A professional area value is created for the search criteria.
31 *
32 * <p><b>Post Failure</b><br>
33 * The API does not create a professional area criteria value and
34 * raises an error.
35 *
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_effective_date Reference date for validating lookup values are
40 * applicable during the start to end active date range. This date does
41 * not determine when the changes take effect.
42 * @param p_search_criteria_id Identifies the search criteria for which the
43 * professional area value will be added.
44 * @param p_professional_area Professional area criteria
45 * value.
46 * @param p_prof_area_criteria_value_id Primary key of the professional
47 * area criteria in the IRC_PROF_AREA_CRITERIA_VALUES table.
48 * @param p_object_version_number If p_validate is false, then set to the
49 * version number of the created assignment detail. If p_validate is true,
50 * then the value will be null.
51 * @rep:displayname Creates Professional Area Criteria
52 * @rep:category BUSINESS_ENTITY IRC_JOB_SEARCH_PROF_AREA
53 * @rep:lifecycle active
54 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
55 * @rep:scope public
56 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
57 */
58 --
59 -- {End Of Comments}
60 --
61 procedure CREATE_PROF_AREA_CRITERIA
62 (p_validate in boolean default false
63 ,p_effective_date in date
64 ,p_search_criteria_id in number
65 ,p_professional_area in varchar2
66 ,p_prof_area_criteria_value_id out nocopy number
67 ,p_object_version_number out nocopy number
68 );
69 --
70 -- ----------------------------------------------------------------------------
71 -- |------------------------< delete_prof_area_criteria >---------------------|
72 -- ----------------------------------------------------------------------------
73 --
74 -- {Start Of Comments}
75 /*#
76 * This API deletes a single professional area value for a given search
77 * criteria.
78 *
79 *
80 * <p><b>Licensing</b><br>
81 * This API is licensed for use with iRecruitment.
82 *
83 * <p><b>Prerequisites</b><br>
84 * A valid professional area criteria value ID and object version number.
85 *
86 * <p><b>Post Success</b><br>
87 * The professional area criteria value will be deleted.
88 *
89 * <p><b>Post Failure</b><br>
90 * The API does not delete the professional area criteria value and
91 * raises an error.
92 *
93 * @param p_validate If true, then validation alone will be performed and the
94 * database will remain unchanged. If false and all validation checks pass,
95 * then the database will be modified.
96 * @param p_prof_area_criteria_value_id Identifies the professional
97 * area criteria value.
98 * @param p_object_version_number Current version number of the location
99 * criteria to be deleted.
100 * @rep:displayname Delete Professional Area Criteria
101 * @rep:category BUSINESS_ENTITY IRC_JOB_SEARCH_PROF_AREA
102 * @rep:lifecycle active
103 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
104 * @rep:scope public
105 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
106 */
107 --
108 -- {End Of Comments}
109 --
110 procedure DELETE_PROF_AREA_CRITERIA
111 (p_validate in boolean default false
112 ,p_prof_area_criteria_value_id in number
113 ,p_object_version_number in number
114 );
115 --
116 end IRC_PROF_AREA_CRITERIA_VAL_API;