APPS.MRP_VALIDATE_SHIPPING_ORG SQL Statements

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

Line: 127

PROCEDURE Entity_Delete
(   x_return_status                 OUT NOCOPY VARCHAR2
,   p_Shipping_Org_rec              IN  MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 141

    SELECT count(*)
    INTO   l_count
    FROM   MRP_SR_SOURCE_ORG
    WHERE  sr_receipt_id = p_Shipping_Org_rec.sr_receipt_id
    AND    sr_source_id <> p_Shipping_Org_rec.sr_source_id;

Line: 150

        FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');

Line: 181

            ,   'Entity_Delete'
            );

Line: 185

END Entity_Delete;

Line: 405

    IF  p_Shipping_Org_rec.Last_Updated_By IS NOT NULL AND
        (   p_Shipping_Org_rec.Last_Updated_By <>
            p_old_Shipping_Org_rec.Last_Updated_By OR
            p_old_Shipping_Org_rec.Last_Updated_By IS NULL )
    THEN
        IF NOT Val_Last_Updated_By(p_Shipping_Org_rec.Last_Updated_By) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 415

    IF  p_Shipping_Org_rec.Last_Update_Date IS NOT NULL AND
        (   p_Shipping_Org_rec.Last_Update_Date <>
            p_old_Shipping_Org_rec.Last_Update_Date OR
            p_old_Shipping_Org_rec.Last_Update_Date IS NULL )
    THEN
        IF NOT Val_Last_Update_Date(p_Shipping_Org_rec.Last_Update_Date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 425

    IF  p_Shipping_Org_rec.Last_Update_Login IS NOT NULL AND
        (   p_Shipping_Org_rec.Last_Update_Login <>
            p_old_Shipping_Org_rec.Last_Update_Login OR
            p_old_Shipping_Org_rec.Last_Update_Login IS NULL )
    THEN
        IF NOT Val_Last_Update_Login(p_Shipping_Org_rec.Last_Update_Login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 455

    IF  p_Shipping_Org_rec.Program_Update_Date IS NOT NULL AND
        (   p_Shipping_Org_rec.Program_Update_Date <>
            p_old_Shipping_Org_rec.Program_Update_Date OR
            p_old_Shipping_Org_rec.Program_Update_Date IS NULL )
    THEN
        IF NOT Val_Program_Update_Date(p_Shipping_Org_rec.Program_Update_Date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 943

FUNCTION Val_Last_Updated_By
(   p_Last_Updated_By               IN  NUMBER
)   RETURN BOOLEAN
IS
BEGIN

    IF p_Last_Updated_By IS NULL OR
       p_Last_Updated_By = FND_API.G_MISS_NUM
    THEN
        RETURN TRUE;

Line: 957

END Val_Last_Updated_By;

Line: 961

FUNCTION Val_Last_Update_Date
(   p_Last_Update_Date              IN  DATE
)   RETURN BOOLEAN
IS
BEGIN

    IF p_Last_Update_Date IS NULL OR
       p_Last_Update_Date = FND_API.G_MISS_DATE
    THEN
        RETURN TRUE;

Line: 975

END Val_Last_Update_Date;

Line: 979

FUNCTION Val_Last_Update_Login
(   p_Last_Update_Login             IN  NUMBER
)   RETURN BOOLEAN
IS
BEGIN

    IF p_Last_Update_Login IS NULL OR
       p_Last_Update_Login = FND_API.G_MISS_NUM
    THEN
        RETURN TRUE;

Line: 993

END Val_Last_Update_Login;

Line: 1033

FUNCTION Val_Program_Update_Date
(   p_Program_Update_Date           IN  DATE
)   RETURN BOOLEAN
IS
BEGIN

    IF p_Program_Update_Date IS NULL OR
       p_Program_Update_Date = FND_API.G_MISS_DATE
    THEN
        RETURN TRUE;

Line: 1047

END Val_Program_Update_Date;

Line: 1122

    	SELECT count(*)
	INTO   l_count
	FROM   MTL_INTERORG_SHIP_METHODS
	WHERE  ship_method = p_Ship_Method
     	AND    from_organization_id = p_source_organization_id
	AND    to_organization_id in (
	       	SELECT receipt_organization_id
	       	FROM   mrp_sr_receipt_org
		WHERE  sr_receipt_id = p_sr_receipt_id);

Line: 1162

        SELECT count(*)
        INTO   l_count
        FROM   MTL_PARAMETERS
        WHERE  organization_id = p_Source_Organization_Id;

Line: 1243

	SELECT count(*)
	INTO   l_count
	FROM   po_vendors
	WHERE  vendor_id = p_Vendor_Id;

Line: 1278

	SELECT count(*)
	INTO   l_count
	FROM   po_vendor_sites_all
	WHERE  vendor_id = p_vendor_id
	AND    vendor_site_id = p_vendor_site_id;