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_ORG_HIERARCHY_PKG dependencies on AMW_AUDIT_UNITS_V

Line 2871: from amw_audit_units_v aauv

2867:
2868: cursor c2(pid number, orgName varchar2) is
2869: select aauv.organization_id,
2870: name
2871: from amw_audit_units_v aauv
2872: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
2873: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)
2874: and aauv.organization_id not in(
2875: select distinct organization_id

Line 2888: from amw_audit_units_v aauv

2884: and (UPPER(NAME) LIKE UPPER(orgName));
2885: cursor c3(pid number, rangeFrom varchar2, rangeTo varchar2) is
2886: select aauv.organization_id,
2887: name
2888: from amw_audit_units_v aauv
2889: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
2890: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)
2891: and aauv.organization_id not in(
2892: select distinct organization_id

Line 2923: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,

2919: union
2920: select pid process_to_count from dual;
2921:
2922:
2923: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,
2924: org_name amw_audit_units_v.name%type);
2925:
2926: type t_audit_units_tbl is table of t_audit_unit_rec;
2927: l_audit_units_tbl t_audit_units_tbl;

Line 2924: org_name amw_audit_units_v.name%type);

2920: select pid process_to_count from dual;
2921:
2922:
2923: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,
2924: org_name amw_audit_units_v.name%type);
2925:
2926: type t_audit_units_tbl is table of t_audit_unit_rec;
2927: l_audit_units_tbl t_audit_units_tbl;
2928:

Line 3096: from amw_audit_units_v aauv

3092: ,APO.last_update_login = G_LOGIN_ID
3093: where APO.end_date is null
3094: and APO.process_id <> -2
3095: and APO.organization_id in ( select aauv.organization_id
3096: from amw_audit_units_v aauv
3097: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
3098: and NAME >= p_org_range_from and substr(NAME,0,length(p_org_range_to))<= p_org_range_to);
3099: else
3100:

Line 3150: from amw_audit_units_v aauv

3146: ,APO.last_update_login = G_LOGIN_ID
3147: where APO.end_date is null
3148: and APO.process_id <> -2
3149: and APO.organization_id in ( select aauv.organization_id
3150: from amw_audit_units_v aauv
3151: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
3152: and (UPPER(NAME) LIKE UPPER(p_org_name || '%')));
3153:
3154: end if;

Line 3224: from amw_audit_units_v aauv

3220: where APO.approval_date is not null
3221: and APO.approval_end_date is null
3222: and APO.process_id <> -2
3223: and APO.organization_id in ( select aauv.organization_id
3224: from amw_audit_units_v aauv
3225: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
3226: and NAME >= p_org_range_from and substr(NAME,0,length(p_org_range_to))<= p_org_range_to);
3227: else
3228:

Line 3285: from amw_audit_units_v aauv

3281: where APO.approval_date is not null
3282: and APO.approval_end_date is null
3283: and APO.process_id <> -2
3284: and APO.organization_id in ( select aauv.organization_id
3285: from amw_audit_units_v aauv
3286: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
3287: and (UPPER(NAME) LIKE UPPER(p_org_name || '%')));
3288: end if;
3289:

Line 3459: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,

3455:
3456: TYPE t_org_cur IS REF CURSOR;
3457: l_org_cur t_org_cur;
3458:
3459: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,
3460: org_name amw_audit_units_v.name%type);
3461:
3462: type t_audit_units_tbl is table of t_audit_unit_rec;
3463: l_audit_units_tbl t_audit_units_tbl;

Line 3460: org_name amw_audit_units_v.name%type);

3456: TYPE t_org_cur IS REF CURSOR;
3457: l_org_cur t_org_cur;
3458:
3459: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,
3460: org_name amw_audit_units_v.name%type);
3461:
3462: type t_audit_units_tbl is table of t_audit_unit_rec;
3463: l_audit_units_tbl t_audit_units_tbl;
3464:

Line 3520: l_sql_string := 'select organization_id, name from amw_audit_units_v where organization_id in ( ' ||

3516:
3517: FOR k IN 1..TO_NUMBER(p_org_id_count) LOOP
3518: l_org_string := l_org_string || p_org_ids(k);
3519: END LOOP;
3520: l_sql_string := 'select organization_id, name from amw_audit_units_v where organization_id in ( ' ||
3521: replace(rtrim(l_org_string,'x'),'x',',') || ')';
3522: open l_org_cur for l_sql_string;
3523: fetch l_org_cur bulk collect into l_audit_units_tbl;
3524: close l_org_cur;

Line 8394: FROM amw_audit_units_v aauv,

8390: ELSIF p_org_range_from IS NOT NULL and p_org_range_to IS NOT NULL then
8391: init;
8392: SELECT DISTINCT aauv.organization_id
8393: BULK COLLECT INTO Org_Ids
8394: FROM amw_audit_units_v aauv,
8395: amw_process_organization apo
8396: WHERE aauv.organization_id=apo.organization_id
8397: AND NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
8398: AND apo.process_id=p_process_id

Line 8406: from amw_audit_units_v aauv,

8402: else
8403: init;
8404: select distinct aauv.organization_id
8405: BULK COLLECT INTO Org_Ids
8406: from amw_audit_units_v aauv,
8407: amw_process_organization apo
8408: where aauv.organization_id=apo.organization_id
8409: and NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
8410: and apo.process_id=p_process_id

Line 8610: from amw_audit_units_v aauv

8606:
8607: cursor c2(pid number, orgName varchar2) is
8608: select aauv.organization_id,
8609: name
8610: from amw_audit_units_v aauv
8611: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
8612: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)
8613: and aauv.organization_id not in(
8614: select distinct organization_id

Line 8627: from amw_audit_units_v aauv

8623: and (UPPER(NAME) LIKE UPPER(orgName));
8624: cursor c3(pid number, rangeFrom varchar2, rangeTo varchar2) is
8625: select aauv.organization_id,
8626: name
8627: from amw_audit_units_v aauv
8628: where NVL( AAUV.DATE_TO,SYSDATE ) >= SYSDATE
8629: and 'Y' = AMW_UTILITY_PVT.IS_ORG_REGISTERED(aauv.ORGANIZATION_ID)
8630: and aauv.organization_id not in(
8631: select distinct organization_id

Line 8663: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,

8659: select pid process_to_count from dual;
8660:
8661:
8662:
8663: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,
8664: org_name amw_audit_units_v.name%type);
8665:
8666: type t_audit_units_tbl is table of t_audit_unit_rec;
8667: l_audit_units_tbl t_audit_units_tbl;

Line 8664: org_name amw_audit_units_v.name%type);

8660:
8661:
8662:
8663: type t_audit_unit_rec is record (organization_id amw_audit_units_v.organization_id%type,
8664: org_name amw_audit_units_v.name%type);
8665:
8666: type t_audit_units_tbl is table of t_audit_unit_rec;
8667: l_audit_units_tbl t_audit_units_tbl;
8668: