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_WF_HIERARCHY_PKG dependencies on AMW_PROCESS_ORGANIZATION

Line 678: (process_id amw_process_organization.process_id%type,

674:
675: procedure reset_proc_org_risk_ctrl_count( p_org_id IN NUMBER) is
676:
677: type rec_amw_porg_counts IS record
678: (process_id amw_process_organization.process_id%type,
679: no_assoc_risks amw_process_organization.risk_count%type,
680: no_assoc_controls amw_process_organization.control_count%type,
681: risk_count amw_process_organization.risk_count%type,
682: control_count amw_process_organization.control_count%type);

Line 679: no_assoc_risks amw_process_organization.risk_count%type,

675: procedure reset_proc_org_risk_ctrl_count( p_org_id IN NUMBER) is
676:
677: type rec_amw_porg_counts IS record
678: (process_id amw_process_organization.process_id%type,
679: no_assoc_risks amw_process_organization.risk_count%type,
680: no_assoc_controls amw_process_organization.control_count%type,
681: risk_count amw_process_organization.risk_count%type,
682: control_count amw_process_organization.control_count%type);
683:

Line 680: no_assoc_controls amw_process_organization.control_count%type,

676:
677: type rec_amw_porg_counts IS record
678: (process_id amw_process_organization.process_id%type,
679: no_assoc_risks amw_process_organization.risk_count%type,
680: no_assoc_controls amw_process_organization.control_count%type,
681: risk_count amw_process_organization.risk_count%type,
682: control_count amw_process_organization.control_count%type);
683:
684:

Line 681: risk_count amw_process_organization.risk_count%type,

677: type rec_amw_porg_counts IS record
678: (process_id amw_process_organization.process_id%type,
679: no_assoc_risks amw_process_organization.risk_count%type,
680: no_assoc_controls amw_process_organization.control_count%type,
681: risk_count amw_process_organization.risk_count%type,
682: control_count amw_process_organization.control_count%type);
683:
684:
685: v_rec_amw_porg_counts rec_amw_porg_counts;

Line 682: control_count amw_process_organization.control_count%type);

678: (process_id amw_process_organization.process_id%type,
679: no_assoc_risks amw_process_organization.risk_count%type,
680: no_assoc_controls amw_process_organization.control_count%type,
681: risk_count amw_process_organization.risk_count%type,
682: control_count amw_process_organization.control_count%type);
683:
684:
685: v_rec_amw_porg_counts rec_amw_porg_counts;
686: type t_amw_porg_counts IS table of rec_amw_porg_counts index by binary_integer;

Line 691: from amw_process_organization

687: v_amw_porg_counts t_amw_porg_counts;
688:
689: cursor c_populate_amw_org_counts(l_org_id number) is
690: select process_id, risk_count, control_count, 0, 0
691: from amw_process_organization
692: where organization_id = l_org_id
693: and end_date is null;
694:
695: cursor c_org(p_org_id number) is

Line 696: select distinct organization_id from amw_process_organization where organization_id = nvl(p_org_id, organization_id) and end_date is null;

692: where organization_id = l_org_id
693: and end_date is null;
694:
695: cursor c_org(p_org_id number) is
696: select distinct organization_id from amw_process_organization where organization_id = nvl(p_org_id, organization_id) and end_date is null;
697:
698: l_org number;
699: v_index NUMBER;
700: l_risk_count number;

Line 705: update amw_process_organization apo

701: l_control_count number;
702: insert_row_cnt number;
703:
704: begin
705: update amw_process_organization apo
706: set risk_count =
707: (select count(ara.risk_id)
708: from amw_risk_associations ara
709: where pk1 = apo.process_organization_id

Line 740: from amw_process_organization amwp, Amw_Org_Hierarchy_Denorm aodenorm

736: loop
737:
738: select nvl(sum(risk_count), 0), nvl(sum(control_count), 0)
739: into l_risk_count, l_control_count
740: from amw_process_organization amwp, Amw_Org_Hierarchy_Denorm aodenorm
741: where aodenorm.organization_id = l_org
742: and aodenorm.process_id = v_index
743: and aodenorm.up_down_ind = 'D'
744: and amwp.process_id = aodenorm.parent_child_id

Line 759: update amw_process_organization

755: v_index := v_amw_porg_counts.first;
756: while v_index <= v_amw_porg_counts.last
757: loop
758:
759: update amw_process_organization
760: set risk_count = v_amw_porg_counts(v_index).risk_count,
761: control_count = v_amw_porg_counts(v_index).control_count
762: where process_id = v_index
763: and organization_id = l_org

Line 798: select process_id from amw_process_organization where organization_id = l_org_id and end_date is null;

794:
795: procedure populate_flatlist(p_org_id in number) is
796:
797: cursor c11(l_org_id number) is
798: select process_id from amw_process_organization where organization_id = l_org_id and end_date is null;
799:
800: type t_apo_id is table of amw_process_organization.process_id%type;
801: v_apo_id t_apo_id;
802:

Line 800: type t_apo_id is table of amw_process_organization.process_id%type;

796:
797: cursor c11(l_org_id number) is
798: select process_id from amw_process_organization where organization_id = l_org_id and end_date is null;
799:
800: type t_apo_id is table of amw_process_organization.process_id%type;
801: v_apo_id t_apo_id;
802:
803: v_index number;
804: v_indexDown number;

Line 1490: delete from amw_process_organization

1486: x_msg_data => x_msg_data );
1487:
1488: disassoc_proc_org_hier(p_process_id =>p_process_id, p_org_id => p_org_id);
1489:
1490: delete from amw_process_organization
1491: where organization_id = p_org_id
1492: and end_date is not null;
1493:
1494: populate_flatlist(p_org_id);

Line 1806: from amw_process_organization amwpo

1802: begin
1803:
1804: update amw_process amwp
1805: set amwp.org_count = (select count(process_organization_id)
1806: from amw_process_organization amwpo
1807: where amwpo.process_id = amwp.process_id
1808: and amwpo.end_date is null);
1809: exception
1810: when deadlock_detected then

Line 2009: from amw_process_organization

2005: l_org_id number;
2006:
2007: cursor c_all_orgs(l_pid number) is
2008: select distinct organization_id
2009: from amw_process_organization
2010: where process_id = l_pid
2011: and end_date is null;
2012:
2013: cursor c_all_exorgs(l_pid number) is

Line 2015: from amw_process_organization

2011: and end_date is null;
2012:
2013: cursor c_all_exorgs(l_pid number) is
2014: select distinct organization_id
2015: from amw_process_organization
2016: where process_id = l_pid
2017: and end_date is null
2018: and organization_id not in
2019: (select distinct old_pk1 from amw_exceptions_b where ((old_pk2 = l_pid and object_type in ('PROCESS','RISK','CONTROL'))or (object_type = 'PROCESS' and old_pk3 = l_pid)) and old_pk1 is not null)

Line 2366: from amw_process_organization

2362: j := oldCount1 + 1;
2363: FOR i IN j..v_child_name.count LOOP
2364: begin
2365: select 1 into l_dummy
2366: from amw_process_organization
2367: where end_date is null
2368: and process_id = (select process_id from amw_process where name = v_child_name(i));
2369: oldCount1 := v_child_name.count;
2370: return 1;

Line 2398: from amw_process_organization

2394: begin
2395: x_return_status := FND_API.G_RET_STS_SUCCESS;
2396:
2397: select 1 into l_dummy
2398: from amw_process_organization
2399: where process_id = p_process_id
2400: and end_date is null;
2401:
2402: p_out := 1;

Line 2579: from amw_process_organization

2575: end;
2576:
2577: begin
2578: select 1 into l_dummy
2579: from amw_process_organization
2580: where end_date is null
2581: and organization_id = p_org_id
2582: and process_owner_id = l_party_id;
2583: return 1;

Line 2883: type t_org is table of amw_process_organization.organization_id%type;

2879: v_amwp_name t_amwp_name;
2880: type t_amwp_pid is table of amw_process.process_id%type;
2881: v_amwp_pid t_amwp_pid;
2882:
2883: type t_org is table of amw_process_organization.organization_id%type;
2884: v_org t_org;
2885:
2886: --type rec_amw IS record
2887: -- (name amw_process.name%type,

Line 2933: from amw_process_organization

2929: from amw_process;
2930:
2931: cursor c_org (p_pid number) is
2932: select organization_id
2933: from amw_process_organization
2934: where process_id = p_pid;
2935:
2936: cursor exceptions_to_be_del is
2937: select exception_id

Line 3250: type t_org is table of amw_process_organization.organization_id%type;

3246: v_amwp_name t_amwp_name;
3247: type t_amwp_pid is table of amw_process.process_id%type;
3248: v_amwp_pid t_amwp_pid;
3249:
3250: type t_org is table of amw_process_organization.organization_id%type;
3251: v_org t_org;
3252:
3253: type t_delete_list IS table of amw_process.name%type index by binary_integer;
3254: v_delete_list t_delete_list;

Line 3274: from amw_process_organization

3270: from amw_process;
3271:
3272: cursor c_org (p_pid number) is
3273: select organization_id
3274: from amw_process_organization
3275: where process_id = p_pid;
3276:
3277: cursor exceptions_to_be_del is
3278: select exception_id