DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_PKG dependencies on WIP_SUB_OPERATION_RESOURCES

Line 347: FROM WIP_SUB_OPERATION_RESOURCES WSOR

343:
344: BEGIN
345: SELECT nvl(max(resource_seq_num), 10)
346: INTO l_wsor_max_res_seq_num
347: FROM WIP_SUB_OPERATION_RESOURCES WSOR
348: WHERE wip_entity_id = p_wip_entity_id
349: AND OPERATION_SEQ_NUM = p_operation_seq_num;
350: EXCEPTION
351: WHEN no_data_found THEN

Line 355: INSERT INTO WIP_SUB_OPERATION_RESOURCES

351: WHEN no_data_found THEN
352: null;
353: END;
354:
355: INSERT INTO WIP_SUB_OPERATION_RESOURCES
356: (wip_entity_id,
357: operation_seq_num,
358: resource_seq_num,
359: organization_id,