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

Line 152: insert into amw_ap_associations

148:
149: SELECT organization_id into l_org_id2 from amw_process_organization where process_organization_id = p_process_organization_id;
150: SELECT process_id into l_process_id2 from amw_process_organization where process_organization_id = p_process_organization_id;
151:
152: insert into amw_ap_associations
153: (AP_ASSOCIATION_ID,
154: LAST_UPDATE_DATE,
155: LAST_UPDATED_BY,
156: CREATION_DATE,

Line 184: amw_ap_associations_s.nextval,

180: OBJECT_VERSION_NUMBER,
181: DESIGN_EFFECTIVENESS,
182: OP_EFFECTIVENESS )
183: ( select
184: amw_ap_associations_s.nextval,
185: sysdate,
186: FND_GLOBAL.USER_ID,
187: sysdate,
188: FND_GLOBAL.USER_ID,

Line 214: from amw_ap_associations

210: ATTRIBUTE15,
211: 1,
212: DESIGN_EFFECTIVENESS,
213: OP_EFFECTIVENESS
214: from amw_ap_associations
215: where object_type = 'CTRL'
216: and pk1 in (select control_id from amw_control_associations
217: where object_type = 'RISK'
218: and pk1 = p_risk_id));

Line 225: insert into amw_ap_associations

221:
222: SELECT organization_id into l_org_id2 from amw_process_organization where process_organization_id = p_process_organization_id;
223: SELECT process_id into l_process_id2 from amw_process_organization where process_organization_id = p_process_organization_id;
224:
225: insert into amw_ap_associations
226: (AP_ASSOCIATION_ID,
227: LAST_UPDATE_DATE,
228: LAST_UPDATED_BY,
229: CREATION_DATE,

Line 257: amw_ap_associations_s.nextval,

253: OBJECT_VERSION_NUMBER,
254: DESIGN_EFFECTIVENESS,
255: OP_EFFECTIVENESS )
256: ( select
257: amw_ap_associations_s.nextval,
258: sysdate,
259: FND_GLOBAL.USER_ID,
260: sysdate,
261: FND_GLOBAL.USER_ID,

Line 287: from amw_ap_associations

283: ATTRIBUTE15,
284: 1,
285: DESIGN_EFFECTIVENESS,
286: OP_EFFECTIVENESS
287: from amw_ap_associations
288: where object_type = 'CTRL'
289: and pk1 = p_control_id);
290:
291: END IF;

Line 314: delete from amw_ap_associations

310: FETCH cc5 INTO delete_ctrl_org;
311: EXIT WHEN cc5%NOTFOUND;
312:
313: -- added mpande 11/14/2003
314: delete from amw_ap_associations
315: where object_type='CTRL_ORG'
316: and pk1 = ( SELECT organization_id from amw_process_organization
317: where process_organization_id = p_process_organization_id )
318: and pk2 = ( SELECT process_id from amw_process_organization

Line 335: delete from amw_ap_associations

331: CLOSE cc5 ;
332: AMW_WF_HIERARCHY_PKG.reset_proc_org_risk_ctrl_count(l_org_id);
333: ELSIF (p_object = 'CONTROL_ORG') THEN
334: -- added mpande 11/14/2003
335: delete from amw_ap_associations
336: where object_type='CTRL_ORG'
337: and pk1 = ( SELECT organization_id from amw_process_organization
338: where process_organization_id = p_process_organization_id )
339: and pk2 = ( SELECT process_id from amw_process_organization