[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION insert_row (
p_samples IN GMD_SAMPLES%ROWTYPE
, x_samples OUT NOCOPY GMD_SAMPLES%ROWTYPE) RETURN BOOLEAN IS
BEGIN
x_samples := p_samples;
INSERT INTO GMD_SAMPLES
(
SAMPLE_ID
,SAMPLE_NO
,SAMPLE_DESC
,LAB_ORGANIZATION_ID
,SAMPLE_DISPOSITION
,RETAIN_AS
,INVENTORY_ITEM_ID
,ORGANIZATION_ID
,SUBINVENTORY
,LOCATOR_ID
,EXPIRATION_DATE
,PARENT_LOT_NUMBER
,LOT_NUMBER
,REVISION
,BATCH_ID
,RECIPE_ID
,FORMULA_ID
,FORMULALINE_ID
,MATERIAL_DETAIL_ID
,ROUTING_ID
,OPRN_ID
,CHARGE
,CUST_ID
,ORDER_ID
,ORDER_LINE_ID
,SHIP_TO_SITE_ID
,ORG_ID
,SUPPLIER_ID
,SUPPLIER_SITE_ID
,SAMPLE_QTY
,SAMPLE_QTY_UOM
,REMAINING_QTY
,SOURCE
,SAMPLE_INSTANCE
,SAMPLER_ID
,DATE_DRAWN
,SOURCE_COMMENT
,STORAGE_SUBINVENTORY
,STORAGE_LOCATOR_ID
,STORAGE_ORGANIZATION_ID -- 5283854
,EXTERNAL_ID
,SAMPLE_APPROVER_ID
,INV_APPROVER_ID
,PRIORITY
,SAMPLE_INV_TRANS_IND
,DELETE_MARK
,TEXT_CODE
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE20
,ATTRIBUTE21
,ATTRIBUTE22
,ATTRIBUTE23
,ATTRIBUTE24
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,CREATION_DATE
,CREATED_BY
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,STEP_ID
,STEP_NO
,SAMPLING_EVENT_ID
,LOT_RETEST_IND
,SOURCE_SUBINVENTORY
,SOURCE_LOCATOR_ID
,SAMPLE_TYPE
,VARIANT_ID
,TIME_POINT_ID
,INSTANCE_ID
,RESOURCES
,RETRIEVAL_DATE
,DATE_RECEIVED
,DATE_REQUIRED
,PO_HEADER_ID
,PO_LINE_ID
,RECEIPT_ID
,RECEIPT_LINE_ID
,SUPPLIER_LOT_NO
)
VALUES
(
gmd_qc_sample_id_s.NEXTVAL
,x_samples.SAMPLE_NO
,x_samples.SAMPLE_DESC
,x_samples.LAB_ORGANIZATION_ID
,x_samples.SAMPLE_DISPOSITION
,x_samples.RETAIN_AS
,x_samples.INVENTORY_ITEM_ID
,x_samples.ORGANIZATION_ID
,x_samples.SUBINVENTORY
,x_samples.LOCATOR_ID
,x_samples.EXPIRATION_DATE
,x_samples.PARENT_LOT_NUMBER
,x_samples.LOT_NUMBER
,x_samples.REVISION
,x_samples.BATCH_ID
,x_samples.RECIPE_ID
,x_samples.FORMULA_ID
,x_samples.FORMULALINE_ID
,x_samples.MATERIAL_DETAIL_ID
,x_samples.ROUTING_ID
,x_samples.OPRN_ID
,x_samples.CHARGE
,x_samples.CUST_ID
,x_samples.ORDER_ID
,x_samples.ORDER_LINE_ID
,x_samples.SHIP_TO_SITE_ID
,x_samples.ORG_ID
,x_samples.SUPPLIER_ID
,x_samples.SUPPLIER_SITE_ID
,x_samples.SAMPLE_QTY
,x_samples.SAMPLE_QTY_UOM
,x_samples.REMAINING_QTY
,x_samples.SOURCE
,x_samples.SAMPLE_INSTANCE
,x_samples.SAMPLER_ID
,x_samples.DATE_DRAWN
,x_samples.SOURCE_COMMENT
,x_samples.STORAGE_SUBINVENTORY
,x_samples.STORAGE_LOCATOR_ID
,x_samples.STORAGE_ORGANIZATION_ID -- 5283854
,x_samples.EXTERNAL_ID
,x_samples.SAMPLE_APPROVER_ID
,x_samples.INV_APPROVER_ID
,x_samples.PRIORITY
,x_samples.SAMPLE_INV_TRANS_IND
,x_samples.DELETE_MARK
,x_samples.TEXT_CODE
,x_samples.ATTRIBUTE_CATEGORY
,x_samples.ATTRIBUTE1
,x_samples.ATTRIBUTE2
,x_samples.ATTRIBUTE3
,x_samples.ATTRIBUTE4
,x_samples.ATTRIBUTE5
,x_samples.ATTRIBUTE6
,x_samples.ATTRIBUTE7
,x_samples.ATTRIBUTE8
,x_samples.ATTRIBUTE9
,x_samples.ATTRIBUTE10
,x_samples.ATTRIBUTE11
,x_samples.ATTRIBUTE12
,x_samples.ATTRIBUTE13
,x_samples.ATTRIBUTE14
,x_samples.ATTRIBUTE15
,x_samples.ATTRIBUTE16
,x_samples.ATTRIBUTE17
,x_samples.ATTRIBUTE18
,x_samples.ATTRIBUTE19
,x_samples.ATTRIBUTE20
,x_samples.ATTRIBUTE21
,x_samples.ATTRIBUTE22
,x_samples.ATTRIBUTE23
,x_samples.ATTRIBUTE24
,x_samples.ATTRIBUTE25
,x_samples.ATTRIBUTE26
,x_samples.ATTRIBUTE27
,x_samples.ATTRIBUTE28
,x_samples.ATTRIBUTE29
,x_samples.ATTRIBUTE30
,x_samples.CREATION_DATE
,x_samples.CREATED_BY
,x_samples.LAST_UPDATED_BY
,x_samples.LAST_UPDATE_DATE
,x_samples.LAST_UPDATE_LOGIN
,x_samples.STEP_ID
,x_samples.STEP_NO
,x_samples.SAMPLING_EVENT_ID
,x_samples.LOT_RETEST_IND
,x_samples.SOURCE_SUBINVENTORY
,x_samples.SOURCE_LOCATOR_ID
,x_samples.SAMPLE_TYPE
,x_samples.VARIANT_ID
,x_samples.TIME_POINT_ID
,x_samples.INSTANCE_ID
,x_samples.RESOURCES
,x_samples.RETRIEVAL_DATE
,x_samples.DATE_RECEIVED
,x_samples.DATE_REQUIRED
,x_samples.PO_HEADER_ID
,x_samples.PO_LINE_ID
,x_samples.RECEIPT_ID
,x_samples.RECEIPT_LINE_ID
,x_samples.SUPPLIER_LOT_NO
)
RETURNING sample_id INTO x_samples.sample_id
;
fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'INSERT_ROW');
END insert_row;
FUNCTION delete_row (
p_sample_id IN NUMBER
, p_organization_id IN VARCHAR2
, p_sample_no IN VARCHAR2
) RETURN BOOLEAN IS
dummy PLS_INTEGER;
SELECT 1
INTO dummy
FROM gmd_samples
WHERE sample_id = p_sample_id
FOR UPDATE NOWAIT;
UPDATE gmd_samples
SET delete_mark = 1,
last_updated_by = fnd_global.user_id,
last_update_date = SYSDATE
WHERE sample_id = p_sample_id
;
SELECT 1
INTO dummy
FROM gmd_samples
WHERE organization_id = p_organization_id
AND sample_no = p_sample_no
FOR UPDATE NOWAIT;
UPDATE gmd_samples
SET delete_mark = 1,
last_updated_by = fnd_global.user_id,
last_update_date = SYSDATE
WHERE organization_id = p_organization_id
AND sample_no = p_sample_no
;
fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'DELETE_ROW');
END delete_row;
SELECT 1
INTO dummy
FROM gmd_samples
WHERE sample_id = p_sample_id
FOR UPDATE NOWAIT;
SELECT 1
INTO dummy
FROM gmd_samples
WHERE organization_id = p_organization_id
AND sample_no = p_sample_no
FOR UPDATE NOWAIT;
fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'DELETE_ROW');
SELECT *
INTO x_samples
FROM gmd_samples
WHERE sample_id = p_samples.sample_id
;
SELECT *
INTO x_samples
FROM gmd_samples
WHERE organization_id = p_samples.organization_id
AND sample_no = p_samples.sample_no
;