[Home] [Help]
PACKAGE: APPS.PA_MASS_ASGMT_TRX
Source
1 PACKAGE pa_mass_asgmt_trx AS
2 -- $Header: PARMATXS.pls 120.1 2005/08/29 20:51:10 sunkalya noship $
3
4 pa_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5 pa_empty_varchar2_1_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
6 pa_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
7 pa_empty_varchar2_240_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
8
9
10 G_MASS_ASGMT CONSTANT VARCHAR2(30) := 'MASS_ASGMT';
11 G_MASS_UPDATE_ASGMT_BASIC_INFO CONSTANT VARCHAR2(30) := 'MASS_UPDATE_ASGMT_BASIC_INFO';
12 G_MASS_UPDATE_COMPETENCIES CONSTANT VARCHAR2(30) := 'MASS_UPDATE_COMPETENCIES';
13 G_MASS_UPDATE_FORECAST_ITEMS CONSTANT VARCHAR2(30) := 'MASS_UPDATE_FORECAST_ITEMS';
14 G_MASS_SUBMIT_FOR_APPROVAL CONSTANT VARCHAR2(30) := 'MASS_SUBMIT_FOR_APPROVAL';
15 G_MASS_UPDATE_SCHEDULE CONSTANT VARCHAR2(30) := 'MASS_UPDATE_SCHEDULE';
16 G_SAVE CONSTANT VARCHAR2(30) := 'SAVE';
17 G_SAVE_AND_SUBMIT CONSTANT VARCHAR2(30) := 'SAVE_AND_SUBMIT';
18 G_SUBMIT CONSTANT VARCHAR2(30) := 'SUBMIT';
19
20 G_SUBMITTER_USER_ID NUMBER;
21 G_SOURCE_TYPE1 CONSTANT VARCHAR2(30) := 'MASS_ASSIGNMENT_TRANSACTION';
22 G_WORKFLOW_ITEM_TYPE CONSTANT VARCHAR2(30) := 'PARMATRX';
23 G_WORKFLOW_ITEM_KEY NUMBER;
24
25 PROCEDURE start_mass_asgmt_trx_wf
26 (p_mode IN VARCHAR2
27 ,p_action IN VARCHAR2
28 ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
29 ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
30 ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
31 ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32 ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33 ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34 ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35 ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36 ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
37 ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
38 ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
39 ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
40 ,p_append_description_flag IN VARCHAR2 := 'N'
41 ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
42 ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
43 ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
44 ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
45 ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
46 ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
47 ,p_append_information_flag IN VARCHAR2 := 'N'
48 ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
49 ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
50 ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
51 ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52 ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53 ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54 ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55 ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56 ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57 ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58 ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59 ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60 ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61 ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62 ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65 ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66 ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67 ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68 ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69 ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70 ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71 ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72 ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73 ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74 ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75 ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76 ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77 ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78 ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79 ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80 ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81 ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82 ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83 ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84 ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85 ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86 ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87 ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88 ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89 ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90 ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91 ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92 ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93 ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94 ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95 ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96 ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
97 ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
98 ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
99 ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
100 ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
101 ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
102 ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
103 ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
104 ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
105 ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
106 ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
107 ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
108 ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
109 ,p_non_working_day_flag IN VARCHAR2 := 'N'
110 ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111 ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
112 ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
113 ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114 ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115 ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116 ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117 ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118 ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119 ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120 ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121 ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122 ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123 ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
124 ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
125 ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
126 ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
127 ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
128 ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
129 ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl
130 ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
131 ,x_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
132 );
133
134 PROCEDURE mass_asgmt_trx_wf
135 (p_item_type IN VARCHAR2,
136 p_item_key IN VARCHAR2,
137 p_actid IN NUMBER,
138 p_funcmode IN VARCHAR2,
139 p_result OUT NOCOPY VARCHAR2); --Bug: 4537865
140
141
142 PROCEDURE mass_asgmt_autonomous_trx
143 (p_item_type IN VARCHAR2,
144 p_item_key IN VARCHAR2,
145 p_actid IN NUMBER,
146 p_funcmode IN VARCHAR2,
147 p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,
148 p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
149 x_mode OUT NOCOPY VARCHAR2, --Bug: 4537865
150 x_action OUT NOCOPY VARCHAR2, --Bug: 4537865
151 x_start_date OUT NOCOPY DATE, --Bug: 4537865
152 x_end_date OUT NOCOPY DATE, --Bug: 4537865
153 x_project_id OUT NOCOPY NUMBER, --Bug: 4537865
154 x_document OUT NOCOPY VARCHAR2); --Bug: 4537865
155
156 PROCEDURE Start_Mass_Apprvl_WF_If_Req
157 (p_item_type IN VARCHAR2,
158 p_item_key IN VARCHAR2,
159 p_actid IN NUMBER,
160 p_funcmode IN VARCHAR2,
161 p_result OUT NOCOPY VARCHAR2); --Bug: 4537865
162
163 PROCEDURE Display_Updated_Attributes(document_id IN VARCHAR2,
164 display_type IN VARCHAR2,
165 document IN OUT NOCOPY VARCHAR2, --Bug: 4537865
166 document_type IN OUT NOCOPY VARCHAR2); --Bug: 4537865
167
168 PROCEDURE Revert_Cancel_Overcom_Items
169 (p_item_type IN VARCHAR2,
170 p_item_key IN VARCHAR2,
171 p_actid IN NUMBER,
172 p_funcmode IN VARCHAR2,
173 p_result OUT NOCOPY VARCHAR2); --Bug: 4537865
174
175 FUNCTION Is_Asgmt_Revert_Or_Cancel(p_conflict_group_id IN NUMBER,
176 p_assignment_id IN pa_project_assignments.assignment_id%TYPE)
177 RETURN BOOLEAN;
178
179 PROCEDURE check_action_on_conflicts
180 (p_item_type IN VARCHAR2,
181 p_item_key IN VARCHAR2,
182 p_actid IN NUMBER,
183 p_funcmode IN VARCHAR2,
184 p_result OUT NOCOPY VARCHAR2); --Bug: 4537865
185
186 FUNCTION get_translated_attr_name (p_lookup_code IN VARCHAR2)
187 RETURN VARCHAR2;
188
189 PROCEDURE Cancel_Mass_Trx_WF
190 (p_item_type IN VARCHAR2,
191 p_item_key IN VARCHAR2,
192 p_actid IN NUMBER,
193 p_funcmode IN VARCHAR2,
194 p_result OUT NOCOPY VARCHAR2); --Bug: 4537865
195
196 PROCEDURE Abort_Remaining_Trx
197 (p_item_type IN VARCHAR2,
198 p_item_key IN VARCHAR2,
199 p_actid IN NUMBER,
200 p_funcmode IN VARCHAR2,
201 p_result OUT NOCOPY VARCHAR2); --Bug: 4537865
202
203 PROCEDURE Set_Submitter_User_Name
204 (p_item_type IN VARCHAR2,
205 p_item_key IN VARCHAR2,
206 p_actid IN NUMBER,
207 p_funcmode IN VARCHAR2,
208 p_result OUT NOCOPY VARCHAR2); --Bug: 4537865
209
210 END;
211