eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SAMPLING_EVENTS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26


FUNCTION insert_row (
  p_sampling_events IN  GMD_SAMPLING_EVENTS%ROWTYPE
, x_sampling_events OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE) RETURN BOOLEAN IS
BEGIN

  x_sampling_events := p_sampling_events;

Line: 33


  INSERT INTO GMD_SAMPLING_EVENTS
   (
    SAMPLING_EVENT_ID
   ,ORIGINAL_SPEC_VR_ID
   ,ORGANIZATION_ID
   ,DISPOSITION
   ,SAMPLE_REQ_CNT
   ,SAMPLE_TAKEN_CNT
   ,ARCHIVED_TAKEN
   ,RESERVED_TAKEN
   ,SAMPLING_PLAN_ID
   ,EVENT_TYPE_CODE
   ,EVENT_ID
   ,SAMPLE_TYPE
   ,SOURCE
   ,INVENTORY_ITEM_ID
   ,REVISION
   ,PARENT_LOT_NUMBER
   ,LOT_NUMBER
   ,SUBINVENTORY
   ,LOCATOR_ID
   ,BATCH_ID
   ,RECIPE_ID
   ,FORMULA_ID
   ,FORMULALINE_ID
   ,MATERIAL_DETAIL_ID
   ,ROUTING_ID
   ,STEP_ID
   ,STEP_NO
   ,OPRN_ID
   ,CHARGE
   ,CUST_ID
   ,ORDER_ID
   ,ORDER_LINE_ID
   ,SHIP_TO_SITE_ID
   ,ORG_ID
   ,SUPPLIER_ID
   ,SUPPLIER_SITE_ID
   ,PO_LINE_ID
   ,RECEIPT_LINE_ID
   ,SUPPLIER_LOT_NO
   ,RESOURCES
   ,INSTANCE_ID
   ,VARIANT_ID
   ,TIME_POINT_ID
   ,COMPLETE_IND
   ,SAMPLE_ID_TO_EVALUATE
   ,COMPOSITE_ID_TO_EVALUATE
   ,TEXT_CODE
   ,CREATION_DATE
   ,CREATED_BY
   ,LAST_UPDATED_BY
   ,LAST_UPDATE_DATE
   ,LAST_UPDATE_LOGIN
   ,PO_HEADER_ID
   ,RECEIPT_ID
   ,LOT_RETEST_IND
   ,SAMPLE_ACTIVE_CNT
   ,MIGRATED_IND
   ,LPN_ID
   )
   VALUES
   (
    gmd_qc_sampling_event_id_s.NEXTVAL
   ,x_sampling_events.ORIGINAL_SPEC_VR_ID
   ,x_sampling_events.ORGANIZATION_ID
   ,x_sampling_events.DISPOSITION
   ,x_sampling_events.SAMPLE_REQ_CNT
   ,x_sampling_events.SAMPLE_TAKEN_CNT
   ,x_sampling_events.ARCHIVED_TAKEN
   ,x_sampling_events.RESERVED_TAKEN
   ,x_sampling_events.SAMPLING_PLAN_ID
   ,x_sampling_events.EVENT_TYPE_CODE
   ,x_sampling_events.EVENT_ID
   ,x_sampling_events.SAMPLE_TYPE
   ,x_sampling_events.SOURCE
   ,x_sampling_events.INVENTORY_ITEM_ID
   ,x_sampling_events.REVISION
   ,x_sampling_events.PARENT_LOT_NUMBER
   ,x_sampling_events.LOT_NUMBER
   ,x_sampling_events.SUBINVENTORY
   ,x_sampling_events.LOCATOR_ID
   ,x_sampling_events.BATCH_ID
   ,x_sampling_events.RECIPE_ID
   ,x_sampling_events.FORMULA_ID
   ,x_sampling_events.FORMULALINE_ID
   ,x_sampling_events.MATERIAL_DETAIL_ID
   ,x_sampling_events.ROUTING_ID
   ,x_sampling_events.STEP_ID
   ,x_sampling_events.STEP_NO
   ,x_sampling_events.OPRN_ID
   ,x_sampling_events.CHARGE
   ,x_sampling_events.CUST_ID
   ,x_sampling_events.ORDER_ID
   ,x_sampling_events.ORDER_LINE_ID
   ,x_sampling_events.SHIP_TO_SITE_ID
   ,x_sampling_events.ORG_ID
   ,x_sampling_events.SUPPLIER_ID
   ,x_sampling_events.SUPPLIER_SITE_ID
   ,x_sampling_events.PO_LINE_ID
   ,x_sampling_events.RECEIPT_LINE_ID
   ,x_sampling_events.SUPPLIER_LOT_NO
   ,x_sampling_events.RESOURCES
   ,x_sampling_events.INSTANCE_ID
   ,x_sampling_events.VARIANT_ID
   ,x_sampling_events.TIME_POINT_ID
   ,x_sampling_events.COMPLETE_IND
   ,x_sampling_events.SAMPLE_ID_TO_EVALUATE
   ,x_sampling_events.COMPOSITE_ID_TO_EVALUATE
   ,x_sampling_events.TEXT_CODE
   ,x_sampling_events.CREATION_DATE
   ,x_sampling_events.CREATED_BY
   ,x_sampling_events.LAST_UPDATED_BY
   ,x_sampling_events.LAST_UPDATE_DATE
   ,x_sampling_events.LAST_UPDATE_LOGIN
   ,x_sampling_events.PO_HEADER_ID
   ,x_sampling_events.RECEIPT_ID
   ,x_sampling_events.LOT_RETEST_IND
   ,x_sampling_events.SAMPLE_ACTIVE_CNT
   ,0
   ,x_sampling_events.LPN_ID
   )
      RETURNING sampling_event_id INTO x_sampling_events.sampling_event_id
   ;

Line: 166


    fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'INSERT_ROW');

Line: 168


END insert_row;

Line: 174


FUNCTION delete_row (p_sampling_event_id IN NUMBER)
RETURN BOOLEAN IS

  dummy       PLS_INTEGER;

Line: 184


    SELECT 1
    INTO   dummy
    FROM   gmd_sampling_events
    WHERE  sampling_event_id = p_sampling_event_id
    FOR UPDATE NOWAIT;

Line: 190


    DELETE gmd_sampling_events
    WHERE  sampling_event_id = p_sampling_event_id
    ;

Line: 214


     fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'DELETE_ROW');

Line: 217


END delete_row;

Line: 232


    SELECT 1
    INTO   dummy
    FROM   gmd_sampling_events
    WHERE  sampling_event_id = p_sampling_event_id
    FOR UPDATE NOWAIT;

Line: 253


     fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'DELETE_ROW');

Line: 269


    SELECT *
    INTO   x_sampling_events
    FROM   gmd_sampling_events
    WHERE  sampling_event_id = p_sampling_events.sampling_event_id
    ;