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_UTILITY_PVT dependencies on AMW_PROCESS

Line 827: from wf_activities_tl watl, wf_activities wa, amw_process ap

823: FUNCTION get_process_name(p_process_id in number) return varchar2 is
824: l_process_name varchar2(240);
825: begin
826: select watl.display_name into l_process_name
827: from wf_activities_tl watl, wf_activities wa, amw_process ap
828: where ap.process_id = p_process_id
829: and ap.name = wa.name
830: and wa.item_type = 'AUDITMGR'
831: and wa.end_date is null

Line 1035: from amw_process

1031: else
1032: if p_objectContext = 'PROCESS' then
1033: select Process_Owner_Id
1034: into process_owner_id
1035: from amw_process
1036: where process_id = p_pk;
1037: elsif p_objectContext = 'PROCESS_ORG' then
1038: select Process_Owner_Id
1039: into process_owner_id

Line 1040: from amw_process_organization

1036: where process_id = p_pk;
1037: elsif p_objectContext = 'PROCESS_ORG' then
1038: select Process_Owner_Id
1039: into process_owner_id
1040: from amw_process_organization
1041: where process_organization_id = p_pk;
1042: end if;
1043:
1044: select person_party_id

Line 1147: l_display_name amw_process_names_tl.display_name%type;

1143:
1144:
1145: FUNCTION get_process_name_approved (p_process_id in number) return varchar2
1146: is
1147: l_display_name amw_process_names_tl.display_name%type;
1148: begin
1149: select display_name into l_display_name
1150: from amw_process amwp,
1151: amw_process_names_tl amwp_tl

Line 1150: from amw_process amwp,

1146: is
1147: l_display_name amw_process_names_tl.display_name%type;
1148: begin
1149: select display_name into l_display_name
1150: from amw_process amwp,
1151: amw_process_names_tl amwp_tl
1152: where amwp.process_rev_id = amwp_tl.process_rev_id and
1153: amwp.process_id = p_process_id and
1154: amwp.approval_date is not null and

Line 1151: amw_process_names_tl amwp_tl

1147: l_display_name amw_process_names_tl.display_name%type;
1148: begin
1149: select display_name into l_display_name
1150: from amw_process amwp,
1151: amw_process_names_tl amwp_tl
1152: where amwp.process_rev_id = amwp_tl.process_rev_id and
1153: amwp.process_id = p_process_id and
1154: amwp.approval_date is not null and
1155: amwp.approval_end_date is null and

Line 1173: l_display_name amw_process_names_tl.display_name%type;

1169: FUNCTION get_process_name_by_status(p_process_id in number,
1170: p_status in varchar2) return varchar2
1171:
1172: is
1173: l_display_name amw_process_names_tl.display_name%type;
1174: begin
1175:
1176: if(p_status = 'L')
1177: then

Line 1179: from amw_process amwp,

1175:
1176: if(p_status = 'L')
1177: then
1178: select display_name into l_display_name
1179: from amw_process amwp,
1180: amw_process_names_tl amwp_tl
1181: where amwp.process_rev_id = amwp_tl.process_rev_id and
1182: amwp.process_id = p_process_id and
1183: amwp.end_date is null and

Line 1180: amw_process_names_tl amwp_tl

1176: if(p_status = 'L')
1177: then
1178: select display_name into l_display_name
1179: from amw_process amwp,
1180: amw_process_names_tl amwp_tl
1181: where amwp.process_rev_id = amwp_tl.process_rev_id and
1182: amwp.process_id = p_process_id and
1183: amwp.end_date is null and
1184: amwp_tl.language=userenv('LANG');

Line 1192: from amw_process amwp,

1188:
1189: if(p_status = 'A')
1190: then
1191: select display_name into l_display_name
1192: from amw_process amwp,
1193: amw_process_names_tl amwp_tl
1194: where amwp.process_rev_id = amwp_tl.process_rev_id and
1195: amwp.process_id = p_process_id and
1196: amwp.approval_date is not null and

Line 1193: amw_process_names_tl amwp_tl

1189: if(p_status = 'A')
1190: then
1191: select display_name into l_display_name
1192: from amw_process amwp,
1193: amw_process_names_tl amwp_tl
1194: where amwp.process_rev_id = amwp_tl.process_rev_id and
1195: amwp.process_id = p_process_id and
1196: amwp.approval_date is not null and
1197: amwp.approval_end_date is null and

Line 1223: l_display_name amw_process_names_tl.display_name%type;

1219: --11/06/2004 KOSRINIV Created
1220: ---------------------------------------------------------------------
1221: FUNCTION get_approved_org_process_name (p_process_id in number, p_org_id in number) return varchar2
1222: is
1223: l_display_name amw_process_names_tl.display_name%type;
1224: begin
1225: select display_name into l_display_name
1226: from amw_process_organization apo,
1227: amw_process_names_tl amwp_tl

Line 1226: from amw_process_organization apo,

1222: is
1223: l_display_name amw_process_names_tl.display_name%type;
1224: begin
1225: select display_name into l_display_name
1226: from amw_process_organization apo,
1227: amw_process_names_tl amwp_tl
1228: where apo.approval_date is not null
1229: and apo.approval_end_date is null
1230: and apo.rl_process_rev_id = amwp_tl.process_rev_id

Line 1227: amw_process_names_tl amwp_tl

1223: l_display_name amw_process_names_tl.display_name%type;
1224: begin
1225: select display_name into l_display_name
1226: from amw_process_organization apo,
1227: amw_process_names_tl amwp_tl
1228: where apo.approval_date is not null
1229: and apo.approval_end_date is null
1230: and apo.rl_process_rev_id = amwp_tl.process_rev_id
1231: and apo.process_id = p_process_id

Line 1250: from amw_process_locks

1246: begin
1247:
1248: if p_process_id IS null then
1249: select 1 INTO l_dummy
1250: from amw_process_locks
1251: where organization_id = p_org_id;
1252: else
1253: select 1
1254: into l_dummy

Line 1255: from amw_process_locks

1251: where organization_id = p_org_id;
1252: else
1253: select 1
1254: into l_dummy
1255: from amw_process_locks
1256: where locked_process_id = p_process_id
1257: and organization_id = p_org_id;
1258: end if;
1259:

Line 1307: FROM AMW_PROCESS_OBJECTIVES_VL APV,

1303: is
1304: l_dummy varchar2(80):=null;
1305: begin
1306: SELECT APV.name into l_dummy
1307: FROM AMW_PROCESS_OBJECTIVES_VL APV,
1308: AMW_OBJECTIVE_ASSOCIATIONS AOA
1309: WHERE
1310: APV.PROCESS_OBJECTIVE_ID =AOA.PROCESS_OBJECTIVE_ID
1311: AND AOA.PK1 = p_org_id

Line 1371: FROM AMW_PROCESS_OBJECTIVES_VL APV,

1367: is
1368: l_dummy varchar2(80):=null;
1369: begin
1370: SELECT APV.name into l_dummy
1371: FROM AMW_PROCESS_OBJECTIVES_VL APV,
1372: AMW_OBJECTIVE_ASSOCIATIONS AOA
1373: WHERE
1374: APV.PROCESS_OBJECTIVE_ID =AOA.PROCESS_OBJECTIVE_ID
1375: AND AOA.PK1 = p_org_id

Line 1463: amw_process ap

1459: select
1460: count(1) into dummy_count
1461: from
1462: amw_control_associations aca,
1463: amw_process ap
1464: where
1465: aca.pk1 = ap.process_id
1466: and aca.object_type = 'RISK'
1467: and aca.pk1 = ap.process_id

Line 1493: amw_process_vl apvl

1489: select
1490: ((select count(1)
1491: from
1492: amw_control_associations aca,
1493: amw_process_vl apvl
1494: where
1495: aca.object_type = 'RISK'
1496: and aca.pk1 = apvl.process_id
1497: and aca.pk2 = p_risk_id

Line 1506: amw_process ap

1502: (select count(1)
1503: from
1504: amw_control_associations aca,
1505: Amw_Proc_Hierarchy_Denorm aphd,
1506: amw_process ap
1507: where aphd.process_id = ap.process_id
1508: and aphd.up_down_ind = 'D'
1509: and ap.process_id = aphd.parent_child_id
1510: and aca.object_type = 'RISK'

Line 1920: from amw_process_organization

1916: l_dummy varchar2(1):='N';
1917: BEGIN
1918: -- for the time being we just check for the existance of -2 row in org.if it present then the org is usable to assign processes.
1919: select 'Y' into l_dummy
1920: from amw_process_organization
1921: where organization_id = p_org_id
1922: and process_id = -2;
1923: return l_dummy;
1924: EXCEPTION