eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

6:
7: PROCEDURE Create_Staffed_Assignment
8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
21: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: )

Line 32: l_new_open_asgn_id pa_project_assignments.assignment_id%TYPE;

28: l_schedule_basis_flag VARCHAR2(1);
29: l_msg_count NUMBER;
30: l_msg_data VARCHAR2(2000);
31: l_new_open_asgn_count NUMBER := 0;
32: l_new_open_asgn_id pa_project_assignments.assignment_id%TYPE;
33: l_new_open_asgn_number pa_project_assignments.assignment_number%TYPE;
34: l_new_open_asgn_row_id ROWID;
35: l_return_status VARCHAR2(1);
36: l_ret_code VARCHAR2(1);

Line 33: l_new_open_asgn_number pa_project_assignments.assignment_number%TYPE;

29: l_msg_count NUMBER;
30: l_msg_data VARCHAR2(2000);
31: l_new_open_asgn_count NUMBER := 0;
32: l_new_open_asgn_id pa_project_assignments.assignment_id%TYPE;
33: l_new_open_asgn_number pa_project_assignments.assignment_number%TYPE;
34: l_new_open_asgn_row_id ROWID;
35: l_return_status VARCHAR2(1);
36: l_ret_code VARCHAR2(1);
37: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;

Line 76: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;

72: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
73: l_resource_organization_id NUMBER;
74:
75: l_person_id_tmp NUMBER;
76: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
77: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
78: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
79: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
80: l_person_type_code Varchar2(30);

Line 77: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;

73: l_resource_organization_id NUMBER;
74:
75: l_person_id_tmp NUMBER;
76: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
77: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
78: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
79: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
80: l_person_type_code Varchar2(30);
81: l_future_dated_emp Varchar2(1);

Line 78: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;

74:
75: l_person_id_tmp NUMBER;
76: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
77: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
78: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
79: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
80: l_person_type_code Varchar2(30);
81: l_future_dated_emp Varchar2(1);
82: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL; -- Added for Bug 6056112

Line 79: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

75: l_person_id_tmp NUMBER;
76: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
77: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
78: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
79: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
80: l_person_type_code Varchar2(30);
81: l_future_dated_emp Varchar2(1);
82: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL; -- Added for Bug 6056112
83:

Line 167: l_expenditure_type_tmp1 pa_project_assignments.expenditure_type%TYPE;

163: AND effective_start_date <= sysdate
164: AND rownum = 1;
165:
166: -- 5130421 : Added the following variables
167: l_expenditure_type_tmp1 pa_project_assignments.expenditure_type%TYPE;
168: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
169: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
170: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
171: -- 5130421 : End

Line 168: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;

164: AND rownum = 1;
165:
166: -- 5130421 : Added the following variables
167: l_expenditure_type_tmp1 pa_project_assignments.expenditure_type%TYPE;
168: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
169: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
170: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
171: -- 5130421 : End
172:

Line 169: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;

165:
166: -- 5130421 : Added the following variables
167: l_expenditure_type_tmp1 pa_project_assignments.expenditure_type%TYPE;
168: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
169: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
170: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
171: -- 5130421 : End
172:
173: BEGIN

Line 170: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;

166: -- 5130421 : Added the following variables
167: l_expenditure_type_tmp1 pa_project_assignments.expenditure_type%TYPE;
168: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
169: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
170: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
171: -- 5130421 : End
172:
173: BEGIN
174:

Line 927: PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row

923: --RESET the global variable after usage
924: PA_STAFFED_ASSIGNMENT_PVT.G_AUTO_APPROVE := NULL;
925: --End 5130421
926:
927: PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row
928: (p_assignment_name => l_assignment_rec.assignment_name
929: ,p_assignment_type => l_assignment_rec.assignment_type
930: ,p_multiple_status_flag => l_assignment_rec.multiple_status_flag
931: ,p_status_code => l_assignment_rec.status_code

Line 1234: l_new_status_code pa_project_assignments.status_code%TYPE ;

1230: ) IS
1231:
1232: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
1233: -- added for Bug: 4537865
1234: l_new_status_code pa_project_assignments.status_code%TYPE ;
1235:
1236: -- added for Bug: 4537865
1237: l_old_status_code pa_project_assignments.status_code%TYPE;
1238: l_old_start_date pa_project_assignments.start_date%TYPE;

Line 1237: l_old_status_code pa_project_assignments.status_code%TYPE;

1233: -- added for Bug: 4537865
1234: l_new_status_code pa_project_assignments.status_code%TYPE ;
1235:
1236: -- added for Bug: 4537865
1237: l_old_status_code pa_project_assignments.status_code%TYPE;
1238: l_old_start_date pa_project_assignments.start_date%TYPE;
1239: l_old_end_date pa_project_assignments.end_date%TYPE;
1240: l_return_status VARCHAR2(1);
1241: l_msg_count NUMBER;

Line 1238: l_old_start_date pa_project_assignments.start_date%TYPE;

1234: l_new_status_code pa_project_assignments.status_code%TYPE ;
1235:
1236: -- added for Bug: 4537865
1237: l_old_status_code pa_project_assignments.status_code%TYPE;
1238: l_old_start_date pa_project_assignments.start_date%TYPE;
1239: l_old_end_date pa_project_assignments.end_date%TYPE;
1240: l_return_status VARCHAR2(1);
1241: l_msg_count NUMBER;
1242: l_msg_data VARCHAR2(2000);

Line 1239: l_old_end_date pa_project_assignments.end_date%TYPE;

1235:
1236: -- added for Bug: 4537865
1237: l_old_status_code pa_project_assignments.status_code%TYPE;
1238: l_old_start_date pa_project_assignments.start_date%TYPE;
1239: l_old_end_date pa_project_assignments.end_date%TYPE;
1240: l_return_status VARCHAR2(1);
1241: l_msg_count NUMBER;
1242: l_msg_data VARCHAR2(2000);
1243: l_change_id NUMBER;

Line 1261: l_cur_resource_id pa_project_assignments.resource_id%TYPE;

1257: l_last_struct_version_id NUMBER;
1258: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1259: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1260:
1261: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1264: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;

Line 1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;

1258: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1259: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1260:
1261: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1264: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1266: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;

Line 1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;

1259: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1260:
1261: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1264: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1266: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1267: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

Line 1264: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;

1260:
1261: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1264: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1266: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1267: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1268: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;

Line 1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;

1261: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1264: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1266: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1267: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1268: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1269: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;

Line 1266: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;

1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1264: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1266: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1267: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1268: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1269: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1270:

Line 1267: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1264: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1266: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1267: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1268: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1269: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1270:
1271: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;

Line 1269: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;

1265: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1266: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1267: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1268: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1269: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1270:
1271: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1272: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1273: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;

Line 1317: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;

1313:
1314: l_resource_organization_id NUMBER;
1315:
1316: l_person_id_tmp NUMBER;
1317: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1318: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1319: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1320: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1321: l_person_type_code Varchar2(30);

Line 1318: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;

1314: l_resource_organization_id NUMBER;
1315:
1316: l_person_id_tmp NUMBER;
1317: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1318: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1319: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1320: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1321: l_person_type_code Varchar2(30);
1322: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112

Line 1319: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;

1315:
1316: l_person_id_tmp NUMBER;
1317: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1318: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1319: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1320: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1321: l_person_type_code Varchar2(30);
1322: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112
1323:

Line 1320: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

1316: l_person_id_tmp NUMBER;
1317: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1318: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1319: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1320: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1321: l_person_type_code Varchar2(30);
1322: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112
1323:
1324: CURSOR assignment_status_code_csr

Line 1327: FROM pa_project_assignments

1323:
1324: CURSOR assignment_status_code_csr
1325: IS
1326: SELECT status_code, start_date, end_date
1327: FROM pa_project_assignments
1328: WHERE assignment_id = p_assignment_rec.assignment_id;
1329:
1330: CURSOR get_unlinked_res_asgmts IS
1331: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id

Line 1413: FROM pa_project_assignments

1409: expenditure_type,
1410: project_role_id, assignment_name,
1411: resource_list_member_id,
1412: project_role_id
1413: FROM pa_project_assignments
1414: WHERE assignment_id = l_assignment_rec.assignment_id;
1415:
1416: -- get the resource's organization in HR
1417: CURSOR get_resource_organization IS

Line 1626: FROM per_all_assignments_f assn, pa_project_assignments pa

1622: ELSE --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
1623:
1624: SELECT job_id
1625: INTO l_fcst_job_id_tmp
1626: FROM per_all_assignments_f assn, pa_project_assignments pa
1627: WHERE assn.person_id = l_person_id_tmp
1628: AND pa.assignment_id = l_assignment_rec.assignment_id
1629: AND pa.start_date BETWEEN assn.effective_start_date
1630: AND assn.effective_end_date

Line 1642: FROM per_all_people_f peo, pa_project_assignments pa

1638: END IF;
1639:
1640: SELECT decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK')
1641: INTO l_person_type_code
1642: FROM per_all_people_f peo, pa_project_assignments pa
1643: WHERE peo.person_id = l_person_id_tmp
1644: AND pa.assignment_id = l_assignment_rec.assignment_id
1645: AND pa.start_date BETWEEN peo.effective_start_date
1646: AND peo.effective_end_date

Line 2032: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

2028: ,x_msg => 'Update Assignment Record.'
2029: ,x_log_level => 5);
2030: END IF;
2031:
2032: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
2033: (p_assignment_row_id => l_assignment_rec.assignment_row_id
2034: ,p_assignment_id => l_assignment_rec.assignment_id
2035: ,p_record_version_number => l_assignment_rec.record_version_number
2036: ,p_assignment_name => l_assignment_rec.assignment_name

Line 2123: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM

2119:
2120:
2121: PROCEDURE Delete_Staffed_Assignment
2122: ( p_assignment_row_id IN ROWID --(Bug-1851096)
2123: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
2124: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
2125: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
2126: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
2127: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 2143: FROM pa_project_assignments asgn,

2139: l_person_id NUMBER;
2140:
2141: CURSOR get_start_end_date IS
2142: SELECT asgn.start_date, asgn.end_date, asgn.project_id, res.person_id
2143: FROM pa_project_assignments asgn,
2144: pa_resources_denorm res
2145: WHERE assignment_id = p_assignment_id
2146: AND res.resource_id = asgn.resource_id
2147: AND rownum=1;

Line 2216: PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row

2212: ,x_log_level => 5);
2213: END IF;
2214:
2215: -- Delete the master record
2216: PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row
2217: ( p_assignment_row_id => p_assignment_row_id
2218: ,p_assignment_id => p_assignment_id
2219: ,p_record_version_number => p_record_version_number
2220: ,x_return_status => x_return_status