[Home] [Help]
PACKAGE: APPS.PA_ASSIGNMENTS_HISTORY_PKG
Source
1 PACKAGE PA_ASSIGNMENTS_HISTORY_PKG AS
2 /*$Header: PARAAPKS.pls 120.1 2005/08/19 16:47:06 mwasowic noship $*/
3
4 PROCEDURE Insert_Row
5 ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6 ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7 ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8 ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9 ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10 ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11 ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12 ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13 ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14 ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15 ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16 ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17 ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18 ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19 ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20 ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21 ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22 ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23 ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24 ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25 ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26 ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27 ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28 ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29 ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30 ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31 ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32 ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33 ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34 ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35 ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36 ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37 ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38 ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39 ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40 ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41 ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42 ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43 ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44 ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45 ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46 ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47 ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48 ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49 ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50 ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51 ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52 ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53 ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54 ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55 ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56 ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57 ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58 ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59 ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60 ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61 ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62 ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63 ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64 ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65 ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66 ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67 ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68 ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69 ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70 ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71 ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72 ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73 ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74 ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75 ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76 ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77 ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78 ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79 ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80 ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81 ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82 ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83 ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84 ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85 ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86 /* Added 2 columns for 3051110 */
87 ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88 ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89 /* Added 2 columns for 3041583 */
90 ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
91 ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
92 ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
93 ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
94 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95 );
96
97
98 PROCEDURE Update_Row
99 ( p_assignment_row_id IN ROWID :=NULL
100 ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
101 ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
102 ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
103 ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
104 ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
105 ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
106 ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107 ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108 ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109 ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110 ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111 ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112 ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113 ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114 ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115 ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116 ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117 ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118 ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119 ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120 ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121 ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122 ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123 ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124 ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125 ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126 ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127 ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128 ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129 ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130 ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131 ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132 ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133 ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134 ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135 ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136 ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137 ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138 ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139 ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140 ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141 ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142 ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143 ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144 ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145 ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146 ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147 ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148 ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149 ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150 ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151 ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152 ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153 ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154 ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155 ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156 ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157 ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158 ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
159 ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
160 ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
161 ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
165 /* Added 2 columns for 3041583 */
162 /* Added 2 columns for 3051110 */
163 ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
164 ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
166 ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
167 ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
168 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
169 );
170
171
172 PROCEDURE Delete_Row
173 ( p_assignment_row_id IN ROWID := NULL
174 ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
175 ,p_change_id IN pa_assignments_history.change_id%TYPE := NULL
176 ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := NULL
177 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
178 );
179
180
181 PROCEDURE Delete_By_Assignment
182 ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE
183 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
184 );
185
186 END PA_ASSIGNMENTS_HISTORY_PKG;