eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AMW_SCOPE_PVT dependencies on AMW_AUDIT_PROJECTS

Line 1564: SELECT 'Y' FROM AMW_AUDIT_PROJECTS

1560: x_msg_count OUT nocopy NUMBER,
1561: x_msg_data OUT nocopy VARCHAR2
1562: ) IS
1563: CURSOR c_project IS
1564: SELECT 'Y' FROM AMW_AUDIT_PROJECTS
1565: WHERE audit_project_id = p_audit_project_id
1566: FOR UPDATE nowait;
1567:
1568: CURSOR c_project_scope_org IS

Line 1910: amw_audit_projects_v pp,

1906: FROM amw_ap_associations apa,
1907: amw_audit_procedures_b aapb,
1908: amw_ap_tasks apt,
1909: amw_control_associations aca,
1910: amw_audit_projects_v pp,
1911: amw_audit_tasks_v pt1,
1912: amw_audit_tasks_v pt2
1913: WHERE apa.object_type = 'CTRL_ORG'
1914: AND aca.object_type='PROJECT'

Line 1983: amw_audit_projects_v pp,

1979: FROM amw_ap_associations apa,
1980: amw_audit_procedures_b aapb,
1981: amw_ap_tasks apt,
1982: amw_control_associations aca,
1983: amw_audit_projects_v pp,
1984: amw_template_tasks_v pt1,
1985: amw_audit_tasks_v pt2
1986: WHERE apa.object_type = 'CTRL_ORG'
1987: AND aca.object_type='PROJECT'

Line 2307: amw_audit_projects_v pp,

2303: FROM amw_ap_associations apa,
2304: amw_audit_procedures_b aapb,
2305: amw_ap_tasks apt,
2306: amw_control_associations aca,
2307: amw_audit_projects_v pp,
2308: amw_audit_tasks_v pt1,
2309: amw_audit_tasks_v pt2
2310: WHERE apa.object_type = 'ENTITY_AP'
2311: AND aca.object_type='PROJECT'

Line 2378: amw_audit_projects_v pp,

2374: FROM amw_ap_associations apa,
2375: amw_audit_procedures_b aapb,
2376: amw_ap_tasks apt,
2377: amw_control_associations aca,
2378: amw_audit_projects_v pp,
2379: amw_template_tasks_v pt1,
2380: amw_audit_tasks_v pt2
2381: WHERE apa.object_type = 'ENTITY_AP'
2382: AND aca.object_type='PROJECT'

Line 2505: UPDATE AMW_AUDIT_PROJECTS

2501: WHERE entity_type='PROJECT'
2502: AND entity_id=p_audit_project_id
2503: AND SCOPE_CHANGED_STATUS = 'C';
2504:
2505: UPDATE AMW_AUDIT_PROJECTS
2506: SET scope_changed_flag = 'N'
2507: WHERE project_id = p_audit_project_id;
2508:
2509:

Line 3636: --Step 6: Mark relevant rows in AMW_AUDIT_PROJECTS

3632: AND NVL(lob_vs, 'AMW_NULL_CODE') = NVL(p_lob_vs, NVL(lob_vs, 'AMW_NULL_CODE'))
3633: AND NVL(lob_code, 'AMW_NULL_CODE') = NVL(p_lob_code, NVL(lob_code, 'AMW_NULL_CODE'))
3634: AND NVL(organization_id, -999) = NVL(p_organization_id, NVL(organization_id, -999));
3635:
3636: --Step 6: Mark relevant rows in AMW_AUDIT_PROJECTS
3637: IF p_entity_type = 'PROJECT'
3638: THEN
3639: UPDATE amw_audit_projects
3640: SET SCOPE_CHANGED_FLAG = 'Y'

Line 3639: UPDATE amw_audit_projects

3635:
3636: --Step 6: Mark relevant rows in AMW_AUDIT_PROJECTS
3637: IF p_entity_type = 'PROJECT'
3638: THEN
3639: UPDATE amw_audit_projects
3640: SET SCOPE_CHANGED_FLAG = 'Y'
3641: WHERE project_id = p_entity_id;
3642: END IF;
3643: