APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_EXECUTION_SCOPE

Line 40: from amw_execution_scope

36: BEGIN
37: select 'Y' into l_scope_exits
38: from dual
39: where exists ( select 1
40: from amw_execution_scope
41: where entity_type = 'PROJECT'
42: and entity_id = p_source_entity_id);
43: EXCEPTION
44: WHEN no_data_found THEN

Line 68: INSERT INTO AMW_EXECUTION_SCOPE (

64:
65: THEN
66: COPY_SCOPE_INEFF_CONTROLS(p_source_entity_id,p_target_entity_id,x_return_status);
67: ElSE
68: INSERT INTO AMW_EXECUTION_SCOPE (
69: EXECUTION_SCOPE_ID,
70: ENTITY_TYPE,
71: ENTITY_ID,
72: CREATED_BY,

Line 88: SELECT amw_execution_scope_s.nextval,

84: PROCESS_ID,
85: PROCESS_ORG_REV_ID,
86: TOP_PROCESS_ID,
87: PARENT_PROCESS_ID)
88: SELECT amw_execution_scope_s.nextval,
89: 'PROJECT',
90: p_target_entity_id,
91: FND_GLOBAL.USER_ID,
92: SYSDATE,

Line 107: FROM AMW_EXECUTION_SCOPE

103: PROCESS_ID,
104: PROCESS_ORG_REV_ID,
105: TOP_PROCESS_ID,
106: PARENT_PROCESS_ID
107: FROM AMW_EXECUTION_SCOPE
108: WHERE ENTITY_TYPE = 'PROJECT'
109: AND ENTITY_ID = p_source_entity_id;
110: END IF;
111:

Line 1737: INSERT INTO AMW_EXECUTION_SCOPE (

1733: l_audit_project_id NUMBER;
1734: BEGIN
1735:
1736:
1737: INSERT INTO AMW_EXECUTION_SCOPE (
1738: EXECUTION_SCOPE_ID,
1739: ENTITY_TYPE,
1740: ENTITY_ID,
1741: CREATED_BY,

Line 1758: SELECT amw_execution_scope_s.nextval,

1754: PROCESS_ORG_REV_ID,
1755: TOP_PROCESS_ID,
1756: PARENT_PROCESS_ID)
1757:
1758: SELECT amw_execution_scope_s.nextval,
1759: 'PROJECT',
1760: p_target_entity_id,
1761: FND_GLOBAL.USER_ID,
1762: SYSDATE,

Line 1777: FROM AMW_EXECUTION_SCOPE aes

1773: PROCESS_ID,
1774: PROCESS_ORG_REV_ID,
1775: TOP_PROCESS_ID,
1776: PARENT_PROCESS_ID
1777: FROM AMW_EXECUTION_SCOPE aes
1778: WHERE ENTITY_TYPE = 'PROJECT'
1779: AND ENTITY_ID = p_source_entity_id
1780: AND aes.PROCESS_ID is not null
1781: and exists(

Line 1788: INSERT INTO AMW_EXECUTION_SCOPE (

1784: and audit_result_code ='EFFECTIVE' and
1785: object_name='AMW_ORG_CONTROL') and pk3=aes.PROCESS_ID);
1786:
1787:
1788: INSERT INTO AMW_EXECUTION_SCOPE (
1789: EXECUTION_SCOPE_ID,
1790: ENTITY_TYPE,
1791: ENTITY_ID,
1792: CREATED_BY,

Line 1808: SELECT amw_execution_scope_s.nextval,

1804: PROCESS_ID,
1805: PROCESS_ORG_REV_ID,
1806: TOP_PROCESS_ID,
1807: PARENT_PROCESS_ID)
1808: SELECT amw_execution_scope_s.nextval,
1809: 'PROJECT',
1810: p_target_entity_id,
1811: FND_GLOBAL.USER_ID,
1812: SYSDATE,

Line 1827: FROM AMW_EXECUTION_SCOPE aes

1823: PROCESS_ID,
1824: PROCESS_ORG_REV_ID,
1825: TOP_PROCESS_ID,
1826: PARENT_PROCESS_ID
1827: FROM AMW_EXECUTION_SCOPE aes
1828: WHERE ENTITY_TYPE = 'PROJECT'
1829: AND ENTITY_ID = p_source_entity_id
1830: AND aes.PARENT_PROCESS_ID =-1
1831: AND exists(select 1 from AMW_EXECUTION_SCOPE aes2 where

Line 1831: AND exists(select 1 from AMW_EXECUTION_SCOPE aes2 where

1827: FROM AMW_EXECUTION_SCOPE aes
1828: WHERE ENTITY_TYPE = 'PROJECT'
1829: AND ENTITY_ID = p_source_entity_id
1830: AND aes.PARENT_PROCESS_ID =-1
1831: AND exists(select 1 from AMW_EXECUTION_SCOPE aes2 where
1832: exists (select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'
1833: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id
1834: and audit_result_code ='EFFECTIVE' and
1835: object_name='AMW_ORG_CONTROL') and pk3=aes2.PROCESS_ID) and aes.process_id=aes2.parent_process_id );

Line 1838: INSERT INTO AMW_EXECUTION_SCOPE (

1834: and audit_result_code ='EFFECTIVE' and
1835: object_name='AMW_ORG_CONTROL') and pk3=aes2.PROCESS_ID) and aes.process_id=aes2.parent_process_id );
1836:
1837:
1838: INSERT INTO AMW_EXECUTION_SCOPE (
1839: EXECUTION_SCOPE_ID,
1840: ENTITY_TYPE,
1841: ENTITY_ID,
1842: CREATED_BY,

Line 1858: SELECT amw_execution_scope_s.nextval,

1854: PROCESS_ID,
1855: PROCESS_ORG_REV_ID,
1856: TOP_PROCESS_ID,
1857: PARENT_PROCESS_ID)
1858: SELECT amw_execution_scope_s.nextval,
1859: 'PROJECT',
1860: p_target_entity_id,
1861: FND_GLOBAL.USER_ID,
1862: SYSDATE,

Line 1877: FROM AMW_EXECUTION_SCOPE aes

1873: PROCESS_ID,
1874: PROCESS_ORG_REV_ID,
1875: TOP_PROCESS_ID,
1876: PARENT_PROCESS_ID
1877: FROM AMW_EXECUTION_SCOPE aes
1878: WHERE ENTITY_TYPE = 'PROJECT'
1879: AND ENTITY_ID = p_source_entity_id
1880: AND aes.PROCESS_ID is null
1881: and exists(