DBA Data[Home] [Help]

APPS.EAM_JOBCLOSE_PRIV dependencies on WF_EVENT

Line 20: l_wf_event_seq NUMBER;

16: l_status_changed_event VARCHAR2(240);
17: l_event_name VARCHAR2(240);
18: l_parameter_list wf_parameter_list_t;
19: l_event_key VARCHAR2(200);
20: l_wf_event_seq NUMBER;
21: l_estimation_status NUMBER;
22: l_cost_estimate NUMBER;
23: l_return_status VARCHAR2(1);
24: l_err_text VARCHAR2(2000);

Line 31: IF (WF_EVENT.TEST(l_status_changed_event) <> 'NONE' --if status change event enabled

27: BEGIN
28:
29: l_status_changed_event := 'oracle.apps.eam.workorder.status.changed';
30:
31: IF (WF_EVENT.TEST(l_status_changed_event) <> 'NONE' --if status change event enabled
32: ) THEN
33: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
34: INTO l_wf_event_seq
35: FROM DUAL;

Line 34: INTO l_wf_event_seq

30:
31: IF (WF_EVENT.TEST(l_status_changed_event) <> 'NONE' --if status change event enabled
32: ) THEN
33: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
34: INTO l_wf_event_seq
35: FROM DUAL;
36:
37: l_parameter_list := wf_parameter_list_t();
38: l_event_name := l_status_changed_event;

Line 40: l_event_key := TO_CHAR(l_wf_event_seq);

36:
37: l_parameter_list := wf_parameter_list_t();
38: l_event_name := l_status_changed_event;
39:
40: l_event_key := TO_CHAR(l_wf_event_seq);
41: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
42: -- Add Parameters
43: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
44: p_value => TO_CHAR(p_wip_entity_id),

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

39:
40: l_event_key := TO_CHAR(l_wf_event_seq);
41: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
42: -- Add Parameters
43: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
44: p_value => TO_CHAR(p_wip_entity_id),
45: p_parameterlist => l_parameter_list);
46: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
47: p_value =>p_wip_entity_name,

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

42: -- Add Parameters
43: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
44: p_value => TO_CHAR(p_wip_entity_id),
45: p_parameterlist => l_parameter_list);
46: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
47: p_value =>p_wip_entity_name,
48: p_parameterlist => l_parameter_list);
49: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
50: p_value => TO_CHAR(p_organization_id),

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

45: p_parameterlist => l_parameter_list);
46: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
47: p_value =>p_wip_entity_name,
48: p_parameterlist => l_parameter_list);
49: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
50: p_value => TO_CHAR(p_organization_id),
51: p_parameterlist => l_parameter_list);
52: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
53: p_value => TO_CHAR(p_new_status),

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

48: p_parameterlist => l_parameter_list);
49: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
50: p_value => TO_CHAR(p_organization_id),
51: p_parameterlist => l_parameter_list);
52: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
53: p_value => TO_CHAR(p_new_status),
54: p_parameterlist => l_parameter_list);
55: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
56: p_value => TO_CHAR(p_new_status),

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

51: p_parameterlist => l_parameter_list);
52: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
53: p_value => TO_CHAR(p_new_status),
54: p_parameterlist => l_parameter_list);
55: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
56: p_value => TO_CHAR(p_new_status),
57: p_parameterlist => l_parameter_list);
58: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
59: p_value => TO_CHAR(p_old_system_status),

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

54: p_parameterlist => l_parameter_list);
55: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
56: p_value => TO_CHAR(p_new_status),
57: p_parameterlist => l_parameter_list);
58: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
59: p_value => TO_CHAR(p_old_system_status),
60: p_parameterlist => l_parameter_list);
61: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
62: p_value => TO_CHAR(p_old_wo_status),

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

57: p_parameterlist => l_parameter_list);
58: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
59: p_value => TO_CHAR(p_old_system_status),
60: p_parameterlist => l_parameter_list);
61: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
62: p_value => TO_CHAR(p_old_wo_status),
63: p_parameterlist => l_parameter_list);
64: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
65: p_value => TO_CHAR(p_workflow_type),

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

60: p_parameterlist => l_parameter_list);
61: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
62: p_value => TO_CHAR(p_old_wo_status),
63: p_parameterlist => l_parameter_list);
64: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
65: p_value => TO_CHAR(p_workflow_type),
66: p_parameterlist => l_parameter_list);
67: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
68: p_value =>FND_GLOBAL.USER_NAME ,

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

63: p_parameterlist => l_parameter_list);
64: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
65: p_value => TO_CHAR(p_workflow_type),
66: p_parameterlist => l_parameter_list);
67: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
68: p_value =>FND_GLOBAL.USER_NAME ,
69: p_parameterlist => l_parameter_list);
70: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
71:

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

68: p_value =>FND_GLOBAL.USER_NAME ,
69: p_parameterlist => l_parameter_list);
70: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
71:
72: Wf_Event.Raise( p_event_name => l_event_name,
73: p_event_key => l_event_key,
74: p_parameters => l_parameter_list);
75: l_parameter_list.DELETE;
76: WF_CORE.CONTEXT('Enterprise Asset Management..','Work Order Status Changed Event','After raising event');