APPS.PA_RESOURCE_SETUP_PVT dependencies on PA_PROJECTS

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 67: FROM pa_projects

63: if p_validate_only <> FND_API.G_TRUE then
64: BEGIN
65:
66: SELECT 'x' INTO l_dummy
67: FROM pa_projects
68: WHERE project_id = p_project_id
69: AND record_version_number = p_record_version_number
70: FOR UPDATE OF record_version_number NOWAIT;
71:

Line 102: FROM pa_projects

98: else
99:
100: BEGIN
101: SELECT 'x' INTO l_dummy
102: FROM pa_projects
103: WHERE project_id = p_project_id
104: AND record_version_number = p_record_version_number;
105: EXCEPTION
106: WHEN NO_DATA_FOUND THEN

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)