APPS.PA_RESOURCE_SETUP_PVT dependencies on PA_PROJECTS_ALL

Line 38: l_record_version_number PA_PROJECTS_ALL.RECORD_VERSION_NUMBER%TYPE;

34: l_msg_count NUMBER;
35: l_msg_data VARCHAR2(250);
36: l_data VARCHAR2(250);
37: l_msg_index_out NUMBER;
38: l_record_version_number PA_PROJECTS_ALL.RECORD_VERSION_NUMBER%TYPE;
39: l_dummy VARCHAR2(1);
40: l_debug_mode VARCHAR2(10);
41:
42: BEGIN

Line 136: UPDATE pa_projects_all

132:
133: IF NOT FND_API.TO_BOOLEAN(p_validate_only) THEN
134:
135: -- update the project table
136: UPDATE pa_projects_all
137: SET record_version_number = record_version_number + 1
138: ,calendar_id = decode(p_calendar_id, FND_API.G_MISS_NUM, calendar_id, p_calendar_id)
139: ,role_list_id = decode(p_role_list_id, FND_API.G_MISS_NUM, role_list_id, p_role_list_id)
140: ,adv_action_set_id = decode(p_adv_action_set_id, FND_API.G_MISS_NUM, adv_action_set_id, p_adv_action_set_id)