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.

APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_AP_ASSOCIATIONS

Line 974: TYPE ap_cur_type IS REF CURSOR; --RETURN amw_ap_associations%ROWTYPE;

970: src_task_id NUMBER;
971: dest_task_id NUMBER;
972: org_id NUMBER;
973:
974: TYPE ap_cur_type IS REF CURSOR; --RETURN amw_ap_associations%ROWTYPE;
975: my_rec ap_cur_type;
976: x_number amw_ap_associations.audit_procedure_id%TYPE;
977:
978: CURSOR c_srceng_ap IS

Line 976: x_number amw_ap_associations.audit_procedure_id%TYPE;

972: org_id NUMBER;
973:
974: TYPE ap_cur_type IS REF CURSOR; --RETURN amw_ap_associations%ROWTYPE;
975: my_rec ap_cur_type;
976: x_number amw_ap_associations.audit_procedure_id%TYPE;
977:
978: CURSOR c_srceng_ap IS
979: SELECT
980: PROJECT_ID,

Line 1024: from amw_ap_associations src ,amw_ap_associations dest

1020: select distinct src.pk1 src_pk1,src.pk2 src_pk2,src.pk3 src_pk3,src.pk4 src_pk4,
1021: dest.pk1 dest_pk1,dest.pk2 dest_pk2,dest.pk3 dest_pk3,
1022: dest.pk4 dest_pk4,src.audit_procedure_rev_id src_audit_procedure_rev_id,
1023: dest.audit_procedure_rev_id dest_audit_procedure_rev_id
1024: from amw_ap_associations src ,amw_ap_associations dest
1025: where src.pk1=p_source_project_id and dest.pk1=p_dest_project_id
1026: and src.OBJECT_TYPE='PROJECT' and src.association_creation_date is not null
1027: and dest.OBJECT_TYPE ='PROJECT_NEW' and dest.association_creation_date is not null
1028: and src.pk2=dest.pk2 and src.pk3=dest.pk3

Line 1148: INSERT INTO amw_ap_associations (

1144: B.LANGUAGE,
1145: B.SOURCE_LANG
1146: from AMW_AUDIT_PROCEDURES_TL B
1147: where AUDIT_PROCEDURE_REV_ID =ap_rec.AUDIT_PROCEDURE_REV_ID;
1148: INSERT INTO amw_ap_associations (
1149: ap_association_id,
1150: last_update_date,
1151: last_updated_by,
1152: creation_date,

Line 1164: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1160: pk3,
1161: pk4,
1162: object_type,
1163: object_version_number)
1164: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1165: SYSDATE ,
1166: FND_GLOBAL.USER_ID,
1167: SYSDATE,
1168: FND_GLOBAL.USER_ID,

Line 1180: amw_ap_associations apa

1176: apa.pk4,
1177: 'PROJECT_NEW',
1178: 1
1179: from
1180: amw_ap_associations apa
1181: where pk1=ap_rec.PROJECT_ID
1182: and apa.OBJECT_TYPE='PROJECT' and association_creation_date is not null
1183: and apa.AUDIT_PROCEDURE_ID=ap_rec.AUDIT_PROCEDURE_ID
1184: and NOT EXISTS

Line 1185: (SELECT 'Y' from amw_ap_associations apa2

1181: where pk1=ap_rec.PROJECT_ID
1182: and apa.OBJECT_TYPE='PROJECT' and association_creation_date is not null
1183: and apa.AUDIT_PROCEDURE_ID=ap_rec.AUDIT_PROCEDURE_ID
1184: and NOT EXISTS
1185: (SELECT 'Y' from amw_ap_associations apa2
1186: where apa2.object_type in ('PROJECT','PROJECT_NEW')
1187: AND apa2.pk1 = p_dest_project_id
1188: AND apa2.pk2 = apa.pk2
1189: AND apa2.pk3 = apa.pk3

Line 1196: OPEN my_rec FOR SELECT audit_procedure_id from amw_ap_associations where

1192: AND (apa.pk3=-1 or apa.pk3 in (select 1 from amw_control_associations WHERE object_type='PROJECT'
1193: AND pk1 = p_source_project_id and control_id=apa.pk3));
1194:
1195:
1196: OPEN my_rec FOR SELECT audit_procedure_id from amw_ap_associations where
1197: pk1=p_dest_project_id and audit_procedure_id=l_audit_procedure_id ;
1198: LOOP
1199: FETCH my_rec INTO x_number;
1200: EXIT WHEN my_rec%NOTFOUND;

Line 1209: and src.task_id=(select distinct pk4 from amw_ap_associations where

1205: from amw_audit_tasks_v src , amw_audit_tasks_v dest
1206: where dest.audit_project_id =p_dest_project_id
1207: and src.audit_project_id =p_source_project_id and src.task_name=dest.task_name
1208: and src.task_number = dest.task_number
1209: and src.task_id=(select distinct pk4 from amw_ap_associations where
1210: audit_procedure_id=l_audit_procedure_id and
1211: audit_procedure_rev_id=l_audit_procedure_rev_id );
1212:
1213: update amw_ap_associations set pk4=dest_task_id

Line 1213: update amw_ap_associations set pk4=dest_task_id

1209: and src.task_id=(select distinct pk4 from amw_ap_associations where
1210: audit_procedure_id=l_audit_procedure_id and
1211: audit_procedure_rev_id=l_audit_procedure_rev_id );
1212:
1213: update amw_ap_associations set pk4=dest_task_id
1214: where pk1=p_dest_project_id and pk4=src_task_id
1215: and audit_procedure_id=l_audit_procedure_id and
1216: audit_procedure_rev_id=l_audit_procedure_rev_id;
1217:

Line 1218: select distinct pk2 into org_id from amw_ap_associations

1214: where pk1=p_dest_project_id and pk4=src_task_id
1215: and audit_procedure_id=l_audit_procedure_id and
1216: audit_procedure_rev_id=l_audit_procedure_rev_id;
1217:
1218: select distinct pk2 into org_id from amw_ap_associations
1219: where audit_procedure_id=l_audit_procedure_id and
1220: audit_procedure_rev_id=l_audit_procedure_rev_id;
1221:
1222: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',

Line 1238: INSERT INTO amw_ap_associations (

1234: END IF;
1235:
1236:
1237: END LOOP;
1238: INSERT INTO amw_ap_associations (
1239: ap_association_id,
1240: last_update_date,
1241: last_updated_by,
1242: creation_date,

Line 1254: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1250: pk3,
1251: pk4,
1252: object_type,
1253: object_version_number)
1254: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1255: SYSDATE ,
1256: FND_GLOBAL.USER_ID,
1257: SYSDATE,
1258: FND_GLOBAL.USER_ID,

Line 1270: amw_ap_associations apa

1266: apa.pk4,
1267: 'PROJECT_NEW',
1268: 1
1269: from
1270: amw_ap_associations apa
1271: where apa.audit_procedure_id not in (
1272: select distinct audit_procedure_id from amw_audit_procedures_b where
1273: project_id=p_source_project_id
1274: )

Line 1278: (SELECT 'Y' from amw_ap_associations apa2

1274: )
1275: and apa.OBJECT_TYPE='PROJECT' and association_creation_date is not null
1276: and apa.pk1=p_source_project_id
1277: and NOT EXISTS
1278: (SELECT 'Y' from amw_ap_associations apa2
1279: where apa2.object_type in ('PROJECT','PROJECT_NEW')
1280: AND apa2.pk1 = p_dest_project_id
1281: AND apa2.pk2 = apa.pk2
1282: AND apa2.pk3 = apa.pk3

Line 1288: update amw_ap_associations set pk4=ap_task.dest_task_id

1284: AND apa2.AUDIT_PROCEDURE_ID=apa.AUDIT_PROCEDURE_ID)
1285: AND (apa.pk3=-1 or apa.pk3 in (select 1 from amw_control_associations WHERE object_type='PROJECT'
1286: AND pk1 = p_source_project_id and control_id=apa.pk3));
1287: FOR ap_task in c_tasks LOOP
1288: update amw_ap_associations set pk4=ap_task.dest_task_id
1289: where pk1=p_dest_project_id and pk4=ap_task.src_task_id;
1290: END LOOP;
1291:
1292: select category_id into v_category_id

Line 1311: update amw_ap_associations set object_type = 'PROJECT'

1307: X_TO_CATEGORY_ID => v_category_id);
1308:
1309: END LOOP;
1310:
1311: update amw_ap_associations set object_type = 'PROJECT'
1312: where object_type = 'PROJECT_NEW'
1313: and pk1 = p_dest_project_id;
1314:
1315: For ap_task_icm in c_task_icm

Line 1318: -- from amw_ap_associations dest ,amw_ap_associations src

1314:
1315: For ap_task_icm in c_task_icm
1316: LOOP
1317: -- select src.audit_procedure_rev_id into l_audit_procedure_rev_id
1318: -- from amw_ap_associations dest ,amw_ap_associations src
1319: -- where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1320: -- and src.audit_procedure_id=dest.audit_procedure_id
1321: -- and src.pk4=ap_task_icm.src_task_id
1322: -- and src.audit_procedure_rev_id=dest.audit_procedure_rev_id;

Line 1324: update amw_ap_associations

1320: -- and src.audit_procedure_id=dest.audit_procedure_id
1321: -- and src.pk4=ap_task_icm.src_task_id
1322: -- and src.audit_procedure_rev_id=dest.audit_procedure_rev_id;
1323:
1324: update amw_ap_associations
1325: set pk4= ap_task_icm.dest_task_id
1326: where pk1=p_dest_project_id
1327: and audit_procedure_id in (
1328: select src.audit_procedure_id

Line 1329: from amw_ap_associations dest ,amw_ap_associations src

1325: set pk4= ap_task_icm.dest_task_id
1326: where pk1=p_dest_project_id
1327: and audit_procedure_id in (
1328: select src.audit_procedure_id
1329: from amw_ap_associations dest ,amw_ap_associations src
1330: where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1331: and src.audit_procedure_id=dest.audit_procedure_id
1332: and src.pk4=ap_task_icm.src_task_id
1333: and src.association_creation_date is null);

Line 1340: from amw_ap_associations dest ,amw_ap_associations src

1336: set pk3_value=ap_task_icm.dest_task_id
1337: where pk1_value=to_char(p_dest_project_id) and pk3_value=-1
1338: and pk4_value in (
1339: select src.audit_procedure_rev_id
1340: from amw_ap_associations dest ,amw_ap_associations src
1341: where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1342: and src.audit_procedure_id=dest.audit_procedure_id
1343: and src.pk4=ap_task_icm.src_task_id
1344: and src.association_creation_date is null) ;

Line 1412: from amw_ap_associations src ,amw_ap_associations dest

1408: select distinct src.pk1 src_pk1,src.pk2 src_pk2,src.pk3 src_pk3,src.pk4 src_pk4,
1409: dest.pk1 dest_pk1,dest.pk2 dest_pk2,dest.pk3 dest_pk3,
1410: dest.pk4 dest_pk4,src.audit_procedure_rev_id src_audit_procedure_rev_id,
1411: dest.audit_procedure_rev_id dest_audit_procedure_rev_id
1412: from amw_ap_associations src ,amw_ap_associations dest
1413: where src.pk1=p_source_project_id and dest.pk1=p_dest_project_id
1414: and src.OBJECT_TYPE='PROJECT' and src.association_creation_date is not null
1415: and dest.OBJECT_TYPE ='PROJECT_NEW' and dest.association_creation_date is not null
1416: and src.pk2=dest.pk2 and src.pk3=dest.pk3

Line 1536: INSERT INTO amw_ap_associations (

1532: B.LANGUAGE,
1533: B.SOURCE_LANG
1534: from AMW_AUDIT_PROCEDURES_TL B
1535: where AUDIT_PROCEDURE_REV_ID =ap_rec.AUDIT_PROCEDURE_REV_ID;
1536: INSERT INTO amw_ap_associations (
1537: ap_association_id,
1538: last_update_date,
1539: last_updated_by,
1540: creation_date,

Line 1552: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1548: pk3,
1549: pk4,
1550: object_type,
1551: object_version_number)
1552: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1553: SYSDATE ,
1554: FND_GLOBAL.USER_ID,
1555: SYSDATE,
1556: FND_GLOBAL.USER_ID,

Line 1568: amw_ap_associations apa

1564: apa.pk4,
1565: 'PROJECT_NEW',
1566: 1
1567: from
1568: amw_ap_associations apa
1569: where pk1=ap_rec.PROJECT_ID
1570: and apa.OBJECT_TYPE='PROJECT' and association_creation_date is not null
1571: and apa.AUDIT_PROCEDURE_ID=ap_rec.AUDIT_PROCEDURE_ID
1572: and NOT EXISTS

Line 1573: (SELECT 'Y' from amw_ap_associations apa2

1569: where pk1=ap_rec.PROJECT_ID
1570: and apa.OBJECT_TYPE='PROJECT' and association_creation_date is not null
1571: and apa.AUDIT_PROCEDURE_ID=ap_rec.AUDIT_PROCEDURE_ID
1572: and NOT EXISTS
1573: (SELECT 'Y' from amw_ap_associations apa2
1574: where apa2.object_type in ('PROJECT','PROJECT_NEW')
1575: AND apa2.pk1 = p_dest_project_id
1576: AND apa2.pk2 = apa.pk2
1577: AND apa2.pk3 = apa.pk3

Line 1587: and src.task_id=(select distinct pk4 from amw_ap_associations where

1583: where dest.audit_project_id =p_dest_project_id
1584:
1585: and src.audit_project_id =p_source_project_id and src.task_name=dest.task_name
1586: and src.task_number = dest.task_number
1587: and src.task_id=(select distinct pk4 from amw_ap_associations where
1588: audit_procedure_id=l_audit_procedure_id and
1589: audit_procedure_rev_id=l_audit_procedure_rev_id );
1590:
1591: update amw_ap_associations set pk4=dest_task_id

Line 1591: update amw_ap_associations set pk4=dest_task_id

1587: and src.task_id=(select distinct pk4 from amw_ap_associations where
1588: audit_procedure_id=l_audit_procedure_id and
1589: audit_procedure_rev_id=l_audit_procedure_rev_id );
1590:
1591: update amw_ap_associations set pk4=dest_task_id
1592: where pk1=p_dest_project_id and pk4=src_task_id
1593: and audit_procedure_id=l_audit_procedure_id and
1594: audit_procedure_rev_id=l_audit_procedure_rev_id;
1595:

Line 1596: select distinct pk2 into org_id from amw_ap_associations

1592: where pk1=p_dest_project_id and pk4=src_task_id
1593: and audit_procedure_id=l_audit_procedure_id and
1594: audit_procedure_rev_id=l_audit_procedure_rev_id;
1595:
1596: select distinct pk2 into org_id from amw_ap_associations
1597: where audit_procedure_id=l_audit_procedure_id and
1598: audit_procedure_rev_id=l_audit_procedure_rev_id;
1599:
1600: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROJECT_AP',

Line 1616: INSERT INTO amw_ap_associations (

1612:
1613:
1614:
1615: END LOOP;
1616: INSERT INTO amw_ap_associations (
1617: ap_association_id,
1618: last_update_date,
1619: last_updated_by,
1620: creation_date,

Line 1632: SELECT AMW_AP_ASSOCIATIONS_S.nextval,

1628: pk3,
1629: pk4,
1630: object_type,
1631: object_version_number)
1632: SELECT AMW_AP_ASSOCIATIONS_S.nextval,
1633: SYSDATE ,
1634: FND_GLOBAL.USER_ID,
1635: SYSDATE,
1636: FND_GLOBAL.USER_ID,

Line 1648: amw_ap_associations apa

1644: apa.pk4,
1645: 'PROJECT_NEW',
1646: 1
1647: from
1648: amw_ap_associations apa
1649: where apa.audit_procedure_id not in (
1650: select distinct audit_procedure_id from amw_audit_procedures_b where
1651: project_id=p_source_project_id
1652: )

Line 1656: (SELECT 'Y' from amw_ap_associations apa2

1652: )
1653: and apa.OBJECT_TYPE='PROJECT' and association_creation_date is not null
1654: and apa.pk1=p_source_project_id
1655: and NOT EXISTS
1656: (SELECT 'Y' from amw_ap_associations apa2
1657: where apa2.object_type in ('PROJECT','PROJECT_NEW')
1658: AND apa2.pk1 = p_dest_project_id
1659: AND apa2.pk2 = apa.pk2
1660: AND apa2.pk3 = apa.pk3

Line 1664: update amw_ap_associations set pk4=ap_task.dest_task_id

1660: AND apa2.pk3 = apa.pk3
1661: AND apa2.pk4 = apa.pk4
1662: AND apa2.AUDIT_PROCEDURE_ID=apa.AUDIT_PROCEDURE_ID);
1663: FOR ap_task in c_tasks LOOP
1664: update amw_ap_associations set pk4=ap_task.dest_task_id
1665: where pk1=p_dest_project_id and pk4=ap_task.src_task_id;
1666: END LOOP;
1667:
1668: select category_id into v_category_id

Line 1687: update amw_ap_associations set object_type = 'PROJECT'

1683: X_TO_CATEGORY_ID => v_category_id);
1684:
1685: END LOOP;
1686:
1687: update amw_ap_associations set object_type = 'PROJECT'
1688: where object_type = 'PROJECT_NEW'
1689: and pk1 = p_dest_project_id;
1690:
1691: For ap_task_icm in c_task_icm

Line 1694: -- from amw_ap_associations dest ,amw_ap_associations src

1690:
1691: For ap_task_icm in c_task_icm
1692: LOOP
1693: -- select src.audit_procedure_rev_id into l_audit_procedure_rev_id
1694: -- from amw_ap_associations dest ,amw_ap_associations src
1695: -- where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1696: -- and src.audit_procedure_id=dest.audit_procedure_id
1697: -- and src.pk4=ap_task_icm.src_task_id
1698: -- and src.audit_procedure_rev_id=dest.audit_procedure_rev_id;

Line 1700: update amw_ap_associations

1696: -- and src.audit_procedure_id=dest.audit_procedure_id
1697: -- and src.pk4=ap_task_icm.src_task_id
1698: -- and src.audit_procedure_rev_id=dest.audit_procedure_rev_id;
1699:
1700: update amw_ap_associations
1701: set pk4= ap_task_icm.dest_task_id
1702: where pk1=p_dest_project_id
1703: and audit_procedure_id in (
1704: select src.audit_procedure_id

Line 1705: from amw_ap_associations dest ,amw_ap_associations src

1701: set pk4= ap_task_icm.dest_task_id
1702: where pk1=p_dest_project_id
1703: and audit_procedure_id in (
1704: select src.audit_procedure_id
1705: from amw_ap_associations dest ,amw_ap_associations src
1706: where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1707: and src.audit_procedure_id=dest.audit_procedure_id
1708: and src.pk4=ap_task_icm.src_task_id
1709: and src.association_creation_date is null);

Line 1716: from amw_ap_associations dest ,amw_ap_associations src

1712: set pk3_value=ap_task_icm.dest_task_id
1713: where pk1_value=to_char(p_dest_project_id) and pk3_value=-1
1714: and pk4_value in (
1715: select src.audit_procedure_rev_id
1716: from amw_ap_associations dest ,amw_ap_associations src
1717: where dest.pk1=p_dest_project_id and src.pk1=p_source_project_id
1718: and src.audit_procedure_id=dest.audit_procedure_id
1719: and src.pk4=ap_task_icm.src_task_id
1720: and src.association_creation_date is null) ;