5697: IS
5698:
5699: l_event_key Number;
5700: l_param_list wf_parameter_list_t := wf_parameter_list_t();
5701: l_param_t wf_parameter_t := wf_parameter_t(10,10);
5702: l_api_name Varchar2(30) := 'RAISE_RO_STATUS_BEVENT';
5703:
5704: BEGIN
5705:
5712: Select csd_ro_status_bevent_key_s1.nextval into l_event_key from dual ;
5713:
5714: -- Initialize Parameters
5715: l_param_list.extend;
5716: l_param_list(1) := wf_parameter_t('REPAIR_LINE_ID',p_ro_status_bevent_rec.repair_line_id);
5717:
5718: l_param_list.extend;
5719: l_param_list(2) := wf_parameter_t('FROM_STATUS_ID',p_ro_status_bevent_rec.from_flow_status_id);
5720:
5715: l_param_list.extend;
5716: l_param_list(1) := wf_parameter_t('REPAIR_LINE_ID',p_ro_status_bevent_rec.repair_line_id);
5717:
5718: l_param_list.extend;
5719: l_param_list(2) := wf_parameter_t('FROM_STATUS_ID',p_ro_status_bevent_rec.from_flow_status_id);
5720:
5721: l_param_list.extend;
5722: l_param_list(3) := wf_parameter_t('TO_STATUS_ID',p_ro_status_bevent_rec.to_flow_status_id);
5723:
5718: l_param_list.extend;
5719: l_param_list(2) := wf_parameter_t('FROM_STATUS_ID',p_ro_status_bevent_rec.from_flow_status_id);
5720:
5721: l_param_list.extend;
5722: l_param_list(3) := wf_parameter_t('TO_STATUS_ID',p_ro_status_bevent_rec.to_flow_status_id);
5723:
5724: l_param_list.extend;
5725: l_param_list(4) := wf_parameter_t('OBJECT_VERSION_NUMBER',p_ro_status_bevent_rec.object_version_number);
5726:
5721: l_param_list.extend;
5722: l_param_list(3) := wf_parameter_t('TO_STATUS_ID',p_ro_status_bevent_rec.to_flow_status_id);
5723:
5724: l_param_list.extend;
5725: l_param_list(4) := wf_parameter_t('OBJECT_VERSION_NUMBER',p_ro_status_bevent_rec.object_version_number);
5726:
5727: -- Call to Raise the Business Event
5728: wf_event.raise
5729: ( p_event_name => 'oracle.apps.csd.repair.status.change',
5944: END IF;
5945:
5946: -- Initialize the Parameters
5947: l_parameter_list.extend;
5948: l_parameter_list(1):= wf_parameter_t('REPAIR_LINE_ID',to_char(p_repair_line_id));
5949:
5950: l_parameter_list.extend;
5951: l_parameter_list(2):= wf_parameter_t('MODULE_NAME',p_module_name);
5952:
5947: l_parameter_list.extend;
5948: l_parameter_list(1):= wf_parameter_t('REPAIR_LINE_ID',to_char(p_repair_line_id));
5949:
5950: l_parameter_list.extend;
5951: l_parameter_list(2):= wf_parameter_t('MODULE_NAME',p_module_name);
5952:
5953: l_parameter_list.extend;
5954: l_parameter_list(3):= wf_parameter_t('MESSAGE_CODE',l_message_code);
5955:
5950: l_parameter_list.extend;
5951: l_parameter_list(2):= wf_parameter_t('MODULE_NAME',p_module_name);
5952:
5953: l_parameter_list.extend;
5954: l_parameter_list(3):= wf_parameter_t('MESSAGE_CODE',l_message_code);
5955:
5956: l_parameter_list.extend;
5957: l_parameter_list(4) := wf_parameter_t('MESSAGE_TEXT',l_msg);
5958:
5953: l_parameter_list.extend;
5954: l_parameter_list(3):= wf_parameter_t('MESSAGE_CODE',l_message_code);
5955:
5956: l_parameter_list.extend;
5957: l_parameter_list(4) := wf_parameter_t('MESSAGE_TEXT',l_msg);
5958:
5959: -- Call the Raise Event
5960: wf_event.raise(
5961: p_event_name => l_event_name,