APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_AUDIT_PROJECTS

Line 54: from amw_audit_projects

50: | For PA , the tasks are copied in PA. |
51: +---------------------------------------------------*/
52: BEGIN
53: select 'ICM' into l_source
54: from amw_audit_projects
55: where audit_project_id = p_source_entity_id
56: and project_id is null;
57: EXCEPTION
58: WHEN no_data_found THEN

Line 315: select AMW_AUDIT_PROJECTS_S.nextval into l_audit_project_id FROM DUAL;

311:
312: BEGIN
313:
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,

Line 325: INSERT INTO AMW_AUDIT_PROJECTS (

321: where ppa.project_id = p_project_id
322: and ppa.project_type = pt.project_type
323: and pt.project_type_id = typ.project_type_id;
324:
325: INSERT INTO AMW_AUDIT_PROJECTS (
326: AUDIT_PROJECT_ID,
327: PROJECT_ID,
328: ENGAGEMENT_TYPE_ID,
329: AUDIT_PROJECT_STATUS,

Line 352: FROM AMW_AUDIT_PROJECTS

348: FND_GLOBAL.USER_ID,
349: 1
350: FROM dual
351: WHERE not exists (SELECT 'Y'
352: FROM AMW_AUDIT_PROJECTS
353: WHERE PROJECT_ID = p_project_id);
354:
355: p_audit_project_id := l_audit_project_id ;
356: x_return_status := 'S';

Line 607: UPDATE amw_audit_projects

603: --dbms_output.put_line('status :' || x_return_status);
604:
605: IF x_return_status = 'S' THEN
606: /* Update the status in the icm table */
607: UPDATE amw_audit_projects
608: SET audit_project_status = p_project_status
609: WHERE project_id = p_project_id
610: AND audit_project_status <> p_project_status;
611:

Line 613: UPDATE amw_audit_projects

609: WHERE project_id = p_project_id
610: AND audit_project_status <> p_project_status;
611:
612: /* Update the signOffRequired flag in the icm table */
613: UPDATE amw_audit_projects
614: SET sign_off_required_flag = p_sign_off_required
615: WHERE project_id = p_project_id
616: AND NVL(sign_off_required_flag,'N') <> p_sign_off_required;
617: END IF;