[Home] [Help]
3598: ************************************************************************************/
3599:
3600: PROCEDURE process_update_item_lifecycle(
3601: p_commit IN VARCHAR2 := FND_API.g_false
3602: ,p_update_item_tbl IN inv_ebi_item_attr_tbl
3603: ,x_out OUT NOCOPY inv_ebi_item_output_obj
3604: ) IS
3605:
3606: l_output_status inv_ebi_output_status;
4940: --
4941: ************************************************************************************/
4942: PROCEDURE get_item_attributes(
4943: p_get_item_inp_obj IN inv_ebi_get_item_input,
4944: x_item_tbl_obj OUT NOCOPY inv_ebi_item_attr_tbl_obj,
4945: x_return_status OUT NOCOPY VARCHAR2,
4946: x_msg_count OUT NOCOPY NUMBER,
4947: x_msg_data OUT NOCOPY VARCHAR2
4948: )
4988: l_org_id NUMBER;
4989: l_item_id NUMBER;
4990: l_msg_data VARCHAR2(100);
4991: l_msg_count NUMBER;
4992: l_item_attr_tbl inv_ebi_item_attr_tbl;
4993: l_mfr_part_table inv_ebi_mfg_part_obj_tbl_type;
4994: l_return_status VARCHAR2(1);
4995: l_msg VARCHAR2(100);
4996: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
5006: WHERE inventory_item_id = p_item_id AND organization_id=p_org_id;
5007:
5008: BEGIN
5009: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.get_item_attributes');
5010: l_item_attr_tbl := inv_ebi_item_attr_tbl();
5011: x_return_status := FND_API.G_RET_STS_SUCCESS;
5012: IF p_get_item_inp_obj.p_config_flags IS NULL THEN
5013: l_getitemoprattrs := FND_API.G_TRUE;
5014: ELSE
6084: ,x_err_msg => x_msg_data
6085: );
6086: END;
6087: END LOOP;
6088: x_item_tbl_obj:=inv_ebi_item_attr_tbl_obj(l_item_attr_tbl);
6089: INV_EBI_UTIL.debug_line('STEP 120: END INSIDE INV_EBI_ITEM_HELPER.get_item_attributes STATUS: '||x_return_status);
6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: x_return_status := FND_API.G_RET_STS_ERROR;