APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on PA_PROJECTS_ALL

Line 318: from pa_projects_all ppa,

314:
315: select AMW_AUDIT_PROJECTS_S.nextval into l_audit_project_id FROM DUAL;
316:
317: select typ.work_type_id into l_engagement_type_id
318: from pa_projects_all ppa,
319: amw_work_types_b typ,
320: pa_project_types_all pt
321: where ppa.project_id = p_project_id
322: and ppa.project_type = pt.project_type

Line 542: l_created_from_project_id pa_projects_all.created_from_project_id%TYPE;

538: l_data VARCHAR2(2000);
539: l_msg_index_out NUMBER;
540:
541: l_return_status VARCHAR2(1);
542: l_created_from_project_id pa_projects_all.created_from_project_id%TYPE;
543: l_project_status pa_projects_all.project_status_code%TYPE;
544: l_project_number pa_projects_all.segment1%TYPE;
545: l_project_name pa_projects_all.name%TYPE;
546:

Line 543: l_project_status pa_projects_all.project_status_code%TYPE;

539: l_msg_index_out NUMBER;
540:
541: l_return_status VARCHAR2(1);
542: l_created_from_project_id pa_projects_all.created_from_project_id%TYPE;
543: l_project_status pa_projects_all.project_status_code%TYPE;
544: l_project_number pa_projects_all.segment1%TYPE;
545: l_project_name pa_projects_all.name%TYPE;
546:
547:

Line 544: l_project_number pa_projects_all.segment1%TYPE;

540:
541: l_return_status VARCHAR2(1);
542: l_created_from_project_id pa_projects_all.created_from_project_id%TYPE;
543: l_project_status pa_projects_all.project_status_code%TYPE;
544: l_project_number pa_projects_all.segment1%TYPE;
545: l_project_name pa_projects_all.name%TYPE;
546:
547:
548: BEGIN

Line 545: l_project_name pa_projects_all.name%TYPE;

541: l_return_status VARCHAR2(1);
542: l_created_from_project_id pa_projects_all.created_from_project_id%TYPE;
543: l_project_status pa_projects_all.project_status_code%TYPE;
544: l_project_number pa_projects_all.segment1%TYPE;
545: l_project_name pa_projects_all.name%TYPE;
546:
547:
548: BEGIN
549:

Line 552: from pa_projects_all

548: BEGIN
549:
550: select created_from_project_id, project_status_code, segment1, name
551: into l_created_from_project_id, l_project_status, l_project_number, l_project_name
552: from pa_projects_all
553: where project_id = p_project_id;
554:
555: -- IF p_project_manager IS NOT NULL THEN
556: -- l_key_members(1).person_id := p_project_manager;

Line 684: from pa_projects_all

680: p_msg_data => l_msg_data,
681: p_return_status => l_return_status);
682:
683: select segment1,pm_project_reference into l_prj_number,l_prj_ref
684: from pa_projects_all
685: where project_id = p_project_id;
686:
687: FND_MSG_PUB.initialize;
688:

Line 774: from pa_projects_all

770: p_msg_data => l_msg_data,
771: p_return_status => l_return_status);
772:
773: select segment1,pm_project_reference into l_prj_number,l_prj_ref
774: from pa_projects_all
775: where project_id = p_project_id;
776:
777: FND_MSG_PUB.initialize;
778:

Line 859: from pa_projects_all

855: p_msg_data => l_msg_data,
856: p_return_status => l_return_status);
857:
858: select segment1,pm_project_reference into l_prj_number,l_prj_ref
859: from pa_projects_all
860: where project_id = p_project_id;
861:
862: select task_number into l_task_number
863: from pa_tasks