The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT mrp_sr_source_org_s.NEXTVAL
INTO l_sr_source_id
FROM dual;
FUNCTION Get_Last_Updated_By
RETURN NUMBER
IS
BEGIN
RETURN NULL;
END Get_Last_Updated_By;
FUNCTION Get_Last_Update_Date
RETURN DATE
IS
BEGIN
RETURN NULL;
END Get_Last_Update_Date;
FUNCTION Get_Last_Update_Login
RETURN NUMBER
IS
BEGIN
RETURN NULL;
END Get_Last_Update_Login;
FUNCTION Get_Program_Update_Date
RETURN DATE
IS
BEGIN
RETURN NULL;
END Get_Program_Update_Date;
IF g_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
g_Shipping_Org_rec.Last_Updated_By := Get_Last_Updated_By;
IF g_Shipping_Org_rec.Last_Updated_By IS NOT NULL THEN
IF MRP_Validate_Shipping_Org.Val_Last_Updated_By
( g_Shipping_Org_rec.Last_Updated_By )
THEN
MRP_Shipping_Org_Util.Clear_Dependent_Attr
( p_attr_id => MRP_Shipping_Org_Util.G_LAST_UPDATED_BY
, p_Shipping_Org_rec => g_Shipping_Org_rec
, x_Shipping_Org_rec => g_Shipping_Org_rec
);
g_Shipping_Org_rec.Last_Updated_By := NULL;
IF g_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
g_Shipping_Org_rec.Last_Update_Date := Get_Last_Update_Date;
IF g_Shipping_Org_rec.Last_Update_Date IS NOT NULL THEN
IF MRP_Validate_Shipping_Org.Val_Last_Update_Date
( g_Shipping_Org_rec.Last_Update_Date )
THEN
MRP_Shipping_Org_Util.Clear_Dependent_Attr
( p_attr_id => MRP_Shipping_Org_Util.G_LAST_UPDATE_DATE
, p_Shipping_Org_rec => g_Shipping_Org_rec
, x_Shipping_Org_rec => g_Shipping_Org_rec
);
g_Shipping_Org_rec.Last_Update_Date := NULL;
IF g_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
g_Shipping_Org_rec.Last_Update_Login := Get_Last_Update_Login;
IF g_Shipping_Org_rec.Last_Update_Login IS NOT NULL THEN
IF MRP_Validate_Shipping_Org.Val_Last_Update_Login
( g_Shipping_Org_rec.Last_Update_Login )
THEN
MRP_Shipping_Org_Util.Clear_Dependent_Attr
( p_attr_id => MRP_Shipping_Org_Util.G_LAST_UPDATE_LOGIN
, p_Shipping_Org_rec => g_Shipping_Org_rec
, x_Shipping_Org_rec => g_Shipping_Org_rec
);
g_Shipping_Org_rec.Last_Update_Login := NULL;
IF g_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
g_Shipping_Org_rec.Program_Update_Date := Get_Program_Update_Date;
IF g_Shipping_Org_rec.Program_Update_Date IS NOT NULL THEN
IF MRP_Validate_Shipping_Org.Val_Program_Update_Date
( g_Shipping_Org_rec.Program_Update_Date )
THEN
MRP_Shipping_Org_Util.Clear_Dependent_Attr
( p_attr_id => MRP_Shipping_Org_Util.G_PROGRAM_UPDATE_DATE
, p_Shipping_Org_rec => g_Shipping_Org_rec
, x_Shipping_Org_rec => g_Shipping_Org_rec
);
g_Shipping_Org_rec.Program_Update_Date := NULL;
OR g_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE
OR g_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE
OR g_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR
OR g_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR
OR g_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM
OR g_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM
THEN
MRP_Default_Shipping_Org.Attributes
( p_Shipping_Org_rec => g_Shipping_Org_rec
, p_iteration => p_iteration + 1
, x_Shipping_Org_rec => x_Shipping_Org_rec
);