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: network_child_name VARCHAR2(240); -- fix for 9572411
979:
980:

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

1208:
1209:
1210:
1211: IF(l_workflow_enabled='Y' AND x_transaction_type=2
1212: AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE') )THEN
1213: EAM_WORKFLOW_DETAILS_PUB.Eam_Wf_Is_Approval_Required(p_old_wo_rec => NULL,
1214: p_new_wo_rec => NULL,
1215: p_wip_entity_id => x_wip_entity_id,
1216: p_new_system_status => 3,

Line 1249: INTO l_wf_event_seq

1245: END;
1246:
1247:
1248: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1249: INTO l_wf_event_seq
1250: FROM DUAL;
1251:
1252: l_parameter_list := wf_parameter_list_t();
1253: l_event_name := l_status_pending_event;

Line 1255: l_event_key := TO_CHAR(l_wf_event_seq);

1251:
1252: l_parameter_list := wf_parameter_list_t();
1253: l_event_name := l_status_pending_event;
1254:
1255: l_event_key := TO_CHAR(l_wf_event_seq);
1256: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released change event','Building parameter list');
1257:
1258:
1259: INSERT INTO EAM_WO_WORKFLOWS

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

1265: );
1266:
1267:
1268: -- Add Parameters
1269: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1270: p_value => TO_CHAR(x_wip_entity_id),
1271: p_parameterlist => l_parameter_list);
1272: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1273: p_value =>l_wip_entity_name,

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

1268: -- Add Parameters
1269: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1270: p_value => TO_CHAR(x_wip_entity_id),
1271: p_parameterlist => l_parameter_list);
1272: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1273: p_value =>l_wip_entity_name,
1274: p_parameterlist => l_parameter_list);
1275: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1276: p_value => TO_CHAR(i_org_id),

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

1271: p_parameterlist => l_parameter_list);
1272: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1273: p_value =>l_wip_entity_name,
1274: p_parameterlist => l_parameter_list);
1275: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1276: p_value => TO_CHAR(i_org_id),
1277: p_parameterlist => l_parameter_list);
1278: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1279: p_value =>'3' ,

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

1274: p_parameterlist => l_parameter_list);
1275: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1276: p_value => TO_CHAR(i_org_id),
1277: p_parameterlist => l_parameter_list);
1278: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1279: p_value =>'3' ,
1280: p_parameterlist => l_parameter_list);
1281: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1282: p_value => TO_CHAR(l_old_system_status),

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

1277: p_parameterlist => l_parameter_list);
1278: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1279: p_value =>'3' ,
1280: p_parameterlist => l_parameter_list);
1281: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1282: p_value => TO_CHAR(l_old_system_status),
1283: p_parameterlist => l_parameter_list);
1284: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1285: p_value => TO_CHAR(l_old_eam_status),

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

1280: p_parameterlist => l_parameter_list);
1281: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1282: p_value => TO_CHAR(l_old_system_status),
1283: p_parameterlist => l_parameter_list);
1284: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1285: p_value => TO_CHAR(l_old_eam_status),
1286: p_parameterlist => l_parameter_list);
1287: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1288: p_value => '3',

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

1283: p_parameterlist => l_parameter_list);
1284: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1285: p_value => TO_CHAR(l_old_eam_status),
1286: p_parameterlist => l_parameter_list);
1287: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1288: p_value => '3',
1289: p_parameterlist => l_parameter_list);
1290: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1291: p_value => TO_CHAR(l_workflow_type),

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

1286: p_parameterlist => l_parameter_list);
1287: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1288: p_value => '3',
1289: p_parameterlist => l_parameter_list);
1290: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1291: p_value => TO_CHAR(l_workflow_type),
1292: p_parameterlist => l_parameter_list);
1293: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1294: p_value =>FND_GLOBAL.USER_NAME ,

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

1289: p_parameterlist => l_parameter_list);
1290: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1291: p_value => TO_CHAR(l_workflow_type),
1292: p_parameterlist => l_parameter_list);
1293: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1294: p_value =>FND_GLOBAL.USER_NAME ,
1295: p_parameterlist => l_parameter_list);
1296: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
1297: p_value => l_workflow_name,

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

1292: p_parameterlist => l_parameter_list);
1293: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1294: p_value =>FND_GLOBAL.USER_NAME ,
1295: p_parameterlist => l_parameter_list);
1296: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
1297: p_value => l_workflow_name,
1298: p_parameterlist => l_parameter_list);
1299: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
1300: p_value => l_workflow_process,

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

1295: p_parameterlist => l_parameter_list);
1296: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
1297: p_value => l_workflow_name,
1298: p_parameterlist => l_parameter_list);
1299: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
1300: p_value => l_workflow_process,
1301: p_parameterlist => l_parameter_list);
1302: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
1303: p_value => TO_CHAR(l_cost_estimate),

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

1298: p_parameterlist => l_parameter_list);
1299: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
1300: p_value => l_workflow_process,
1301: p_parameterlist => l_parameter_list);
1302: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
1303: p_value => TO_CHAR(l_cost_estimate),
1304: p_parameterlist => l_parameter_list);
1305: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
1306:

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

1303: p_value => TO_CHAR(l_cost_estimate),
1304: p_parameterlist => l_parameter_list);
1305: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
1306:
1307: Wf_Event.Raise( p_event_name => l_event_name,
1308: p_event_key => l_event_key,
1309: p_parameters => l_parameter_list);
1310: l_parameter_list.DELETE;
1311: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released Event','After raising event');

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

1782:
1783:
1784: --Raise status changed event when a workorder is completed/uncompleted
1785:
1786: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
1787: ) THEN
1788:
1789: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1790: INTO l_wf_event_seq

Line 1790: INTO l_wf_event_seq

1786: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
1787: ) THEN
1788:
1789: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
1790: INTO l_wf_event_seq
1791: FROM DUAL;
1792:
1793: l_parameter_list := wf_parameter_list_t();
1794: l_event_name := l_status_changed_event;

Line 1796: l_event_key := TO_CHAR(l_wf_event_seq);

1792:
1793: l_parameter_list := wf_parameter_list_t();
1794: l_event_name := l_status_changed_event;
1795:
1796: l_event_key := TO_CHAR(l_wf_event_seq);
1797: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
1798: -- Add Parameters
1799: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1800: p_value => TO_CHAR(x_wip_entity_id),

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

1795:
1796: l_event_key := TO_CHAR(l_wf_event_seq);
1797: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
1798: -- Add Parameters
1799: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1800: p_value => TO_CHAR(x_wip_entity_id),
1801: p_parameterlist => l_parameter_list);
1802: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1803: p_value =>l_wip_entity_name,

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

1798: -- Add Parameters
1799: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
1800: p_value => TO_CHAR(x_wip_entity_id),
1801: p_parameterlist => l_parameter_list);
1802: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1803: p_value =>l_wip_entity_name,
1804: p_parameterlist => l_parameter_list);
1805: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1806: p_value => TO_CHAR(i_org_id),

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

1801: p_parameterlist => l_parameter_list);
1802: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
1803: p_value =>l_wip_entity_name,
1804: p_parameterlist => l_parameter_list);
1805: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1806: p_value => TO_CHAR(i_org_id),
1807: p_parameterlist => l_parameter_list);
1808: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1809: p_value => TO_CHAR(i_status_type),

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

1804: p_parameterlist => l_parameter_list);
1805: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
1806: p_value => TO_CHAR(i_org_id),
1807: p_parameterlist => l_parameter_list);
1808: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1809: p_value => TO_CHAR(i_status_type),
1810: p_parameterlist => l_parameter_list);
1811: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1812: p_value => TO_CHAR(i_status_type),

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

1807: p_parameterlist => l_parameter_list);
1808: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
1809: p_value => TO_CHAR(i_status_type),
1810: p_parameterlist => l_parameter_list);
1811: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1812: p_value => TO_CHAR(i_status_type),
1813: p_parameterlist => l_parameter_list);
1814: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1815: p_value => TO_CHAR(l_old_system_status),

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

1810: p_parameterlist => l_parameter_list);
1811: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
1812: p_value => TO_CHAR(i_status_type),
1813: p_parameterlist => l_parameter_list);
1814: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1815: p_value => TO_CHAR(l_old_system_status),
1816: p_parameterlist => l_parameter_list);
1817: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1818: p_value => TO_CHAR(l_old_eam_status),

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

1813: p_parameterlist => l_parameter_list);
1814: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
1815: p_value => TO_CHAR(l_old_system_status),
1816: p_parameterlist => l_parameter_list);
1817: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1818: p_value => TO_CHAR(l_old_eam_status),
1819: p_parameterlist => l_parameter_list);
1820: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1821: p_value => TO_CHAR(l_workflow_type),

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

1816: p_parameterlist => l_parameter_list);
1817: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
1818: p_value => TO_CHAR(l_old_eam_status),
1819: p_parameterlist => l_parameter_list);
1820: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1821: p_value => TO_CHAR(l_workflow_type),
1822: p_parameterlist => l_parameter_list);
1823: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1824: p_value =>FND_GLOBAL.USER_NAME ,

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

1819: p_parameterlist => l_parameter_list);
1820: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1821: p_value => TO_CHAR(l_workflow_type),
1822: p_parameterlist => l_parameter_list);
1823: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1824: p_value =>FND_GLOBAL.USER_NAME ,
1825: p_parameterlist => l_parameter_list);
1826: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
1827:

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

1824: p_value =>FND_GLOBAL.USER_NAME ,
1825: p_parameterlist => l_parameter_list);
1826: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
1827:
1828: Wf_Event.Raise( p_event_name => l_event_name,
1829: p_event_key => l_event_key,
1830: p_parameters => l_parameter_list);
1831: l_parameter_list.DELETE;
1832: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status Changed Event','After raising event');