DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_PKG dependencies on WIP_SUB_OPERATION_RESOURCES

Line 349: FROM WIP_SUB_OPERATION_RESOURCES WSOR

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

Line 357: INSERT INTO WIP_SUB_OPERATION_RESOURCES

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

Line 1342: DELETE from WIP_SUB_OPERATION_RESOURCES

1338: WHERE wip_entity_id = P_Wip_Entity_Id
1339: AND operation_seq_num = P_Operation_Seq_Num
1340: AND organization_id = P_Organization_Id;
1341:
1342: DELETE from WIP_SUB_OPERATION_RESOURCES
1343: WHERE wip_entity_id = P_Wip_Entity_Id
1344: AND operation_seq_num = P_Operation_Seq_Num
1345: AND organization_id = P_Organization_Id;
1346: