APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_PROCESS

Line 1: PACKAGE BODY AMW_PROCESS_CERT_SUMMARY as

1: PACKAGE BODY AMW_PROCESS_CERT_SUMMARY as
2: /* $Header: amwpcesb.pls 120.5.12000000.6 2007/03/28 21:21:09 npanandi ship $ */
3:
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 322: amw_process_organization procorg

318: IS
319: SELECT count(1)
320: FROM (SELECT distinct procorg.organization_id, procorg.process_id
321: FROM amw_execution_scope scp,
322: amw_process_organization procorg
323: WHERE scp.process_org_rev_id = procorg.process_org_rev_id
324: AND procorg.standard_variation IN
325: (select process_rev_id
326: from amw_process

Line 326: from amw_process

322: amw_process_organization procorg
323: WHERE scp.process_org_rev_id = procorg.process_org_rev_id
324: AND procorg.standard_variation IN
325: (select process_rev_id
326: from amw_process
327: where process_id = p_process_id)
328: AND scp.organization_id IN
329: (SELECT object_id
330: FROM amw_entity_hierarchies

Line 374: amw_process_organization procorg

370: SELECT count(1)
371: FROM (SELECT distinct opinion.pk1_value, opinion.pk3_value
372: FROM amw_opinions_v opinion,
373: amw_execution_scope scp,
374: amw_process_organization procorg
375: WHERE opinion.pk2_value = p_certification_id
376: AND opinion.pk1_value = scp.process_id
377: AND opinion.pk3_value = scp.organization_id
378: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'

Line 383: from amw_process

379: AND scp.entity_id = p_certification_id
380: AND scp.process_org_rev_id = procorg.process_org_rev_id
381: AND procorg.standard_variation in
382: (select process_rev_id
383: from amw_process
384: where process_id = p_process_id)
385: AND scp.organization_id IN
386: (SELECT object_id
387: FROM amw_entity_hierarchies

Line 495: amw_process_organization procorg

491: SELECT count(1)
492: FROM (SELECT distinct opinion.pk1_value, opinion.pk3_value
493: FROM amw_opinions_v opinion,
494: amw_execution_scope scp,
495: amw_process_organization procorg
496: WHERE opinion.pk2_value = p_certification_id
497: AND opinion.pk1_value = scp.process_id
498: AND opinion.pk3_value = scp.organization_id
499: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'

Line 504: from amw_process

500: AND scp.entity_id = p_certification_id
501: AND scp.process_org_rev_id = procorg.process_org_rev_id
502: AND procorg.standard_variation in
503: (select process_rev_id
504: from amw_process
505: where process_id = p_process_id)
506: AND scp.organization_id IN
507: (SELECT object_id
508: FROM amw_entity_hierarchies

Line 1512: amw_process_cert_scope_pvt.insert_audit_units

1508: --In AMW.D and future releases we don't need to rescope everytime the user runs the concurrent program
1509:
1510: /*IF p_certification_id IS NOT NULL
1511: THEN
1512: amw_process_cert_scope_pvt.insert_audit_units
1513: (p_certification_id => p_certification_id,
1514: x_return_status => lx_return_status,
1515: x_msg_count => lx_msg_count,
1516: x_msg_data => lx_msg_data);

Line 1526: amw_process_cert_scope_pvt.insert_audit_units

1522:
1523: ELSE
1524: FOR each_record IN get_all_certifications
1525: LOOP
1526: amw_process_cert_scope_pvt.insert_audit_units
1527: (p_certification_id => each_record.certification_id,
1528: x_return_status => lx_return_status,
1529: x_msg_count => lx_msg_count,
1530: x_msg_data => lx_msg_data);

Line 1748: END AMW_PROCESS_CERT_SUMMARY;

1744:
1745: END Populate_Proccert_Findings;
1746:
1747:
1748: END AMW_PROCESS_CERT_SUMMARY;