DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_UTILITIES dependencies on WIP_SUB_OPERATION_RESOURCES

Line 412: FROM WIP_SUB_OPERATION_RESOURCES WSOR

408:
409: BEGIN
410: SELECT nvl(max(resource_seq_num), 10)
411: INTO l_wsor_max_res_seq_num
412: FROM WIP_SUB_OPERATION_RESOURCES WSOR
413: WHERE wip_entity_id = x_wip_entity_id
414: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num;
415: EXCEPTION
416: WHEN no_data_found THEN

Line 420: INSERT INTO WIP_SUB_OPERATION_RESOURCES

416: WHEN no_data_found THEN
417: null;
418: END;
419:
420: INSERT INTO WIP_SUB_OPERATION_RESOURCES
421: (wip_entity_id,
422: operation_seq_num,
423: resource_seq_num,
424: organization_id,