The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT a.GUID
,a.NAME
,a.TYPE
,a.STATUS
,a.GENERATE_FUNCTION
,a.JAVA_GENERATE_FUNC
,a.OWNER_NAME
,a.OWNER_TAG
,a.CUSTOMIZATION_LEVEL
,a.DISPLAY_NAME
,a.DESCRIPTION
FROM
wf_events_vl a,
wf_event_subscriptions b
WHERE a.GUID = b.EVENT_FILTER_GUID
and b.RULE_FUNCTION in ('GMO_CBR_GRP.PROCESS_EVENT','GMO_CBR_GRP.PROCESS_INSTANCE_INSTR_SET');
SELECT b.GUID
,b.SYSTEM_GUID
,b.SOURCE_TYPE
,b.SOURCE_AGENT_GUID
,b.EVENT_FILTER_GUID
,b.PHASE
,b.STATUS
,b.RULE_DATA
,b.OUT_AGENT_GUID
,b.TO_AGENT_GUID
,b.PRIORITY
,b.RULE_FUNCTION
,b.WF_PROCESS_TYPE
,b.WF_PROCESS_NAME
,b.PARAMETERS
,b.OWNER_NAME
,b.OWNER_TAG
,b.DESCRIPTION
,b.EXPRESSION
,b.SECURITY_GROUP_ID
,b.CUSTOMIZATION_LEVEL
,b.LICENSED_FLAG
,b.INVOCATION_ID
,b.MAP_CODE
,b.STANDARD_TYPE
,b.STANDARD_CODE
,b.JAVA_RULE_FUNC
,b.ON_ERROR_CODE
,b.ACTION_CODE
FROM
wf_events_vl a,
wf_event_subscriptions b
WHERE a.GUID = b.EVENT_FILTER_GUID
AND b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
AND a.name = l_event_name
and b.owner_tag <> 'GMO'
and b.status = 'ENABLED';
SELECT b.GUID
,b.SYSTEM_GUID
,b.SOURCE_TYPE
,b.SOURCE_AGENT_GUID
,b.EVENT_FILTER_GUID
,b.PHASE
,b.STATUS
,b.RULE_DATA
,b.OUT_AGENT_GUID
,b.TO_AGENT_GUID
,b.PRIORITY
,b.RULE_FUNCTION
,b.WF_PROCESS_TYPE
,b.WF_PROCESS_NAME
,b.PARAMETERS
,b.OWNER_NAME
,b.OWNER_TAG
,b.DESCRIPTION
,b.EXPRESSION
,b.SECURITY_GROUP_ID
,b.CUSTOMIZATION_LEVEL
,b.LICENSED_FLAG
,b.INVOCATION_ID
,b.MAP_CODE
,b.STANDARD_TYPE
,b.STANDARD_CODE
,b.JAVA_RULE_FUNC
,b.ON_ERROR_CODE
,b.ACTION_CODE
FROM
wf_events_vl a,
wf_event_subscriptions b
WHERE a.GUID = b.EVENT_FILTER_GUID
AND a.name = l_event_name
AND b.owner_tag = 'GMO'
AND b.status = 'DISABLED' ;
WF_EVENTS_PKG.UPDATE_ROW(X_GUID => l_EVENT_REC.GUID
,X_NAME => l_EVENT_REC.NAME
,X_TYPE => l_EVENT_REC.TYPE
,X_STATUS => 'ENABLED'
,X_GENERATE_FUNCTION => l_EVENT_REC.GENERATE_FUNCTION
,X_OWNER_NAME => l_EVENT_REC.OWNER_NAME
,X_OWNER_TAG => l_EVENT_REC.OWNER_TAG
,X_DISPLAY_NAME => l_EVENT_REC.DISPLAY_NAME
,X_DESCRIPTION => l_EVENT_REC.DESCRIPTION
,X_CUSTOMIZATION_LEVEL => l_EVENT_REC.CUSTOMIZATION_LEVEL
,X_LICENSED_FLAG => l_EVENT_REC.CUSTOMIZATION_LEVEL
,X_JAVA_GENERATE_FUNC => l_EVENT_REC.JAVA_GENERATE_FUNC);
WF_EVENT_SUBSCRIPTIONS_PKG.UPDATE_ROW(X_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.GUID
,X_SYSTEM_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.SYSTEM_GUID
,X_SOURCE_TYPE => l_CBR_EVENT_SUBCRIPTIONS_REC.SOURCE_TYPE
,X_SOURCE_AGENT_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.SOURCE_AGENT_GUID
,X_EVENT_FILTER_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.EVENT_FILTER_GUID
,X_PHASE => l_CBR_EVENT_SUBCRIPTIONS_REC.PHASE
,X_STATUS => 'DISABLED'
,X_RULE_DATA => l_CBR_EVENT_SUBCRIPTIONS_REC.RULE_DATA
,X_OUT_AGENT_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.OUT_AGENT_GUID
,X_TO_AGENT_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.TO_AGENT_GUID
,X_PRIORITY => l_CBR_EVENT_SUBCRIPTIONS_REC.PRIORITY
,X_RULE_FUNCTION => l_CBR_EVENT_SUBCRIPTIONS_REC.RULE_FUNCTION
,X_WF_PROCESS_TYPE => l_CBR_EVENT_SUBCRIPTIONS_REC.WF_PROCESS_TYPE
,X_WF_PROCESS_NAME => l_CBR_EVENT_SUBCRIPTIONS_REC.WF_PROCESS_NAME
,X_PARAMETERS => l_CBR_EVENT_SUBCRIPTIONS_REC.PARAMETERS
,X_OWNER_NAME => l_CBR_EVENT_SUBCRIPTIONS_REC.OWNER_NAME
,X_OWNER_TAG => l_CBR_EVENT_SUBCRIPTIONS_REC.OWNER_TAG
,X_CUSTOMIZATION_LEVEL => l_CBR_EVENT_SUBCRIPTIONS_REC.CUSTOMIZATION_LEVEL
,X_LICENSED_FLAG => l_CBR_EVENT_SUBCRIPTIONS_REC.LICENSED_FLAG
,X_DESCRIPTION => l_CBR_EVENT_SUBCRIPTIONS_REC.DESCRIPTION
,X_EXPRESSION => l_CBR_EVENT_SUBCRIPTIONS_REC.EXPRESSION
,X_ACTION_CODE => l_CBR_EVENT_SUBCRIPTIONS_REC.ACTION_CODE
,X_ON_ERROR_CODE => l_CBR_EVENT_SUBCRIPTIONS_REC.ON_ERROR_CODE
,X_JAVA_RULE_FUNC => l_CBR_EVENT_SUBCRIPTIONS_REC.JAVA_RULE_FUNC
,X_MAP_CODE => l_CBR_EVENT_SUBCRIPTIONS_REC.MAP_CODE
,X_STANDARD_CODE => l_CBR_EVENT_SUBCRIPTIONS_REC.STANDARD_CODE
,X_STANDARD_TYPE => l_CBR_EVENT_SUBCRIPTIONS_REC.STANDARD_TYPE);
WF_EVENT_SUBSCRIPTIONS_PKG.UPDATE_ROW(X_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.GUID
,X_SYSTEM_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.SYSTEM_GUID
,X_SOURCE_TYPE => l_CBR_GMO_SUBCRIPTIONS_REC.SOURCE_TYPE
,X_SOURCE_AGENT_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.SOURCE_AGENT_GUID
,X_EVENT_FILTER_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.EVENT_FILTER_GUID
,X_PHASE => l_CBR_GMO_SUBCRIPTIONS_REC.PHASE
,X_STATUS => 'ENABLED'
,X_RULE_DATA => l_CBR_GMO_SUBCRIPTIONS_REC.RULE_DATA
,X_OUT_AGENT_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.OUT_AGENT_GUID
,X_TO_AGENT_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.TO_AGENT_GUID
,X_PRIORITY => l_CBR_GMO_SUBCRIPTIONS_REC.PRIORITY
,X_RULE_FUNCTION => l_CBR_GMO_SUBCRIPTIONS_REC.RULE_FUNCTION
,X_WF_PROCESS_TYPE => l_CBR_GMO_SUBCRIPTIONS_REC.WF_PROCESS_TYPE
,X_WF_PROCESS_NAME => l_CBR_GMO_SUBCRIPTIONS_REC.WF_PROCESS_NAME
,X_PARAMETERS => l_CBR_GMO_SUBCRIPTIONS_REC.PARAMETERS
,X_OWNER_NAME => l_CBR_GMO_SUBCRIPTIONS_REC.OWNER_NAME
,X_OWNER_TAG => l_CBR_GMO_SUBCRIPTIONS_REC.OWNER_TAG
,X_CUSTOMIZATION_LEVEL => l_CBR_GMO_SUBCRIPTIONS_REC.CUSTOMIZATION_LEVEL
,X_LICENSED_FLAG => l_CBR_GMO_SUBCRIPTIONS_REC.LICENSED_FLAG
,X_DESCRIPTION => l_CBR_GMO_SUBCRIPTIONS_REC.DESCRIPTION
,X_EXPRESSION => l_CBR_GMO_SUBCRIPTIONS_REC.EXPRESSION
,X_ACTION_CODE => l_CBR_GMO_SUBCRIPTIONS_REC.ACTION_CODE
,X_ON_ERROR_CODE => l_CBR_GMO_SUBCRIPTIONS_REC.ON_ERROR_CODE
,X_JAVA_RULE_FUNC => l_CBR_GMO_SUBCRIPTIONS_REC.JAVA_RULE_FUNC
,X_MAP_CODE => l_CBR_GMO_SUBCRIPTIONS_REC.MAP_CODE
,X_STANDARD_CODE => l_CBR_GMO_SUBCRIPTIONS_REC.STANDARD_CODE
,X_STANDARD_TYPE => l_CBR_GMO_SUBCRIPTIONS_REC.STANDARD_TYPE);
PROCEDURE UPDATE_EVENT (P_ERECORD_ID NUMBER, P_BATCH_PROGRESSION_ID NUMBER, P_EVENT_DATE DATE, P_STATUS VARCHAR2) IS
BEGIN
--
-- Update event details based on parameters
--
IF P_ERECORD_ID IS NOT NULL
THEN
UPDATE gmo_batch_progression
SET STATUS = P_STATUS,
EVENT_DATE = p_EVENT_DATE
WHERE ERECORD_ID = p_ERECORD_ID;
UPDATE gmo_batch_progression
SET STATUS = P_STATUS,
EVENT_DATE = p_EVENT_DATE
WHERE PROGRESSION_ID = P_BATCH_PROGRESSION_ID;
END UPDATE_EVENT ;
PROCEDURE INSERT_EVENT(P_BATCH_PROG_REC GMO_BATCH_PROGRESSION%ROWTYPE,P_BATCH_PROGRESSION_ID OUT NOCOPY NUMBER) IS
CURSOR get_progression_ID is
SELECT GMO_BATCH_PROGRESSION_S.nextval
FROM DUAL;
INSERT INTO GMO_BATCH_PROGRESSION (
PROGRESSION_ID
,BATCH_ID
,BATCHSTEP_ID
,MATERIAL_LINE_ID
,BATCHACTIVITY_ID
,BATCHRSRC_ID
,DISPENSE_ID
,SAMPLE_ID
,DEVIATION_ID
,TRANSACTION_ID
,PARENT_NODE
,PARENT_KEY_NODE
,PARENT_KEY_VAL
,CURR_NODE_KEY
,CURR_KEY_VAL
,USER_KEY_LABEL_PROD
,USER_KEY_LABEL_TOKEN
,USER_KEY_LABEL
,USER_KEY_VALUE
,EXTERNAL_EVENT
,INCLUDE_IN_CBR
,EVENT
,EVENT_KEY
,EVENT_DATE
,PLANED_START_DATE
,ERECORD_ID
,XML_EREC
,STATUS
,INCLUDED_IN_CBR
,XML_MAP_CODE
,compare_xml)
VALUES
(P_BATCH_PROGRESSION_ID
,P_BATCH_PROG_REC.BATCH_ID
,P_BATCH_PROG_REC.BATCHSTEP_ID
,P_BATCH_PROG_REC.MATERIAL_LINE_ID
,P_BATCH_PROG_REC.BATCHACTIVITY_ID
,P_BATCH_PROG_REC.BATCHRSRC_ID
,P_BATCH_PROG_REC.DISPENSE_ID
,P_BATCH_PROG_REC.SAMPLE_ID
,P_BATCH_PROG_REC.DEVIATION_ID
,P_BATCH_PROG_REC.TRANSACTION_ID
,P_BATCH_PROG_REC.PARENT_NODE
,P_BATCH_PROG_REC.PARENT_KEY_NODE
,P_BATCH_PROG_REC.PARENT_KEY_VAL
,P_BATCH_PROG_REC.CURR_NODE_KEY
,P_BATCH_PROG_REC.CURR_KEY_VAL
,P_BATCH_PROG_REC.USER_KEY_LABEL_PROD
,P_BATCH_PROG_REC.USER_KEY_LABEL_TOKEN
,P_BATCH_PROG_REC.USER_KEY_LABEL
,P_BATCH_PROG_REC.USER_KEY_VALUE
,P_BATCH_PROG_REC.EXTERNAL_EVENT
,P_BATCH_PROG_REC.INCLUDE_IN_CBR
,P_BATCH_PROG_REC.EVENT
,P_BATCH_PROG_REC.EVENT_KEY
,P_BATCH_PROG_REC.EVENT_DATE
,P_BATCH_PROG_REC.PLANED_START_DATE
,P_BATCH_PROG_REC.ERECORD_ID
,P_BATCH_PROG_REC.XML_EREC
,P_BATCH_PROG_REC.STATUS
,P_BATCH_PROG_REC.INCLUDED_IN_CBR
,P_BATCH_PROG_REC.XML_MAP_CODE
,P_BATCH_PROG_REC.compare_xml );
SELECT PROGRESSION_ID,ERECORD_ID,BATCH_ID ,BATCHSTEP_ID,
MATERIAL_LINE_ID,BATCHACTIVITY_ID,BATCHRSRC_ID
FROM GMO_BATCH_PROGRESSION
WHERE BATCH_ID = P_BATCH_ID
AND STATUS = 'INPROGRESS'
AND ERECORD_ID IS NOT NULL;
SELECT PROGRESSION_ID,EVENT,EVENT_KEY,dispense_id
FROM GMO_BATCH_PROGRESSION
WHERE BATCH_ID IS NULL
AND STATUS = 'INPROGRESS'
AND ERECORD_ID IS NOT NULL
AND event in ('oracle.apps.gmo.mtl.dispense',
'oracle.apps.gmo.mtl.revdisp',
'oracle.apps.gmo.labelprint');
SELECT batch_id, batch_step_id ,material_detail_id
FROM gmo_material_dispenses
WHERE dispense_id = l_dispense_id;
SELECT batch_id, batch_step_id ,material_detail_id,dispense_id
FROM gmo_material_undispenses
WHERE undispense_id = l_event_key;
SELECT entity_name, entity_key
from gmo_label_history
where label_id = l_event_key;
UPDATE GMO_BATCH_PROGRESSION
SET batch_id = l_batch_id,
batchstep_id = l_batchstep_id,
material_line_id = l_material_detail_id
WHERE PROGRESSION_ID = l_progression_id;
UPDATE GMO_BATCH_PROGRESSION
SET batch_id = l_batch_id,
batchstep_id = l_batchstep_id,
material_line_id = l_material_detail_id,
dispense_id = l_dispense_id
WHERE PROGRESSION_ID = l_progression_id;
DELETE FROM GMO_BATCH_PROGRESSION WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
UPDATE GMO_BATCH_PROGRESSION
SET STATUS = 'COMPLETE'
WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
,'oracle.apps.qa.disp.update'
,'oracle.apps.qa.ncm.create'
,'oracle.apps.qa.ncm.detail.approve'
,'oracle.apps.qa.ncm.master.approve'
,'oracle.apps.qa.ncm.update')
THEN
DBMS_LOB.CREATETEMPORARY(l_PROG_EREC,TRUE,DBMS_LOB.SESSION);
UPDATE GMO_BATCH_PROGRESSION
SET XML_EREC = l_PROG_EREC,
PARENT_NODE = l_parent_node,
PARENT_KEY_NODE = l_parent_key_node,
PARENT_KEY_VAL = l_parent_key_val,
CURR_NODE_KEY = l_curr_node_key,
CURR_KEY_VAL = l_curr_key_val
WHERE PROGRESSION_ID = GMO_BATCH_PROGRESSION_REC.PROGRESSION_ID;
* update the progression status based on Batch status
*/
PROCEDURE UPDATE_PROGRESSION_STATUS(P_BATCH_ID IN NUMBER ,P_BATCHSTEP_ID IN NUMBER,P_EVENT_NAME IN VARCHAR2) IS
BEGIN
IF P_EVENT_NAME='oracle.apps.gme.batch.complete' THEN
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='BYPASSED'
WHERE BATCH_ID = P_BATCH_ID
AND STATUS='PENDING'
AND EVENT IN ('oracle.apps.gme.batch.release'
,'oracle.apps.gme.batchstep.release'
,'oracle.apps.gme.batchstep.complete');
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='CANCEL'
WHERE BATCH_ID = P_BATCH_ID
AND STATUS IN ('PENDING','INPROGRESS');
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='CANCEL'
WHERE BATCH_ID = P_BATCH_ID
AND STATUS='PENDING'
AND EVENT IN ('oracle.apps.gme.batchstep.complete'
,'oracle.apps.gme.batchstep.release'
,'oracle.apps.gme.batchstep.close');
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='CANCEL'
WHERE BATCH_ID = P_BATCH_ID
AND STATUS='INPROGRESS'
AND EVENT = 'oracle.apps.gmo.instrset.update';
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='TERMINATE'
WHERE BATCH_ID = P_BATCH_ID
AND STATUS IN ('PENDING','INPROGRESS');
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='BYPASSED'
WHERE BATCH_ID = P_BATCH_ID
AND STATUS='PENDING'
AND EVENT ='oracle.apps.gme.batchstep.close';
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='OPTIONAL_ACK'
WHERE BATCH_ID = P_BATCH_ID
AND STATUS='INPROGRESS'
AND EVENT = 'oracle.apps.gmo.instrset.update';
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='BYPASSED'
WHERE BATCH_ID = P_BATCH_ID
AND BATCHSTEP_ID = P_BATCHSTEP_ID
AND STATUS='PENDING'
AND EVENT ='oracle.apps.gme.batchstep.release';
UPDATE GMO_BATCH_PROGRESSION
SET STATUS='OPTIONAL_ACK'
WHERE BATCH_ID = P_BATCH_ID
AND BATCHSTEP_ID = P_BATCHSTEP_ID
AND STATUS='INPROGRESS'
AND EVENT = 'oracle.apps.gmo.instrset.update';
END UPDATE_PROGRESSION_STATUS;
SELECT PROCESS_BATCH_ID
,PROCESS_BATCHSTEP_ID
,PROCESS_OPERATION_ID
,PROCESS_ACTIVITY_ID
,PROCESS_RESOURCE_ID
,PROCESS_PARAMETER_ID
FROM QA_RESULTS
WHERE
plan_id = l_plan_id
AND collection_id = l_collection_id
AND occurrence = l_occurrence ;
SELECT substrb(l_event_key,instrb(l_event_key,'-',1,1)+1,
decode(instrb(l_event_key,'-',1,2),0,
length(substrb(l_event_key,instrb(l_event_key,'-',1,1)+1)),
instrb(l_event_key,'-',1,2)-(instrb(l_event_key,'-',1,1)+1)))
FROM DUAL;
SELECT SMPL.BATCH_ID,SMPL.STEP_ID,SMPL.FORMULALINE_ID
,SMPL.MATERIAL_DETAIL_ID
FROM GMD_SAMPLES SMPL
WHERE SMPL.SAMPLE_ID = l_sample_id;
,'oracle.apps.qa.disp.update'
,'oracle.apps.qa.ncm.create'
,'oracle.apps.qa.ncm.detail.approve'
,'oracle.apps.qa.ncm.master.approve'
,'oracle.apps.qa.ncm.update')
THEN
l_plan_id := substrb(l_event_key,1,instrb(l_event_key,'-',1,1)-1);
,'oracle.apps.gme.batch.update')
THEN
--
-- process batch level Events
--
l_batch_id := l_event_key;
SELECT PLAN_START_DATE into l_plan_start_date
FROM GME_BATCH_HEADER
WHERE batch_id = l_batch_id;
insert into GMO_CBR_XML (batch_id, CBR_XML)
VALUES (l_batch_id,p_event.geteventdata());
INSERT_BATH_EVENTS(l_batch_id);
SELECT batch_id,PLAN_START_DATE into l_batch_id,l_plan_start_date
FROM GME_BATCH_STEPS
WHERE batchstep_id = l_batchstep_id;
,'oracle.apps.gme.batchstep.update') THEN
--
-- process batch step events
--
l_batch_id := substrb(l_event_key,1,instrb(l_event_key,'-',1)-1);
SELECT PLAN_START_DATE into l_plan_start_date
FROM GME_BATCH_STEPS
WHERE batch_id = l_batch_id
AND batchstep_id = l_batchstep_id;
,'oracle.apps.gme.batchmtl.updated') THEN
--
-- process batch material events
--
l_batch_id := substrb(l_event_key,1,instrb(l_event_key,'-',1)-1);
,'oracle.apps.gme.resource.update') THEN
--
-- process batch step resource events
--
l_batch_id := substrb(l_event_key,1,instrb(l_event_key,'-',1)-1);
SELECT PLAN_START_DATE into l_plan_start_date
FROM GME_BATCH_STEP_RESOURCES
WHERE batch_id = l_batch_id
AND BATCHSTEP_RESOURCE_ID = l_batch_rsrc_id;
,'oracle.apps.gme.activity.update') THEN
--
-- process batch step activity events
--
l_batch_id := substrb(l_event_key,1,instrb(l_event_key,'-',1)-1);
SELECT PLAN_START_DATE into l_plan_start_date
FROM GME_BATCH_STEP_ACTIVITIES
WHERE batch_id = l_batch_id
AND BATCHSTEP_ACTIVITY_ID = l_batch_activity_id;
SELECT entity_name, entity_key INTO l_entity_name,l_dispense_id
from gmo_label_history
where label_id = l_event_key;
/* delete progression row created when batch is created */
delete GMO_BATCH_PROGRESSION
where event = l_event_name
AND event_key = l_event_key
AND STATUS = 'PENDING';
/* update the progression status for other event */
UPDATE_PROGRESSION_STATUS(l_batch_id,l_batchstep_id,l_event_name);
l_error_text := 'Before insert' ;
gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
PROCEDURE INSERT_BATH_EVENTS(P_BATCH_ID IN NUMBER) IS
l_batch_prog_rec GMO_BATCH_PROGRESSION%ROWTYPE;
SELECT BATCH_ID,BATCH_NO,PLANT_CODE,PLAN_START_DATE,PLAN_CMPLT_DATE
FROM GME_BATCH_HEADER_VW
WHERE batch_id = P_BATCH_ID;
SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_NO,OPERATION_NO,PLAN_START_DATE,PLAN_CMPLT_DATE
FROM gme_batch_steps_v
WHERE BATCH_ID = P_BATCH_ID;
gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
select extractValue(P_XML,P_VARIABLE) into tmp from dual;
SELECT batch_id, batch_step_id ,material_detail_id
FROM gmo_material_dispenses
WHERE dispense_id = p_entity_key;
SELECT batch_id, batch_step_id ,material_detail_id,dispense_id
FROM gmo_material_undispenses
WHERE undispense_id = p_entity_key;
SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_ACTIVITY_ID FROM GME_BATCH_STEP_RESOURCES
where BATCHSTEP_RESOURCE_ID = p_entity_key;
delete GMO_BATCH_PROGRESSION
where event = P_EVENT_NAME
AND event_key = p_event_key
AND STATUS = 'INPROGRESS';
select P_FINAL_XML.getCLobVal() into l_event_data from dual;
SELECT BATCH_ID,BATCHSTEP_ID into l_batch_id,l_batchstep_id FROM GME_BATCH_STEP_ACTIVITIES
WHERE batchstep_activity_id = p_entity_key;
select batch_id into l_batch_id from gme_material_details
where material_detail_id=p_entity_key;
SELECT batch_id into l_batch_id
FROM GME_BATCH_STEPS
WHERE batchstep_id = p_entity_key;
gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
select STATUS
from gmo_batch_progression
where event =p_event_name
and EVENT_KEY=p_event_key
and STATUS = 'INPROGRESS' ;
PROCEDURE DELETE_PROGRESSION_ROW (P_BATCH_PROGRESSION_ID NUMBER DEFAULT Null,
P_ERECORD_ID NUMBER DEFAULT Null,
P_EVENT VARCHAR2 DEFAULT Null,
P_EVENT_KEY VARCHAR2 DEFAULT Null,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2) IS
BEGIN
IF P_BATCH_PROGRESSION_ID IS NOT NULL
THEN
DELETE GMO_BATCH_PROGRESSION
WHERE PROGRESSION_ID = P_BATCH_PROGRESSION_ID;
DELETE GMO_BATCH_PROGRESSION
WHERE ERECORD_ID = P_ERECORD_ID;
DELETE GMO_BATCH_PROGRESSION
WHERE EVENT = P_EVENT
AND EVENT_KEY = P_EVENT_KEY;
'gmo.plsql.GMO_CBR_GRP.DELETE_PROGRESSION_ROW',
FALSE
);
END DELETE_PROGRESSION_ROW;