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.EAM_COMPLETION dependencies on WF_EVENT

Line 976: l_wf_event_seq NUMBER;

972: l_workflow_type NUMBER;
973: l_event_name VARCHAR2(240);
974: l_parameter_list wf_parameter_list_t;
975: l_event_key VARCHAR2(200);
976: l_wf_event_seq NUMBER;
977: l_cost_estimate NUMBER;
978:
979:
980: BEGIN

Line 1171: AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE') )THEN

1167:
1168:
1169:
1170: IF(l_workflow_enabled='Y' AND x_transaction_type=2
1171: AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE') )THEN
1172: EAM_WORKFLOW_DETAILS_PUB.Eam_Wf_Is_Approval_Required(p_old_wo_rec => NULL,
1173: p_new_wo_rec => NULL,
1174: p_wip_entity_id => x_wip_entity_id,
1175: p_new_system_status => 3,

Line 1208: INTO l_wf_event_seq

1204: END;
1205:
1206:
1207: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1208: INTO l_wf_event_seq
1209: FROM DUAL;
1210:
1211: l_parameter_list := wf_parameter_list_t();
1212: l_event_name := l_status_pending_event;

Line 1214: l_event_key := TO_CHAR(l_wf_event_seq);

1210:
1211: l_parameter_list := wf_parameter_list_t();
1212: l_event_name := l_status_pending_event;
1213:
1214: l_event_key := TO_CHAR(l_wf_event_seq);
1215: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released change event','Building parameter list');
1216:
1217:
1218: INSERT INTO EAM_WO_WORKFLOWS

Line 1228: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

1224: );
1225:
1226:
1227: -- Add Parameters
1228: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1229: p_value => TO_CHAR(x_wip_entity_id),
1230: p_parameterlist => l_parameter_list);
1231: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1232: p_value =>l_wip_entity_name,

Line 1231: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

1227: -- Add Parameters
1228: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1229: p_value => TO_CHAR(x_wip_entity_id),
1230: p_parameterlist => l_parameter_list);
1231: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1232: p_value =>l_wip_entity_name,
1233: p_parameterlist => l_parameter_list);
1234: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1235: p_value => TO_CHAR(i_org_id),

Line 1234: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

1230: p_parameterlist => l_parameter_list);
1231: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1232: p_value =>l_wip_entity_name,
1233: p_parameterlist => l_parameter_list);
1234: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1235: p_value => TO_CHAR(i_org_id),
1236: p_parameterlist => l_parameter_list);
1237: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1238: p_value =>'3' ,

Line 1237: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',

1233: p_parameterlist => l_parameter_list);
1234: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1235: p_value => TO_CHAR(i_org_id),
1236: p_parameterlist => l_parameter_list);
1237: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1238: p_value =>'3' ,
1239: p_parameterlist => l_parameter_list);
1240: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1241: p_value => TO_CHAR(l_old_system_status),

Line 1240: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',

1236: p_parameterlist => l_parameter_list);
1237: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1238: p_value =>'3' ,
1239: p_parameterlist => l_parameter_list);
1240: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1241: p_value => TO_CHAR(l_old_system_status),
1242: p_parameterlist => l_parameter_list);
1243: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1244: p_value => TO_CHAR(l_old_eam_status),

Line 1243: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',

1239: p_parameterlist => l_parameter_list);
1240: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1241: p_value => TO_CHAR(l_old_system_status),
1242: p_parameterlist => l_parameter_list);
1243: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1244: p_value => TO_CHAR(l_old_eam_status),
1245: p_parameterlist => l_parameter_list);
1246: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1247: p_value => '3',

Line 1246: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',

1242: p_parameterlist => l_parameter_list);
1243: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1244: p_value => TO_CHAR(l_old_eam_status),
1245: p_parameterlist => l_parameter_list);
1246: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1247: p_value => '3',
1248: p_parameterlist => l_parameter_list);
1249: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1250: p_value => TO_CHAR(l_workflow_type),

Line 1249: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

1245: p_parameterlist => l_parameter_list);
1246: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1247: p_value => '3',
1248: p_parameterlist => l_parameter_list);
1249: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1250: p_value => TO_CHAR(l_workflow_type),
1251: p_parameterlist => l_parameter_list);
1252: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1253: p_value =>FND_GLOBAL.USER_NAME ,

Line 1252: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

1248: p_parameterlist => l_parameter_list);
1249: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1250: p_value => TO_CHAR(l_workflow_type),
1251: p_parameterlist => l_parameter_list);
1252: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1253: p_value =>FND_GLOBAL.USER_NAME ,
1254: p_parameterlist => l_parameter_list);
1255: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
1256: p_value => l_workflow_name,

Line 1255: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',

1251: p_parameterlist => l_parameter_list);
1252: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1253: p_value =>FND_GLOBAL.USER_NAME ,
1254: p_parameterlist => l_parameter_list);
1255: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
1256: p_value => l_workflow_name,
1257: p_parameterlist => l_parameter_list);
1258: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
1259: p_value => l_workflow_process,

Line 1258: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',

1254: p_parameterlist => l_parameter_list);
1255: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
1256: p_value => l_workflow_name,
1257: p_parameterlist => l_parameter_list);
1258: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
1259: p_value => l_workflow_process,
1260: p_parameterlist => l_parameter_list);
1261: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
1262: p_value => TO_CHAR(l_cost_estimate),

Line 1261: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',

1257: p_parameterlist => l_parameter_list);
1258: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
1259: p_value => l_workflow_process,
1260: p_parameterlist => l_parameter_list);
1261: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
1262: p_value => TO_CHAR(l_cost_estimate),
1263: p_parameterlist => l_parameter_list);
1264: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
1265:

Line 1266: Wf_Event.Raise( p_event_name => l_event_name,

1262: p_value => TO_CHAR(l_cost_estimate),
1263: p_parameterlist => l_parameter_list);
1264: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
1265:
1266: Wf_Event.Raise( p_event_name => l_event_name,
1267: p_event_key => l_event_key,
1268: p_parameters => l_parameter_list);
1269: l_parameter_list.DELETE;
1270: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released Event','After raising event');

Line 1739: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled

1735:
1736:
1737: --Raise status changed event when a workorder is completed/uncompleted
1738:
1739: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
1740: ) THEN
1741:
1742: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1743: INTO l_wf_event_seq

Line 1743: INTO l_wf_event_seq

1739: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
1740: ) THEN
1741:
1742: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1743: INTO l_wf_event_seq
1744: FROM DUAL;
1745:
1746: l_parameter_list := wf_parameter_list_t();
1747: l_event_name := l_status_changed_event;

Line 1749: l_event_key := TO_CHAR(l_wf_event_seq);

1745:
1746: l_parameter_list := wf_parameter_list_t();
1747: l_event_name := l_status_changed_event;
1748:
1749: l_event_key := TO_CHAR(l_wf_event_seq);
1750: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
1751: -- Add Parameters
1752: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1753: p_value => TO_CHAR(x_wip_entity_id),

Line 1752: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

1748:
1749: l_event_key := TO_CHAR(l_wf_event_seq);
1750: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
1751: -- Add Parameters
1752: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1753: p_value => TO_CHAR(x_wip_entity_id),
1754: p_parameterlist => l_parameter_list);
1755: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1756: p_value =>l_wip_entity_name,

Line 1755: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

1751: -- Add Parameters
1752: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1753: p_value => TO_CHAR(x_wip_entity_id),
1754: p_parameterlist => l_parameter_list);
1755: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1756: p_value =>l_wip_entity_name,
1757: p_parameterlist => l_parameter_list);
1758: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1759: p_value => TO_CHAR(i_org_id),

Line 1758: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

1754: p_parameterlist => l_parameter_list);
1755: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1756: p_value =>l_wip_entity_name,
1757: p_parameterlist => l_parameter_list);
1758: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1759: p_value => TO_CHAR(i_org_id),
1760: p_parameterlist => l_parameter_list);
1761: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1762: p_value => TO_CHAR(i_status_type),

Line 1761: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',

1757: p_parameterlist => l_parameter_list);
1758: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1759: p_value => TO_CHAR(i_org_id),
1760: p_parameterlist => l_parameter_list);
1761: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1762: p_value => TO_CHAR(i_status_type),
1763: p_parameterlist => l_parameter_list);
1764: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1765: p_value => TO_CHAR(i_status_type),

Line 1764: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',

1760: p_parameterlist => l_parameter_list);
1761: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1762: p_value => TO_CHAR(i_status_type),
1763: p_parameterlist => l_parameter_list);
1764: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1765: p_value => TO_CHAR(i_status_type),
1766: p_parameterlist => l_parameter_list);
1767: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1768: p_value => TO_CHAR(l_old_system_status),

Line 1767: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',

1763: p_parameterlist => l_parameter_list);
1764: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1765: p_value => TO_CHAR(i_status_type),
1766: p_parameterlist => l_parameter_list);
1767: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1768: p_value => TO_CHAR(l_old_system_status),
1769: p_parameterlist => l_parameter_list);
1770: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1771: p_value => TO_CHAR(l_old_eam_status),

Line 1770: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',

1766: p_parameterlist => l_parameter_list);
1767: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1768: p_value => TO_CHAR(l_old_system_status),
1769: p_parameterlist => l_parameter_list);
1770: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1771: p_value => TO_CHAR(l_old_eam_status),
1772: p_parameterlist => l_parameter_list);
1773: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1774: p_value => TO_CHAR(l_workflow_type),

Line 1773: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

1769: p_parameterlist => l_parameter_list);
1770: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1771: p_value => TO_CHAR(l_old_eam_status),
1772: p_parameterlist => l_parameter_list);
1773: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1774: p_value => TO_CHAR(l_workflow_type),
1775: p_parameterlist => l_parameter_list);
1776: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1777: p_value =>FND_GLOBAL.USER_NAME ,

Line 1776: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

1772: p_parameterlist => l_parameter_list);
1773: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1774: p_value => TO_CHAR(l_workflow_type),
1775: p_parameterlist => l_parameter_list);
1776: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1777: p_value =>FND_GLOBAL.USER_NAME ,
1778: p_parameterlist => l_parameter_list);
1779: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
1780:

Line 1781: Wf_Event.Raise( p_event_name => l_event_name,

1777: p_value =>FND_GLOBAL.USER_NAME ,
1778: p_parameterlist => l_parameter_list);
1779: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
1780:
1781: Wf_Event.Raise( p_event_name => l_event_name,
1782: p_event_key => l_event_key,
1783: p_parameters => l_parameter_list);
1784: l_parameter_list.DELETE;
1785: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status Changed Event','After raising event');