[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Row(x_return_status OUT NOCOPY VARCHAR2,
p_Pull_Sequence_Id NUMBER,
p_Inventory_item_id NUMBER,
p_Organization_id NUMBER,
p_Subinventory_name VARCHAR2,
p_Kanban_Plan_id NUMBER,
p_Source_type NUMBER,
p_Last_Update_Date DATE,
p_Last_Updated_By NUMBER,
p_Creation_Date DATE,
p_Created_By NUMBER,
p_Last_Update_Login NUMBER,
p_Locator_id NUMBER,
p_Supplier_id NUMBER,
p_Supplier_site_id NUMBER,
p_Source_Organization_id NUMBER,
p_Source_Subinventory VARCHAR2,
p_Source_Locator_id NUMBER,
p_Wip_Line_id NUMBER,
p_Release_Kanban_flag NUMBER,
p_Calculate_Kanban_flag NUMBER,
p_Kanban_size NUMBER,
p_Number_of_cards NUMBER,
p_Minimum_order_quantity NUMBER,
p_Aggregation_Type NUMBER,
p_Allocation_Percent NUMBER,
p_Replenishment_lead_time NUMBER,
p_Fixed_Lot_multiplier NUMBER,
p_Safety_Stock_Days NUMBER,
p_Updated_Flag NUMBER,
p_Attribute_Category VARCHAR2,
p_Attribute1 VARCHAR2,
p_Attribute2 VARCHAR2,
p_Attribute3 VARCHAR2,
p_Attribute4 VARCHAR2,
p_Attribute5 VARCHAR2,
p_Attribute6 VARCHAR2,
p_Attribute7 VARCHAR2,
p_Attribute8 VARCHAR2,
p_Attribute9 VARCHAR2,
p_Attribute10 VARCHAR2,
p_Attribute11 VARCHAR2,
p_Attribute12 VARCHAR2,
p_Attribute13 VARCHAR2,
p_Attribute14 VARCHAR2,
p_Attribute15 VARCHAR2,
p_point_of_use_x NUMBER DEFAULT NULL,
p_point_of_use_y NUMBER DEFAULT NULL,
p_point_of_supply_x NUMBER DEFAULT NULL,
p_point_of_supply_y NUMBER DEFAULT NULL,
p_planning_update_status NUMBER DEFAULT NULL,
p_auto_request VARCHAR2 DEFAULT NULL,
p_Auto_Allocate_Flag NUMBER DEFAULT NULL, --Bug3905884
--eKanban Changes
p_replenishment_type NUMBER DEFAULT NULL,
p_future_card_size NUMBER DEFAULT NULL,
p_future_no_of_cards NUMBER DEFAULT NULL,
p_planning_effectivity DATE DEFAULT NULL,
p_consolidation NUMBER DEFAULT NULL,
p_consolidation_group VARCHAR2 DEFAULT NULL,
p_avg_dependent_demand NUMBER DEFAULT NULL,
p_avg_independent_demand NUMBER DEFAULT NULL,
p_last_imp_plan VARCHAR2 DEFAULT NULL,
p_imp_plan_start_date DATE DEFAULT NULL,
p_imp_plan_end_date DATE DEFAULT NULL,
p_no_of_temp_card NUMBER DEFAULT NULL,
p_no_of_temp_cycle NUMBER DEFAULT NULL,
p_temp_exp_date DATE DEFAULT NULL)
IS
l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
UPDATE MTL_KANBAN_PULL_SEQUENCES
SET
Inventory_item_id = p_Inventory_item_id,
Organization_Id = p_Organization_Id,
Subinventory_name = p_Subinventory_name,
Kanban_Plan_id = p_Kanban_Plan_id,
Source_type = p_Source_type,
Last_Update_Date = p_Last_Update_Date,
Last_Updated_By = p_Last_Updated_By,
Creation_Date = p_Creation_Date,
Created_By = p_Created_By,
Last_Update_Login = p_Last_Update_Login,
Locator_id = p_Locator_id,
Supplier_id = p_Supplier_id,
Supplier_site_id = p_Supplier_site_id,
Source_Organization_id = p_Source_Organization_id,
Source_Subinventory = p_Source_Subinventory,
Source_Locator_id = p_Source_Locator_id,
Wip_Line_id = p_Wip_Line_id,
Release_Kanban_Flag = p_Release_Kanban_flag,
Calculate_Kanban_Flag = p_Calculate_Kanban_flag,
Kanban_size = p_Kanban_size,
Number_of_cards = p_Number_of_cards,
Minimum_order_quantity = p_Minimum_order_quantity,
Aggregation_Type = p_Aggregation_Type,
Allocation_Percent = p_Allocation_Percent,
Replenishment_lead_time = p_Replenishment_lead_time,
Fixed_Lot_multiplier = p_Fixed_Lot_multiplier,
Safety_Stock_Days = p_Safety_Stock_Days,
Updated_Flag = p_Updated_Flag,
Attribute_Category = p_Attribute_Category,
Attribute1 = p_Attribute1,
Attribute2 = p_Attribute2,
Attribute3 = p_Attribute3,
Attribute4 = p_Attribute4,
Attribute5 = p_Attribute5,
Attribute6 = p_Attribute6,
Attribute7 = p_Attribute7,
Attribute8 = p_Attribute8,
Attribute9 = p_Attribute9,
Attribute10 = p_Attribute10,
Attribute11 = p_Attribute11,
Attribute12 = p_Attribute12,
Attribute13 = p_Attribute13,
Attribute14 = p_Attribute14,
Attribute15 = p_Attribute15,
point_of_use_x = p_point_of_use_x,
point_of_use_y = p_point_of_use_y,
point_of_supply_x = p_point_of_supply_x,
point_of_supply_y = p_point_of_supply_y,
planning_update_status = p_planning_update_status,
auto_request = p_auto_request,
Auto_Allocate_Flag = p_Auto_Allocate_Flag,
--eKanban Changes
replenishment_type = p_replenishment_type,
future_card_size = p_future_card_size,
future_no_of_cards = p_future_no_of_cards,
planning_effectivity = p_planning_effectivity,
consolidation = p_consolidation,
consolidation_group = p_consolidation_group,
avg_dependent_demand = p_avg_dependent_demand,
avg_independent_demand = p_avg_independent_demand,
last_implemented_plan = p_last_imp_plan,
plan_start_date = p_imp_plan_start_date,
plan_end_date = p_imp_plan_end_date,
no_of_temp_cards = p_no_of_temp_card,
no_of_temp_cycles = p_no_of_temp_cycle,
temp_expiry_date = p_temp_exp_date
WHERE pull_sequence_id = p_pull_sequence_id;
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row(x_return_status OUT NOCOPY Varchar2,
p_pull_sequence_id IN Out NOCOPY NUMBER,
p_Inventory_item_id NUMBER,
p_Organization_id NUMBER,
p_Subinventory_name VARCHAR2,
p_Kanban_Plan_id NUMBER,
p_Source_type NUMBER,
p_Last_Update_Date DATE,
p_Last_Updated_By NUMBER,
p_Creation_Date DATE,
p_Created_By NUMBER,
p_Last_Update_Login NUMBER,
p_Locator_id NUMBER,
p_Supplier_id NUMBER,
p_Supplier_site_id NUMBER,
p_Source_Organization_id NUMBER,
p_Source_Subinventory VARCHAR2,
p_Source_Locator_id NUMBER,
p_Wip_Line_id NUMBER,
p_Release_Kanban_Flag NUMBER,
p_Calculate_Kanban_Flag NUMBER,
p_Kanban_size NUMBER,
p_Number_of_cards NUMBER,
p_Minimum_order_quantity NUMBER,
p_Aggregation_type NUMBER,
p_Allocation_Percent NUMBER,
p_Replenishment_lead_time NUMBER,
p_Fixed_Lot_multiplier NUMBER,
p_Safety_Stock_Days NUMBER,
p_Updated_Flag NUMBER,
p_Attribute_Category VARCHAR2,
p_Attribute1 VARCHAR2,
p_Attribute2 VARCHAR2,
p_Attribute3 VARCHAR2,
p_Attribute4 VARCHAR2,
p_Attribute5 VARCHAR2,
p_Attribute6 VARCHAR2,
p_Attribute7 VARCHAR2,
p_Attribute8 VARCHAR2,
p_Attribute9 VARCHAR2,
p_Attribute10 VARCHAR2,
p_Attribute11 VARCHAR2,
p_Attribute12 VARCHAR2,
p_Attribute13 VARCHAR2,
p_Attribute14 VARCHAR2,
p_Attribute15 VARCHAR2,
p_Request_Id NUMBER,
p_Program_application_Id NUMBER,
p_Program_Id NUMBER,
p_Program_Update_date DATE,
p_point_of_use_x NUMBER DEFAULT NULL,
p_point_of_use_y NUMBER DEFAULT NULL,
p_point_of_supply_x NUMBER DEFAULT NULL,
p_point_of_supply_y NUMBER DEFAULT NULL,
p_planning_update_status NUMBER DEFAULT NULL,
p_auto_request VARCHAR2 DEFAULT NULL,
p_Auto_Allocate_Flag NUMBER DEFAULT NULL, --Bug3905884
--eKanban Changes
p_replenishment_type NUMBER DEFAULT NULL,
p_future_card_size NUMBER DEFAULT NULL,
p_future_no_of_cards NUMBER DEFAULT NULL,
p_planning_effectivity DATE DEFAULT NULL,
p_consolidation NUMBER DEFAULT NULL,
p_consolidation_group VARCHAR2 DEFAULT NULL,
p_avg_dependent_demand NUMBER DEFAULT NULL,
p_avg_independent_demand NUMBER DEFAULT NULL,
p_last_imp_plan VARCHAR2 DEFAULT NULL,
p_imp_plan_start_date DATE DEFAULT NULL,
p_imp_plan_end_date DATE DEFAULT NULL,
p_no_of_temp_card NUMBER DEFAULT NULL,
p_no_of_temp_cycle NUMBER DEFAULT NULL,
p_temp_exp_date DATE DEFAULT NULL)
is
l_pull_sequence_Id MTL_Kanban_Pull_Sequences.Pull_Sequence_Id%Type;
Select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL
into l_pull_sequence_Id
from dual;
INSERT INTO MTL_KANBAN_PULL_SEQUENCES
(
Pull_sequence_id,
Inventory_item_id,
Organization_id,
Subinventory_name,
Kanban_Plan_id,
Source_type,
Last_Update_Date,
Last_Updated_By,
Creation_Date,
Created_By,
Last_Update_Login,
Locator_id,
Supplier_id,
Supplier_site_id,
Source_Organization_id,
Source_Subinventory,
Source_Locator_id,
Wip_Line_id,
Release_Kanban_flag,
Calculate_Kanban_flag,
Kanban_size,
Number_of_cards,
Minimum_order_quantity,
Aggregation_type,
Allocation_Percent,
Replenishment_lead_time,
Fixed_Lot_multiplier,
Safety_Stock_Days,
Updated_Flag,
Attribute_Category,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
Request_Id,
Program_application_Id,
Program_Id,
Program_Update_date,
point_of_use_x,
point_of_use_y,
point_of_supply_x,
point_of_supply_y,
planning_update_status,
auto_request,
Auto_Allocate_Flag, --Bug3905884
--eKanban Changes
replenishment_type,
future_card_size,
future_no_of_cards,
planning_effectivity,
consolidation,
consolidation_group,
avg_dependent_demand,
avg_independent_demand,
last_implemented_plan,
plan_start_date,
plan_end_date,
no_of_temp_cards,
no_of_temp_cycles,
temp_expiry_date)
Values
(
l_Pull_sequence_id,
p_Inventory_item_id,
p_Organization_id,
p_Subinventory_name,
p_Kanban_Plan_id,
p_Source_type,
p_Last_Update_Date,
p_Last_Updated_By,
p_Creation_Date,
p_Created_By,
p_Last_Update_Login,
p_Locator_id,
p_Supplier_id,
p_Supplier_site_id,
p_Source_Organization_id,
p_Source_Subinventory,
p_Source_Locator_id,
p_Wip_Line_id,
p_Release_Kanban_flag,
p_Calculate_Kanban_flag,
p_Kanban_size,
p_Number_of_cards,
p_Minimum_order_quantity,
p_Aggregation_type,
p_Allocation_Percent,
p_Replenishment_lead_time,
p_Fixed_Lot_multiplier,
p_Safety_Stock_Days,
p_Updated_Flag,
p_Attribute_Category,
p_Attribute1,
p_Attribute2,
p_Attribute3,
p_Attribute4,
p_Attribute5,
p_Attribute6,
p_Attribute7,
p_Attribute8,
p_Attribute9,
p_Attribute10,
p_Attribute11,
p_Attribute12,
p_Attribute13,
p_Attribute14,
p_Attribute15,
p_Request_Id,
p_Program_application_Id,
p_Program_Id,
p_Program_Update_Date,
p_point_of_use_x,
p_point_of_use_y,
p_point_of_supply_x,
p_point_of_supply_y,
p_planning_update_status,
p_auto_request,
p_Auto_Allocate_Flag, --Bug3905884
--eKanban Changes
p_replenishment_type,
p_future_card_size,
p_future_no_of_cards,
p_planning_effectivity,
p_consolidation,
p_consolidation_group,
p_avg_dependent_demand,
p_avg_independent_demand,
p_last_imp_plan,
p_imp_plan_start_date,
p_imp_plan_end_date,
p_no_of_temp_card,
p_no_of_temp_cycle,
p_temp_exp_date );
, 'Insert_Row'
);
End Insert_Row;
Select 'x'
Into l_Dummy
From MTL_KANBAN_PULL_SEQUENCES
Where organization_id = p_Organization_Id
And kanban_plan_id = p_kanban_plan_id
And inventory_item_id = p_inventory_item_id
And subinventory_name = p_Subinventory_Name
And nvl(locator_id,-1)= nvl(p_locator_id,-1)
And ((p_Pull_Sequence_Id is NULL ) Or
(Pull_Sequence_Id <> p_Pull_Sequence_Id));
SELECT PULL_SEQUENCE_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SUBINVENTORY_NAME
, KANBAN_PLAN_ID
, SOURCE_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LOCATOR_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY
, SOURCE_LOCATOR_ID
, WIP_LINE_ID
, REPLENISHMENT_LEAD_TIME
, RELEASE_KANBAN_FLAG
, CALCULATE_KANBAN_FLAG
, KANBAN_SIZE
, FIXED_LOT_MULTIPLIER
, SAFETY_STOCK_DAYS
, NUMBER_OF_CARDS
, MINIMUM_ORDER_QUANTITY
, AGGREGATION_TYPE
, ALLOCATION_PERCENT
, LAST_UPDATE_LOGIN
, UPDATED_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, POINT_OF_USE_X
, POINT_OF_USE_Y
, POINT_OF_SUPPLY_X
, POINT_OF_SUPPLY_Y
, PLANNING_UPDATE_STATUS
, AUTO_REQUEST
, AUTO_ALLOCATE_FLAG --Added for 3905884
-- eKanban Changes
, REPLENISHMENT_TYPE
, FUTURE_CARD_SIZE
, FUTURE_NO_OF_CARDS
, nvl(PLANNING_EFFECTIVITY,sysdate+1)
, CONSOLIDATION
, CONSOLIDATION_GROUP
, AVG_DEPENDENT_DEMAND
, AVG_INDEPENDENT_DEMAND
INTO l_pull_sequence_rec.pull_sequence_id
, l_pull_sequence_rec.inventory_item_id
, l_pull_sequence_rec.organization_id
, l_pull_sequence_rec.subinventory_name
, l_pull_sequence_rec.Kanban_plan_id
, l_pull_sequence_rec.source_type
, l_pull_sequence_rec.last_update_date
, l_pull_sequence_rec.last_updated_by
, l_pull_sequence_rec.creation_date
, l_pull_sequence_rec.created_by
, l_pull_sequence_rec.locator_id
, l_pull_sequence_rec.supplier_id
, l_pull_sequence_rec.supplier_site_id
, l_pull_sequence_rec.source_organization_id
, l_pull_sequence_rec.source_subinventory
, l_pull_sequence_rec.source_locator_id
, l_pull_sequence_rec.Wip_line_id
, l_pull_sequence_rec.replenishment_lead_time
, l_pull_sequence_rec.Release_Kanban_Flag
, l_pull_sequence_rec.Calculate_Kanban_Flag
, l_pull_sequence_rec.kanban_size
, l_pull_sequence_rec.fixed_lot_multiplier
, l_pull_sequence_rec.safety_stock_days
, l_pull_sequence_rec.number_of_cards
, l_pull_sequence_rec.minimum_order_quantity
, l_pull_sequence_rec.aggregation_Type
, l_pull_sequence_rec.Allocation_Percent
, l_pull_sequence_rec.last_update_login
, l_pull_sequence_rec.updated_flag
, l_pull_sequence_rec.attribute_category
, l_pull_sequence_rec.attribute1
, l_pull_sequence_rec.attribute2
, l_pull_sequence_rec.attribute3
, l_pull_sequence_rec.attribute4
, l_pull_sequence_rec.attribute5
, l_pull_sequence_rec.attribute6
, l_pull_sequence_rec.attribute7
, l_pull_sequence_rec.attribute8
, l_pull_sequence_rec.attribute9
, l_pull_sequence_rec.attribute10
, l_pull_sequence_rec.attribute11
, l_pull_sequence_rec.attribute12
, l_pull_sequence_rec.attribute13
, l_pull_sequence_rec.attribute14
, l_pull_sequence_rec.attribute15
, l_pull_sequence_rec.request_id
, l_pull_sequence_rec.program_application_id
, l_pull_sequence_rec.program_id
, l_pull_sequence_rec.program_update_date
, l_pull_sequence_rec.point_of_use_x
, l_pull_sequence_rec.point_of_use_y
, l_pull_sequence_rec.point_of_supply_x
, l_pull_sequence_rec.point_of_supply_y
, l_pull_sequence_rec.planning_update_status
, l_pull_sequence_rec.auto_request
, l_pull_sequence_rec.auto_allocate_flag --Added for3905884
, l_pull_sequence_rec.REPLENISHMENT_TYPE
, l_pull_sequence_rec.FUTURE_CARD_SIZE
, l_pull_sequence_rec.FUTURE_NO_OF_CARDS
, l_pull_sequence_rec.PLANNING_EFFECTIVITY
, l_pull_sequence_rec.CONSOLIDATION
, l_pull_sequence_rec.CONSOLIDATION_GROUP
, l_pull_sequence_rec.AVG_DEPENDENT_DEMAND
, l_pull_sequence_rec.AVG_INDEPENDENT_DEMAND
FROM MTL_KANBAN_PULL_SEQUENCES
WHERE PULL_SEQUENCE_ID = p_pull_sequence_id ;
IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_pull_sequence_rec.last_update_date := NULL;
IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.last_updated_by := NULL;
IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.last_update_login := NULL;
IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.last_update_login := NULL;
IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.updated_flag := NULL;
IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_pull_sequence_rec.program_update_date := NULL;
IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.planning_update_status := NULL;
IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_pull_sequence_rec.last_update_date := p_old_pull_sequence_rec.last_update_date;
IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.last_updated_by := p_old_pull_sequence_rec.last_updated_by;
IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.last_update_login := p_old_pull_sequence_rec.last_update_login;
IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.updated_flag := p_old_pull_sequence_rec.updated_flag;
IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_pull_sequence_rec.program_update_date := p_old_pull_sequence_rec.program_update_date;
IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
l_pull_sequence_rec.planning_update_status := p_old_pull_sequence_rec.planning_update_status;
PROCEDURE Insert_Row(x_return_status OUT NOCOPY Varchar2,
p_pull_sequence_id IN Out NOCOPY NUMBER,
p_Inventory_item_id NUMBER,
p_Organization_id NUMBER,
p_Subinventory_name VARCHAR2,
p_Kanban_Plan_id NUMBER,
p_Source_type NUMBER,
p_Last_Update_Date DATE,
p_Last_Updated_By NUMBER,
p_Creation_Date DATE,
p_Created_By NUMBER,
p_Last_Update_Login NUMBER,
p_Locator_id NUMBER,
p_Supplier_id NUMBER,
p_Supplier_site_id NUMBER,
p_Source_Organization_id NUMBER,
p_Source_Subinventory VARCHAR2,
p_Source_Locator_id NUMBER,
p_Wip_Line_id NUMBER,
p_Release_Kanban_Flag NUMBER,
p_Calculate_Kanban_Flag NUMBER,
p_Kanban_size NUMBER,
p_Number_of_cards NUMBER,
p_Minimum_order_quantity NUMBER,
p_Aggregation_type NUMBER,
p_Allocation_Percent NUMBER,
p_Replenishment_lead_time NUMBER,
p_Fixed_Lot_multiplier NUMBER,
p_Safety_Stock_Days NUMBER,
p_Updated_Flag NUMBER,
p_Attribute_Category VARCHAR2,
p_Attribute1 VARCHAR2,
p_Attribute2 VARCHAR2,
p_Attribute3 VARCHAR2,
p_Attribute4 VARCHAR2,
p_Attribute5 VARCHAR2,
p_Attribute6 VARCHAR2,
p_Attribute7 VARCHAR2,
p_Attribute8 VARCHAR2,
p_Attribute9 VARCHAR2,
p_Attribute10 VARCHAR2,
p_Attribute11 VARCHAR2,
p_Attribute12 VARCHAR2,
p_Attribute13 VARCHAR2,
p_Attribute14 VARCHAR2,
p_Attribute15 VARCHAR2,
p_Request_Id NUMBER,
p_Program_application_Id NUMBER,
p_Program_Id NUMBER,
p_Program_Update_date DATE,
p_point_of_use_x NUMBER DEFAULT NULL,
p_point_of_use_y NUMBER DEFAULT NULL,
p_point_of_supply_x NUMBER DEFAULT NULL,
p_point_of_supply_y NUMBER DEFAULT NULL,
p_planning_update_status NUMBER DEFAULT NULL,
p_auto_request VARCHAR2 DEFAULT NULL,
p_Auto_Allocate_Flag NUMBER, --Bug3905884
--eKanban Changes
p_replenishment_type NUMBER DEFAULT NULL,
p_future_card_size NUMBER DEFAULT NULL,
p_future_no_of_cards NUMBER DEFAULT NULL,
p_planning_effectivity DATE DEFAULT NULL,
p_consolidation NUMBER DEFAULT NULL,
p_consolidation_group VARCHAR2 DEFAULT NULL,
p_avg_dependent_demand NUMBER DEFAULT NULL,
p_avg_independent_demand NUMBER DEFAULT NULL)
is
l_pull_sequence_Id MTL_Kanban_Pull_Sequences.Pull_Sequence_Id%Type;
Select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL
into l_pull_sequence_Id
from dual;
INSERT INTO MTL_KANBAN_PULL_SEQUENCES
(
Pull_sequence_id,
Inventory_item_id,
Organization_id,
Subinventory_name,
Kanban_Plan_id,
Source_type,
Last_Update_Date,
Last_Updated_By,
Creation_Date,
Created_By,
Last_Update_Login,
Locator_id,
Supplier_id,
Supplier_site_id,
Source_Organization_id,
Source_Subinventory,
Source_Locator_id,
Wip_Line_id,
Release_Kanban_flag,
Calculate_Kanban_flag,
Kanban_size,
Number_of_cards,
Minimum_order_quantity,
Aggregation_type,
Allocation_Percent,
Replenishment_lead_time,
Fixed_Lot_multiplier,
Safety_Stock_Days,
Updated_Flag,
Attribute_Category,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
Request_Id,
Program_application_Id,
Program_Id,
Program_Update_date,
point_of_use_x,
point_of_use_y,
point_of_supply_x,
point_of_supply_y,
planning_update_status,
auto_request,
Auto_Allocate_Flag, --Bug3905884
--eKanban Changes
replenishment_type,
future_card_size,
future_no_of_cards,
planning_effectivity,
consolidation,
consolidation_group,
avg_dependent_demand,
avg_independent_demand)
Values
(
l_Pull_sequence_id,
p_Inventory_item_id,
p_Organization_id,
p_Subinventory_name,
p_Kanban_Plan_id,
p_Source_type,
p_Last_Update_Date,
p_Last_Updated_By,
p_Creation_Date,
p_Created_By,
p_Last_Update_Login,
p_Locator_id,
p_Supplier_id,
p_Supplier_site_id,
p_Source_Organization_id,
p_Source_Subinventory,
p_Source_Locator_id,
p_Wip_Line_id,
p_Release_Kanban_flag,
p_Calculate_Kanban_flag,
p_Kanban_size,
p_Number_of_cards,
p_Minimum_order_quantity,
p_Aggregation_type,
p_Allocation_Percent,
p_Replenishment_lead_time,
p_Fixed_Lot_multiplier,
p_Safety_Stock_Days,
p_Updated_Flag,
p_Attribute_Category,
p_Attribute1,
p_Attribute2,
p_Attribute3,
p_Attribute4,
p_Attribute5,
p_Attribute6,
p_Attribute7,
p_Attribute8,
p_Attribute9,
p_Attribute10,
p_Attribute11,
p_Attribute12,
p_Attribute13,
p_Attribute14,
p_Attribute15,
p_Request_Id,
p_Program_application_Id,
p_Program_Id,
p_Program_Update_Date,
p_point_of_use_x,
p_point_of_use_y,
p_point_of_supply_x,
p_point_of_supply_y,
p_planning_update_status,
p_auto_request,
p_Auto_Allocate_Flag, --Bug3905884
--eKanban Changes
p_replenishment_type,
p_future_card_size,
p_future_no_of_cards,
p_planning_effectivity,
p_consolidation,
p_consolidation_group,
p_avg_dependent_demand,
p_avg_independent_demand
);
, 'Insert_Row'
);
End Insert_Row;
Procedure Insert_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type)
Is
l_Pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type :=
p_pull_sequence_rec;
INV_PullSequence_PKG.Insert_Row(
x_return_status =>l_return_status,
p_pull_sequence_id =>l_Pull_sequence_Rec.pull_sequence_id,
p_Inventory_item_id =>l_Pull_sequence_Rec.Inventory_item_id,
p_Organization_id =>l_Pull_sequence_Rec.Organization_id,
p_Subinventory_name =>l_Pull_sequence_Rec.Subinventory_name,
p_Kanban_Plan_id =>l_Pull_sequence_Rec.Kanban_Plan_id,
p_Source_type =>l_Pull_sequence_Rec.Source_type,
p_Last_Update_Date =>l_Pull_sequence_Rec.Last_Update_Date,
p_Last_Updated_By =>l_Pull_sequence_Rec.Last_Updated_By,
p_Creation_Date =>l_Pull_sequence_Rec.Creation_Date,
p_Created_By =>l_Pull_sequence_Rec.Created_By,
p_Last_Update_Login =>l_Pull_sequence_Rec.Last_Update_Login,
p_Locator_id =>l_Pull_sequence_Rec.Locator_id,
p_Supplier_id =>l_Pull_sequence_Rec.Supplier_id,
p_Supplier_site_id =>l_Pull_sequence_Rec.Supplier_site_id,
p_Source_Organization_id=>l_Pull_sequence_Rec.Source_Organization_id,
p_Source_Subinventory =>l_Pull_sequence_Rec.Source_Subinventory,
p_Source_Locator_id =>l_Pull_sequence_Rec.Source_Locator_id,
p_Wip_Line_id =>l_Pull_Sequence_Rec.Wip_Line_id,
p_Release_Kanban_Flag =>l_Pull_sequence_Rec.Release_Kanban_Flag,
p_Calculate_Kanban_Flag =>l_Pull_sequence_Rec.Calculate_Kanban_Flag,
p_Kanban_size =>l_Pull_sequence_Rec.Kanban_size,
p_Number_of_cards =>l_Pull_sequence_Rec.Number_of_cards,
p_Minimum_order_quantity=>l_Pull_sequence_Rec.Minimum_order_quantity,
p_Aggregation_type =>l_Pull_sequence_Rec.Aggregation_type,
p_Allocation_Percent =>l_Pull_sequence_Rec.Allocation_Percent,
p_Replenishment_lead_time=>l_Pull_sequence_Rec.Replenishment_lead_time,
p_Fixed_Lot_multiplier =>l_Pull_sequence_Rec.Fixed_Lot_multiplier,
p_Safety_Stock_Days =>l_Pull_sequence_Rec.Safety_Stock_Days,
p_Updated_Flag =>l_Pull_sequence_Rec.Updated_Flag,
p_Attribute_Category =>l_Pull_sequence_Rec.Attribute_Category,
p_Attribute1 =>l_Pull_sequence_Rec.Attribute1,
p_Attribute2 =>l_Pull_sequence_Rec.Attribute2,
p_Attribute3 =>l_Pull_sequence_Rec.Attribute3,
p_Attribute4 =>l_Pull_sequence_Rec.Attribute4,
p_Attribute5 =>l_Pull_sequence_Rec.Attribute5,
p_Attribute6 =>l_Pull_sequence_Rec.Attribute6,
p_Attribute7 =>l_Pull_sequence_Rec.Attribute7,
p_Attribute8 =>l_Pull_sequence_Rec.Attribute8,
p_Attribute9 =>l_Pull_sequence_Rec.Attribute9,
p_Attribute10 =>l_Pull_sequence_Rec.Attribute10,
p_Attribute11 =>l_Pull_sequence_Rec.Attribute11,
p_Attribute12 =>l_Pull_sequence_Rec.Attribute12,
p_Attribute13 =>l_Pull_sequence_Rec.Attribute13,
p_Attribute14 =>l_Pull_sequence_Rec.Attribute14,
p_Attribute15 =>l_Pull_sequence_Rec.Attribute15,
p_Request_Id =>l_Pull_sequence_Rec.Request_Id,
p_Program_application_Id=>l_Pull_sequence_Rec.Program_application_Id,
p_Program_Id =>l_Pull_sequence_Rec.Program_Id,
p_Program_Update_date =>l_Pull_sequence_Rec.Program_Update_date,
p_point_of_use_x =>l_Pull_sequence_Rec.point_of_use_x,
p_point_of_use_y =>l_Pull_sequence_Rec.point_of_use_y,
p_point_of_supply_x =>l_Pull_sequence_Rec.point_of_supply_x,
p_point_of_supply_y =>l_Pull_sequence_Rec.point_of_supply_y,
p_planning_update_status=>l_Pull_sequence_Rec.planning_update_status,
p_auto_request =>l_Pull_sequence_Rec.auto_request,
p_Auto_Allocate_Flag =>l_Pull_sequence_Rec.Auto_Allocate_Flag, --Added for 3905884.
--eKanban Changes
p_replenishment_type =>l_Pull_sequence_Rec.replenishment_type,
p_future_card_size =>l_Pull_sequence_Rec.future_card_size,
p_future_no_of_cards =>l_Pull_sequence_Rec.future_no_of_cards,
p_planning_effectivity =>l_Pull_sequence_Rec.planning_effectivity,
p_consolidation =>l_Pull_sequence_Rec.consolidation,
p_consolidation_group =>l_Pull_sequence_Rec.consolidation_group,
p_avg_dependent_demand =>l_Pull_sequence_Rec.avg_dependent_demand,
p_avg_independent_demand =>l_Pull_sequence_Rec.avg_independent_demand,
p_last_imp_plan => l_Pull_sequence_Rec.last_implemented_plan,
p_imp_plan_start_date => l_Pull_sequence_Rec.plan_start_date,
p_imp_plan_end_date => l_Pull_sequence_Rec.plan_end_date,
p_no_of_temp_card => null,
p_no_of_temp_cycle => null,
p_temp_exp_date => null);
, 'Insert_Row'
);
End Insert_Row;
p_Updated_Flag NUMBER,
p_Attribute_Category VARCHAR2,
p_Attribute1 VARCHAR2,
p_Attribute2 VARCHAR2,
p_Attribute3 VARCHAR2,
p_Attribute4 VARCHAR2,
p_Attribute5 VARCHAR2,
p_Attribute6 VARCHAR2,
p_Attribute7 VARCHAR2,
p_Attribute8 VARCHAR2,
p_Attribute9 VARCHAR2,
p_Attribute10 VARCHAR2,
p_Attribute11 VARCHAR2,
p_Attribute12 VARCHAR2,
p_Attribute13 VARCHAR2,
p_Attribute14 VARCHAR2,
p_Attribute15 VARCHAR2,
p_point_of_use_x NUMBER DEFAULT NULL,
p_point_of_use_y NUMBER DEFAULT NULL,
p_point_of_supply_x NUMBER DEFAULT NULL,
p_point_of_supply_y NUMBER DEFAULT NULL,
p_planning_update_status NUMBER DEFAULT NULL,
p_auto_request VARCHAR2 DEFAULT NULL,
p_Auto_Allocate_Flag NUMBER)--Added for 3905884.
IS
CURSOR Get_Current_Row IS
SELECT *
FROM MTL_KANBAN_PULL_SEQUENCES
WHERE pull_sequence_id = p_pull_sequence_id
FOR UPDATE of Organization_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
((Recinfo.Updated_Flag = p_Updated_Flag)
or (Recinfo.Updated_Flag is null and p_Updated_Flag is null)) and
((Recinfo.Attribute_Category = p_Attribute_Category)
or (Recinfo.Attribute_Category is null and p_Attribute_Category is null))
/*Fix for 3905884.*/
and ((Recinfo.Auto_Allocate_Flag = p_Auto_Allocate_Flag)
or (Recinfo.Auto_Allocate_Flag is null and p_Auto_Allocate_Flag is null)) /*End of fix for 3905884*/
) then
RAISE RECORD_CHANGED;
AND ( (Recinfo.planning_update_status= p_planning_update_status)
OR ( (Recinfo.planning_update_status IS NULL)
AND (p_planning_update_status IS NULL)))
AND ( (Recinfo.auto_request = p_auto_request)
OR ( (Recinfo.auto_request IS NULL)
AND (p_auto_request IS NULL)))
) THEN
RAISE RECORD_CHANGED;
PROCEDURE Update_Row(x_return_status OUT NOCOPY VARCHAR2,
p_Pull_Sequence_Id NUMBER,
p_Inventory_item_id NUMBER,
p_Organization_id NUMBER,
p_Subinventory_name VARCHAR2,
p_Kanban_Plan_id NUMBER,
p_Source_type NUMBER,
p_Last_Update_Date DATE,
p_Last_Updated_By NUMBER,
p_Creation_Date DATE,
p_Created_By NUMBER,
p_Last_Update_Login NUMBER,
p_Locator_id NUMBER,
p_Supplier_id NUMBER,
p_Supplier_site_id NUMBER,
p_Source_Organization_id NUMBER,
p_Source_Subinventory VARCHAR2,
p_Source_Locator_id NUMBER,
p_Wip_Line_id NUMBER,
p_Release_Kanban_flag NUMBER,
p_Calculate_Kanban_flag NUMBER,
p_Kanban_size NUMBER,
p_Number_of_cards NUMBER,
p_Minimum_order_quantity NUMBER,
p_Aggregation_Type NUMBER,
p_Allocation_Percent NUMBER,
p_Replenishment_lead_time NUMBER,
p_Fixed_Lot_multiplier NUMBER,
p_Safety_Stock_Days NUMBER,
p_Updated_Flag NUMBER,
p_Attribute_Category VARCHAR2,
p_Attribute1 VARCHAR2,
p_Attribute2 VARCHAR2,
p_Attribute3 VARCHAR2,
p_Attribute4 VARCHAR2,
p_Attribute5 VARCHAR2,
p_Attribute6 VARCHAR2,
p_Attribute7 VARCHAR2,
p_Attribute8 VARCHAR2,
p_Attribute9 VARCHAR2,
p_Attribute10 VARCHAR2,
p_Attribute11 VARCHAR2,
p_Attribute12 VARCHAR2,
p_Attribute13 VARCHAR2,
p_Attribute14 VARCHAR2,
p_Attribute15 VARCHAR2,
p_point_of_use_x NUMBER DEFAULT NULL,
p_point_of_use_y NUMBER DEFAULT NULL,
p_point_of_supply_x NUMBER DEFAULT NULL,
p_point_of_supply_y NUMBER DEFAULT NULL,
p_planning_update_status NUMBER DEFAULT NULL,
p_auto_request VARCHAR2 DEFAULT NULL,
p_Auto_Allocate_Flag NUMBER DEFAULT NULL, --Bug3905884
--eKanban Changes
p_replenishment_type NUMBER DEFAULT NULL,
p_future_card_size NUMBER DEFAULT NULL,
p_future_no_of_cards NUMBER DEFAULT NULL,
p_planning_effectivity DATE DEFAULT NULL,
p_consolidation NUMBER DEFAULT NULL,
p_consolidation_group VARCHAR2 DEFAULT NULL,
p_avg_dependent_demand NUMBER DEFAULT NULL,
p_avg_independent_demand NUMBER DEFAULT NULL)
IS
l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
UPDATE MTL_KANBAN_PULL_SEQUENCES
SET
Inventory_item_id = p_Inventory_item_id,
Organization_Id = p_Organization_Id,
Subinventory_name = p_Subinventory_name,
Kanban_Plan_id = p_Kanban_Plan_id,
Source_type = p_Source_type,
Last_Update_Date = p_Last_Update_Date,
Last_Updated_By = p_Last_Updated_By,
Creation_Date = p_Creation_Date,
Created_By = p_Created_By,
Last_Update_Login = p_Last_Update_Login,
Locator_id = p_Locator_id,
Supplier_id = p_Supplier_id,
Supplier_site_id = p_Supplier_site_id,
Source_Organization_id = p_Source_Organization_id,
Source_Subinventory = p_Source_Subinventory,
Source_Locator_id = p_Source_Locator_id,
Wip_Line_id = p_Wip_Line_id,
Release_Kanban_Flag = p_Release_Kanban_flag,
Calculate_Kanban_Flag = p_Calculate_Kanban_flag,
Kanban_size = p_Kanban_size,
Number_of_cards = p_Number_of_cards,
Minimum_order_quantity = p_Minimum_order_quantity,
Aggregation_Type = p_Aggregation_Type,
Allocation_Percent = p_Allocation_Percent,
Replenishment_lead_time = p_Replenishment_lead_time,
Fixed_Lot_multiplier = p_Fixed_Lot_multiplier,
Safety_Stock_Days = p_Safety_Stock_Days,
Updated_Flag = p_Updated_Flag,
Attribute_Category = p_Attribute_Category,
Attribute1 = p_Attribute1,
Attribute2 = p_Attribute2,
Attribute3 = p_Attribute3,
Attribute4 = p_Attribute4,
Attribute5 = p_Attribute5,
Attribute6 = p_Attribute6,
Attribute7 = p_Attribute7,
Attribute8 = p_Attribute8,
Attribute9 = p_Attribute9,
Attribute10 = p_Attribute10,
Attribute11 = p_Attribute11,
Attribute12 = p_Attribute12,
Attribute13 = p_Attribute13,
Attribute14 = p_Attribute14,
Attribute15 = p_Attribute15,
point_of_use_x = p_point_of_use_x,
point_of_use_y = p_point_of_use_y,
point_of_supply_x = p_point_of_supply_x,
point_of_supply_y = p_point_of_supply_y,
planning_update_status = p_planning_update_status,
auto_request = p_auto_request,
Auto_Allocate_Flag = p_Auto_Allocate_Flag, --Added for 3905884
--eKanban Changes
replenishment_type = p_replenishment_type,
future_card_size = p_future_card_size,
future_no_of_cards = p_future_no_of_cards,
planning_effectivity = p_planning_effectivity,
consolidation = p_consolidation,
consolidation_group = p_consolidation_group,
avg_dependent_demand = p_avg_dependent_demand,
avg_independent_demand = p_avg_independent_demand
WHERE pull_sequence_id = p_pull_sequence_id;
, 'Update_Row'
);
END Update_Row;
PROCEDURE Update_Row(
p_pull_sequence_rec INV_Kanban_PVT.Pull_sequence_Rec_Type)
Is
l_return_status Varchar2(1);
Update_Row(
x_return_status =>l_return_status,
p_pull_sequence_id =>p_Pull_sequence_Rec.pull_sequence_id,
p_Inventory_item_id =>p_Pull_sequence_Rec.Inventory_item_id,
p_Organization_id =>p_Pull_sequence_Rec.Organization_id,
p_Subinventory_name =>p_Pull_sequence_Rec.Subinventory_name,
p_Kanban_Plan_id =>p_Pull_sequence_Rec.Kanban_Plan_id,
p_Source_type =>p_Pull_sequence_Rec.Source_type ,
p_Last_Update_Date =>p_Pull_sequence_Rec.Last_Update_Date,
p_Last_Updated_By =>p_Pull_sequence_Rec.Last_Updated_By,
p_Creation_Date =>p_Pull_sequence_Rec.Creation_Date,
p_Created_By =>p_Pull_sequence_Rec.Created_By,
p_Last_Update_Login =>p_Pull_sequence_Rec.Last_Update_Login ,
p_Locator_id =>p_Pull_sequence_Rec.Locator_id,
p_Supplier_id =>p_Pull_sequence_Rec.Supplier_id,
p_Supplier_site_id =>p_Pull_sequence_Rec.Supplier_site_id ,
p_Source_Organization_id=>p_Pull_sequence_Rec.Source_Organization_id,
p_Source_Subinventory =>p_Pull_sequence_Rec.Source_Subinventory,
p_Source_Locator_id =>p_Pull_sequence_Rec.Source_Locator_id ,
p_Wip_Line_id =>p_Pull_Sequence_Rec.Wip_Line_id ,
p_Release_Kanban_Flag =>p_Pull_sequence_Rec.Release_Kanban_Flag,
p_Calculate_Kanban_Flag =>p_Pull_sequence_Rec.Calculate_Kanban_Flag,
p_Kanban_size =>p_Pull_sequence_Rec.Kanban_size ,
p_Number_of_cards =>p_Pull_sequence_Rec.Number_of_cards ,
p_Minimum_order_quantity=>p_Pull_sequence_Rec.Minimum_order_quantity,
p_Aggregation_type =>p_Pull_sequence_Rec.Aggregation_type ,
p_Allocation_Percent =>p_Pull_sequence_Rec.Allocation_Percent,
p_Replenishment_lead_time=>p_Pull_sequence_Rec.Replenishment_lead_time,
p_Fixed_Lot_multiplier =>p_Pull_sequence_Rec.Fixed_Lot_multiplier,
p_Safety_Stock_Days =>p_Pull_sequence_Rec.Safety_Stock_Days ,
p_Updated_Flag =>p_Pull_sequence_Rec.Updated_Flag ,
p_Attribute_Category =>p_Pull_sequence_Rec.Attribute_Category,
p_Attribute1 =>p_Pull_sequence_Rec.Attribute1 ,
p_Attribute2 =>p_Pull_sequence_Rec.Attribute2 ,
p_Attribute3 =>p_Pull_sequence_Rec.Attribute3 ,
p_Attribute4 =>p_Pull_sequence_Rec.Attribute4 ,
p_Attribute5 =>p_Pull_sequence_Rec.Attribute5 ,
p_Attribute6 =>p_Pull_sequence_Rec.Attribute6 ,
p_Attribute7 =>p_Pull_sequence_Rec.Attribute7 ,
p_Attribute8 =>p_Pull_sequence_Rec.Attribute8 ,
p_Attribute9 =>p_Pull_sequence_Rec.Attribute9 ,
p_Attribute10 =>p_Pull_sequence_Rec.Attribute10 ,
p_Attribute11 =>p_Pull_sequence_Rec.Attribute11 ,
p_Attribute12 =>p_Pull_sequence_Rec.Attribute12 ,
p_Attribute13 =>p_Pull_sequence_Rec.Attribute13 ,
p_Attribute14 =>p_Pull_sequence_Rec.Attribute14 ,
p_Attribute15 =>p_Pull_sequence_Rec.Attribute15 ,
p_point_of_use_x =>p_Pull_sequence_Rec.point_of_use_x ,
p_point_of_use_y =>p_Pull_sequence_Rec.point_of_use_y ,
p_point_of_supply_x =>p_Pull_sequence_Rec.point_of_supply_x ,
p_point_of_supply_y =>p_Pull_sequence_Rec.point_of_supply_y ,
p_planning_update_status =>p_Pull_sequence_Rec.planning_update_status,
p_auto_request =>p_Pull_sequence_Rec.auto_request,
p_Auto_Allocate_Flag =>p_Pull_sequence_Rec.Auto_Allocate_Flag, --Added for 3905884.
--eKanban Changes
p_replenishment_type =>p_Pull_sequence_Rec.replenishment_type,
p_future_card_size =>p_Pull_sequence_Rec.future_card_size,
p_future_no_of_cards =>p_Pull_sequence_Rec.future_no_of_cards,
p_planning_effectivity =>p_Pull_sequence_Rec.planning_effectivity,
p_consolidation =>p_Pull_sequence_Rec.consolidation,
p_consolidation_group =>p_Pull_sequence_Rec.consolidation_group,
p_avg_dependent_demand =>p_Pull_sequence_Rec.avg_dependent_demand,
p_avg_independent_demand =>p_Pull_sequence_Rec.avg_independent_demand,
p_last_imp_plan =>p_Pull_sequence_Rec.last_implemented_plan,
p_imp_plan_start_date =>p_Pull_sequence_Rec.plan_start_date,
p_imp_plan_end_date =>p_Pull_sequence_Rec.plan_end_date,
p_no_of_temp_card =>null,
p_no_of_temp_cycle =>null,
p_temp_exp_date =>null );
, 'Update_Row'
);
END Update_Row;
PROCEDURE Delete_Row(x_return_status OUT NOCOPY VARCHAR2,
p_Pull_Sequence_Id Number)
IS
l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR;
if INV_Kanban_PVT.Ok_To_Delete_Pull_Sequence(p_pull_sequence_Id)
then
DELETE FROM MTL_KANBAN_PULL_SEQUENCES
WHERE pull_sequence_id = p_pull_sequence_id;
DELETE FROM MTL_PULL_SEQ_SUPPLIERS
WHERE pull_sequence_id = p_pull_sequence_id;
, 'Delete_Row'
);
END Delete_Row;