[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT approval_status INTO l_approval_status
FROM mtl_system_items_b
WHERE inventory_item_id = l_inventory_item_id
AND organization_id = p_item.main_obj_type.organization_id;
x_last_login_id => p_item.main_obj_type.last_updated_by,
x_bom_rev_starting => NULL,
x_rtg_rev_starting => NULL,
x_ecn_name => NULL,
x_item_code => 1, --to transfer item to Mfg
x_bom_code => 1, --to transfer Bom to Mfg
x_rtg_code => 2,
x_mfg_description => p_item.main_obj_type.description,
x_segment1 => p_item.main_obj_type.segment1,
x_segment2 => p_item.main_obj_type.segment2,
x_segment3 => p_item.main_obj_type.segment3,
x_segment4 => p_item.main_obj_type.segment4,
x_segment5 => p_item.main_obj_type.segment5,
x_segment6 => p_item.main_obj_type.segment6,
x_segment7 => p_item.main_obj_type.segment7,
x_segment8 => p_item.main_obj_type.segment8,
x_segment9 => p_item.main_obj_type.segment9,
x_segment10 => p_item.main_obj_type.segment10,
x_segment11 => p_item.main_obj_type.segment11,
x_segment12 => p_item.main_obj_type.segment12,
x_segment13 => p_item.main_obj_type.segment13,
x_segment14 => p_item.main_obj_type.segment14,
x_segment15 => p_item.main_obj_type.segment15,
x_segment16 => p_item.main_obj_type.segment16,
x_segment17 => p_item.main_obj_type.segment17,
x_segment18 => p_item.main_obj_type.segment18,
x_segment19 => p_item.main_obj_type.segment19,
x_segment20 => p_item.main_obj_type.segment20,
x_implemented_only => NULL,
x_commit => FALSE
);
l_update_item_count NUMBER :=0;
l_update_item_tab FND_TABLE_OF_NUMBER;
l_update_item_index NUMBER := 0;
SELECT revision
FROM mtl_item_revisions_b
WHERE
organization_id = p_organization_id AND
inventory_item_id = p_inventory_item_id;
l_update_item_tab := FND_TABLE_OF_NUMBER();
IF l_eco_obj_validate_eco.NAME_VALUE_TBL(x).PARAM_NAME in ('VALIDATE_REVISED_ITEM_REVISION','TEMPLATE_FOR_ITEM_UPDATE_ALLOWED') THEN
l_eco_obj_validate_eco.eco_revised_item_type(i).item.NAME_VALUE_TBL.extend();
INV_EBI_UTIL.debug_line('STEP: 60 START update mtl_item_revisions_b');
UPDATE mtl_item_revisions_b
SET
implementation_date = sysdate,
effectivity_date = sysdate,
creation_date = sysdate,
last_update_date = sysdate,
last_updated_by = DECODE(last_updated_by, NULL, fnd_global.user_id,last_updated_by),
created_by = DECODE(last_updated_by, NULL, fnd_global.user_id,last_updated_by)
WHERE
inventory_item_id = l_item_output.inventory_item_id AND
organization_id = l_item_output.organization_id AND
revision = l_revision;
INV_EBI_UTIL.debug_line('STEP: 70 END update mtl_item_revisions_b');
l_update_item_count := l_item_obj_tbl.COUNT;
l_item_obj_tbl(l_update_item_count) := INV_EBI_GET_ITEM_OUTPUT_OBJ(NULL,NULL,NULL,NULL);
l_item_obj_tbl(l_update_item_count).item_obj := l_eco_obj_validate_eco.eco_revised_item_type(i).item;
l_update_item_tab.EXTEND(1);
l_update_item_tab(l_update_item_count) := l_item_count;
SELECT status_code
INTO l_curr_status_code
FROM eng_engineering_changes
WHERE change_id = l_change_id;
SELECT status_code
INTO l_status_code
FROM eng_change_statuses_vl
WHERE LOWER(status_name) = 'scheduled'; -- Scheduled
SELECT change_order_type_id INTO l_change_order_type_id
FROM eng_engineering_changes
WHERE change_notice = l_eco_obj.eco_change_order_type.eco_name
AND organization_id = l_organization_id;
l_update_item_index := l_update_item_tab(j);
,p_operation => INV_EBI_ITEM_PUB.g_otype_update
,p_item => l_item_obj_tbl(j).item_obj
,x_out => l_item_output
);
l_item_output_tbl(l_update_item_index) := l_item_output;
,p_last_update_status IN VARCHAR2
,p_revised_item_sequence_id IN NUMBER
,p_name_val_list IN inv_ebi_name_value_list
,x_eco_obj OUT NOCOPY inv_ebi_eco_obj
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_eco_obj inv_ebi_eco_obj;
,p_last_update_status => p_last_update_status
,p_revised_item_sequence_id => p_revised_item_sequence_id
,p_name_val_list => p_name_val_list
,x_eco_obj => l_eco_obj
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date_str :=
INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date);
x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date_str :=
INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);
x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date_str :=
INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);
x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str :=
INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str);
SELECT inv_ebi_change_id_obj(geco.change_id,'N')
FROM (SELECT eec1.change_id
FROM eng_engineering_changes eec,eng_engineering_changes eec1
where eec.change_id=p_chg_id
and eec.change_notice=eec1.change_notice
MINUS
SELECT b.change_id
FROM THE (SELECT CAST(p_change_lst as inv_ebi_change_id_obj_tbl)
FROM dual) b ) geco;
SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
FROM (SELECT b.change_id,b.last_update_status
FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)
FROM dual ) b
UNION
SELECT c.change_id,c.last_update_status
FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)
FROM dual ) c ) geco;
,p_last_update_status => l_eco_output_tbl_lst(l_cnt_cid).last_update_status
,p_revised_item_sequence_id => NULL
,p_name_val_list => l_name_val_list
,x_eco_obj => l_eco_obj
,x_return_status => l_return_status
,x_msg_count => l_count
,x_msg_data => l_msg_data
);