APPS.PA_XC_PROJECT_PUB dependencies on PA_PROJECTS

Line 497: l_dummy pa_projects_all.name%TYPE;

493: l_project_reference VARCHAR2(25);
494: l_project_mpx_start_date DATE;
495: l_project_mpx_end_date DATE;
496:
497: l_dummy pa_projects_all.name%TYPE;
498:
499: l_err_code NUMBER := 0;
500: l_err_stage VARCHAR2(2000);
501: l_err_stack VARCHAR2(2000);

Line 526: FROM pa_projects

522: -- needed to get the field values associated to a particular Project_id
523: CURSOR l_get_project_csr (p_project_id NUMBER)
524: IS
525: SELECT name
526: FROM pa_projects
527: WHERE project_id = p_project_id;
528:
529: -- Fix for Bug # 4513291. Commented below cusror and added new
530: /*

Line 568: FROM PA_PROJECTS_ALL

564: -- project simultaneously
565: CURSOR lock_project_record (c_project_id NUMBER)
566: IS
567: SELECT name
568: FROM PA_PROJECTS_ALL
569: WHERE project_id = c_project_id
570: FOR UPDATE of name NOWAIT;
571:
572: l_org_id NUMBER;

Line 695: select org_id from pa_projects_all where project_id = p_project_id;

691: -- 4363092 MOAC Changes, Added cursor to retrieve
692: -- operating unit id of the project
693: CURSOR proj_ou_id_csr
694: IS
695: select org_id from pa_projects_all where project_id = p_project_id;
696:
697: BEGIN
698: -- Fix for Bug # 4513291. Added Debug.write calls instead of debug.debug
699: IF p_debug_mode = 'Y' THEN

Line 911: select org_id into l_org_id from pa_projects_all where project_id = p_project_id;

907: --Sakthi
908: -- Need to remove after Omkar able to take care this portion of code in Java.
909: BEGIN
910:
911: select org_id into l_org_id from pa_projects_all where project_id = p_project_id;
912: dbms_application_info.set_client_info(l_org_id);
913:
914: EXCEPTION
915: WHEN OTHERS THEN

Line 968: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');

964: end if;
965:
966: CLOSE lock_project_record;
967: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
968: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
969: FND_MESSAGE.Set_token('PROJECT',to_char(p_project_id));
970: FND_MESSAGE.Set_token('TASK',NULL);
971: x_msg_count := x_msg_count + 1;
972: x_msg_data.extend(1);

Line 1274: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');

1270: end if;
1271:
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1273: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
1274: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
1275: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
1276: FND_MESSAGE.Set_token('TASK',NULL);
1277: x_msg_count := x_msg_count + 1;
1278: x_msg_data.extend(1);