存储过程4

jar_java

        PROC_STATUS,
           CRM_ORG_ID
      FROM INT_ERP_PO_INFO
     WHERE PROC_STATUS = 0
       AND ERP_PO_STATUS = 0;
BEGIN

  OPEN C_PO_INFO;

  IF C_PO_INFO%ISOPEN THEN
    LOOP
      --query INT_ERP_PO_INFO
      FETCH C_PO_INFO
        INTO V_SOURCE_TYPE_CODE, V_PO_TYPE, V_GROUP_CODE, V_HEADER_DESCRIPTION, V_NOTE_TO_BUYER, V_NOTE_TO_RECEIVER, V_REFERENCE_NUM, V_SOURCE_ORGANIZATION_ID, V_DESTINATION_ORGANIZATION_ID, V_STORE_CODE, V_NEED_BY_DATE, V_SOURCE_CODE, V_SOURCE_HEADER_ID, V_CHANNEL_CODE, V_CUSTOMER_PO_NUMBER, V_ORDER_TYPE_ID, V_PRICE_LIST_ID, V_CHANNEL_LOCATION_BILL, V_CHANNEL_LOCATION_SHIP, V_DELIVERY_INSTRUCTIONS, V_ADDRESS1, V_ADDRESS2, V_ADDRESS3, V_ADDRESS4, V_CITY, V_COUNTY, V_STATE, V_PROVINCE, V_COUNTRY, V_POSTAL_CODE, V_GPS_COORDINATE_LATITUDE, V_GPS_COORDINATE_LONGITUDE, V_CONTACT_FIRST_NAME, V_CONTACT_LAST_NAME, V_CREATION_DATE, V_PROC_STATUS, V_CRM_ORG_ID;
      EXIT WHEN C_PO_INFO%NOTFOUND;
      --query the data is still can create PO or not