17: begin
18:
19: IF (WIP_JOB_DETAILS.STD_ALONE = 1) THEN
20: Update WIP_JOB_DTLS_INTERFACE
21: SET interface_id = WIP_INTERFACE_S.NEXTVAL,
22: process_status = WIP_CONSTANTS.RUNNING
23: WHERE group_id = p_group_id
24: AND process_status = WIP_CONSTANTS.PENDING
25: AND process_phase = WIP_CONSTANTS.ML_VALIDATION;
24: AND process_status = WIP_CONSTANTS.PENDING
25: AND process_phase = WIP_CONSTANTS.ML_VALIDATION;
26: ELSE
27: Update WIP_JOB_DTLS_INTERFACE
28: SET interface_id = WIP_INTERFACE_S.NEXTVAL,
29: process_status = WIP_CONSTANTS.RUNNING
30: WHERE group_id = p_group_id
31: AND parent_header_id = p_parent_header_id
32: AND process_status = WIP_CONSTANTS.PENDING