[Home] [Help]
PACKAGE: APPS.HR_ASSIGNMENT_COMMON_SAVE_WEB
Source
1 PACKAGE hr_assignment_common_save_web AUTHID CURRENT_USER AS
2 /* $Header: hrascmsw.pkh 120.1 2005/09/23 13:51:03 svittal noship $*/
3 --
4 g_data_error exception;
5 --
6 -- -------------------------------------------------------------------------- --
7 -- -----------------------< validate_assignment >---------------------------- --
8 -- -------------------------------------------------------------------------- --
9 --
10 procedure validate_assignment
11 (p_validate in boolean
12 ,p_assignment_id in number
13 ,p_object_version_number in number
14 ,p_effective_date in date
15 ,p_datetrack_update_mode in varchar2
16 ,p_organization_id in number
17 ,p_position_id in number default null
18 ,p_job_id in number default null
19 ,p_grade_id in number default null
20 ,p_location_id in number default null
21 ,p_employment_category in varchar2 default null
22 --
23 ,p_supervisor_id in number default null
24 ,p_manager_flag in varchar2 default null
25 ,p_normal_hours in number default null
26 ,p_frequency in varchar2 default null
27 ,p_time_normal_finish in varchar2 default null
28 ,p_time_normal_start in varchar2 default null
29 ,p_assignment_status_type_id in number default null
30 ,p_change_reason in varchar2 default null
31 ,p_ass_attribute_category in varchar2 default null
32 ,p_ass_attribute1 in varchar2 default null
33 ,p_ass_attribute2 in varchar2 default null
34 ,p_ass_attribute3 in varchar2 default null
35 ,p_ass_attribute4 in varchar2 default null
36 ,p_ass_attribute5 in varchar2 default null
37 ,p_ass_attribute6 in varchar2 default null
38 ,p_ass_attribute7 in varchar2 default null
39 ,p_ass_attribute8 in varchar2 default null
40 ,p_ass_attribute9 in varchar2 default null
41 ,p_ass_attribute10 in varchar2 default null
42 ,p_ass_attribute11 in varchar2 default null
43 ,p_ass_attribute12 in varchar2 default null
44 ,p_ass_attribute13 in varchar2 default null
45 ,p_ass_attribute14 in varchar2 default null
46 ,p_ass_attribute15 in varchar2 default null
47 ,p_ass_attribute16 in varchar2 default null
48 ,p_ass_attribute17 in varchar2 default null
49 ,p_ass_attribute18 in varchar2 default null
50 ,p_ass_attribute19 in varchar2 default null
51 ,p_ass_attribute20 in varchar2 default null
52 ,p_ass_attribute21 in varchar2 default null
53 ,p_ass_attribute22 in varchar2 default null
54 ,p_ass_attribute23 in varchar2 default null
55 ,p_ass_attribute24 in varchar2 default null
56 ,p_ass_attribute25 in varchar2 default null
57 ,p_ass_attribute26 in varchar2 default null
58 ,p_ass_attribute27 in varchar2 default null
59 ,p_ass_attribute28 in varchar2 default null
60 ,p_ass_attribute29 in varchar2 default null
61 ,p_ass_attribute30 in varchar2 default null
62 ,p_scl_segment1 in varchar2 default null
63 ,p_scl_segment2 in varchar2 default null
64 ,p_scl_segment3 in varchar2 default null
65 ,p_scl_segment4 in varchar2 default null
66 ,p_scl_segment5 in varchar2 default null
67 ,p_scl_segment6 in varchar2 default null
68 ,p_scl_segment7 in varchar2 default null
69 ,p_scl_segment8 in varchar2 default null
70 ,p_scl_segment9 in varchar2 default null
71 ,p_scl_segment10 in varchar2 default null
72 ,p_scl_segment11 in varchar2 default null
73 ,p_scl_segment12 in varchar2 default null
74 ,p_scl_segment13 in varchar2 default null
75 ,p_scl_segment14 in varchar2 default null
76 ,p_scl_segment15 in varchar2 default null
77 ,p_scl_segment16 in varchar2 default null
78 ,p_scl_segment17 in varchar2 default null
79 ,p_scl_segment18 in varchar2 default null
80 ,p_scl_segment19 in varchar2 default null
81 ,p_scl_segment20 in varchar2 default null
82 ,p_scl_segment21 in varchar2 default null
83 ,p_scl_segment22 in varchar2 default null
84 ,p_scl_segment23 in varchar2 default null
85 ,p_scl_segment24 in varchar2 default null
86 ,p_scl_segment25 in varchar2 default null
87 ,p_scl_segment26 in varchar2 default null
88 ,p_scl_segment27 in varchar2 default null
89 ,p_scl_segment28 in varchar2 default null
90 ,p_scl_segment29 in varchar2 default null
91 ,p_scl_segment30 in varchar2 default null
92 ,p_pgp_segment1 in varchar2 default null
93 ,p_pgp_segment2 in varchar2 default null
94 ,p_pgp_segment3 in varchar2 default null
95 ,p_pgp_segment4 in varchar2 default null
96 ,p_pgp_segment5 in varchar2 default null
97 ,p_pgp_segment6 in varchar2 default null
98 ,p_pgp_segment7 in varchar2 default null
99 ,p_pgp_segment8 in varchar2 default null
100 ,p_pgp_segment9 in varchar2 default null
101 ,p_pgp_segment10 in varchar2 default null
102 ,p_pgp_segment11 in varchar2 default null
103 ,p_pgp_segment12 in varchar2 default null
104 ,p_pgp_segment13 in varchar2 default null
105 ,p_pgp_segment14 in varchar2 default null
106 ,p_pgp_segment15 in varchar2 default null
107 ,p_pgp_segment16 in varchar2 default null
108 ,p_pgp_segment17 in varchar2 default null
109 ,p_pgp_segment18 in varchar2 default null
110 ,p_pgp_segment19 in varchar2 default null
111 ,p_pgp_segment20 in varchar2 default null
112 ,p_pgp_segment21 in varchar2 default null
113 ,p_pgp_segment22 in varchar2 default null
114 ,p_pgp_segment23 in varchar2 default null
115 ,p_pgp_segment24 in varchar2 default null
116 ,p_pgp_segment25 in varchar2 default null
117 ,p_pgp_segment26 in varchar2 default null
118 ,p_pgp_segment27 in varchar2 default null
119 ,p_pgp_segment28 in varchar2 default null
120 ,p_pgp_segment29 in varchar2 default null
121 ,p_pgp_segment30 in varchar2 default null
122
123 --
124 ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
125 ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
126 ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
127 ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
128 ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
129 ,p_person_id in per_all_assignments_f.person_id%TYPE
130 ,p_effective_start_date out nocopy date
131 ,p_effective_end_date out nocopy date
132 ,p_element_warning in boolean
133 ,p_element_changed in out nocopy varchar2
134 ,p_email_id in varchar2 default null
135 );
136 --
137 procedure get_asg_from_tt
138 (p_transaction_step_id in number
139 ,p_assignment_rec out nocopy per_all_assignments_f%rowtype
140 );
141 --
142 procedure get_pgp_from_tt
143 (p_transaction_step_id in number
144 ,p_pgp_rec out nocopy pay_people_groups%rowtype
145 );
146 --
147 procedure get_scl_from_tt
148 (p_transaction_step_id in number
149 ,p_scl_rec out nocopy hr_soft_coding_keyflex%rowtype
150 );
151 --
152 procedure get_asg_from_asg(p_assignment_id in number
153 ,p_effective_date in date
154 ,p_assignment_rec out nocopy per_all_assignments_f%rowtype);
155 --
156 procedure get_pgp_from_pgp(p_people_group_id in number
157 ,p_pgp_rec out nocopy pay_people_groups%rowtype);
158 --
159 procedure get_scl_from_scl(p_soft_coding_keyflex_id in number
160 ,p_scl_rec out nocopy hr_soft_coding_keyflex%rowtype);
161 --
162 procedure get_asg(
163 p_item_type in wf_items.item_type%TYPE
164 ,p_item_key in wf_items.item_key%TYPE
165 ,p_assignment_id in per_all_assignments_f.assignment_id%type
166 ,p_effective_date in date
167 ,p_assignment_rec out nocopy per_all_assignments_f%rowtype);
168 --
169 procedure get_step(
170 p_item_type in wf_items.item_type%TYPE
171 ,p_item_key in wf_items.item_key%TYPE
172 ,p_api_name in varchar2
173 ,p_transaction_step_id out nocopy number
174 ,p_transaction_id out nocopy number);
175 --
176 function step_open(
177 p_item_type in wf_items.item_type%TYPE
178 ,p_item_key in wf_items.item_key%TYPE
179 ,p_api_name in varchar2) return boolean;
180 --
181 end hr_assignment_common_save_web;