[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT excess_service_level,
repair_service_level,
newbuy_service_level,
excess_edq_Factor,
repair_edq_Factor,
newbuy_edq_Factor,
edq_multiple
INTO l_excess_Service_level,
l_repair_Service_level,
l_newbuy_Service_level,
l_excess_edq_factor,
l_repair_edq_Factor,
l_newbuy_edq_Factor,
l_edq_multiple
FROM csp_planning_parameters cpp
WHERE organization_id = p_organization_id
and cpp.organization_type = 'W';
SELECT excess_service_level,
repair_service_level,
newbuy_service_level,
excess_edq_factor,
repair_edq_factor,
newbuy_edq_factor,
excess_edq_multiple,
repair_edq_multiple,
newbuy_edq_multiple
INTO l_item_excess_Service_level,
l_item_repair_Service_level,
l_item_newbuy_service_level,
l_item_excess_edq_factor,
l_item_repair_edq_factor,
l_item_newbuy_edq_factor,
l_item_excess_Edq_multiple,
l_item_repair_edq_multiple,
l_item_newbuy_edq_multiple
FROM csp_item_pl_params
WHERE organization_id = p_organization_id
AND inventory_item_id = p_inventory_item_id;
UPDATE csp_item_pl_params
SET excess_service_level = decode(p_excess_service_level, nvl(l_item_excess_Service_level, l_excess_service_level), excess_service_level, p_excess_service_level),
repair_service_level = decode(p_repair_service_level, nvl(l_item_repair_Service_level, l_repair_service_level), repair_service_level, p_repair_service_level),
newbuy_service_level = decode(p_newbuy_service_level, nvl(l_item_newbuy_service_level, l_newbuy_service_level), newbuy_service_level, p_newbuy_service_level),
excess_edq_factor = decode(p_excess_edq_factor, nvl(l_item_excess_edq_factor, l_excess_edq_factor), excess_edq_factor, p_excess_edq_factor),
repair_edq_factor = decode(p_repair_edq_factor, nvl(l_item_repair_edq_factor, l_repair_edq_factor), repair_edq_factor, p_repair_edq_factor),
newbuy_edq_factor = decode(p_newbuy_edq_factor, nvl(l_item_newbuy_edq_factor, l_newbuy_edq_factor), newbuy_edq_factor, p_newbuy_edq_factor),
excess_edq_multiple = decode(p_excess_edq_multiple, nvl(l_item_excess_Edq_multiple, l_edq_multiple), excess_edq_multiple, p_excess_edq_multiple),
repair_edq_multiple = decode(p_repair_edq_multiple, nvl(l_item_repair_edq_multiple, l_edq_multiple), repair_edq_multiple, p_repair_edq_multiple),
newbuy_edq_multiple = decode(p_newbuy_edq_multiple, nvl(l_item_newbuy_edq_multiple, l_edq_multiple), newbuy_edq_multiple, p_newbuy_edq_multiple),
last_updated_by = fnd_global.user_id,
last_update_date = sysdate,
last_update_login = fnd_global.login_id
WHERE organization_id = p_organization_id
AND inventory_item_id = p_inventory_item_id;
SELECT csp_item_pl_params_s1.nextval
INTO l_item_pl_params_s
FROM dual;
INSERT INTO csp_item_pl_params(ITEM_PL_PARAMS_ID,
ORGANIZATION_ID,
INVENTORY_ITEM_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
EXCESS_SERVICE_LEVEL,
REPAIR_SERVICE_LEVEL,
NEWBUY_SERVICE_LEVEL,
EXCESS_EDQ_FACTOR,
REPAIR_EDQ_FACTOR,
NEWBUY_EDQ_FACTOR,
EXCESS_EDQ_MULTIPLE,
REPAIR_EDQ_MULTIPLE,
NEWBUY_EDQ_MULTIPLE)
SELECT
l_item_pl_params_s,
p_organization_id,
p_inventory_item_id,
fnd_global.user_id created_by,
sysdate creation_date,
fnd_global.user_id last_updated_by,
sysdate last_update_Date,
fnd_global.login_id last_update_login,
decode(nvl(p_excess_service_level, 0), nvl(cpp.excess_service_level, 0), null, p_excess_service_level) excess_Service_level,
decode(p_repair_service_level, cpp.repair_service_level, null, p_repair_service_level) repair_Service_level,
decode(p_newbuy_service_level, cpp.newbuy_service_level, null, p_newbuy_service_level) newbuy_service_level,
decode(p_excess_edq_factor, cpp.excess_edq_factor, null, p_excess_edq_Factor) excess_edq_Factor,
decode(p_repair_edq_factor, cpp.repair_edq_factor, null, p_repair_edq_Factor) repair_edq_Factor,
decode(p_newbuy_edq_factor, cpp.newbuy_edq_factor, null, p_newbuy_edq_Factor) newbuy_edq_Factor,
decode(p_excess_edq_multiple, cpp.edq_multiple, null, p_excess_edq_multiple) excess_Edq_multiple,
decode(p_repair_edq_multiple, cpp.edq_multiple, null, p_repair_edq_multiple) repair_edq_multiple,
decode(p_newbuy_edq_multiple, cpp.edq_multiple, null, p_newbuy_edq_multiple) newbuy_edq_multiple
FROM csp_planning_parameters cpp
WHERE cpp.organization_id = p_organization_id
AND cpp.organization_type = 'W';
UPDATE SET cipp.excess_service_level = decode(p_excess_service_level, cpp.excess_service_level, FND_API.G_MISS_NUM, p_excess_service_level),
cipp.repair_service_level = decode(p_repair_service_level, cpp.repair_service_level, FND_API.G_MISS_NUM, p_repair_service_level)
WHEN NOT MATCHED THEN
*/
-- END IF;