1 package HR_ASSIGNMENT_BUSINESS_EVENT as
2 /* $Header: peasgbev.pkh 120.0 2005/10/31 04:39:32 bshukla noship $ */
3 --
4 -- -----------------------------------------------------------------------------------
5 -- |--------------------------< assignment_business_event >--------------------------|
6 -- -----------------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This package raises a business event when an assignment is updated.
11 --
12 -- Prerequisites:
13 -- None
14 -- In Parameters:
15 --
16 -- Name Reqd Type Description
17 -- p_event Y varchar2
18 -- p_assignment_type Y varchar2
19 -- p_primary_flag Y varchar2
20 -- p_effective_date Y date
21 -- p_datetrack_update_mode N varchar2
22 -- p_assignment_id Y number
23 -- p_object_version_number N number
24 -- p_grade_id N number
25 -- p_position_id N number
26 -- p_job_id N number
27 -- p_payroll_id N number
28 -- p_location_id N number
29 -- p_special_ceiling_step_id N number
30 -- p_organization_id N number
31 -- p_pay_basis_id N number
32 -- p_segment1 N varchar2
33 -- p_segment2 N varchar2
34 -- p_segment3 N varchar2
35 -- p_segment4 N varchar2
36 -- p_segment5 N varchar2
37 -- p_segment6 N varchar2
38 -- p_segment7 N varchar2
39 -- p_segment8 N varchar2
40 -- p_segment9 N varchar2
41 -- p_segment10 N varchar2
42 -- p_segment11 N varchar2
43 -- p_segment12 N varchar2
44 -- p_segment13 N varchar2
45 -- p_segment14 N varchar2
46 -- p_segment15 N varchar2
47 -- p_segment16 N varchar2
48 -- p_segment17 N varchar2
49 -- p_segment18 N varchar2
50 -- p_segment19 N varchar2
51 -- p_segment20 N varchar2
52 -- p_segment21 N varchar2
53 -- p_segment22 N varchar2
54 -- p_segment23 N varchar2
55 -- p_segment24 N varchar2
56 -- p_segment25 N varchar2
57 -- p_segment26 N varchar2
58 -- p_segment27 N varchar2
59 -- p_segment28 N varchar2
60 -- p_segment29 N varchar2
61 -- p_segment30 N varchar2
62 -- p_people_group_name N varchar2
63 -- p_group_name N varchar2
64 -- p_employment_category N varchar2
65 -- p_effective_start_date N date
66 -- p_effective_end_date N date
67 -- p_people_group_id N number
68 -- p_org_now_no_manager_warning N boolean
69 -- p_other_manager_warning N boolean
70 -- p_spp_delete_warning N boolean
71 -- p_entries_changed_warning N varchar2
72 -- p_tax_district_changed_warning N boolean
73 -- p_concat_segments N varchar2
74 -- p_contract_id N number
75 -- p_establishment_id N number
76 -- p_concatenated_segments N varchar2
77 -- p_soft_coding_keyflex_id N number
78 -- p_scl_segment1 N varchar2
79 --
80 -- Post Success:
81 -- A Business Event will be raised on update of Assignment.
82 --
83 --
84 -- Post Failure:
85 -- Business Event will not be raised and an error will be raised.
86 --
87 -- Access Status:
88 -- Public.
89 --
90 -- {End Of Comments}
91
92
93 procedure assignment_business_event(
94 p_event in varchar2,
95 p_assignment_type in varchar2,
96 p_primary_flag in varchar2,
97 p_effective_date in date,
98 p_datetrack_update_mode in varchar2 default hr_api.g_update,
99 p_assignment_id in number,
100 p_object_version_number in number,
101 p_grade_id in number default hr_api.g_number,
102 p_position_id in number default hr_api.g_number,
103 p_job_id in number default hr_api.g_number,
104 p_payroll_id in number default hr_api.g_number,
105 p_location_id in number default hr_api.g_number,
106 p_special_ceiling_step_id in number default hr_api.g_number,
107 p_organization_id in number default hr_api.g_number,
108 p_pay_basis_id in number default hr_api.g_number,
109 p_segment1 in varchar2 default hr_api.g_varchar2,
110 p_segment2 in varchar2 default hr_api.g_varchar2,
111 p_segment3 in varchar2 default hr_api.g_varchar2,
112 p_segment4 in varchar2 default hr_api.g_varchar2,
113 p_segment5 in varchar2 default hr_api.g_varchar2,
114 p_segment6 in varchar2 default hr_api.g_varchar2,
115 p_segment7 in varchar2 default hr_api.g_varchar2,
116 p_segment8 in varchar2 default hr_api.g_varchar2,
117 p_segment9 in varchar2 default hr_api.g_varchar2,
118 p_segment10 in varchar2 default hr_api.g_varchar2,
119 p_segment11 in varchar2 default hr_api.g_varchar2,
120 p_segment12 in varchar2 default hr_api.g_varchar2,
121 p_segment13 in varchar2 default hr_api.g_varchar2,
122 p_segment14 in varchar2 default hr_api.g_varchar2,
123 p_segment15 in varchar2 default hr_api.g_varchar2,
124 p_segment16 in varchar2 default hr_api.g_varchar2,
125 p_segment17 in varchar2 default hr_api.g_varchar2,
126 p_segment18 in varchar2 default hr_api.g_varchar2,
127 p_segment19 in varchar2 default hr_api.g_varchar2,
128 p_segment20 in varchar2 default hr_api.g_varchar2,
129 p_segment21 in varchar2 default hr_api.g_varchar2,
130 p_segment22 in varchar2 default hr_api.g_varchar2,
131 p_segment23 in varchar2 default hr_api.g_varchar2,
132 p_segment24 in varchar2 default hr_api.g_varchar2,
133 p_segment25 in varchar2 default hr_api.g_varchar2,
134 p_segment26 in varchar2 default hr_api.g_varchar2,
135 p_segment27 in varchar2 default hr_api.g_varchar2,
136 p_segment28 in varchar2 default hr_api.g_varchar2,
137 p_segment29 in varchar2 default hr_api.g_varchar2,
138 p_segment30 in varchar2 default hr_api.g_varchar2,
139 p_people_group_name in varchar2 default hr_api.g_varchar2,
140 p_group_name in varchar2 default hr_api.g_varchar2,
141 p_employment_category in varchar2 default hr_api.g_varchar2,
142 p_effective_start_date in date default hr_api.g_date,
143 p_effective_end_date in date default hr_api.g_date,
144 p_people_group_id in number default hr_api.g_number,
145 p_org_now_no_manager_warning in boolean default false,
146 p_other_manager_warning in boolean default false,
147 p_spp_delete_warning in boolean default false,
148 p_entries_changed_warning in varchar2 default hr_api.g_varchar2,
149 p_tax_district_changed_warning in boolean default false,
150 p_concat_segments in varchar2 default hr_api.g_varchar2,
151 p_contract_id in number default hr_api.g_number,
152 p_establishment_id in number default hr_api.g_number,
153 p_concatenated_segments in varchar2 default hr_api.g_varchar2,
154 p_soft_coding_keyflex_id in number default hr_api.g_number,
155 p_scl_segment1 in varchar2 default hr_api.g_varchar2);
156
157 end HR_ASSIGNMENT_BUSINESS_EVENT;