APPS.PA_XC_PROJECT_PUB dependencies on PA_PROJECTS

Line 486: l_dummy pa_projects_all.name%TYPE;

482: l_project_reference VARCHAR2(25);
483: l_project_mpx_start_date DATE;
484: l_project_mpx_end_date DATE;
485:
486: l_dummy pa_projects_all.name%TYPE;
487:
488: l_err_code NUMBER := 0;
489: l_err_stage VARCHAR2(2000);
490: l_err_stack VARCHAR2(2000);

Line 515: FROM pa_projects

511: -- needed to get the field values associated to a particular Project_id
512: CURSOR l_get_project_csr (p_project_id NUMBER)
513: IS
514: SELECT name
515: FROM pa_projects
516: WHERE project_id = p_project_id;
517:
518: -- Fix for Bug # 4513291. Commented below cusror and added new
519: /*

Line 557: FROM PA_PROJECTS_ALL

553: -- project simultaneously
554: CURSOR lock_project_record (c_project_id NUMBER)
555: IS
556: SELECT name
557: FROM PA_PROJECTS_ALL
558: WHERE project_id = c_project_id
559: FOR UPDATE of name NOWAIT;
560:
561: l_org_id NUMBER;

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

680: -- 4363092 MOAC Changes, Added cursor to retrieve
681: -- operating unit id of the project
682: CURSOR proj_ou_id_csr
683: IS
684: select org_id from pa_projects_all where project_id = p_project_id;
685:
686: BEGIN
687: -- Fix for Bug # 4513291. Added Debug.write calls instead of debug.debug
688: IF p_debug_mode = 'Y' THEN

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

896: --Sakthi
897: -- Need to remove after Omkar able to take care this portion of code in Java.
898: BEGIN
899:
900: select org_id into l_org_id from pa_projects_all where project_id = p_project_id;
901: dbms_application_info.set_client_info(l_org_id);
902:
903: EXCEPTION
904: WHEN OTHERS THEN

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

953: end if;
954:
955: CLOSE lock_project_record;
956: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
957: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
958: FND_MESSAGE.Set_token('PROJECT',to_char(p_project_id));
959: FND_MESSAGE.Set_token('TASK',NULL);
960: x_msg_count := x_msg_count + 1;
961: x_msg_data.extend(1);

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

1259: end if;
1260:
1261: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1262: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
1263: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
1264: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
1265: FND_MESSAGE.Set_token('TASK',NULL);
1266: x_msg_count := x_msg_count + 1;
1267: x_msg_data.extend(1);