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_AP_ASSOCIATIONS

Line 1956: from amw_ap_associations where object_type='CTRL' and pk1=l_control_id;

1952: attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,
1953: attribute9,attribute10,attribute11,attribute12,attribute13,attribute14,
1954: attribute15,security_group_id,object_version_number,design_effectiveness,
1955: op_effectiveness
1956: from amw_ap_associations where object_type='CTRL' and pk1=l_control_id;
1957: l_aaa_row c1%rowtype;
1958: /*
1959: cursor c2 is
1960: select ap_association_id,audit_procedure_id

Line 1961: from amw_ap_associations where object_type='CTRL_ORG'

1957: l_aaa_row c1%rowtype;
1958: /*
1959: cursor c2 is
1960: select ap_association_id,audit_procedure_id
1961: from amw_ap_associations where object_type='CTRL_ORG'
1962: and pk1=l_control_association_id; ---and risk_id=;
1963: */
1964:
1965: --mpande added 11/14/2003

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 2021: ** select count(*) into row_count from amw_ap_associations

2017:
2018:
2019:
2020: /*
2021: ** select count(*) into row_count from amw_ap_associations
2022: ** where object_type='CTRL_ORG'
2023: ** and pk1=l_control_association_id
2024: ** and audit_procedure_id=l_aaa_row.audit_procedure_id;
2025: */

Line 2027: select count(*) into row_count from amw_ap_associations

2023: ** and pk1=l_control_association_id
2024: ** and audit_procedure_id=l_aaa_row.audit_procedure_id;
2025: */
2026:
2027: select count(*) into row_count from amw_ap_associations
2028: where object_type='CTRL_ORG'
2029: and pk1=l_org_id
2030: and pk2 = l_process_id
2031: and pk3 = p_control_id

Line 2036: select amw_ap_associations_s.nextval into l_ap_association_id from dual;

2032: and audit_procedure_id=l_aaa_row.audit_procedure_id;
2033:
2034:
2035: if row_count = 0 then
2036: select amw_ap_associations_s.nextval into l_ap_association_id from dual;
2037:
2038:
2039: insert into amw_ap_associations(ap_association_id,last_update_date,
2040: last_updated_by,creation_date,created_by,

Line 2039: insert into amw_ap_associations(ap_association_id,last_update_date,

2035: if row_count = 0 then
2036: select amw_ap_associations_s.nextval into l_ap_association_id from dual;
2037:
2038:
2039: insert into amw_ap_associations(ap_association_id,last_update_date,
2040: last_updated_by,creation_date,created_by,
2041: last_update_login,pk1,pk2,pk3,pk4,pk5,object_type,
2042: audit_procedure_id,attribute_category,attribute1,attribute2,
2043: attribute3,attribute4,attribute5,attribute6,attribute7,

Line 2072: delete from amw_ap_associations

2068: loop
2069: fetch c2 into l_update;
2070: exit when c2%notfound;
2071:
2072: delete from amw_ap_associations
2073: where ap_association_id=l_update.ap_association_id ;
2074: -- commented by mpande
2075: -- and object_type='CTRL_ORG' ;
2076: -- and pk1=p_control_association_id;