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_PROC_ORG_HIERARCHY_PVT dependencies on AMW_CONTROL_ASSOCIATIONS

Line 1173: from amw_CONTROL_associations

1169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'DOING CONTROL ASSOCIATIONS HERE' );
1170: begin
1171: select CONTROL_association_id
1172: into l_CONTROL_association_id
1173: from amw_CONTROL_associations
1174: where object_type='RISK_ORG'
1175: and pk1=l_risk_association_id
1176: and CONTROL_id=p_CONTROL_id;
1177:

Line 1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;

1179:
1180: exception
1181: when no_data_found then
1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;
1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);

Line 1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');

1181: when no_data_found then
1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;
1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);
1188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||l_risk_association_id);
1189:

Line 1190: insert into amw_CONTROL_associations(CONTROL_association_id,

1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);
1188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||l_risk_association_id);
1189:
1190: insert into amw_CONTROL_associations(CONTROL_association_id,
1191: last_update_date,
1192: last_updated_by,
1193: creation_date,
1194: created_by,

Line 1739: from amw_control_associations

1735: attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,
1736: attribute11,attribute12,attribute13,attribute14,attribute15,
1737: security_group_id,object_version_number,effective_date_from,
1738: effective_date_to
1739: from amw_control_associations
1740: where object_type='RISK' and pk1=l_risk_id;
1741: l_aca_row c1%rowtype;
1742:
1743: cursor c2 is

Line 1745: from amw_control_associations where object_type='RISK_ORG'

1741: l_aca_row c1%rowtype;
1742:
1743: cursor c2 is
1744: select control_association_id,control_id
1745: from amw_control_associations where object_type='RISK_ORG'
1746: and pk1=l_risk_association_id; ---and risk_id=;
1747: l_update c2%rowtype;
1748:
1749: row_count number := 0;

Line 1776: select count(*) into row_count from amw_control_associations

1772: open c1;
1773: loop
1774: fetch c1 into l_aca_row;
1775: exit when c1%notfound;
1776: select count(*) into row_count from amw_control_associations
1777: where object_type='RISK_ORG'
1778: and pk1=l_risk_association_id
1779: and control_id=l_aca_row.control_id;
1780:

Line 1782: select amw_control_associations_s.nextval into l_control_association_id from dual;

1778: and pk1=l_risk_association_id
1779: and control_id=l_aca_row.control_id;
1780:
1781: if row_count = 0 then
1782: select amw_control_associations_s.nextval into l_control_association_id from dual;
1783:
1784: -----------------dbms_output.put_line('INSERTING IN AMW_CONTROL_ASSOCIATIONS');
1785: ----------------------dbms_output.put_line('control_association_id: '||l_control_association_id);
1786: insert into amw_control_associations(control_association_id,last_update_date,

Line 1784: -----------------dbms_output.put_line('INSERTING IN AMW_CONTROL_ASSOCIATIONS');

1780:
1781: if row_count = 0 then
1782: select amw_control_associations_s.nextval into l_control_association_id from dual;
1783:
1784: -----------------dbms_output.put_line('INSERTING IN AMW_CONTROL_ASSOCIATIONS');
1785: ----------------------dbms_output.put_line('control_association_id: '||l_control_association_id);
1786: insert into amw_control_associations(control_association_id,last_update_date,
1787: last_updated_by,creation_date,created_by,
1788: last_update_login,control_id,pk1,pk2,pk3,pk4,pk5,

Line 1786: insert into amw_control_associations(control_association_id,last_update_date,

1782: select amw_control_associations_s.nextval into l_control_association_id from dual;
1783:
1784: -----------------dbms_output.put_line('INSERTING IN AMW_CONTROL_ASSOCIATIONS');
1785: ----------------------dbms_output.put_line('control_association_id: '||l_control_association_id);
1786: insert into amw_control_associations(control_association_id,last_update_date,
1787: last_updated_by,creation_date,created_by,
1788: last_update_login,control_id,pk1,pk2,pk3,pk4,pk5,
1789: object_type,attribute_category,attribute1,attribute2,
1790: attribute3,attribute4,attribute5,attribute6,attribute7,

Line 1849: delete from amw_control_associations

1845: x_return_status => x_return_status,
1846: x_msg_count => x_msg_count,
1847: x_msg_data => x_msg_data
1848: );
1849: delete from amw_control_associations
1850: where control_association_id=l_update.control_association_id
1851: and object_type='RISK_ORG'
1852: and pk1=p_risk_association_id;
1853:

Line 1968: from amw_process_organization apo, amw_risk_associations ara, amw_control_associations aca, amw_ap_associations apa

1964:
1965: --mpande added 11/14/2003
1966: cursor c2 is
1967: select ap_association_id,audit_procedure_id
1968: from amw_process_organization apo, amw_risk_associations ara, amw_control_associations aca, amw_ap_associations apa
1969: where apo.process_organization_id = ara.pk1
1970: and ara.risk_association_id = aca.pk1
1971: and aca.control_association_id = p_control_association_id
1972: and apa.pk1 = apo.organization_id

Line 2013: from amw_process_organization apo, amw_risk_associations ara, amw_control_associations aca

2009: exit when c1%notfound;
2010:
2011: select apo.process_id, apo.organization_id
2012: into l_process_id, l_org_id
2013: from amw_process_organization apo, amw_risk_associations ara, amw_control_associations aca
2014: where apo.process_organization_id = ara.pk1
2015: and ara.risk_association_id = aca.pk1
2016: and aca.control_association_id = p_control_association_id;
2017: