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_PROCESS_CERT_SCOPE_PVT dependencies on AMW_EXECUTION_SCOPE

Line 41: INSERT INTO AMW_EXECUTION_SCOPE (

37: BEGIN
38: FOR proc_rec IN c_process LOOP
39: Insert_Process (p_level_id+1,proc_rec.process_id,p_top_process_id,p_subsidiary_vs,
40: p_subsidiary_code,p_lob_vs,p_lob_code,p_organization_id,p_certification_id);
41: INSERT INTO AMW_EXECUTION_SCOPE (
42: EXECUTION_SCOPE_ID,
43: ENTITY_TYPE,
44: ENTITY_ID,
45: CREATED_BY,

Line 60: SELECT amw_execution_scope_s.nextval,

56: ORGANIZATION_ID,
57: PROCESS_ID,
58: TOP_PROCESS_ID,
59: PARENT_PROCESS_ID)
60: SELECT amw_execution_scope_s.nextval,
61: 'PROCESS_CERTIFICATION',
62: p_certification_id,
63: FND_GLOBAL.USER_ID,
64: SYSDATE,

Line 115: delete from AMW_EXECUTION_SCOPE

111: x_return_status := fnd_api.g_ret_sts_success;
112:
113: SAVEPOINT INSERT_AUDIT_UNITS_PVT;
114:
115: delete from AMW_EXECUTION_SCOPE
116: where entity_id = p_certification_id
117: and entity_type = 'PROCESS_CERTIFICATION';
118:
119:

Line 122: INSERT INTO AMW_EXECUTION_SCOPE (

118:
119:
120: FOR audit_rec IN c_audit_unit LOOP
121:
122: INSERT INTO AMW_EXECUTION_SCOPE (
123: EXECUTION_SCOPE_ID,
124: ENTITY_TYPE,
125: ENTITY_ID,
126: CREATED_BY,

Line 141: SELECT amw_execution_scope_s.nextval,

137: ORGANIZATION_ID,
138: PROCESS_ID,
139: TOP_PROCESS_ID,
140: PARENT_PROCESS_ID)
141: SELECT amw_execution_scope_s.nextval,
142: 'PROCESS_CERTIFICATION',
143: p_certification_id,
144: FND_GLOBAL.USER_ID,
145: SYSDATE,

Line 161: FROM AMW_EXECUTION_SCOPE

157: null,
158: null
159: FROM DUAL
160: WHERE not exists (SELECT 'Y'
161: FROM AMW_EXECUTION_SCOPE
162: WHERE entity_type='PROCESS_CERTIFICATION'
163: AND entity_id= p_certification_id
164: AND subsidiary_vs = audit_rec.subsidiary_valueset
165: AND subsidiary_code= audit_rec.company_code

Line 169: INSERT INTO AMW_EXECUTION_SCOPE (

165: AND subsidiary_code= audit_rec.company_code
166: AND level_id=1);
167:
168:
169: INSERT INTO AMW_EXECUTION_SCOPE (
170: EXECUTION_SCOPE_ID,
171: ENTITY_TYPE,
172: ENTITY_ID,
173: CREATED_BY,

Line 188: SELECT amw_execution_scope_s.nextval,

184: ORGANIZATION_ID,
185: PROCESS_ID,
186: TOP_PROCESS_ID,
187: PARENT_PROCESS_ID)
188: SELECT amw_execution_scope_s.nextval,
189: 'PROCESS_CERTIFICATION',
190: p_certification_id,
191: FND_GLOBAL.USER_ID,
192: SYSDATE,

Line 208: FROM AMW_EXECUTION_SCOPE

204: null,
205: null
206: FROM DUAL
207: WHERE not exists (SELECT 'Y'
208: FROM AMW_EXECUTION_SCOPE
209: WHERE entity_type='PROCESS_CERTIFICATION'
210: AND entity_id= p_certification_id
211: AND subsidiary_vs = audit_rec.subsidiary_valueset
212: AND subsidiary_code= audit_rec.company_code

Line 218: INSERT INTO AMW_EXECUTION_SCOPE (

214: AND lob_code = audit_rec.lob_code
215: AND level_id=2);
216:
217:
218: INSERT INTO AMW_EXECUTION_SCOPE (
219: EXECUTION_SCOPE_ID,
220: ENTITY_TYPE,
221: ENTITY_ID,
222: CREATED_BY,

Line 237: SELECT amw_execution_scope_s.nextval,

233: ORGANIZATION_ID,
234: PROCESS_ID,
235: TOP_PROCESS_ID,
236: PARENT_PROCESS_ID)
237: SELECT amw_execution_scope_s.nextval,
238: 'PROCESS_CERTIFICATION',
239: p_certification_id,
240: FND_GLOBAL.USER_ID,
241: SYSDATE,

Line 257: FROM AMW_EXECUTION_SCOPE

253: null,
254: null
255: FROM DUAL
256: WHERE not exists (SELECT 'Y'
257: FROM AMW_EXECUTION_SCOPE
258: WHERE entity_type='PROCESS_CERTIFICATION'
259: AND entity_id= p_certification_id
260: AND subsidiary_vs = audit_rec.subsidiary_valueset
261: AND subsidiary_code= audit_rec.company_code

Line 270: INSERT INTO AMW_EXECUTION_SCOPE (

266: END LOOP;
267:
268: FOR org_process_rec IN c_org_process LOOP
269:
270: INSERT INTO AMW_EXECUTION_SCOPE (
271: EXECUTION_SCOPE_ID,
272: ENTITY_TYPE,
273: ENTITY_ID,
274: CREATED_BY,

Line 289: SELECT amw_execution_scope_s.nextval,

285: ORGANIZATION_ID,
286: PROCESS_ID,
287: TOP_PROCESS_ID,
288: PARENT_PROCESS_ID)
289: SELECT amw_execution_scope_s.nextval,
290: 'PROCESS_CERTIFICATION',
291: p_certification_id,
292: FND_GLOBAL.USER_ID,
293: SYSDATE,

Line 309: FROM AMW_EXECUTION_SCOPE

305: org_process_rec.top_process_id,
306: -1
307: FROM DUAL
308: WHERE not exists (SELECT 'Y'
309: FROM AMW_EXECUTION_SCOPE
310: WHERE entity_type='PROCESS_CERTIFICATION'
311: AND entity_id= p_certification_id
312: AND subsidiary_vs = org_process_rec.subsidiary_valueset
313: AND subsidiary_code= org_process_rec.company_code

Line 410: DELETE FROM AMW_EXECUTION_SCOPE

406:
407: -- Initialize API return status to SUCCESS
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409:
410: DELETE FROM AMW_EXECUTION_SCOPE
411: WHERE entity_id = p_certification_id
412: AND entity_type = 'PROCESS_CERTIFICATION';
413:
414: FOR each_rec IN 1..p_org_tbl.count

Line 420: INSERT INTO AMW_EXECUTION_SCOPE (

416:
417: FOR audit_rec IN c_audit_unit(p_org_tbl(each_rec).org_id)
418: LOOP
419:
420: INSERT INTO AMW_EXECUTION_SCOPE (
421: EXECUTION_SCOPE_ID,
422: ENTITY_TYPE,
423: ENTITY_ID,
424: CREATED_BY,

Line 439: SELECT amw_execution_scope_s.nextval,

435: ORGANIZATION_ID,
436: PROCESS_ID,
437: TOP_PROCESS_ID,
438: PARENT_PROCESS_ID)
439: SELECT amw_execution_scope_s.nextval,
440: 'PROCESS_CERTIFICATION',
441: p_certification_id,
442: FND_GLOBAL.USER_ID,
443: SYSDATE,

Line 459: FROM AMW_EXECUTION_SCOPE

455: null,
456: null
457: FROM DUAL
458: WHERE not exists (SELECT 'Y'
459: FROM AMW_EXECUTION_SCOPE
460: WHERE entity_type='PROCESS_CERTIFICATION'
461: AND entity_id= p_certification_id
462: AND subsidiary_vs = audit_rec.subsidiary_valueset
463: AND subsidiary_code= audit_rec.company_code

Line 466: INSERT INTO AMW_EXECUTION_SCOPE (

462: AND subsidiary_vs = audit_rec.subsidiary_valueset
463: AND subsidiary_code= audit_rec.company_code
464: AND level_id=1);
465:
466: INSERT INTO AMW_EXECUTION_SCOPE (
467: EXECUTION_SCOPE_ID,
468: ENTITY_TYPE,
469: ENTITY_ID,
470: CREATED_BY,

Line 485: SELECT amw_execution_scope_s.nextval,

481: ORGANIZATION_ID,
482: PROCESS_ID,
483: TOP_PROCESS_ID,
484: PARENT_PROCESS_ID)
485: SELECT amw_execution_scope_s.nextval,
486: 'PROCESS_CERTIFICATION',
487: p_certification_id,
488: FND_GLOBAL.USER_ID,
489: SYSDATE,

Line 505: FROM AMW_EXECUTION_SCOPE

501: null,
502: null
503: FROM DUAL
504: WHERE not exists (SELECT 'Y'
505: FROM AMW_EXECUTION_SCOPE
506: WHERE entity_type='PROCESS_CERTIFICATION'
507: AND entity_id= p_certification_id
508: AND subsidiary_vs = audit_rec.subsidiary_valueset
509: AND subsidiary_code= audit_rec.company_code

Line 514: INSERT INTO AMW_EXECUTION_SCOPE (

510: AND lob_vs = audit_rec.lob_valueset
511: AND lob_code = audit_rec.lob_code
512: AND level_id=2);
513:
514: INSERT INTO AMW_EXECUTION_SCOPE (
515: EXECUTION_SCOPE_ID,
516: ENTITY_TYPE,
517: ENTITY_ID,
518: CREATED_BY,

Line 533: SELECT amw_execution_scope_s.nextval,

529: ORGANIZATION_ID,
530: PROCESS_ID,
531: TOP_PROCESS_ID,
532: PARENT_PROCESS_ID)
533: SELECT amw_execution_scope_s.nextval,
534: 'PROCESS_CERTIFICATION',
535: p_certification_id,
536: FND_GLOBAL.USER_ID,
537: SYSDATE,

Line 553: FROM AMW_EXECUTION_SCOPE

549: null,
550: null
551: FROM DUAL
552: WHERE not exists (SELECT 'Y'
553: FROM AMW_EXECUTION_SCOPE
554: WHERE entity_type='PROCESS_CERTIFICATION'
555: AND entity_id= p_certification_id
556: AND subsidiary_vs = audit_rec.subsidiary_valueset
557: AND subsidiary_code= audit_rec.company_code

Line 591: INSERT INTO AMW_EXECUTION_SCOPE (

587: l_lob_code,
588: l_lob_valueset;
589: EXIT WHEN process_cursor%NOTFOUND;
590:
591: INSERT INTO AMW_EXECUTION_SCOPE (
592: EXECUTION_SCOPE_ID,
593: ENTITY_TYPE,
594: ENTITY_ID,
595: CREATED_BY,

Line 610: SELECT amw_execution_scope_s.nextval,

606: ORGANIZATION_ID,
607: PROCESS_ID,
608: TOP_PROCESS_ID,
609: PARENT_PROCESS_ID)
610: SELECT amw_execution_scope_s.nextval,
611: 'PROCESS_CERTIFICATION',
612: p_certification_id,
613: FND_GLOBAL.USER_ID,
614: SYSDATE,

Line 630: FROM AMW_EXECUTION_SCOPE

626: l_process_id,
627: -1
628: FROM DUAL
629: WHERE not exists (SELECT 'Y'
630: FROM AMW_EXECUTION_SCOPE
631: WHERE entity_type='PROCESS_CERTIFICATION'
632: AND entity_id= p_certification_id
633: AND subsidiary_vs = l_subsidiary_valueset
634: AND subsidiary_code= l_company_code