APPS.OE_CANSRV dependencies on SO_HOLD_RELEASES

Line 823: SELECT SO_HOLD_RELEASES_S.NEXTVAL

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

Line 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,

Line 925: SELECT SO_HOLD_RELEASES_S.NEXTVAL

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

Line 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,