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_ORG_HIERARCHY_PKG dependencies on AMW_AP_ASSOCIATIONS

Line 1261: insert into amw_ap_associations

1257: and c.pk2 = o.pk1
1258: and c.pk3 = o.pk2
1259: and o.pk3 = c.control_id);
1260:
1261: insert into amw_ap_associations
1262: (AP_ASSOCIATION_ID,
1263: AUDIT_PROCEDURE_ID,
1264: PK1,
1265: PK2,

Line 1281: AMW_AP_ASSOCIATIONS_S.nextval,

1277: CREATED_BY,
1278: LAST_UPDATE_LOGIN,
1279: OBJECT_VERSION_NUMBER)
1280: (select
1281: AMW_AP_ASSOCIATIONS_S.nextval,
1282: AUDIT_PROCEDURE_ID,
1283: p_org_id,
1284: p_child_process_id,
1285: PK1,

Line 1300: from amw_ap_associations

1296: sysdate,
1297: G_USER_ID,
1298: G_LOGIN_ID,
1299: 1
1300: from amw_ap_associations
1301: where PK1 in --ko, replacing = with in controls can be more than one..
1302: (select distinct control_id
1303: from amw_control_associations
1304: where PK1 = p_child_process_id

Line 1531: delete from amw_ap_associations

1527:
1528: -- in orgs, ap's don't undergo revisions..
1529: -- association creation date is null for AP's for draft control associations..We can remove those aps..
1530: -- ko1. uncommenting the following lines.. We do need to set the deletion date in order to maintain the history.
1531: delete from amw_ap_associations
1532: where pk1 = p_org_id
1533: and pk2 = p_process_id
1534: and association_creation_date is null
1535: and object_type = 'CTRL_ORG';

Line 1537: update amw_ap_associations

1533: and pk2 = p_process_id
1534: and association_creation_date is null
1535: and object_type = 'CTRL_ORG';
1536:
1537: update amw_ap_associations
1538: set DELETION_DATE = sysdate
1539: where pk1 = p_org_id
1540: and pk2 = p_process_id
1541: and object_type = 'CTRL_ORG'

Line 4989: delete from amw_ap_associations

4985: and object_type in ('PROCESS_ORG', 'CONTROL_ORG')
4986: and deletion_date is not null
4987: and deletion_approval_date is null;
4988:
4989: delete from amw_ap_associations
4990: where pk1 = p_organization_id
4991: and pk2 = p_process_id
4992: and association_creation_date is null
4993: and object_type = 'CTRL_ORG';

Line 5076: insert into amw_ap_associations

5072: RAISE FND_API.G_EXC_ERROR;
5073: END IF;
5074:
5075:
5076: insert into amw_ap_associations
5077: (AP_ASSOCIATION_ID,
5078: AUDIT_PROCEDURE_ID,
5079: PK1,
5080: PK2,

Line 5096: AMW_AP_ASSOCIATIONS_S.nextval,

5092: CREATED_BY,
5093: LAST_UPDATE_LOGIN,
5094: OBJECT_VERSION_NUMBER)
5095: (select
5096: AMW_AP_ASSOCIATIONS_S.nextval,
5097: APA.AUDIT_PROCEDURE_ID,
5098: p_organization_id,
5099: p_process_id,
5100: CONTROLS.control_id,

Line 5115: amw_ap_associations APA,

5111: G_USER_ID,
5112: G_LOGIN_ID,
5113: 1
5114: from
5115: amw_ap_associations APA,
5116: (SELECT distinct control_id from
5117: amw_control_associations
5118: where object_type = 'RISK_ORG'
5119: AND PK1 = p_organization_id

Line 5127: and APA.audit_procedure_id not in ( select audit_procedure_id from amw_ap_associations

5123: where APA.object_type = 'CTRL'
5124: and APA.pk1 = CONTROLS.control_id
5125: and APA.approval_date is not null
5126: and APA.deletion_approval_date is null
5127: and APA.audit_procedure_id not in ( select audit_procedure_id from amw_ap_associations
5128: where object_type = 'CTRL_ORG'
5129: and pk1 = p_organization_id
5130: and pk2 = p_process_id
5131: and pk3 = CONTROLS.control_id

Line 5135: DELETE FROM AMW_AP_ASSOCIATIONS

5131: and pk3 = CONTROLS.control_id
5132: and deletion_date is null));
5133:
5134:
5135: DELETE FROM AMW_AP_ASSOCIATIONS
5136: WHERE object_type = 'CTRL_ORG'
5137: and pk1 = p_organization_id
5138: and pk2 = p_process_id
5139: and association_creation_date is null

Line 5200: insert into amw_ap_associations

5196: RAISE FND_API.G_EXC_ERROR;
5197: END IF;
5198:
5199:
5200: insert into amw_ap_associations
5201: (AP_ASSOCIATION_ID,
5202: AUDIT_PROCEDURE_ID,
5203: PK1,
5204: PK2,

Line 5219: AMW_AP_ASSOCIATIONS_S.nextval,

5215: CREATED_BY,
5216: LAST_UPDATE_LOGIN,
5217: OBJECT_VERSION_NUMBER)
5218: (select
5219: AMW_AP_ASSOCIATIONS_S.nextval,
5220: APA.AUDIT_PROCEDURE_ID,
5221: p_organization_id,
5222: CONTROLS.control_id,
5223: APA.DESIGN_EFFECTIVENESS,

Line 5237: amw_ap_associations APA,

5233: G_USER_ID,
5234: G_LOGIN_ID,
5235: 1
5236: from
5237: amw_ap_associations APA,
5238: (SELECT distinct control_id from
5239: amw_control_associations
5240: where object_type = 'ENTITY_CONTROL'
5241: AND PK1 = p_organization_id

Line 5247: and APA.audit_procedure_id not in ( select audit_procedure_id from amw_ap_associations

5243: where APA.object_type = 'CTRL'
5244: and APA.pk1 = CONTROLS.control_id
5245: and APA.approval_date is not null
5246: and APA.deletion_approval_date is null
5247: and APA.audit_procedure_id not in ( select audit_procedure_id from amw_ap_associations
5248: where object_type = 'ENTITY_AP'
5249: and pk1 = p_organization_id
5250: and pk2 = CONTROLS.control_id)
5251: );

Line 5254: DELETE FROM AMW_AP_ASSOCIATIONS

5250: and pk2 = CONTROLS.control_id)
5251: );
5252:
5253:
5254: DELETE FROM AMW_AP_ASSOCIATIONS
5255: WHERE object_type = 'ENTITY_AP'
5256: and pk1 = p_organization_id
5257: and pk2 not in ( SELECT control_id from
5258: amw_control_associations

Line 5986: delete from amw_ap_associations

5982: and pk2 = p_process_id
5983: and object_type = 'RISK_ORG'
5984: and deletion_date is null));
5985: -- THIRD..AUDIT PROCEDURES..
5986: delete from amw_ap_associations
5987: where pk1 = p_org_id
5988: and pk2 = p_process_id
5989: and association_creation_date is null
5990: and object_type = 'CTRL_ORG';

Line 5992: update amw_ap_associations

5988: and pk2 = p_process_id
5989: and association_creation_date is null
5990: and object_type = 'CTRL_ORG';
5991:
5992: update amw_ap_associations
5993: set DELETION_DATE = sysdate
5994: where pk1 = p_org_id
5995: and pk2 = p_process_id
5996: and object_type = 'CTRL_ORG'

Line 5999: from amw_ap_associations

5995: and pk2 = p_process_id
5996: and object_type = 'CTRL_ORG'
5997: and deletion_date is null
5998: and (pk3, audit_procedure_id) not in (select pk1, audit_procedure_id
5999: from amw_ap_associations
6000: where object_type = 'CTRL'
6001: and approval_date is not null
6002: and deletion_approval_date is null);
6003: insert into amw_ap_associations

Line 6003: insert into amw_ap_associations

5999: from amw_ap_associations
6000: where object_type = 'CTRL'
6001: and approval_date is not null
6002: and deletion_approval_date is null);
6003: insert into amw_ap_associations
6004: (AP_ASSOCIATION_ID,
6005: AUDIT_PROCEDURE_ID,
6006: PK1,
6007: PK2,

Line 6023: AMW_AP_ASSOCIATIONS_S.nextval,

6019: CREATED_BY,
6020: LAST_UPDATE_LOGIN,
6021: OBJECT_VERSION_NUMBER)
6022: (select
6023: AMW_AP_ASSOCIATIONS_S.nextval,
6024: AUDIT_PROCEDURE_ID,
6025: p_org_id,
6026: p_process_id,
6027: PK1,

Line 6042: from amw_ap_associations

6038: sysdate,
6039: G_USER_ID,
6040: G_LOGIN_ID,
6041: 1
6042: from amw_ap_associations
6043: where PK1 in --ko, replacing = with in controls can be more than one..
6044: (select distinct control_id
6045: from amw_control_associations
6046: where PK1 = p_process_id

Line 6054: from amw_ap_associations

6050: and object_type = 'CTRL'
6051: and approval_date is not null
6052: and deletion_approval_date is null
6053: and (pk1, audit_procedure_id) not in(select pk3,audit_procedure_id
6054: from amw_ap_associations
6055: where pk1 = p_org_id
6056: and pk2 = p_process_id
6057: and object_type = 'CTRL_ORG'
6058: and deletion_date is null));

Line 6303: insert into amw_ap_associations

6299: and pk2 = p_process_id
6300: and object_type = 'RISK_ORG'
6301: and deletion_date is null));
6302: -- NOW AUDIT PROCEDURES...
6303: insert into amw_ap_associations
6304: (AP_ASSOCIATION_ID,
6305: AUDIT_PROCEDURE_ID,
6306: PK1,
6307: PK2,

Line 6323: AMW_AP_ASSOCIATIONS_S.nextval,

6319: CREATED_BY,
6320: LAST_UPDATE_LOGIN,
6321: OBJECT_VERSION_NUMBER)
6322: (select
6323: AMW_AP_ASSOCIATIONS_S.nextval,
6324: AUDIT_PROCEDURE_ID,
6325: p_org_id,
6326: p_process_id,
6327: PK1,

Line 6342: from amw_ap_associations

6338: sysdate,
6339: G_USER_ID,
6340: G_LOGIN_ID,
6341: 1
6342: from amw_ap_associations
6343: where PK1 in --ko, replacing = with in controls can be more than one..
6344: (select distinct control_id
6345: from amw_control_associations
6346: where PK1 = p_process_id

Line 6354: from amw_ap_associations

6350: and object_type = 'CTRL'
6351: and approval_date is not null
6352: and deletion_approval_date is null
6353: and (pk1, audit_procedure_id) not in(select pk3,audit_procedure_id
6354: from amw_ap_associations
6355: where pk1 = p_org_id
6356: and pk2 = p_process_id
6357: and object_type = 'CTRL_ORG'
6358: and deletion_date is null));

Line 6637: delete from amw_ap_associations

6633:
6634:
6635: -- THIRD..AUDIT PROCEDURES..
6636: FORALL indx IN Org_Ids.FIRST .. Org_Ids.LAST
6637: delete from amw_ap_associations
6638: where pk1 = Org_Ids(indx)
6639: and pk2 = p_process_id
6640: and association_creation_date is null
6641: and object_type = 'CTRL_ORG';

Line 6644: update amw_ap_associations

6640: and association_creation_date is null
6641: and object_type = 'CTRL_ORG';
6642:
6643: FORALL indx IN Org_Ids.FIRST .. Org_Ids.LAST
6644: update amw_ap_associations
6645: set DELETION_DATE = sysdate
6646: where pk1 = Org_Ids(indx)
6647: and pk2 = p_process_id
6648: and object_type = 'CTRL_ORG'

Line 6651: from amw_ap_associations

6647: and pk2 = p_process_id
6648: and object_type = 'CTRL_ORG'
6649: and deletion_date is null
6650: and (pk3, audit_procedure_id) not in (select pk1, audit_procedure_id
6651: from amw_ap_associations
6652: where object_type = 'CTRL'
6653: and approval_date is not null
6654: and deletion_approval_date is null);
6655:

Line 6657: insert into amw_ap_associations

6653: and approval_date is not null
6654: and deletion_approval_date is null);
6655:
6656: FORALL indx IN Org_Ids.FIRST .. Org_Ids.LAST
6657: insert into amw_ap_associations
6658: (AP_ASSOCIATION_ID,
6659: AUDIT_PROCEDURE_ID,
6660: PK1,
6661: PK2,

Line 6677: AMW_AP_ASSOCIATIONS_S.nextval,

6673: CREATED_BY,
6674: LAST_UPDATE_LOGIN,
6675: OBJECT_VERSION_NUMBER)
6676: (select
6677: AMW_AP_ASSOCIATIONS_S.nextval,
6678: AUDIT_PROCEDURE_ID,
6679: Org_Ids(indx),
6680: p_process_id,
6681: PK1,

Line 6696: from amw_ap_associations

6692: sysdate,
6693: G_USER_ID,
6694: G_LOGIN_ID,
6695: 1
6696: from amw_ap_associations
6697: where PK1 in --ko, replacing = with in controls can be more than one..
6698: (select distinct control_id
6699: from amw_control_associations
6700: where PK1 = p_process_id

Line 6708: from amw_ap_associations

6704: and object_type = 'CTRL'
6705: and approval_date is not null
6706: and deletion_approval_date is null
6707: and (pk1, audit_procedure_id) not in(select pk3,audit_procedure_id
6708: from amw_ap_associations
6709: where pk1 = Org_Ids(indx)
6710: and pk2 = p_process_id
6711: and object_type = 'CTRL_ORG'
6712: and deletion_date is null));

Line 6906: insert into amw_ap_associations

6902: and object_type = 'RISK_ORG'
6903: and deletion_date is null));
6904: -- NOW AUDIT PROCEDURES...
6905: FORALL indx IN Org_Ids.FIRST .. Org_Ids.LAST
6906: insert into amw_ap_associations
6907: (AP_ASSOCIATION_ID,
6908: AUDIT_PROCEDURE_ID,
6909: PK1,
6910: PK2,

Line 6926: AMW_AP_ASSOCIATIONS_S.nextval,

6922: CREATED_BY,
6923: LAST_UPDATE_LOGIN,
6924: OBJECT_VERSION_NUMBER)
6925: (select
6926: AMW_AP_ASSOCIATIONS_S.nextval,
6927: AUDIT_PROCEDURE_ID,
6928: Org_Ids(indx),
6929: p_process_id,
6930: PK1,

Line 6945: from amw_ap_associations

6941: sysdate,
6942: G_USER_ID,
6943: G_LOGIN_ID,
6944: 1
6945: from amw_ap_associations
6946: where PK1 in --ko, replacing = with in controls can be more than one..
6947: (select distinct control_id
6948: from amw_control_associations
6949: where PK1 = p_process_id

Line 6957: from amw_ap_associations

6953: and object_type = 'CTRL'
6954: and approval_date is not null
6955: and deletion_approval_date is null
6956: and (pk1, audit_procedure_id) not in(select pk3,audit_procedure_id
6957: from amw_ap_associations
6958: where pk1 = Org_Ids(indx)
6959: and pk2 = p_process_id
6960: and object_type = 'CTRL_ORG'
6961: and deletion_date is null));