DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_ASSIGNMENTS_PUB

Line 669: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;

665: )
666:
667: IS
668:
669: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
670: l_change_id NUMBER;
671: l_record_version_number NUMBER;
672: l_return_status VARCHAR2(1);
673: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

Line 1190: l_asmt_history_rec pa_assignments_pub.assignment_rec_type;

1186: l_return_status VARCHAR2(1);
1187: l_msg_count NUMBER;
1188: l_msg_data VARCHAR2(2000);
1189: l_changed_item pa_lookups.meaning%TYPE;
1190: l_asmt_history_rec pa_assignments_pub.assignment_rec_type;
1191: l_saved_asmt_rec pa_assignments_pub.assignment_rec_type;
1192: l_updated_asmt_rec pa_assignments_pub.assignment_rec_type;
1193:
1194: CURSOR get_rec_ver_num IS

Line 1191: l_saved_asmt_rec pa_assignments_pub.assignment_rec_type;

1187: l_msg_count NUMBER;
1188: l_msg_data VARCHAR2(2000);
1189: l_changed_item pa_lookups.meaning%TYPE;
1190: l_asmt_history_rec pa_assignments_pub.assignment_rec_type;
1191: l_saved_asmt_rec pa_assignments_pub.assignment_rec_type;
1192: l_updated_asmt_rec pa_assignments_pub.assignment_rec_type;
1193:
1194: CURSOR get_rec_ver_num IS
1195: SELECT record_version_number

Line 1192: l_updated_asmt_rec pa_assignments_pub.assignment_rec_type;

1188: l_msg_data VARCHAR2(2000);
1189: l_changed_item pa_lookups.meaning%TYPE;
1190: l_asmt_history_rec pa_assignments_pub.assignment_rec_type;
1191: l_saved_asmt_rec pa_assignments_pub.assignment_rec_type;
1192: l_updated_asmt_rec pa_assignments_pub.assignment_rec_type;
1193:
1194: CURSOR get_rec_ver_num IS
1195: SELECT record_version_number
1196: FROM pa_project_assignments

Line 1725: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;

1721: ,x_log_level => 5);
1722: END IF;
1723:
1724: -- Initialize the error flag
1725: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;
1726:
1727: -- Issue API savepoint if the transaction is to be committed
1728: IF p_commit = FND_API.G_TRUE THEN
1729: SAVEPOINT ASG_PUB_CHANGE_STATUS;

Line 1747: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1743: IF check_record_version%NOTFOUND THEN
1744:
1745: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1746: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
1747: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1748:
1749: ELSE
1750:
1751: l_record_version_number := p_record_version_number;

Line 1945: PA_ASSIGNMENTS_PUB.Copy_Team_Role (p_assignment_id => l_source_assignment_id

1941: --dbms_output.put_line('Reopen requirement now');
1942:
1943:
1944: --create a new requirement for canceled assignment
1945: PA_ASSIGNMENTS_PUB.Copy_Team_Role (p_assignment_id => l_source_assignment_id
1946: ,p_asgn_creation_mode => 'COPY' ---Fix for Bug 6169205
1947: ,x_new_assignment_id => l_new_assignment_id
1948: ,x_assignment_number => l_assignment_number
1949: ,x_assignment_row_id => l_assignment_row_id