819: LOOP_HOLD_ENTITY_ID := c1rec.hold_entity_id;
820: LOOP_HOLD_ENTITY_CODE := c1rec.hold_entity_code;
821: LOOP_ORDER_HOLD_ID := c1rec.order_hold_id;
822:
823: SELECT SO_HOLD_RELEASES_S.NEXTVAL
824: INTO V_HOLD_RELEASE_ID
825: FROM DUAL;
826:
827: INSERT INTO SO_HOLD_RELEASES
823: SELECT SO_HOLD_RELEASES_S.NEXTVAL
824: INTO V_HOLD_RELEASE_ID
825: FROM DUAL;
826:
827: INSERT INTO SO_HOLD_RELEASES
828: (HOLD_RELEASE_ID,
829: HOLD_SOURCE_ID,
830: LAST_UPDATE_DATE,
831: LAST_UPDATED_BY,
921: LOOP_HOLD_ENTITY_ID := c1rec.hold_entity_id;
922: LOOP_HOLD_ENTITY_CODE := c1rec.hold_entity_code;
923: LOOP_ORDER_HOLD_ID := c1rec.order_hold_id;
924:
925: SELECT SO_HOLD_RELEASES_S.NEXTVAL
926: INTO V_HOLD_RELEASE_ID
927: FROM DUAL;
928:
929: INSERT INTO SO_HOLD_RELEASES
925: SELECT SO_HOLD_RELEASES_S.NEXTVAL
926: INTO V_HOLD_RELEASE_ID
927: FROM DUAL;
928:
929: INSERT INTO SO_HOLD_RELEASES
930: (HOLD_RELEASE_ID,
931: HOLD_SOURCE_ID,
932: LAST_UPDATE_DATE,
933: LAST_UPDATED_BY,