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 958: PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row

954: --RESET the global variable after usage
955: PA_STAFFED_ASSIGNMENT_PVT.G_AUTO_APPROVE := NULL;
956: --End 5130421
957:
958: PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row
959: (p_assignment_name => l_assignment_rec.assignment_name
960: ,p_assignment_type => l_assignment_rec.assignment_type
961: ,p_multiple_status_flag => l_assignment_rec.multiple_status_flag
962: ,p_status_code => l_assignment_rec.status_code

Line 1265: l_new_status_code pa_project_assignments.status_code%TYPE ;

1261: ) IS
1262:
1263: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
1264: -- added for Bug: 4537865
1265: l_new_status_code pa_project_assignments.status_code%TYPE ;
1266:
1267: -- added for Bug: 4537865
1268: l_old_status_code pa_project_assignments.status_code%TYPE;
1269: l_old_start_date pa_project_assignments.start_date%TYPE;

Line 1268: l_old_status_code pa_project_assignments.status_code%TYPE;

1264: -- added for Bug: 4537865
1265: l_new_status_code pa_project_assignments.status_code%TYPE ;
1266:
1267: -- added for Bug: 4537865
1268: l_old_status_code pa_project_assignments.status_code%TYPE;
1269: l_old_start_date pa_project_assignments.start_date%TYPE;
1270: l_old_end_date pa_project_assignments.end_date%TYPE;
1271: l_return_status VARCHAR2(1);
1272: l_msg_count NUMBER;

Line 1269: l_old_start_date pa_project_assignments.start_date%TYPE;

1265: l_new_status_code pa_project_assignments.status_code%TYPE ;
1266:
1267: -- added for Bug: 4537865
1268: l_old_status_code pa_project_assignments.status_code%TYPE;
1269: l_old_start_date pa_project_assignments.start_date%TYPE;
1270: l_old_end_date pa_project_assignments.end_date%TYPE;
1271: l_return_status VARCHAR2(1);
1272: l_msg_count NUMBER;
1273: l_msg_data VARCHAR2(2000);

Line 1270: l_old_end_date pa_project_assignments.end_date%TYPE;

1266:
1267: -- added for Bug: 4537865
1268: l_old_status_code pa_project_assignments.status_code%TYPE;
1269: l_old_start_date pa_project_assignments.start_date%TYPE;
1270: l_old_end_date pa_project_assignments.end_date%TYPE;
1271: l_return_status VARCHAR2(1);
1272: l_msg_count NUMBER;
1273: l_msg_data VARCHAR2(2000);
1274: l_change_id NUMBER;

Line 1292: l_cur_resource_id pa_project_assignments.resource_id%TYPE;

1288: l_last_struct_version_id NUMBER;
1289: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1290: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1291:
1292: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1293: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1294: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;

Line 1293: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;

1289: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1290: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1291:
1292: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1293: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1294: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;

Line 1294: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;

1290: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1291:
1292: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1293: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1294: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

Line 1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;

1291:
1292: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1293: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1294: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;

Line 1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;

1292: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1293: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1294: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;

Line 1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;

1293: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1294: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1301:

Line 1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

1294: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1301:
1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;

Line 1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;

1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1301:
1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1303: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1304: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;

Line 1348: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;

1344:
1345: l_resource_organization_id NUMBER;
1346:
1347: l_person_id_tmp NUMBER;
1348: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1349: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1350: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1351: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1352: l_person_type_code Varchar2(30);

Line 1349: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;

1345: l_resource_organization_id NUMBER;
1346:
1347: l_person_id_tmp NUMBER;
1348: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1349: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1350: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1351: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1352: l_person_type_code Varchar2(30);
1353: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112

Line 1350: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;

1346:
1347: l_person_id_tmp NUMBER;
1348: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1349: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1350: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1351: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1352: l_person_type_code Varchar2(30);
1353: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112
1354:

Line 1351: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

1347: l_person_id_tmp NUMBER;
1348: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1349: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1350: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1351: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1352: l_person_type_code Varchar2(30);
1353: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112
1354:
1355: CURSOR assignment_status_code_csr

Line 1358: FROM pa_project_assignments

1354:
1355: CURSOR assignment_status_code_csr
1356: IS
1357: SELECT status_code, start_date, end_date
1358: FROM pa_project_assignments
1359: WHERE assignment_id = p_assignment_rec.assignment_id;
1360:
1361: CURSOR get_unlinked_res_asgmts IS
1362: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id

Line 1444: FROM pa_project_assignments

1440: expenditure_type,
1441: project_role_id, assignment_name,
1442: resource_list_member_id,
1443: project_role_id
1444: FROM pa_project_assignments
1445: WHERE assignment_id = l_assignment_rec.assignment_id;
1446:
1447: -- get the resource's organization in HR
1448: CURSOR get_resource_organization IS

Line 1657: FROM per_all_assignments_f assn, pa_project_assignments pa

1653: ELSE --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
1654:
1655: SELECT job_id
1656: INTO l_fcst_job_id_tmp
1657: FROM per_all_assignments_f assn, pa_project_assignments pa
1658: WHERE assn.person_id = l_person_id_tmp
1659: AND pa.assignment_id = l_assignment_rec.assignment_id
1660: AND pa.start_date BETWEEN assn.effective_start_date
1661: AND assn.effective_end_date

Line 1673: FROM per_all_people_f peo, pa_project_assignments pa

1669: END IF;
1670:
1671: SELECT decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK')
1672: INTO l_person_type_code
1673: FROM per_all_people_f peo, pa_project_assignments pa
1674: WHERE peo.person_id = l_person_id_tmp
1675: AND pa.assignment_id = l_assignment_rec.assignment_id
1676: AND pa.start_date BETWEEN peo.effective_start_date
1677: AND peo.effective_end_date

Line 2069: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

2065: ,x_msg => 'Update Assignment Record.'
2066: ,x_log_level => 5);
2067: END IF;
2068:
2069: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
2070: (p_assignment_row_id => l_assignment_rec.assignment_row_id
2071: ,p_assignment_id => l_assignment_rec.assignment_id
2072: ,p_record_version_number => l_assignment_rec.record_version_number
2073: ,p_assignment_name => l_assignment_rec.assignment_name

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

2156:
2157:
2158: PROCEDURE Delete_Staffed_Assignment
2159: ( p_assignment_row_id IN ROWID --(Bug-1851096)
2160: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
2161: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
2162: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
2163: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
2164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 2180: FROM pa_project_assignments asgn,

2176: l_person_id NUMBER;
2177:
2178: CURSOR get_start_end_date IS
2179: SELECT asgn.start_date, asgn.end_date, asgn.project_id, res.person_id
2180: FROM pa_project_assignments asgn,
2181: pa_resources_denorm res
2182: WHERE assignment_id = p_assignment_id
2183: AND res.resource_id = asgn.resource_id
2184: AND rownum=1;

Line 2253: PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row

2249: ,x_log_level => 5);
2250: END IF;
2251:
2252: -- Delete the master record
2253: PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row
2254: ( p_assignment_row_id => p_assignment_row_id
2255: ,p_assignment_id => p_assignment_id
2256: ,p_record_version_number => p_record_version_number
2257: ,x_return_status => x_return_status