DBA Data[Home] [Help]

APPS.WIP_JDI_UTILS dependencies on WIP_INTERFACE_S

Line 21: SET interface_id = WIP_INTERFACE_S.NEXTVAL,

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;

Line 28: SET interface_id = WIP_INTERFACE_S.NEXTVAL,

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