[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM gme_material_details
WHERE batch_id = v_batch_id;
SELECT *
FROM gme_material_details
WHERE batch_id = v_batch_id
AND line_type = 1
AND inventory_item_id =
(SELECT inventory_item_id
FROM gmd_recipe_validity_rules
WHERE recipe_validity_rule_id =
(SELECT recipe_validity_rule_id
FROM gme_batch_header
WHERE batch_id = v_batch_id) );
SELECT *
FROM ic_plnt_inv
WHERE orgn_code = v_plant_code AND
item_id = v_item_id AND
delete_mark = 0;
SELECT concatenated_segments,description
FROM mtl_system_items_kfv
WHERE inventory_item_id = v_inventory_item_id
AND organization_id = v_org_id;
/*SELECT *
FROM mtl_system_items_kfv
WHERE inventory_item_id = v_inventory_item_id
AND organization_id = v_org_id;*/
SELECT std_lot_size, primary_uom_code, fixed_lead_time
,variable_lead_time
FROM mtl_system_items_b
WHERE inventory_item_id = v_inventory_item_id
AND organization_id = v_org_id;
SELECT *
INTO l_item_row
FROM ic_item_mst
WHERE ic_item_mst.item_id = x_prim_prod_row.inventory_item_id;
SELECT v.inventory_item_id, i.primary_uom_code
FROM gmd_recipe_validity_rules v, mtl_system_items i
WHERE recipe_validity_rule_id = v_validity_rule_id
AND i.organization_id = v_organization_id
AND v.inventory_item_id = i.inventory_item_id;
PROCEDURE update_original_fpo (
p_fpo_header_row IN gme_batch_header%ROWTYPE
,p_prim_prod_row IN gme_material_details%ROWTYPE
,p_pregen_fpo_row IN pregen_fpo_row
,p_fpo_material_details_tab IN fpo_material_details_tab
,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE
,x_return_status OUT NOCOPY VARCHAR2)
IS
CURSOR get_phantom_fpo (v_batch_id NUMBER)
IS
SELECT phantom_id
FROM gme_material_details
WHERE batch_id = v_batch_id AND phantom_id IS NOT NULL;
l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ORIGINAL_FPO';
update_row_err EXCEPTION;
delete_pending_trans_err EXCEPTION;
update_pending_trans EXCEPTION;
('in IF.gonna update header and delete pending trans');
l_return := gme_batch_header_dbl.update_row (l_fpo_header_row);
gme_debug.put_line ('l_return from update_row = FALSE');
RAISE update_row_err;
gme_debug.put_line ('l_return from update_row = TRUE');
UPDATE gme_material_details
SET plan_qty = 0
WHERE batch_id = l_fpo_header_row.batch_id;
gme_trans_engine_pvt.update_pending_trans (
l_tran_row,
l_return_status
);
RAISE update_pending_trans;
/* code to delete the resource transactions */
/*l_resource_txns.resource_usage := 0;
GME_RESOURCE_ENGINE_PVT.update_resource_trans (p_tran_row => l_resource_txns
,x_return_status => l_return_status);*/
gme_resource_engine_pvt.delete_resource_trans
(p_tran_rec => l_resource_txns
,x_return_status => l_return_status);
RAISE update_row_err;
WHEN update_row_err THEN
IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
gme_debug.put_line ('update_row _fail');
WHEN delete_pending_trans_err THEN
IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
gme_debug.put_line ('delete_pending_trans _fail');
WHEN update_pending_trans THEN
IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
gme_debug.put_line ('update_pending_trans _fail');
,'UPDATE_ORIGINAL_FPO');
END update_original_fpo;
SELECT v.inventory_item_id, i.primary_uom_code
FROM gmd_recipe_validity_rules v, mtl_system_items i
WHERE recipe_validity_rule_id = v_validity_rule_id
AND i.organization_id = v_organization_id
AND v.inventory_item_id = i.inventory_item_id;
update_original_fpo_failure EXCEPTION;
update_original_fpo
(p_fpo_header_row => l_fpo_header_row
,p_prim_prod_row => l_prim_prod_row
,p_pregen_fpo_row => l_pregen_fpo_row
,p_fpo_material_details_tab => l_fpo_material_details_tab
,p_enforce_vldt_check => p_enforce_vldt_check
,x_fpo_header_row => x_batch_header
,x_return_status => x_return_status);
gme_debug.put_line ( 'in private convert_fpo-after update'
|| x_return_status);
RAISE update_original_fpo_failure;
WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
x_return_status := fnd_api.g_ret_sts_error;