22: l_key := l_event_name || '-' || p_comp_plan.COMP_PLAN_ID;
23:
24: -- build parameter list as appropriate
25: IF (p_operation = 'create') THEN
26: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
27: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
28:
29: ELSIF (p_operation = 'update') THEN
30: l_key := l_key || '-' || p_comp_plan.OBJECT_VERSION_NUMBER;
23:
24: -- build parameter list as appropriate
25: IF (p_operation = 'create') THEN
26: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
27: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
28:
29: ELSIF (p_operation = 'update') THEN
30: l_key := l_key || '-' || p_comp_plan.OBJECT_VERSION_NUMBER;
31:
28:
29: ELSIF (p_operation = 'update') THEN
30: l_key := l_key || '-' || p_comp_plan.OBJECT_VERSION_NUMBER;
31:
32: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
33: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
34:
35: ELSIF (p_operation = 'delete') THEN
36: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
29: ELSIF (p_operation = 'update') THEN
30: l_key := l_key || '-' || p_comp_plan.OBJECT_VERSION_NUMBER;
31:
32: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
33: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
34:
35: ELSIF (p_operation = 'delete') THEN
36: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
37: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
32: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
33: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
34:
35: ELSIF (p_operation = 'delete') THEN
36: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
37: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
38: END IF;
39:
40: -- Raise Event
33: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
34:
35: ELSIF (p_operation = 'delete') THEN
36: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan.COMP_PLAN_ID,l_list);
37: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
38: END IF;
39:
40: -- Raise Event
41: wf_event.raise
37: wf_event.AddParameterToList('NAME',p_comp_plan.NAME,l_list);
38: END IF;
39:
40: -- Raise Event
41: wf_event.raise
42: (p_event_name => l_event_name,
43: p_event_key => l_key,
44: p_parameters => l_list);
45: